2

I have data replication setup on MySQL. If I delete data on the master, will replication know data was deleted and automatically delete the same data on slave?

Improve this question

1 Answer 1

Reset to default
2

Yes, it will automatic apply the delete on the slave, with some restrictions:

  • If you have replicate-do-db=db_name enabled, it will automatically filter out the statements to the given database names
  • If you have replicate-ignore-db=db_name enabled, it will automatically filter out statements to the given table names
Improve this answer
3
  • pardon my ignorance but how do I check if those two settings are enabled? Also, what does "delete just the statements" mean? Is that the equivalent of deleting the data? I'm not really understanding the difference between the two restrictions...
    – PLui
    Commented Apr 2, 2013 at 13:46
  • 1
    to check run SHOW VARIABLES LIKE '%replicate%'; if you have replicate-do-db it will replicate statements(queries) just to db that you specify in this field. if you have replicate-ignore-db it will replicate statements(queries) to dbs that isn't in this option, if you don't have anything in this 2 options it will replicate everything.
    – altmannmarcelo
    Commented Apr 2, 2013 at 13:53
  • 2
    There are also replicate-do-table/replicate-ignore-table. Here are some more descriptions of what they do.
    – Derek Downey
    Commented Apr 2, 2013 at 14:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.