MySQL Master-Master Replication question

Hey all,

I'm following the tutorial on:
http://www.howtoforge.com/mysql_master_master_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!

 

Just leave out binlog_do_db and specify only the databases to ignore with binlog_ignore_db.

 

That did it. Works like a champ. Thank you.