MySQL Forums
Forum List  »  Replication

Re: Server 1 to Server 2 replicate DB1, and Server 2 to Server 1 replicate DB2
Posted by: Juan Perez Estrada
Date: December 26, 2009 04:54PM

Thank you very much.

Now I'm figthing with this options:

log_bin=mysqls-bin
innodb_flush_log_at_trx_commit=1
sync_binlog=1
binlog-do-db=dbslave
binlog-ignore-db=mysql
binlog-ignore-db=test

Because, binlog-do-db is very dangerous when you use "USE DB".

Thanks a lot.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Server 1 to Server 2 replicate DB1, and Server 2 to Server 1 replicate DB2
1430
December 26, 2009 04:54PM


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.