MySQL Forums
Forum List  »  Replication

adding db to an established master - master configuration.
Posted by: kevin foote
Date: April 29, 2013 07:23AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
adding db to an established master - master configuration.
1527
April 29, 2013 07:23AM


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.