#mysqladmin -u root -ptmppassword stop-slave
Slave stopped
# mysqladmin -u root -ptmppassword start-slave
slave started
========================================================================
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2836691
Server version: 5.5.25 MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> stop slave;
Query OK, 0 rows affected (14.39 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Queueing master event to the relay log
Master_Host: master server
Master_User: user
Master_Port: mysql master port
Connect_Retry: 60
Master_Log_File: bin.00001
Read_Master_Log_Pos: 4
Relay_Log_File: relay-bin.0001
Relay_Log_Pos: 4
Relay_Master_Log_File: bin.00001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Seconds_Behind_Master: 0
1 row in set (0.48 sec)
No comments:
Post a Comment