MySQL Master-Master Replication question

Discussion in 'HOWTO-Related Questions' started by [email protected], Jan 15, 2012.


    [email protected] New Member

    Hey all,

    I'm following the tutorial on:

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

    I have 2 db servers backending my customers on an ispconfig 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!
  2. falko

    falko Super Moderator ISPConfig Developer

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

    [email protected] New Member

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

Share This Page