lvhejin 发表于 2026-1-16 19:11:14

读写分离

本帖最后由 lvhejin 于 2026-1-28 11:10 编辑

8.4.4-4版本的数据库
greatsql-mysql-router-8.0.32-25.1.el8.x86_64.rpm;支持8.4.4-4版本的MGR数据库集群吗?   有没有ARM64架构版本?

版本需要统一吗?

第一个问题:


配置信息:

# cat /etc/mysql-router/mysqlrouter.conf

# 基础配置
logging_folder = /var/log/mysql-router
plugin_folder = /usr/local/mysql-router/lib/mysqlrouter
runtime_folder = /var/run/mysql-router
config_folder = /etc/mysql-router
# 运行用户
user = mysqlrouter
#keyring_encrypted = no


# 日志配置 # 日志级别:DEBUG/INFO/WARN/ERROR
level = INFO
destination = file:/var/log/mysql-router/mysqlrouter.log
# 日志轮转大小
rotation_size = 100M
# 保留5个日志文件
rotation_files = 5


# MGR集群引导配置(核心)
# MGR复制用户(你的集群用户)
user = rpl_user
# 替换为实际密码
password = 123456789
# MGR所有节点
addresses = 192.168.0.8:3308,192.168.0.9:3308
# 读写分离模式(自动路由写请求到主节点)
mode = read_write_split
# 主节点选择策略
routing_strategy = first-available


# 读写分离端口配置
# 写端口(仅路由到MGR主节点)
read_write_port = 6446
# 读端口(路由到所有从节点)
read_only_port = 6447


# MGR元数据缓存(关键)
cluster_type = group_replication
# 缓存过期时间(秒)
ttl = 30
# 刷新间隔(秒)
refresh_interval = 5异常:

# /usr/local/mysql-router/bin/mysqlrouter --config /etc/mysql-router/mysqlrouter.conf
Encryption key for router keyring:
Error: Failure reading contents of keyring file /usr/local/mysql-router-8.4.8-linux-glibc2.28-aarch64/var/lib/mysqlrouter/keyring
Stopping 'MySQL Router', version: 8.4.8 (MySQL Community - GPL), reason: REQUESTED (Signal Terminated sent by UID: 994 and PID: 3166236)


reddey 发表于 2026-1-16 20:02:15

感觉版本不对头

yejr 发表于 2026-1-17 22:49:00

用MySQL Router 8.4.4吧

lvhejin 发表于 2026-1-21 11:29:03

yejr 发表于 2026-1-17 22:49
用MySQL Router 8.4.4吧
您好,请问:再哪里下载MySQL Router 8.4.4 ARM64的包?下载地址是?

yejr 发表于 昨天 13:51

参考MySQL Router手册,猜测是你没有先进行Bootstrapping操作导致

https://dev.mysql.com/doc/mysql-router/8.4/en/mysql-router-deploying-bootstrapping.html
页: [1]
查看完整版本: 读写分离