-   Linux - Server (
-   -   RHEL 6 MySQL server replication (

Alexrkkl 02-28-2012 08:24 AM

RHEL 6 MySQL server replication
Hi there I am setting up a mysql server for replication.

The question I have is if I have 100 tables in a schema but only want to replicate 3 tables do I have to add
replicate-ignore-table=schema.table for all 97 other tables as well as
replicate-do-table=schema.table for the 3 tables I do want to replicate?

Or is there no need to use replicate-ignore-table=schema.table if I use replicate-do-table=schema.table?

TenTenths 02-28-2012 10:19 AM

Just list the tables in replicate-do-table and you should be fine. Test it on your test instances first ;)

All times are GMT -5. The time now is 12:26 AM.