docker mysql连接不上_一文学会使用docker安装MySQL主从数据库

一、mysql安装步骤

1. 拉取docker pull mysql:5.7
2. docker-compose安装
   1. sudo curl -L https://github.com/docker/compose/releases/download/1.17.1/docker-compose-`uname -s`-`uname -m` > /usr/local/bin/docker-compose
   2. sudo chmod +x /usr/local/bin/docker-compose
3. 创建mysql主从库配置目录
   1. mkdir -p /data1/mysql/master/conf
   2. mkdir -p /data1/mysql/slave/conf
4. 在主库 /data1/mysql/master/conf创建my.cnf配置文件

[client]port=3306default-character-set=utf8[mysql]default-character-set=utf8[mysqld]character_set_server=utf8sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES# 配置大小写不敏感lower_case_table_names=1# 同一局域网内注意要唯一server-id=100  # 开启二进制日志功能(关键)log-bin=mysql-bin

5. 在从库 /data1/mysql/slave/conf创建my.cnf配置文件

[client]port=3306default-character-set=utf8[mysql]default-character-set=utf8[mysqld]character_set_server=utf8sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES# 配置大小写不敏感lower_case_table_names=1# 同一局域网内注意要唯一server-id=200  

6. 使用docker-compose来管理mysql主从库
   1. vi /data1/mysql/docker-compose.yaml (配置文件如下：)

version: '3'services:  mysql-slave:    image: mysql:5.7    depends_on:      - mysql-master    links:      - mysql-master    volumes:      - /data1/mysql/slave/data:/var/lib/mysql      - /data1/mysql/slave/conf:/etc/mysql      - /data1/mysql/slave/log:/var/log/mysql    ports:         - "3308:3306"    restart: always    environment:      MYSQL_ROOT_PASSWORD: root    container_name: mysql-slave  mysql-master:    image: mysql:5.7    volumes:      - /data1/mysql/master/data:/var/lib/mysql      - /data1/mysql/master/conf:/etc/mysql      - /data1/mysql/master/log:/var/log/mysql    ports:         - "3307:3306"    restart: alwaysdocker pull mysql:5.7    environment:      MYSQL_ROOT_PASSWORD: root    container_name: mysql-master

7. 启动compose来启动mysql
   1. cd /data1/mysql
   2. docker-compose up -d

8. 查看docker容器是否在运行

9. 主数据库配置，连接主库并创建数据同步用户
   1. 使用Navicat for MySQL 连接上主库
   2. 创建同步账号：CREATE USER 'slave'@'%' IDENTIFIED BY '123456';
   3. 授权：GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'slave'@'%';
   4. SHOW MASTER STATUS ;

10. 从数据库配置，连接从库配置从库同步连接(指定连接的ip/port/user/passwd以及上图中show master status命令得到的file和position值)
    1. 使用Navicat for MySQL 连接上从库
    2. CHANGE MASTER TO MASTER_HOST='192.168.183.134',MASTER_PORT=3307,MASTER_USER='slave',MASTER_PASSWORD='123456',MASTER_LOG_FILE='mysql-bin.000003',MASTER_LOG_POS=609;
    3. 启动同步进程：START SLAVE;

11. 测试结果状态
    1. 主库查询进程：SHOW PROCESSLIST

11. 1. 从库查询进程：SHOW PROCESSLIST

12. 到此安装完成，更多my.cnf请自行配置