# Replication with 5.0 master and 5.6 slave

**URL:** <https://forums.percona.com/t/replication-with-5-0-master-and-5-6-slave/2035>\
**Category:** Other MySQL® Questions\
**Created:** [April 8, 2013, 10:52am UTC](https://forums.percona.com/t/replication-with-5-0-master-and-5-6-slave/2035 "2013-04-08T10:52:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![hammer](https://avatars.discourse-cdn.com/v4/letter/h/bc79bd/32.png) [@hammer](https://forums.percona.com/u/hammer)\
**Post date:** [April 8, 2013, 10:52am UTC](https://forums.percona.com/t/replication-with-5-0-master-and-5-6-slave/2035/1 "2013-04-08T10:52:54Z")

</div>

Hello,

I have a problem with a replica. We have 2 servers in a master-master circular replication and each of them has some slaves. All these are mysql 5.0 servers. We now decided to upgrade to mysql 5.6 to take advantage of it’s improvements but we run into an issue. We upgraded one of the slaves to 5.6 and we have a problem because the 5.6 slave doesn’t seem to be using the indexes when executing the statements (we are not yet using row based replication). Any idea what could be the problem or how to debug this issue?

Thank you

---

<div class="post-metadata">

**Author:** ![hammer](https://avatars.discourse-cdn.com/v4/letter/h/bc79bd/32.png) [@hammer](https://forums.percona.com/u/hammer)\
**Post date:** [April 8, 2013, 12:09pm UTC](https://forums.percona.com/t/replication-with-5-0-master-and-5-6-slave/2035/2 "2013-04-08T12:09:08Z")

</div>

What i could add is that some indexes are on varchar fields using latin1 with latin1\_general\_ci collation and we are using also local variables. Checking with mysqlbinlog i can see those variables appear in the relay log. Here is an example:  
SET @`trId`:=\_latin1 0x3065376231633363656562383130333039623235343830623630633061 336564 COLLATE `latin1_general_ci`/_!_/;

However the update query using this variable is not using the index. Any ideas?

Thank you

---

<div class="post-metadata">

**Author:** ![hammer](https://avatars.discourse-cdn.com/v4/letter/h/bc79bd/32.png) [@hammer](https://forums.percona.com/u/hammer)\
**Post date:** [April 9, 2013, 3:41am UTC](https://forums.percona.com/t/replication-with-5-0-master-and-5-6-slave/2035/3 "2013-04-09T03:41:53Z")

</div>

It’s a query like:

update mytable set f1=‘abc’ where tr=@trId;

Nobody has any clues what could be the issue? ☹

---

<div class="post-metadata">

**Author:** ![hammer](https://avatars.discourse-cdn.com/v4/letter/h/bc79bd/32.png) [@hammer](https://forums.percona.com/u/hammer)\
**Post date:** [April 15, 2013, 5:06pm UTC](https://forums.percona.com/t/replication-with-5-0-master-and-5-6-slave/2035/4 "2013-04-15T17:06:59Z")

</div>

Hi Tom,

I just realized that i did not answer your question ☹  
No we are not using Percona Server but mysql server version 5.0.45 on the master and myqsl server 5.6.10. Both are x64 running on CentOS 6.3 and are installed from RPM.

Thank you,  
Pavel

---

<div class="post-metadata">

**Author:** ![hammer](https://avatars.discourse-cdn.com/v4/letter/h/bc79bd/32.png) [@hammer](https://forums.percona.com/u/hammer)\
**Post date:** [April 19, 2013, 10:25am UTC](https://forums.percona.com/t/replication-with-5-0-master-and-5-6-slave/2035/5 "2013-04-19T10:25:05Z")

</div>

Hi Tom,

Do you have any suggestions? I still didn’t figure out what could be the issue ☹ I really see no logic behind this and i can’t understand why the index is not being used…

Thanks,  
Pavel

---

<div class="post-metadata">

**Author:** ![hammer](https://avatars.discourse-cdn.com/v4/letter/h/bc79bd/32.png) [@hammer](https://forums.percona.com/u/hammer)\
**Post date:** [May 15, 2013, 6:51am UTC](https://forums.percona.com/t/replication-with-5-0-master-and-5-6-slave/2035/6 "2013-05-15T06:51:12Z")

</div>

Just in case somebody else has this issue…It seems the issue is actually a bug in MySQL and not somethimg related to replication from 5.0 master.  
It has been fixed in 5.6.12: [url][MySQL Bugs: #68811: Replication slave stuck on simple query with user variables.](http://bugs.mysql.com/bug.php?id=68811%5B/url%5D)

Any idea when 5.6.12 will be GA?