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 15th January 2012, 21:47
david_hitt@lionlike.com david_hitt@lionlike.com is offline
Junior Member
 
Join Date: Feb 2011
Posts: 25
Thanks: 6
Thanked 4 Times in 4 Posts
Default MySQL Master-Master Replication question

Hey all,

I'm following the tutorial on:
http://www.howtoforge.com/mysql_mast...er_replication

And on step 2, you enter db to replicate and db to ignore.

I have 2 db servers backending my customers on an ispconfig 3.0.3.3 setup.

I want to replicate all customer databases coming from ispconfig with the "c" prefix, but ignore the mysql, dbispconfig and information_schema databases.

Does binlog_do_db accept a wildcard? Or do I have to specify each database to be replicated?

Here's a section of my config (/etc/mysql/my.cnf):

binlog_do_db = c%
binlog_ignore_db = mysql
binlog_ignore_db = dbispconfig
binlog_ignore_db = information_schema

MySQL documentation doesn't say anything on database replication, but does say wildcards will work on table and column replication.

Any ideas or help is much appreciated!
Reply With Quote
Sponsored Links
  #2  
Old 16th January 2012, 13:45
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

Just leave out binlog_do_db and specify only the databases to ignore with binlog_ignore_db.
__________________
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:
david_hitt@lionlike.com (17th January 2012)
  #3  
Old 17th January 2012, 03:50
david_hitt@lionlike.com david_hitt@lionlike.com is offline
Junior Member
 
Join Date: Feb 2011
Posts: 25
Thanks: 6
Thanked 4 Times in 4 Posts
 
Default

That did it. Works like a champ. Thank you.
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
Add ons for ISPConfig 3 virtue Installation/Configuration 24 16th October 2009 18:30
MySql Master Master replication nadavgg Server Operation 2 20th April 2009 12:33
multiserver - mysql replication question grungy Installation/Configuration 5 30th March 2009 13:32
Replication error in Mysql afaylona HOWTO-Related Questions 1 21st February 2009 18:55
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17


All times are GMT +2. The time now is 02:12.


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