创建目录和配置文件

  1. mkdir -p mysql_sharding/{mysql_3306/config,mysql_3307/config} \
  2. && touch mysql_sharding/mysql_3306/config/my.cnf \
  3. && touch mysql_sharding/mysql_3307/config/my.cnf \
  4. && touch mysql_sharding/docker-compose.yml

编辑配置文件

mysql_3306/config/my.cnf

  1. [mysqld]
  2. # 解决docker启动连接慢的问题
  3. skip-name-resolve
  5. server-id=1
  6. port=3306
  7. default-storage-engine=INNODB
  8. character_set_server=utf8
  9. init_connect='SET NAMES utf8'
  10. lower_case_table_names=1
  11. max_connections=200
  12. max_connect_errors=10
  14. # 开启二进制日志
  15. log-bin=mysql-bin
  16. log_bin-index=mysql-bin.index
  17. log_bin_trust_function_creators=ON
  18. binlog-format=ROW
  20. # 设置自增起始偏移量
  21. auto_increment_offset=1
  22. # 设置自增步长
  23. auto_increment_increment=1
  25. # 开启慢查询日志
  26. slow_query_log=ON
  27. # 设置慢查询时间阈值
  28. long_query_time=1
  29. # 设置慢查询日志文件位置
  30. slow_query_log_file=/var/lib/mysql/slow_query.log

mysql_3307/config/my.cnf

  1. [mysqld]
  2. # 解决docker启动连接慢的问题
  3. skip-name-resolve
  5. server-id=2
  6. port=3307
  7. default-storage-engine=INNODB
  8. character_set_server=utf8
  9. init_connect='SET NAMES utf8'
  10. lower_case_table_names=1
  11. max_connections=200
  12. max_connect_errors=10
  14. # 开启二进制日志
  15. log-bin=mysql-bin
  16. log_bin-index=mysql-bin.index
  17. log_bin_trust_function_creators=ON
  18. binlog-format=ROW
  20. # 设置自增起始偏移量
  21. auto_increment_offset=1
  22. # 设置自增步长
  23. auto_increment_increment=1
  25. # 开启慢查询日志
  26. slow_query_log=ON
  27. # 设置慢查询时间阈值
  28. long_query_time=1
  29. # 设置慢查询日志文件位置
  30. slow_query_log_file=/var/lib/mysql/slow_query.log

mysql_master_slave/docker-compose.yml

  1. version: '3'
  2. services:
  3.   mysql_3306:
  4.     image: mysql:8.0.21
  5.     container_name: mysql_3306
  6.     ports:
  7.       - 3306:3306
  8.     privileged: true
  9.     volumes:
  10.       - ./mysql_3306/config:/etc/mysql/conf.d
  11.       - ./mysql_3306/data:/var/lib/mysql
  12.       - ./mysql_3306/logs:/var/log/mysql
  13.     environment:
  14.       - MYSQL_ROOT_PASSWORD=root
  15.       - MYSQL_USER=admin
  16.       - MYSQL_PASSWORD=admin
  17.       - TZ=Asia/Shanghai
  19.   mysql_3307:
  20.     image: mysql:8.0.21
  21.     container_name: mysql_3307
  22.     ports:
  23.       - 3307:3307
  24.     privileged: true
  25.     volumes:
  26.       - ./mysql_3307/config:/etc/mysql/conf.d
  27.       - ./mysql_3307/data:/var/lib/mysql
  28.       - ./mysql_3307/logs:/var/log/mysql
  29.     environment:
  30.       - MYSQL_ROOT_PASSWORD=root
  31.       - MYSQL_USER=admin
  32.       - MYSQL_PASSWORD=admin
  33.       - TZ=Asia/Shanghai
  35. networks:
  36.   default:
  37.     external:
  38.       name: service_network

启动服务

  1. docker-compose up -d