Docker安装MySQL8(实战篇)

相关配置

创建目录

mkdir -p /home/datadev/testmysql/conf

创建MySQL的配置文件

vim /home/datadev/testmysql/conf/my.cnf

[mysqld]
server-id=1
log-bin=mysql-bin
binlog-format=ROW
gtid_mode=ON
enforce_gtid_consistency=true

启动

启动MySQL容器

sudo docker run -d \
  --restart=always \
  --name=mysql85-server \
  -p 3311:3306 \
  -e MYSQL_ROOT_PASSWORD=123456 \
  -v /home/datadev/testmysql/conf:/etc/mysql/conf.d \
  -e MYSQL_ROOT_HOST=% \
  mysql:8.0.28

启动mysql容器要等6分钟左右才能够连接。

配置GTID

SET @@GLOBAL.GTID_MODE = ON;
SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = ON;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
FLUSH PRIVILEGES;

查看GTID是否可用

-- 查看是否开启gtid
SHOW VARIABLES LIKE 'gtid_mode';
-- 查看已执行的GTID集合
SELECT @@GLOBAL.gtid_executed;
SHOW VARIABLES LIKE 'binlog_format';