Victoria, On Thu, 14 Nov 2002, Victoria Reznichenko wrote:
> Mark, > Thursday, November 14, 2002, 12:02:31 AM, you wrote: > > MI> I am having a problem with replication. When I create a new database on > MI> the master, the CREATE DATABASE command is not shipped to the slave. > MI> Subsequent table creation and table updates on the new database on the > MI> master are replicated on the slave, but since the new database was not > MI> created on the slave, the slave thread hangs. > > It works fine for me. What replication options are you using? >From the master: server-id=5 log-bin=/group/clas/db/clasdb/logs/clasdb2-bin binlog-ignore-db=diskSpace binlog-ignore-db=mysql >From the slave: server-id=4 master-host=clasdb2.jlab.org master-user=repl master-password=******** So it is all pretty vanilla. The diskSpace database is excluded since it is used as a scratch pad for disk management. Since different mirrors may want different access privilege tables, the mysql database is excluded from replication. I forgot to mention: the cure for this is to create the database (zzz in this case) by hand and start the slave again. It's just that I don't want to do this everytime a new database is created on the master. -- Mark --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
