adding db to an established master - master configuration.
I have a working master-master mysql environment. I would like to add two (2) more databases into the replication process, (or for that mater any db I add to the server). With no downtime to the db would be my preference.
RHEL 5
MySQL 5.1.41 community
Here is the binlog section of my.cnf that I currently have configured, I use the innodb engine..
## BINLOG SETTINGS
log-bin = /var/log/mysql/mydb1-bin
log-bin-index = /var/log/mysql/mydb1-bin.index
binlog-do-db = proddb
binlog-ignore-db = mysql
expire_logs_days = 4
sync_binlog = 1
One of the two databases I need added to the replication process has data and is in a production state while the other is yet to be created.
Ideally I'm hoping for some tool or if anyone has a devised set of steps to just add stuff into the replication mix. I'm hoping to do this with no downtime to the databases in question.
Thanks for any pointers... Kevin
Subject
Views
Written By
Posted
adding db to an established master - master configuration.
1527
April 29, 2013 07:23AM
863
April 30, 2013 10:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.