LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



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

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, 10:19 AM   #2
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6
Posts: 1,602

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


Reply

Tags
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 04:19 AM
[SOLVED] mysql server in rhel 6 magicalshashank31 Linux - Server 6 09-10-2011 07:51 AM
Mysql replication failed after mysql reboot ajayan Linux - Newbie 8 09-08-2010 12:00 PM
Port replication/forwarding in RHEL rijesh.menon Linux - Networking 0 01-25-2010 02:06 AM
I have RHEL 5.0 and MySQL start problem, my MySQL server doesn't start rsatya Linux - Enterprise 4 02-03-2009 01:04 PM


All times are GMT -5. The time now is 03:22 PM.

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