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