MySQL Forums
Forum List  »  Replication

REPLICATION problem.
Posted by: Praveen TS
Date: March 31, 2009 07:53AM

Hi,
I have done replication for node1 to node2 and shutdown the two nodes.
When i started the two nodes again, replication is not working.
The show slave status is

Slave_IO_State:
Master_Host: 192.168.10.145
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File:
Relay_Log_Pos: 0
Relay_Master_Log_File:
Slave_IO_Running: No
Slave_SQL_Running: No
Replicate_Do_DB:
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: 0
Relay_Log_Space: 0
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
1 row in set (0.00 sec)

i have done reset the slave, stop the slave, changed the master log,changed the bin, firewall is not blocking.

but unfortunate is "Slave_IO_State: " is also empty.
I dont know what to do?
I thouht to do replication from the scratch.
What are the steps to do replication from the scratch?
i deleted the mysqld.log, mysql-bin.index files, relay log files.
deleted the master.info and relay-info file.

Please let me know what are the steps to do replication from the scratch?
if you have an alternative solution by looking at the log,please let me know..

Thanks in advance,
Praveen



Edited 1 time(s). Last edit at 03/31/2009 07:54AM by Praveen TS.

Options: ReplyQuote


Subject
Views
Written By
Posted
REPLICATION problem.
2592
March 31, 2009 07:53AM


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.