Say one of the tables got corrupted, will that corrupted table still get replicated to the other DB? Or, will the replication stop to prevent the other DB from being corrupted too?
Note: Question is for both master-master or master-slave setup.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
A crash often leaves MyISAM tables in need of "REPAIR". Switch to InnoDB to avoid such.
Even then, it was rarely the "data" that was corrupted, just the index file (
.MYI). The index is maintained separately on each server; replication is not involved.
Bottom line: Don't use MyISAM any more.
If the Master discovers corruption, it will halt. In this case, nothing will go to the Slave.
Replication involves sending changes (either in the form of write SQL statements or the effect of those statements), so corruption is not propagated.
If your definition of "corruption" includes a malicious
DROP TABLE, that "corruption" will be propagated to the Slave.