MySQL Forums
Forum List  »  Replication

Slave is not updating some tables .....
Posted by: aftab ali
Date: June 19, 2009 08:47AM

Hi All.

Here is the slave status\G

{code}
SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.2.2.100
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: replication.002802
Read_Master_Log_Pos: 997606931
Relay_Log_File: relay.008410
Relay_Log_Pos: 245142347
Relay_Master_Log_File: replication.002802
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: DB,DB_merge
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: DB.NOTES
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: DB.STATISTICS%,DB.TRANSACTIONS%,DB.HISTORY%
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 997606931
Relay_Log_Space: 245142676
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: 0
1 row in set (0.00 sec)


{code}


i did stop and start the slave but still not updating the slave ....


actually some of the tables are not getting the data (means not updating )




thanks .......

Options: ReplyQuote


Subject
Views
Written By
Posted
Slave is not updating some tables .....
2524
June 19, 2009 08:47AM


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.