MySQL Forums
Forum List  »  Replication

mysql replication
Posted by: Vishal dhir
Date: May 16, 2014 04:02PM

Hello ,

I refreshed one database on one node of the cluster however the database should have been refresh automatically on other node but that didn't happen.Belwo stats is on node2


mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: xx.xx.xx.xx
Master_User: repl
Master_Port: 3306
Connect_Retry: 10
Master_Log_File: mysql-bin.000031
Read_Master_Log_Pos: 758225577
Relay_Log_File: atdc-cxpussd07-lx02-relay-bin.000022
Relay_Log_Pos: 758225723
Relay_Master_Log_File: mysql-bin.000031
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB: F5NLB
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: 758225577
Relay_Log_Space: 758225936
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: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1236
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position; the first event 'mysql-bin.000031' at 758225577, the last event read from '/mysql-logs/bin-log/mysql-bin.000031' at 4, the last byte read from '/mysql-logs/bin-log/mysql-bin.000031' at 4.'
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 10
1 row in set (0.00 sec)


Best regards,
Vishal

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql replication
2050
May 16, 2014 04:02PM
852
May 19, 2014 04:18PM


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.