I think the process could be simpler:
1. Add new database name in my.cnf files.
2. Restart servers without stop/start replication.
3. Create new database on one of the master, it should
be automatically replicated to another server.
4. Do whatever you need to do on the new dadtabase.
--- Hartleigh Burton <hburton@stripped>
> I would first of all create the databases as you
> have done on both
> servers, then edit the my.cnf file on the slave...
> replicate-do-db = existingdatabasethatisreplicating
> replicate-do-db = newdatabasethatyouwanttoreplicate
> (each database
> does need to be specified in a new replicate-do-db
> report-host = 192.168.1.15 (address of
> master server for
> then on the slave do...
> mysql > stop slave;
> mysql > show slave status\G (to make sure it is not
> restart mysql on slave and show status again...
> mysql> show slave status\G
> *************************** 1. row
> Slave_IO_State: Waiting for master to
> send event
> Master_Host: 192.168.1.15
> Master_User: slaveuser
> Master_Port: 3306
> Connect_Retry: 60
> Master_Log_File: mysql-bin.000004
> Read_Master_Log_Pos: 206957999
> Relay_Log_Pos: 39338
> Relay_Master_Log_File: mysql-bin.000004
> Slave_IO_Running: Yes
> Slave_SQL_Running: Yes
> Last_Errno: 0
> Skip_Counter: 0
> Exec_Master_Log_Pos: 206957999
> Relay_Log_Space: 39338
> Until_Condition: None
> Until_Log_Pos: 0
> Master_SSL_Allowed: No
> Seconds_Behind_Master: 0
> 1 row in set (0.00 sec)
> you should notice that replication has automatically
> started with the
> server and is running with the new database listed.
> hope this helps.
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on