docker搭建mysql读写分离数据库

朱雀 2021-03-24 14:55 475阅读 0赞

# mysql-master-slave-docker #

mysql主从数据库构建

### 第一步 ###

将两个容器启动起来,没有镜像会自己下

docker-compose up -d

### 第二步 ###

本地navacat分别连接到两个mysql

*  容器mysql101(主数据库)
    
    随便点进一个数据，创建查询
    
        show master status

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MDgyMzA0_size_16_color_FFFFFF_t_70]

为从数据库创建用户
    
    ```sql
    SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
    
    GRANT REPLICATION SLAVE ON *.* to 'backup'@'%' identified by '123456';
    ```

*  容器mysql102(从数据库)
    
        SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
        change master to master_host='www.niezhiliang.com',master_user='backup',master_password='123456',master_log_file='mysql-bin.000004',master_log_pos=958;
        
        	master_host为docker的地址不能写127.0.0.1
        	master_user是在主库创建的用户
        	master_log_pos是主库show master status;查询出的Position
    
    启动服务
    
        start slave;
        
        //查看服务状态
        show slave status;
        
        //Waiting for master to send event 就是成功了 
        //Connecting to master 多半是连接不通

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MDgyMzA0_size_16_color_FFFFFF_t_70 1]  
源码：[https://github.com/niezhiliang/mysql-master-slave-docker][https_github.com_niezhiliang_mysql-master-slave-docker]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MDgyMzA0_size_16_color_FFFFFF_t_70]: /images/20210324/1616597719151.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MDgyMzA0_size_16_color_FFFFFF_t_70 1]: /images/20210324/1616597694369.png
[https_github.com_niezhiliang_mysql-master-slave-docker]: https://github.com/niezhiliang/mysql-master-slave-docker