技术开发 频道

Replication安装配置

  12.在slave上启动slave进程

  mysql> start slave;

  Query OK, 0 rows affected (0.00 sec)

  mysql> show warnings;

  Empty set (0.02 sec)

  mysql> show slave status \G;

  *************************** 1. row ***************************

  Slave_IO_State: Waiting for master to send event

  Master_Host: 192.168.60.3

  Master_User: repl

  Master_Port: 3306

  Connect_Retry: 60

  Master_Log_File: test2_log-bin.000003

  Read_Master_Log_Pos: 98

  Relay_Log_File: test1-relay-bin.000003

  Relay_Log_Pos: 239

  Relay_Master_Log_File: test2_log-bin.000003

  Slave_IO_Running: Yes ------可以看到启动了

  Slave_SQL_Running: Yes ------可以看到启动了

  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: 98

  Relay_Log_Space: 239

  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)

  ERROR:

  No query specified

  mysql> show processlist \G ;

  *************************** 1. row ***************************

  Id: 1

  User: root

  Host: localhost

  db: NULL

  Command: Query

  Time: 0

  State: NULL

  Info: show processlist

  *************************** 2. row ***************************

  Id: 2

  User: system user

  Host:

  db: NULL

  Command: Connect

  Time: 29

  State: Waiting for master to send event

  Info: NULL

  *************************** 3. row ***************************

  Id: 3

  User: system user

  Host:

  db: NULL

  Command: Connect

  Time: 18

  State: Has read all relay log; waiting for the slave I/O thread to update it

  Info: NULL

  3 rows in set (0.00 sec)

  ERROR:

  No query specified

0
相关文章