MySQL Forums
Forum List  »  Replication

how to switchback from slave to master
Posted by: Adzuan Amirullail Ahmad
Date: October 27, 2015 10:55PM

Hi Masters out there......

MySQL version : 5.6.27
Master server : x.x.x.236
Slave server : x.x.x.237

Replication status : OK
Switch Over from Master to Slave : OK
Current status Master : MySQL is stop

My question is, how to fallback or switch back to Master?

Below are steps taken to perform switch back from Master to Slave :

---------------------------------------------------------------------
#At Master
-Stop MySQL at master

#At Slave
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)

mysql> reset slave;
Query OK, 0 rows affected (0.03 sec)

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: x.x.x.236
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: repldb-relay-bin.000001
Relay_Log_Pos: 4
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: 174
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: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID: 1769aa95-762f-11e5-902f-38eaa7128f04
Master_Info_File: /mysql/mysql-5.6.27/data/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: 1769aa95-762f-11e5-902f-38eaa7128f04:61-86
Auto_Position: 0
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
how to switchback from slave to master
2012
October 27, 2015 10:55PM


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.