Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/StackDBAs/status/1080252468657831939
added 28 characters in body; edited title
Source Link
RolandoMySQLDBA
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531

In a MysqlMySQL 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?Several Questions

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?

  • 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?

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?

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

Several Questions

  • 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?

edited title
Source Link
kfmfe04
kfmfe04
  • 849
  • 2
  • 8
  • 12

In a Mysql Master/Slave systemreplication, 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?

In a Mysql Master/Slave system, 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?

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?

Source Link
kfmfe04
kfmfe04
  • 849
  • 2
  • 8
  • 12

In a Mysql Master/Slave system, 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?