I have this configuration:
- Master running MySQL 5.5 with log file format: STATEMENT
- Slave running MySQL 8.0 - connected to (1) master. Log file format: ROW
- Another Slave running MySQL 8.0 - connected to (2) the first slave. Log format: ROW
Main problem: Slave number 3 (who is connected to slave number 2 that is connected to the master) sometime goes out of sync for query. I get errors like "Can not execute query. Duplicate ID '12345' already exists". Then I need to dump the database again from slave(2) and start the slave(3) again on the correct location. It keeps syncing for a day or two and then I get an error again.
Secondary problem(s): Trying to fix Main Problem, I tried to change slave(2) (which is also master to slave(3)) log format to STATEMENT but it stopped syncing at all (it was working great before). No error. Just the second_behind_master goes up and up and not advancing the relay log. When I changed the log format back to ROW it resume syncing with no problems.
I also tried to change slave(3) log format to STATEMENT but then I got the error of Master sending ROW format (although I changed it to STATEMENT - see above) and slave is in STATEMENT format.
Any ideas ? Thanks.