mysql> start slave;再次查看同步状态 show slave statusG; 都为 Yes
mysql> show slave statusG;*************************** 1. row ***************************Slave_IO_State: Waiting for master to send eventMaster_Host: 192.168.92.145Master_User: slaveMaster_Port: 3307Connect_Retry: 30Master_Log_File: mall-mysql-bin.000002Read_Master_Log_Pos: 617Relay_Log_File: mall-mysql-relay-bin.000002Relay_Log_Pos: 325Relay_Master_Log_File: mall-mysql-bin.000002Slave_IO_Running: Yes<---Slave_SQL_Running: Yes<---Replicate_Do_DB:Replicate_Ignore_DB:主从复制测试在主库新建库，新建表，插入数据
[root@localhost ~]# docker exec -it mysql-master /bin/bashroot@95fbd9f77daa:/# mysql -uroot -prootmysql> create database d1;Query OK, 1 row affected (0.00 sec)mysql> use d1;Database changedmysql> create table t1(id int, name char(10));Query OK, 0 rows affected (0.01 sec)mysql> insert into t1 values(1,'zhangsan');Query OK, 1 row affected (0.01 sec)mysql> exitBye在从库查看数据：
[root@localhost ~]# docker exec -it mysql-slave /bin/bashroot@81014d1dfdfa:/# root@81014d1dfdfa:/# mysql -uroot -prootmysql> use d1;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select * from t1;+------+----------+| id| name|+------+----------+|1 | zhangsan |+------+----------+1 row in set (0.00 sec)mysql> exitBye完成 。
推荐阅读
- 在vue3中使用vuex
- 揭秘镜子为什么不能对着床
- 真就嵌入了一个完整的安卓系统呗！Win11居然成功安装谷歌套件
- 有效安装谷歌商店google play store的谷歌框架
- JDK和Hadoop环境的安装
- Android 13 虚拟化技术支持安装 Windows 和 Linux 操作系统
- 使用 Docker Buildx 构建多种系统架构镜像
- Ps Adobe Photoshop2022软件下载安装教程
- 含安装包 PS教程：2022版本新功能，一键抠图，太厉害！
- docker背后的原理