MySQL Forums
Forum List  »  Synchronization

Sync on entire master database
Posted by: greg rouf
Date: December 03, 2010 07:14AM


The question is pretty simple, if i want to synchronise/replicate the whole master database, would i need to specify into master's my.cnf the "binlog-do-db" for every existing database?
As far as I know, if I start to specify database using the binlog-do-db options, the slave won't build up new databases if some are created later on the master.

Wouldn't just selecting the right bin-log on the master enough?

Let me explain my question through an example.
My master "my.cnf" doesn't specify any binlog-do-db. Therefore binlog-do-db is empty while doing a show master status.

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
| mysql-bin.000467 | 4067704 | | |

If i still pick up the right mysql-bin.00x file with the correct pointer position, would the slave synchronise the whole database or would it just pick up nothing?

Many thanks for your help.

Options: ReplyQuote

Written By
Sync on entire master database
December 03, 2010 07:14AM
December 03, 2010 08:00AM
December 06, 2010 08:14AM

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.