LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
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, 07:24 AM   #1
Alexrkkl
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
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6 / 7
Posts: 3,475

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


Reply

Tags
mysql, replication



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

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 08:56 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
Open Source Consulting | Domain Registration