前言
个人博客使用了阿里云的服务器,此文是笔者实现WordPress+Docker+MySQL主从同步架构的记录。
环境
Docker version 1.13.1
LNMP:
- 阿里云centos 7.3
- nginx version: nginx/1.12.2
- mysql5.6(Docker镜像)
- PHP 5.4.16
WordPress:
- wordpress-4.9.4-zh_CN.zip
步骤
LNMP结构已经搭建好这里不再累赘,Docker搭建MySQL主从两个容器映射到了主机的3307端口(MySQL主节点)和3307端口(MySQL从节点)。
1、下载mysql5.6镜像
[root@tender]# docker pull mysql:5.6
2、为容器创建映射的配置文件目录、数据目录、和日志目录
[root@tender]# tree .
├── mysql_master
│ ├── conf
│ ├── data
│ └── logs
├── mysql_slave
├── conf
├── data
└── logs
3、在mysql_master、mysql_slave的conf文件夹下创建MySQL主从结构配置文件,映射给容器时会使用这个配置文件启动MySQL。
mysql_master
[root@tender]# vim mysql_master/conf/my.cnf
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
symbolic-links=0
character-set-server = utf8
#skip-networking
innodb_print_all_deadlocks = 1
max_connections = 2000
max_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 128
max_allowed_packet = 4M
binlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 16M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 28M
key_buffer_size = 4M
thread_cache_size = 8
query_cache_type = 1
query_cache_size = 8