使用laradock配置mysql主从同步

   ├── mysql  //laradock 自带的目录 我们用它作为master
│   ├── Dockerfile
│   ├── docker-entrypoint-initdb.d
│   │   └── createdb.sql.example
│   └── my.cnf
├── mysql2 //新建的slave库配置
│   ├── Dockerfile
│   ├── docker-entrypoint-initdb.d
│   │   └── createdb.sql.example
│   └── my.cnfCopy

log-bin=mysql-bin //启用二进制日志
server-id=1         //服务器标识Copy

log-bin=mysql-bin
server-id=2Copy

### MySQL ################################################
  mysql2:
 build: context: ./mysql2 //调整应用主目录
  args:
 - MYSQL_VERSION=${MYSQL_VERSION}
  environment:
 - MYSQL_DATABASE=${MYSQL_DATABASE}
  - MYSQL_USER=${MYSQL_USER}
  - MYSQL_PASSWORD=${MYSQL_PASSWORD}
  - MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
  - TZ=${WORKSPACE_TIMEZONE}
  volumes:
 - ${DATA_PATH_HOST}/mysql:/var/lib/mysql2 //调整映射目录
  - ${MYSQL_ENTRYPOINT_INITDB}:/docker-entrypoint-initdb.d
  ports:
 - "3307:3306" //我们只调整这一步 映射宿主机端口3307
  networks:
 - backend
Copy

$ docker-compose build mysql2
$ docker-compose up -d mysql mysql2Copy

$ docker-compose exec mysql bash
$ docker-compose exec mysql2 bashCopy

mysql -uroot -proot 
show master status;Copy

mysql> change master to
    -> master_host='192.168.135.211',
    -> master_user='root',
    -> master_log_file='mysql-bin.000005',
    -> master_log_pos=154,
    -> master_password='root';
Query OK, 0 rows affected, 2 warnings (0.01 sec)
mysql> start slave; 
Query OK, 0 rows affected (0.01 sec)
 show slave status\G;  //查看连接状态Copy

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;Copy