[MDEV-10163] mysqldump hard to work and dangerous using multi master Created: 2016-06-01 Updated: 2017-05-29 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Replication, Scripts & Clients |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | VAROQUI Stephane | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Description |
|
MariaDB does not provide an easy way to restore a node in multi master What DBA should do for M1<->M2 echo "STOP SLAVE; set sql_log_bin=0;" ; mysqldump .... ; echo "START SLAVE;" > backup.sql This situation is not good as by lack of knowledge many users report active master database corruption caused by binlog reexecution of the restore of the peer node To simplify restoring of a slave MySQL 5.7 introduced Not documented and implemented yet in MariaDB We could implement a --multi-master that is combination of --apply-slave-statements --skip-binlog is still at this time a long awaited option requested 10 years ago Extra workload protection : |