LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   RHEL 6 MySQL server replication (http://www.linuxquestions.org/questions/linux-server-73/rhel-6-mysql-server-replication-931733/)

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 09:43 PM.