1、下载
<span class="token function">docker</span> pull mysql:8.0<span class="token function">docker</span> pull mysql:8.0docker pull mysql:8.0
2、提前创建好文件配置，以及数据卷的文件路径
<span class="token function">mkdir</span> -p /url/local/docker/mysql/log <span class="token function">mkdir</span> -p /url/local/docker/mysql/data <span class="token function">mkdir</span> -p /url/local/docker/mysql/conf <span class="token function">mkdir</span> -p /url/local/docker/mysql/mysql-files<span class="token function">mkdir</span> -p /url/local/docker/mysql/log <span class="token function">mkdir</span> -p /url/local/docker/mysql/data <span class="token function">mkdir</span> -p /url/local/docker/mysql/conf <span class="token function">mkdir</span> -p /url/local/docker/mysql/mysql-filesmkdir -p /url/local/docker/mysql/log mkdir -p /url/local/docker/mysql/data mkdir -p /url/local/docker/mysql/conf mkdir -p /url/local/docker/mysql/mysql-files
3、然后进入/url/local/docker/mysql/conf编辑my.conf文件
<span class="token function">vim</span> /url/local/docker/mysql/conf/my.conf<span class="token function">vim</span> /url/local/docker/mysql/conf/my.confvim /url/local/docker/mysql/conf/my.conf
<span class="token punctuation">[</span>mysql<span class="token punctuation">]</span> default-character-set<span class="token operator">=</span>utf8mb4 <span class="token punctuation">[</span>mysqld<span class="token punctuation">]</span> <span class="token assign-left variable">max_connections</span><span class="token operator">=</span><span class="token number">200</span> character-set-server<span class="token operator">=</span>utf8mb4 default-storage-engine<span class="token operator">=</span>INNODB<span class="token punctuation">[</span>mysql<span class="token punctuation">]</span> default-character-set<span class="token operator">=</span>utf8mb4 <span class="token punctuation">[</span>mysqld<span class="token punctuation">]</span> <span class="token assign-left variable">max_connections</span><span class="token operator">=</span><span class="token number">200</span> character-set-server<span class="token operator">=</span>utf8mb4 default-storage-engine<span class="token operator">=</span>INNODB[mysql] default-character-set=utf8mb4 [mysqld] max_connections=200 character-set-server=utf8mb4 default-storage-engine=INNODB
4、启动设置挂载目录
<span class="token function">docker</span> run <span class="token punctuation">\</span> --name mysql <span class="token punctuation">\</span> -d <span class="token punctuation">\</span> -p <span class="token number">3306</span>:3306 <span class="token punctuation">\</span> --restart unless-stopped <span class="token punctuation">\</span> -v /url/local/docker/mysql/log:/var/log/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql/data:/var/lib/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql/conf:/etc/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql/mysql-files:/var/lib/mysql-files <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span><span class="token number">123456</span> <span class="token punctuation">\</span> --privileged<span class="token operator">=</span>true <span class="token punctuation">\</span> mysql:8.0<span class="token function">docker</span> run <span class="token punctuation">\</span> --name mysql <span class="token punctuation">\</span> -d <span class="token punctuation">\</span> -p <span class="token number">3306</span>:3306 <span class="token punctuation">\</span> --restart unless-stopped <span class="token punctuation">\</span> -v /url/local/docker/mysql/log:/var/log/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql/data:/var/lib/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql/conf:/etc/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql/mysql-files:/var/lib/mysql-files <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span><span class="token number">123456</span> <span class="token punctuation">\</span> --privileged<span class="token operator">=</span>true <span class="token punctuation">\</span> mysql:8.0docker run \ --name mysql \ -d \ -p 3306:3306 \ --restart unless-stopped \ -v /url/local/docker/mysql/log:/var/log/mysql \ -v /url/local/docker/mysql/data:/var/lib/mysql \ -v /url/local/docker/mysql/conf:/etc/mysql \ -v /url/local/docker/mysql/mysql-files:/var/lib/mysql-files \ -e MYSQL_ROOT_PASSWORD=123456 \ --privileged=true \ mysql:8.0
说明：
1、-v：指定容器数据卷的位置，mysql安装完成后，在容器里面和容器外面挂载的数据同步执行，并且如果mysql容器被删除了，挂载到服务器上保存的数据也不会被删除。
2、如果直接启动命令，然后在执行文件的编辑也是可以的，需要编辑好文建好后，修改启动容器的脚本，然后执行docker restart mysql即可
<span class="token function">docker</span> <span class="token builtin class-name">exec</span> -it mysql /bin/bash mysql -u root -p use mysql update user <span class="token builtin class-name">set</span> <span class="token function">host</span> <span class="token operator">=</span> <span class="token string">'%'</span> where user <span class="token operator">=</span> <span class="token string">'root'</span> and <span class="token assign-left variable">host</span><span class="token operator">=</span><span class="token string">'localhost'</span><span class="token punctuation">;</span> GRANT ALL ON *.* TO <span class="token string">'root'</span>@<span class="token string">'%'</span><span class="token punctuation">;</span> flush privileges<span class="token punctuation">;</span> ALTER <span class="token environment constant">USER</span> <span class="token string">'root'</span>@<span class="token string">'%'</span> IDENTIFIED WITH mysql_native_password BY <span class="token string">'密码'</span><span class="token punctuation">;</span><span class="token function">docker</span> <span class="token builtin class-name">exec</span> -it mysql /bin/bash mysql -u root -p use mysql update user <span class="token builtin class-name">set</span> <span class="token function">host</span> <span class="token operator">=</span> <span class="token string">'%'</span> where user <span class="token operator">=</span> <span class="token string">'root'</span> and <span class="token assign-left variable">host</span><span class="token operator">=</span><span class="token string">'localhost'</span><span class="token punctuation">;</span> GRANT ALL ON *.* TO <span class="token string">'root'</span>@<span class="token string">'%'</span><span class="token punctuation">;</span> flush privileges<span class="token punctuation">;</span> ALTER <span class="token environment constant">USER</span> <span class="token string">'root'</span>@<span class="token string">'%'</span> IDENTIFIED WITH mysql_native_password BY <span class="token string">'密码'</span><span class="token punctuation">;</span>docker exec -it mysql /bin/bash mysql -u root -p use mysql update user set host = '%' where user = 'root' and host='localhost'; GRANT ALL ON *.* TO 'root'@'%'; flush privileges; ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
- 如果访问连接不到数据库则可能是端口没开放(购买的服务器的话则需要设置出栈入栈)
firewall-cmd –zone=public –add-port=3306/tcp –permanent && firewall-cmd –reload
1、编辑配置文件
<span class="token function">mkdir</span> -p /url/local/docker/mysql_master/mysql/log <span class="token function">mkdir</span> -p /url/local/docker/mysql_master/mysql/data <span class="token function">mkdir</span> -p /url/local/docker/mysql_master/mysql/conf <span class="token function">mkdir</span> -p /url/local/docker/mysql_master/mysql/mysql-files <span class="token function">vim</span> /url/local/docker/mysql_master/mysql/conf/my.conf<span class="token function">mkdir</span> -p /url/local/docker/mysql_master/mysql/log <span class="token function">mkdir</span> -p /url/local/docker/mysql_master/mysql/data <span class="token function">mkdir</span> -p /url/local/docker/mysql_master/mysql/conf <span class="token function">mkdir</span> -p /url/local/docker/mysql_master/mysql/mysql-files <span class="token function">vim</span> /url/local/docker/mysql_master/mysql/conf/my.confmkdir -p /url/local/docker/mysql_master/mysql/log mkdir -p /url/local/docker/mysql_master/mysql/data mkdir -p /url/local/docker/mysql_master/mysql/conf mkdir -p /url/local/docker/mysql_master/mysql/mysql-files vim /url/local/docker/mysql_master/mysql/conf/my.conf
<span class="token punctuation">[</span>mysqld<span class="token punctuation">]</span> <span class="token assign-left variable">server_id</span><span class="token operator">=</span><span class="token number">101</span> binlog-ignore-db<span class="token operator">=</span>mysql log-bin<span class="token operator">=</span>mall-mysql-bin <span class="token assign-left variable">binlog_cache_size</span><span class="token operator">=</span>1M <span class="token assign-left variable">binlog_format</span><span class="token operator">=</span>mixed <span class="token assign-left variable">expire_logs_days</span><span class="token operator">=</span><span class="token number">7</span> <span class="token assign-left variable">slave_skip_errors</span><span class="token operator">=</span><span class="token number">1062</span><span class="token punctuation">[</span>mysqld<span class="token punctuation">]</span> <span class="token assign-left variable">server_id</span><span class="token operator">=</span><span class="token number">101</span> binlog-ignore-db<span class="token operator">=</span>mysql log-bin<span class="token operator">=</span>mall-mysql-bin <span class="token assign-left variable">binlog_cache_size</span><span class="token operator">=</span>1M <span class="token assign-left variable">binlog_format</span><span class="token operator">=</span>mixed <span class="token assign-left variable">expire_logs_days</span><span class="token operator">=</span><span class="token number">7</span> <span class="token assign-left variable">slave_skip_errors</span><span class="token operator">=</span><span class="token number">1062</span>[mysqld] server_id=101 binlog-ignore-db=mysql log-bin=mall-mysql-bin binlog_cache_size=1M binlog_format=mixed expire_logs_days=7 slave_skip_errors=1062
2、启动mysql主服务
<span class="token function">docker</span> run <span class="token punctuation">\</span> --name mysql-master <span class="token punctuation">\</span> -d <span class="token punctuation">\</span> -p <span class="token number">3306</span>:3306 <span class="token punctuation">\</span> --restart unless-stopped <span class="token punctuation">\</span> -v /url/local/docker/mysql_master/mysql/log:/var/log/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql_master/mysql/data:/var/lib/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql_master/mysql/conf:/etc/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql_master/mysql/mysql-files:/var/lib/mysql-files <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span><span class="token number">123456</span> <span class="token punctuation">\</span> --privileged<span class="token operator">=</span>true <span class="token punctuation">\</span> mysql:8.0<span class="token function">docker</span> run <span class="token punctuation">\</span> --name mysql-master <span class="token punctuation">\</span> -d <span class="token punctuation">\</span> -p <span class="token number">3306</span>:3306 <span class="token punctuation">\</span> --restart unless-stopped <span class="token punctuation">\</span> -v /url/local/docker/mysql_master/mysql/log:/var/log/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql_master/mysql/data:/var/lib/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql_master/mysql/conf:/etc/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql_master/mysql/mysql-files:/var/lib/mysql-files <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span><span class="token number">123456</span> <span class="token punctuation">\</span> --privileged<span class="token operator">=</span>true <span class="token punctuation">\</span> mysql:8.0docker run \ --name mysql-master \ -d \ -p 3306:3306 \ --restart unless-stopped \ -v /url/local/docker/mysql_master/mysql/log:/var/log/mysql \ -v /url/local/docker/mysql_master/mysql/data:/var/lib/mysql \ -v /url/local/docker/mysql_master/mysql/conf:/etc/mysql \ -v /url/local/docker/mysql_master/mysql/mysql-files:/var/lib/mysql-files \ -e MYSQL_ROOT_PASSWORD=123456 \ --privileged=true \ mysql:8.0
3、重启mysql
<span class="token function">docker</span> restart mysql-master<span class="token function">docker</span> restart mysql-masterdocker restart mysql-master
4、进入容器里面
<span class="token function">docker</span> <span class="token builtin class-name">exec</span> -it mysql-master <span class="token function">bash</span> mysql -uroot -p123456<span class="token function">docker</span> <span class="token builtin class-name">exec</span> -it mysql-master <span class="token function">bash</span> mysql -uroot -p123456docker exec -it mysql-master bash mysql -uroot -p123456
5、master容器实力内创建同步用户
CREATE <span class="token environment constant">USER</span> <span class="token string">'slave'</span>@<span class="token string">'%'</span> IDENTIFIED BY <span class="token string">'123456'</span><span class="token punctuation">;</span> GRANT REPLICATION SLAVE,REPLICATION CLIENT ON*.* TO <span class="token string">'slave'</span>@<span class="token string">'%'</span><span class="token punctuation">;</span>CREATE <span class="token environment constant">USER</span> <span class="token string">'slave'</span>@<span class="token string">'%'</span> IDENTIFIED BY <span class="token string">'123456'</span><span class="token punctuation">;</span> GRANT REPLICATION SLAVE,REPLICATION CLIENT ON*.* TO <span class="token string">'slave'</span>@<span class="token string">'%'</span><span class="token punctuation">;</span>CREATE USER 'slave'@'%' IDENTIFIED BY '123456'; GRANT REPLICATION SLAVE,REPLICATION CLIENT ON*.* TO 'slave'@'%';
- 1、新建挂载文件
<span class="token function">mkdir</span> -vp /url/local/docker/mysql-slave<span class="token function">mkdir</span> -vp /url/local/docker/mysql-slavemkdir -vp /url/local/docker/mysql-slave
2、编辑从服务的配置文件
<span class="token function">mkdir</span> -p /url/local/docker/mysql-slave/mysql/log <span class="token function">mkdir</span> -p /url/local/docker/mysql-slave/mysql/data <span class="token function">mkdir</span> -p /url/local/docker/mysql-slave/mysql/conf <span class="token function">mkdir</span> -p /url/local/docker/mysql-slave/mysql/mysql-files <span class="token function">vim</span> /url/local/docker/mysql-slave/mysql/conf/my.conf<span class="token function">mkdir</span> -p /url/local/docker/mysql-slave/mysql/log <span class="token function">mkdir</span> -p /url/local/docker/mysql-slave/mysql/data <span class="token function">mkdir</span> -p /url/local/docker/mysql-slave/mysql/conf <span class="token function">mkdir</span> -p /url/local/docker/mysql-slave/mysql/mysql-files <span class="token function">vim</span> /url/local/docker/mysql-slave/mysql/conf/my.confmkdir -p /url/local/docker/mysql-slave/mysql/log mkdir -p /url/local/docker/mysql-slave/mysql/data mkdir -p /url/local/docker/mysql-slave/mysql/conf mkdir -p /url/local/docker/mysql-slave/mysql/mysql-files vim /url/local/docker/mysql-slave/mysql/conf/my.conf
vim /url/local/docker/mysql-slave/mysql/conf/my.conf
3、编辑从服务里面的文件 ```shell [mysqld] ## 设置server_id，同一局域网中需要唯一 server_id=102 ## 指定不需要同步的数据库名称 binlog-ignore-db=mysql ## 开启二进制日志功能，以备Slave作为其它数据库实例的Master时使用 log-bin=mall-mysql-slave1-bin ## 设置二进制日志使用内存大小（事务） binlog_cache_size=1M ## 设置使用的二进制日志格式（mixed,statement,row） binlog_format=mixed ## 二进制日志过期清理时间。默认值为0，表示不自动清理。 expire_logs_days=7 ## 跳过主从复制中遇到的所有错误或指定类型的错误，避免slave端复制中断。 ## 如：1062错误是指一些主键重复，1032错误是因为主从数据库数据不一致 slave_skip_errors=1062 ## relay_log配置中继日志 relay_log=mall-mysql-relay-bin ## log_slave_updates表示slave将复制事件写进自己的二进制日志 log_slave_updates=1 ## slave设置为只读（具有super权限的用户除外） read_only=13、编辑从服务里面的文件 ```shell [mysqld] ## 设置server_id，同一局域网中需要唯一 server_id=102 ## 指定不需要同步的数据库名称 binlog-ignore-db=mysql ## 开启二进制日志功能，以备Slave作为其它数据库实例的Master时使用 log-bin=mall-mysql-slave1-bin ## 设置二进制日志使用内存大小（事务） binlog_cache_size=1M ## 设置使用的二进制日志格式（mixed,statement,row） binlog_format=mixed ## 二进制日志过期清理时间。默认值为0，表示不自动清理。 expire_logs_days=7 ## 跳过主从复制中遇到的所有错误或指定类型的错误，避免slave端复制中断。 ## 如：1062错误是指一些主键重复，1032错误是因为主从数据库数据不一致 slave_skip_errors=1062 ## relay_log配置中继日志 relay_log=mall-mysql-relay-bin ## log_slave_updates表示slave将复制事件写进自己的二进制日志 log_slave_updates=1 ## slave设置为只读（具有super权限的用户除外） read_only=13、编辑从服务里面的文件 ```shell [mysqld] ## 设置server_id，同一局域网中需要唯一 server_id=102 ## 指定不需要同步的数据库名称 binlog-ignore-db=mysql ## 开启二进制日志功能，以备Slave作为其它数据库实例的Master时使用 log-bin=mall-mysql-slave1-bin ## 设置二进制日志使用内存大小（事务） binlog_cache_size=1M ## 设置使用的二进制日志格式（mixed,statement,row） binlog_format=mixed ## 二进制日志过期清理时间。默认值为0，表示不自动清理。 expire_logs_days=7 ## 跳过主从复制中遇到的所有错误或指定类型的错误，避免slave端复制中断。 ## 如：1062错误是指一些主键重复，1032错误是因为主从数据库数据不一致 slave_skip_errors=1062 ## relay_log配置中继日志 relay_log=mall-mysql-relay-bin ## log_slave_updates表示slave将复制事件写进自己的二进制日志 log_slave_updates=1 ## slave设置为只读（具有super权限的用户除外） read_only=1
4、启动mysql从服务
<span class="token function">docker</span> run -p <span class="token number">3308</span>:3306 --name mysql-slave <span class="token punctuation">\</span> -v /url/local/docker/mysql-slave/mysql/log:/var/log/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql-slave/mysql/data:/var/lib/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql-slave/mysql/conf:/etc/mysql <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span><span class="token number">123456</span> <span class="token punctuation">\</span> -d mysql:8.0<span class="token function">docker</span> run -p <span class="token number">3308</span>:3306 --name mysql-slave <span class="token punctuation">\</span> -v /url/local/docker/mysql-slave/mysql/log:/var/log/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql-slave/mysql/data:/var/lib/mysql <span class="token punctuation">\</span> -v /url/local/docker/mysql-slave/mysql/conf:/etc/mysql <span class="token punctuation">\</span> -e <span class="token assign-left variable">MYSQL_ROOT_PASSWORD</span><span class="token operator">=</span><span class="token number">123456</span> <span class="token punctuation">\</span> -d mysql:8.0docker run -p 3308:3306 --name mysql-slave \ -v /url/local/docker/mysql-slave/mysql/log:/var/log/mysql \ -v /url/local/docker/mysql-slave/mysql/data:/var/lib/mysql \ -v /url/local/docker/mysql-slave/mysql/conf:/etc/mysql \ -e MYSQL_ROOT_PASSWORD=123456 \ -d mysql:8.0
5、启动slave容器(如果先启动，后指定容器数据卷路径，需要执行此操作)
<span class="token function">docker</span> restart mysql-slave<span class="token function">docker</span> restart mysql-slavedocker restart mysql-slave
6、在主库中查看主从同步状态
show master status<span class="token punctuation">;</span>show master status<span class="token punctuation">;</span>show master status;
7、进入从服务器的容器内不
<span class="token function">docker</span> <span class="token builtin class-name">exec</span> -it mysql-slave <span class="token function">bash</span> mysql -uroot -p123456<span class="token function">docker</span> <span class="token builtin class-name">exec</span> -it mysql-slave <span class="token function">bash</span> mysql -uroot -p123456docker exec -it mysql-slave bash mysql -uroot -p123456
8、在数据库中配置主从复制
change master to <span class="token assign-left variable">master_host</span><span class="token operator">=</span><span class="token string">'宿主机ip'</span>, <span class="token assign-left variable">master_user</span><span class="token operator">=</span><span class="token string">'slave'</span>, <span class="token assign-left variable">master_password</span><span class="token operator">=</span><span class="token string">'123456'</span>, <span class="token assign-left variable">master_port</span><span class="token operator">=</span><span class="token number">3307</span>, <span class="token assign-left variable">master_log_file</span><span class="token operator">=</span><span class="token string">'mall-mysql-bin.000001'</span>, <span class="token assign-left variable">master_log_pos</span><span class="token operator">=</span><span class="token number">617</span>, <span class="token assign-left variable">master_connect_retry</span><span class="token operator">=</span><span class="token number">30</span><span class="token punctuation">;</span>change master to <span class="token assign-left variable">master_host</span><span class="token operator">=</span><span class="token string">'宿主机ip'</span>, <span class="token assign-left variable">master_user</span><span class="token operator">=</span><span class="token string">'slave'</span>, <span class="token assign-left variable">master_password</span><span class="token operator">=</span><span class="token string">'123456'</span>, <span class="token assign-left variable">master_port</span><span class="token operator">=</span><span class="token number">3307</span>, <span class="token assign-left variable">master_log_file</span><span class="token operator">=</span><span class="token string">'mall-mysql-bin.000001'</span>, <span class="token assign-left variable">master_log_pos</span><span class="token operator">=</span><span class="token number">617</span>, <span class="token assign-left variable">master_connect_retry</span><span class="token operator">=</span><span class="token number">30</span><span class="token punctuation">;</span>change master to master_host='宿主机ip', master_user='slave', master_password='123456', master_port=3307, master_log_file='mall-mysql-bin.000001', master_log_pos=617, master_connect_retry=30;
- 参数说明
master_host：主数据库的IP地址；
master_port：主数据库的运行端口；
master_user：在主数据库创建的用于同步数据的用户账号；
master_password：在主数据库创建的用于同步数据的用户密码；
master_log_file：指定从数据库要复制数据的日志文件，通过查看主数据的状态，获取File参数；
master_log_pos：指定从数据库从哪个位置开始复制数据，通过查看主数据的状态，获取Position参数；
master_connect_retry：连接失败重试的时间间隔，单位为秒。
9、从数据库中查看主从同步状态
show skave status <span class="token punctuation">\</span>G<span class="token punctuation">;</span>show skave status <span class="token punctuation">\</span>G<span class="token punctuation">;</span>show skave status \G;
10、在从数据库中开启主从同步进入从数据库中
start slave<span class="token punctuation">;</span>start slave<span class="token punctuation">;</span>start slave;
11、查看从数据库状态发现已经同步
Slave_IO_Running: <span class="token function">yes</span> Slave_SQL_Running: <span class="token function">yes</span>Slave_IO_Running: <span class="token function">yes</span> Slave_SQL_Running: <span class="token function">yes</span>Slave_IO_Running: yes Slave_SQL_Running: yes
eg:主机新建库，使用库-新建表，插入数据 ok 从机使用库-查看记录，ok
原文链接：https://blog.csdn.net/www1056481167/article/details/125551759
© 版权声明
声明📢本站内容均来自互联网，归原创作者所有，如有侵权必删除。
本站文章皆由CC-4.0协议发布，如无来源则为原创，转载请注明出处。
THE END
