MySQL Database Replication for Multiple Databases (my.cnf configuration files)

Method used is the same as the one database replication, just multiply the row binlog_do_db.

Here's an example configuration:

server-id = 1

log_bin = /var/log/mysql/mysql-bin.log

expire_logs_days = 10

max_binlog_size = 500M

binlog_do_db = db01

binlog_do_db = db02

binlog_do_db = db03

binlog_do_db = db04

binlog_do_db = db05

binlog_do_db = db06

binlog_do_db = db07

binlog_do_db = db08

binlog_do_db = db09

binlog_do_db = dbxx

 

The content of my.cnf on the slave side is like this:

server-id = 2

log_bin = /var/log/mysql/mysql-bin.log

expire_logs_days = 10

max_binlog_size = 500M

replicate_do_db = db01

replicate_do_db = db02

replicate_do_db = db03

replicate_do_db = db04

replicate_do_db = db05

replicate_do_db = db06

replicate_do_db = db07

replicate_do_db = db08

replicate_do_db = db09

replicate_do_db = dbxx

That's all