# MySQL Mixed Replication uses different method for same query

**URL:** <https://forums.percona.com/t/mysql-mixed-replication-uses-different-method-for-same-query/4090>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [March 5, 2015, 3:04pm UTC](https://forums.percona.com/t/mysql-mixed-replication-uses-different-method-for-same-query/4090 "2015-03-05T15:04:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pparkhill](https://avatars.discourse-cdn.com/v4/letter/p/b5a626/32.png) [@pparkhill](https://forums.percona.com/u/pparkhill)\
**Post date:** [March 5, 2015, 3:04pm UTC](https://forums.percona.com/t/mysql-mixed-replication-uses-different-method-for-same-query/4090/1 "2015-03-05T15:04:32Z")

</div>

mysql\>[COLOR=#00008B]select\*[COLOR=#00008B]from table\_in\_question;| id | parent\_id |[COLOR=#00008B]key| array\_name | value | time | ip | remark | p\_id |  
| id | parent\_id |[COLOR=#00008B]key| array\_name | value | time | ip | remark | p\_id |  
|2128363|0| fname | o | Sue |2015-03-0208:47:48|0.0.0.0||166817|  
|2128365|2128363| lname | o | Susanson |2015-03-0208:47:48|||166817|  
|2128367|2128363| address | o |123 Main |2015-03-0208:47:48|||166817|  
|2128373|2128363| city | o | Nowhere |2015-03-0208:47:48|||166817|  
|2128379|2128363| state | o | LA |2015-03-0208:47:48|||166817|  
|2128385|2128363| postcode | o |11111|2015-03-0208:47:48|||166817|  
|2128389|0| fname | o | Amy |2015-03-0208:47:58|2.2.2.2||0|  
|2128391|2128363| telephone | o |(800)555-1212|2015-03-0208:47:48|||166817|  
|2128397|2128363| email\_address | o | sue@nowhere.com |2015-03-0208:47:48|||166817|  
|2128403|2128363| click | o |369490878|2015-03-0208:47:48|||166817|  
|2128409|2128363| country | o |223|2015-03-0208:47:48|||166817|  
|2128415|2128363| product | c |7|2015-03-0208:47:48|||166817|  
|2128421|2128363| g\_id | c |1|2015-03-0208:47:48|||166817|  
|2128427|2128363| c\_id | c |141|2015-03-0208:47:48|||166817|

Last SQL error: Error ‘Duplicate entry ‘2128391’ for key ‘[COLOR=#00008B]PRIMARY’’[COLOR=#00008B]on query.[COLOR=#00008B]Default[COLOR=#00008B]database:‘XXX’. Query:‘INSERT INTO table\_in\_question (key,value,array\_name,parent\_id) VALUES (‘lname’,‘Amyson’,‘o’,2128389), (‘address’,‘444 Main’,‘o’,2128389), (‘city’,‘Nowhere’,‘o’,2128389), (‘state’,‘NH’,‘o’,2128389), (‘postcode’,‘11111’,‘o’,2128389), (‘telephone’,‘800555-1212’,‘o’,2128389), (‘email\_address’,‘Amy@nowhere.com’,‘o’,2128389), (‘country’,‘223’,‘o’,2128389), (‘product’,‘7’,‘c’,2128389), (‘g\_id’,‘1’,‘c’,2128389), (‘c\_id’,‘141’,‘c’,2128389)’