Skip to main content
2 of 3
edited title
kfmfe04
  • 849
  • 2
  • 8
  • 12

In a Mysql Master/Slave replication, what would happen if I write to the Slave?

Would the Slave entry remain until there is an insert/update/delete to the table on the Master that could affect the Slave?

If not, how do I ensure that the Slave is in-sync with the Master going forward? (either by deleting the Slave entry or copying that entry to the Master manually?) Most importantly, how do I detect that the tables are out-of-sync?

kfmfe04
  • 849
  • 2
  • 8
  • 12