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 220.127.116.11 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!