5

Should MySQL slave have the same version or higher than Master for replication to work properly?

Tom Duckering
  • 235
  • 1
  • 13
Kourosh Samia
  • 321
  • 1
  • 5
  • 12

2 Answers2

4

Someone asked a similar question about the side effects.

The headers of binary logs are different.

MySQL 5.5 has a 107 byte header in a binary log.
MySQL 5.1 has a 106 byte header in a binary log.
MySQL 5.0 and prior has a 98 byte header in a binary log.

So, by all means, use the same version on both master and slave. Higher version on the Slave is OK.

Community
  • 1
RolandoMySQLDBA
  • 16,544
  • 3
  • 48
  • 84
2

I would go for the same version to avoid any incompatibilities. Since the queries are executes "as is", both machines need to interpret them identically.

If you can not match the version, go for a higher version on the slave. However, in my own experience MySQL has been known to add "reserved keywords" in newer version, which broke certain queries for me. That might not be a problem since it's a binary log that is used for replication, not plain text queries.

jishi
  • 868
  • 2
  • 11
  • 25
  • 1
    Just to supplement jishi's answer, please note that if you're using Row-based replication, both master and slave must be >= 5.1. You cannot replicate 5.1 -> 5.0 in that case. – scetoaux Jan 18 '11 at 21:35