1、创建数据目录和配置文件: 1主1从举例
ds0 为主, ds1-3为从;
创建目录
mkdir /root/docker/db/ds0/data -p && \
mkdir /root/docker/db/ds1/data -p && \
mkdir /root/docker/db/ds0/conf -p && \
mkdir /root/docker/db/ds1/conf -p
创建配置文件
2、编辑配置文件my.cnf
ds0 主节点的配置文件:
vi /root/docker/db/ds0/conf/my.cnf
##主库配置
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
skip-host-cache
skip-name-resolve
datadir = /var/lib/mysql
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
# 下面是开启主从复制的配置,