Replication error from Mariadb 10.1 to Mysql 5.1/5.0/5/5 when master's logging format is set to row based
0
votes
2
answers
1100
views
While replicating from Mariadb 10.1 to MySQL (5.0, 5.1, 5.5) or Mariadb (5.2, 5.5) lower versions, if master's
binlog_format
is set to row, the replication failure occurs with the following message at slave (show slave status \G;
):
> Last_Error: Table definition on master and slave does not match: Column 18 type mismatch - received type 19, rtmariadb10.empdetails
> has type 11
Here
Master: Mariadb 10.1,binlog_format: row ;
Slave : Mysql 5.1, binlog_format=statement/row/mixed(any one of these)
Can someone please help to solve this issue?
Asked by Avijit batabyal
(11 rep)
Dec 8, 2016, 12:13 PM
Last activity: Jun 7, 2025, 05:08 AM
Last activity: Jun 7, 2025, 05:08 AM