We all know, there are several methods for syncing data from a mysql master to a slave. After reading many blogs about this issue, two common tools always come up:
- pt-online-schema-change
- pt-table-sync
- xtrabackup
in my case, i cannot use them, because:
- pt-online-schema-change (only works with tables, that don´t have any triggers)
- pt-table-sync (only works if binglog logformat of master is not ROW)
- xtrabackup (only works for the whole server, i need to sync single DBs)
so if my reasons, not using these tools, are not wrong, i am searching for the best solution, with less or none downtime, when syncing all the data from the master to the slave.
Maybe a simple mysqldump
is the best solution here, maybe not.