主从: 有关主从设置的一些命令

查看主服务器运行状态

mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000005 |      407 | go           | mysql            |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

查看从服务器主机列表

mysql> show slave hosts;
+-----------+------+------+-----------+--------------------------------------+
| Server_id | Host | Port | Master_id | Slave_UUID                           |
+-----------+------+------+-----------+--------------------------------------+
|         2 |      | 3306 |         1 | e8cfd148-665e-11e9-ac44-000c294a58de |
+-----------+------+------+-----------+--------------------------------------+
1 row in set (0.00 sec)

获取binlog文件列表

mysql> show binary logs;
+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
| mysql-bin.000001 |      6155 |
| mysql-bin.000002 |       839 |
| mysql-bin.000003 |       753 |
| mysql-bin.000004 |       668 |
| mysql-bin.000005 |       407 |
+------------------+-----------+
5 rows in set (0.00 sec)

只查看第一个binlog文件的内容

查看指定binlog的文件的内容

启动从库复制线程

停止从库复制线程

查看从服务器状态

查看mysql的线程信息

Previous主从: MySQL 从节点设置多线程复制Next问 题

Last updated

Was this helpful?