MySQL Forums
Forum List  »  Synchronization

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

Hello,

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.
Greg

Options: ReplyQuote


Subject
Views
Written By
Posted
Sync on entire master database
6911
December 03, 2010 07:14AM
2969
December 03, 2010 08:00AM
2874
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.