主库 192.168.16.161:3306
备库 192.168.16.162:3306
主从切换,基于主从
主备节点都要创建一个用户
MariaDB [(none)]> grant replication slave on *.* to 'wan'@'192.168.16.%' identified by '123';
Query OK, 0 rows affected (0.00 sec)
查询主库状态
MariaDB [(none)]> show slave hosts;
+-----------+------+------+-----------+
| Server_id | Host | Port | Master_id |
+-----------+------+------+-----------+
| 2 | | 3306 | 1 |
+-----------+------+------+-----------+
从库停止IO_THREAD线程
//从库上操作 192.168.16.162
MariaDB [(none)