MySQL Forums
Forum List  »  Replication

Replication apparently to be working, but just 2 of 4 DB are replicating
Posted by: Ramon Resendiz
Date: November 08, 2012 12:20PM

The replication is compossed by 1 Master (5.5.27) and 2 Slaves (5.5.27 and 5.1.50). One of the slave work perfectly (5.1.50), the 2nd one is working at half, i mean the schemas that are supposted to be replicating are 4, but just 2 of them are replicating.

I've did copy from master to slave, so many times, and set the replication a lot of times. But no matter what it do, i only can do that schemas db1 and db2 replicate in a correct way from master, but db3 and db4 do not do it.

BTW there is not any clue about why coudl this be happening.

MySQL Slave: 'show slave status\G'

*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.X.X
Master_User: ********
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.003248
Read_Master_Log_Pos: 202183595
Relay_Log_File: localhost-relay-bin.000026
Relay_Log_Pos: 51501824
Relay_Master_Log_File: mysql-bin.003248
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: db1,db2,db3,db4
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 202129627
Relay_Log_Space: 51555952
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 1
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 108

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication apparently to be working, but just 2 of 4 DB are replicating
1825
November 08, 2012 12:20PM


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.