MySQL Router安装和读写分离实现

MySQL Router 安装

解压缩，修改路径名字
root@ubuntu06:/usr/local/mysql_install_package# tar xvf mysql-router-8.3.0-linux-glibc2.28-x86_64.tar.xz
root@ubuntu06:/usr/local/mysql_install_package# mv mysql-router-8.3.0-linux-glibc2.28-x86_64 mysql-router8.3
root@ubuntu06:/usr/local/mysql_install_package# cd mysql-router8.3
创建一个router服务的数据路径router
root@ubuntu06:/usr/local/mysql-router8.3# mkdir router
root@ubuntu06:/usr/local/mysql-router8.3# cd router
在router路径下创建data log config run
root@ubuntu06:/usr/local/mysql-router8.3/router# mkdir data log config run

用解压包中的配置文件模板，依据当前的主从复制，编辑router的配置文件

[DEFAULT]
logging_folder = /usr/local/mysql-router8.3/router/log
plugin_folder = /usr/local/mysql-router8.3/lib/mysqlrouter
config_folder = /usr/local/mysql-router8.3/router/config
runtime_folder = /usr/local/mysql-router8.3/router/run
data_folder = /usr/local/mysql-router8.3/router/data
#keyring_path = /var/lib/keyring-data
#master_key_path = /var/lib/keyring-key
[logger]
level = INFO
filename = mysqlrouter.log
timestamp_precision = second
[routing:basic_failover]
# To be more transparent, use MySQL Server port 3306
bind_address = 0.0.0.0
bind_port = 7001
routing_strategy = first-available
mode = read-write
destinations = 192.168.152.112:8000,192.168.152.113:8000
[routing:load_balance]
bind_address = 0.0.0.0
bind_port = 7002
#routing_strategy = first-available
mode = read-only
destinations = 192.168.152.113:8000,192.168.152.112:8000
# If no plugin is configured which starts a service, keepalive
# will make sure MySQL Router will not immediately exit. It is
# safe to remove once Router is configured.
[keepalive]
interval = 60

MySQL Router systemd服务脚本

MySQL Router systemd服务脚本如下

[Unit]
Description=Percona MySQL Router
After=network.target
After=syslog.target
[Service]
Type=notify
User=mysql
Group=mysql
# Start main service
ExecStart=/usr/local/mysql-router8.3/bin/mysqlrouter -c /usr/local/mysql-router8.3/router/config/mysqlrouter.conf
# Sets open_files_limit
LimitNOFILE = 100000
Restart=on-failure
PrivateTmp=true
[Install]
WantedBy=multi-user.target

编辑好MySQL systemd配置文件后，reload