# cat /opt/docker-mysql/run.sh
#!/bin/bash
echo run mysql master
docker run -d \
--restart=always \
--privileged=true \
--name=mysql-master \
--hostname=mysql-master \
-p 3307:3306 \
-e MYSQL_ROOT_PASSWORD=root \
-v /etc/localtime:/etc/localtime \
-v /opt/docker-mysql/master/etc/my.cnf:/etc/mysql/my.cnf \
-v /opt/docker-mysql/master/data:/var/lib/mysql:rw \
harbor.mxnet.io/library/mysql:5.7
echo run mysql slave
docker run -d \
--restart=always \
--privileged=true \
--name=mysql-slave \
--hostname=mysql-slave \
-p 3308:3306 \
-e MYSQL_ROOT_PASSWORD=root \
-v /etc/localtime:/etc/localtime \
-v /opt/docker-mysql/slave/etc/my.cnf:/etc/mysql/my.cnf \
-v /opt/docker-mysql/slave/data:/var/lib/mysql:rw \
harbor.mxnet.io/library/mysql:5.7
cat /opt/docker-mysql/master/etc/my.cnf
[mysql]
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
#log-error = /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
lower_case_table_names = 1 #不区分大小写