Hello All,
I have set master database ( version 5.0.21) and slave database ( 5.0.24a)
to replicate database db1. When database on master is modified changes do
get replicated to the replication relay bin file on slave but they do not
get applied to the database.
Here is section of my.cnf on master.
log-bin=/var/lib/mysql/binlog/rh1_bin_log
binlog-do-db=db1
server-id=1
Here is section of my.cnf on slave.
server-id=2
replicate-do-db=db1;
Here is the output of show slave status \G;
Slave_IO_State: Waiting for master to send event
Master_Host: 172.28.88.51
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: rh1_bin_log.000001
Read_Master_Log_Pos: 1823
Relay_Log_File: rh3-relay-bin.000002
Relay_Log_Pos: 1962
Relay_Master_Log_File: rh1_bin_log.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: db1;,db1;
Replicate_Ignore_DB:
When db1 is modified on master, Read_Master_Log_Pos and Relay_Log_Pos do
changes, also I can open and see the changes in rh3-relay-bin.000002, but
they do not appear in database. No error logged in /var/lib/mysql/rh3.err
file.
Replicate_Do_DB is showing database name twice. I am not sure why.
Any and every help appreciated.
Thanks,
Sudhir Damle
Stratogent.
Thread |
---|
• Replicate_Do_DB shows duplicate name | Sudhir Damle | 30 Oct |