HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

MySQL 5.5 to RDS 5.6 Replication Error

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
rdsmysqlerrorreplication

Problem

I am facing following error and unable to fix it. So far I have disabled binlog checksum on the RDS.

[Warning] Slave I/O: Notifying master by SET @master_binlog_checksum= @@global.binlog_checksum failed with error: Unknown system variable 'binlog_checksum', Error_code: 1193
2015-06-29 11:01:01 8026 [Warning] Slave I/O: Unknown system variable 'SERVER_UUID' on master. A probable cause is that the variable is not supported on the master (version: 5.5.41-0ubuntu0.12.04.1-log), even though it is on the slave (version: 5.6.22-log), Error_code: 1193

Solution

This is due to MySQL Master and Slave version mismatch

The message below is clear, and confirms the master/slaves run different versions. The variable SERVER_UUID is not supported with MySQL 5.5 but is supported with MySQL 5.6

2015-06-29 11:01:01 8026 [Warning] Slave I/O: Unknown system variable 'SERVER_UUID' on master. A probable cause is that the variable is not supported on the master (version: 5.5.41-0ubuntu0.12.04.1-log), even though it is on the slave (version: 5.6.22-log), Error_code: 1193


Please have a look at Link1 & Link2

Code Snippets

2015-06-29 11:01:01 8026 [Warning] Slave I/O: Unknown system variable 'SERVER_UUID' on master. A probable cause is that the variable is not supported on the master (version: 5.5.41-0ubuntu0.12.04.1-log), even though it is on the slave (version: 5.6.22-log), Error_code: 1193

Context

StackExchange Database Administrators Q#105415, answer score: 5

Revisions (0)

No revisions yet.