Beware about admin commands in MySQL replication

by jagbir on November 19, 2010

Here is the situation: We are doing replication of only 1 table from a database (live) to other host (backup). so we expect that updates which are on others DBs/tables except on this table should not replicate. Wrong! they got replicated.

We shifted one DB say DB1 from live env to Backup DB host and then removed that DB1 from Live. Even replication was only for a single table of a particular DB say DB5, DB1 got removed from Backup host as well, living us in vaccum :P

Luckily we had backup so restored immediately. Its like a confirmation now that all administrative commands like creating/dropping databases/tables etc get replicated to your client even if you are doing ‘selective’ replication.

Previous post:

Next post: