江苏龙网

  1. 主页 > 生活百科 > >

Docker安装mysql5.7.37主从( 二 )

docker


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完成 。




推荐阅读


上一篇：程序员与体面的公务员，到底怎么选？现在有结果了

下一篇：玩转SpringBoot 跨域问题的 3 种方案