我在ubuntu 16.04 LTS中使用mysqlrouter版本8.0.18,我已经设置了具有两个节点的mysql 5.7 innoDb集群,并且运行良好,我在此处附加了集群状态
当我在两个mysql实例中都选中show process list时,我可以始终看到仅与路由器连接的主实例,而不与任何路由器连接的辅助实例,我已附加了以下每个节点的屏幕截图
这也是我的路由器配置文件
# File automatically generated during MySQL Router bootstrap
[DEFAULT]
name=system
user=mysqlrouter
keyring_path=/run/mysqlrouter/keyring
master_key_path=/etc/mysqlrouter/mysqlrouter.key
connect_timeout=15
read_timeout=30
dynamic_state=/run/mysqlrouter/state.json
[logger]
level = INFO
[metadata_cache:sharjahCluster]
router_id=2
user=mysql_router2_wvgl33nmqoci
metadata_cluster=sharjahCluster
ttl=0.5
use_gr_notifications=0
[routing:sharjahCluster_default_rw]
bind_address=0.0.0.0
bind_port=6446
destinations=metadata-cache://sharjahCluster/default?role=PRIMARY
routing_strategy=first-available
protocol=classic
[routing:sharjahCluster_default_ro]
bind_address=0.0.0.0
bind_port=6447
destinations=metadata-cache://sharjahCluster/default?role=SECONDARY
routing_strategy=round-robin-with-fallback
protocol=classic
[routing:sharjahCluster_default_x_rw]
bind_address=0.0.0.0
bind_port=64460
destinations=metadata-cache://sharjahCluster/default?role=PRIMARY
routing_strategy=first-available
protocol=x
[routing:sharjahCluster_default_x_ro]
bind_address=0.0.0.0
bind_port=64470
destinations=metadata-cache://sharjahCluster/default?role=SECONDARY
routing_strategy=round-robin-with-fallback
protocol=x
我在数据库配置中使用codeignitor应用程序,我为主机名参数指定了127.0.0.1:6446,我希望路由器将选择查询动态路由到从属节点,但是在show processlist命令中,我看不到从属中的任何查询或路由器连接节点
我仍然感到困惑,我是否缺少任何配置? 请帮助我
谢谢