DROP DATABASE propagation
Hi,
I am using mysql replication and I have found some troubles. I am using mysql 3.23.58 in both, slave and master.
First when I create a user in the master, it doesn't propagate to the slave. Second when I use "drop database" sentence in the master, it works but not propagate to the slave. Therefore when I try to create de database again the slave stops and show an error.
I don't know if this is a restriction of the mysql replication or if I am doing something wrong.
I will appreciate any help you can give me.
Regards,
Master my.cnf:
skip-innodb
server-id=1
log-bin
binlog-do-db=allied
binlog-do-db=mysql
Slave my.cnf:
log-bin
server-id=2
slave-skip-errors=all
log-slave-updates
master-host=***
master-user=***
master-password=***
binlog-do-db=allied
replicate-wild-do-table=allied.%
replicate-wild-do-table=mysql.%
--
Elvis Cartaya
Subject
Views
Written By
Posted
DROP DATABASE propagation
3735
May 19, 2005 09:17AM
1910
June 20, 2005 10:58AM
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.