1. 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.

Share This Page