Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 02-28-2012, 07:24 AM   #1
LQ Newbie
Registered: Jun 2011
Location: Birmingham, England
Distribution: RedHat Enterprise 5.6
Posts: 28

Rep: Reputation: Disabled
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?
Old 02-28-2012, 09:19 AM   #2
Senior Member
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6 / 7
Posts: 2,644

Rep: Reputation: 977Reputation: 977Reputation: 977Reputation: 977Reputation: 977Reputation: 977Reputation: 977Reputation: 977
Just list the tables in replicate-do-table and you should be fine. Test it on your test instances first


mysql, replication

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL replication: move binary logs to different server x_terminat_or_3 Linux - Software 0 12-14-2011 03:19 AM
[SOLVED] mysql server in rhel 6 magicalshashank31 Linux - Server 6 09-10-2011 06:51 AM
Mysql replication failed after mysql reboot ajayan Linux - Newbie 8 09-08-2010 11:00 AM
Port replication/forwarding in RHEL rijesh.menon Linux - Networking 0 01-25-2010 01:06 AM
I have RHEL 5.0 and MySQL start problem, my MySQL server doesn't start rsatya Linux - Enterprise 4 02-03-2009 12:04 PM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 04:57 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration