List:Replication« Previous MessageNext Message »
From:Sudhir Damle Date:October 30 2006 10:25pm
Subject:Replicate_Do_DB shows duplicate name
View as plain text  
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 nameSudhir Damle30 Oct