Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 4th May 2009, 20:25
wxman wxman is offline
Senior Member
 
Join Date: May 2007
Posts: 189
Thanks: 11
Thanked 2 Times in 2 Posts
Default Master master Mysql replication with ignore table

I followed the master master replication how-to's, and they have always worked. This time I needed to add a couple of table to a database that I want the replication to ignore. I thought I understood that I do it something like this:
Code:
replicate-do-db = dbispconfig
replicate-ignore-table=dbispconfig.server
replicate-ignore-table=dbispconfig.monitor_data
I want the dbispconfig Db to be replicated, but not the two tables 'server' and 'monitor_data'. Is this the right my.cnf entry?
Reply With Quote
Sponsored Links
  #2  
Old 5th May 2009, 19:20
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,722 Times in 2,563 Posts
Default

Yes, that's ok.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
wxman (5th May 2009)
  #3  
Old 5th May 2009, 22:25
wxman wxman is offline
Senior Member
 
Join Date: May 2007
Posts: 189
Thanks: 11
Thanked 2 Times in 2 Posts
 
Default

After running through the setup 5 times, I realized I had a typo that was messing it up. Now it works.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySql Master Master replication nadavgg Server Operation 2 20th April 2009 11:33
mysql master to master replication question ubutux HOWTO-Related Questions 7 13th March 2009 17:07
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03
mysql master master replication not working SoftDux HOWTO-Related Questions 5 29th March 2007 14:31


All times are GMT +2. The time now is 07:17.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.