MySQL Forums :: Replication :: Slave is not updating some tables .....


Advanced Search

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 ..... 2489 aftab ali 06/19/2009 08:47AM
Re: Slave is not updating some tables ..... 1767 aftab ali 06/19/2009 10:30AM
Re: Slave is not updating some tables ..... 1714 Rick James 06/20/2009 03:40PM
Re: Slave is not updating some tables ..... 2304 aftab ali 06/22/2009 12:56AM
Re: Slave is not updating some tables ..... 1813 aftab ali 06/22/2009 02:48AM
Re: Slave is not updating some tables ..... 1779 Rick James 06/22/2009 10:41AM


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.