router bootstrap sets all nodes to RO
I'm trying to set up router in a 3 node cluster. I have the cluster set up and it looks like this
{
"clusterName": "N7QNMCluster",
"defaultReplicaSet": {
"name": "default",
"primary": "mysql1:3306",
"ssl": "REQUIRED",
"status": "OK",
"statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",
"topology": {
"mysql1:3306": {
"address": "mysql1:3306",
"memberRole": "PRIMARY",
"mode": "R/W",
"readReplicas": {},
"replicationLag": "applier_queue_applied",
"role": "HA",
"status": "ONLINE",
"version": "8.4.2"
},
"mysql2:3306": {
"address": "mysql2:3306",
"memberRole": "SECONDARY",
"mode": "R/O",
"readReplicas": {},
"replicationLag": "applier_queue_applied",
"role": "HA",
"status": "ONLINE",
"version": "8.4.2"
},
"mysql3:3306": {
"address": "mysql3:3306",
"memberRole": "SECONDARY",
"mode": "R/O",
"readReplicas": {},
"replicationLag": "applier_queue_applied",
"role": "HA",
"status": "ONLINE",
"version": "8.4.2"
}
},
"topologyMode": "Single-Primary"
},
"groupInformationSourceMember": "mysql1:3306"
But when I bootstrap the router, I see this in the log:
2024-09-05 21:28:22 routing INFO [75e4f60006c0] [routing:bootstrap_rw] started: routing strategy = first-available
2024-09-05 21:28:22 routing INFO [75e4f60006c0] Start accepting connections for routing routing:bootstrap_rw listening on '0.0.0.0:6446'
2024-09-05 21:28:22 routing INFO [75e4f6a006c0] Start accepting connections for routing routing:bootstrap_ro listening on '0.0.0.0:6447'
2024-09-05 21:28:22 routing INFO [75e4f56006c0] Start accepting connections for routing routing:bootstrap_x_ro listening on '0.0.0.0:6449'
2024-09-05 21:28:22 routing INFO [75e4f6a006c0] Start accepting connections for routing routing:bootstrap_ro listening on '/tmp/router/mysqlro.sock'
2024-09-05 21:28:22 routing INFO [75e4f4c006c0] Start accepting connections for routing routing:bootstrap_x_rw listening on '0.0.0.0:6448'
2024-09-05 21:28:22 routing INFO [75e4f56006c0] Start accepting connections for routing routing:bootstrap_x_ro listening on '/tmp/router/mysqlxro.sock'
2024-09-05 21:28:22 routing INFO [75e4f60006c0] Start accepting connections for routing routing:bootstrap_rw listening on '/tmp/router/mysql.sock'
2024-09-05 21:28:22 routing INFO [75e4f4c006c0] Start accepting connections for routing routing:bootstrap_x_rw listening on '/tmp/router/mysqlx.sock'
2024-09-05 21:28:22 metadata_cache INFO [75e521fff6c0] Connected with metadata server running on mysql1:3306
2024-09-05 21:28:22 metadata_cache INFO [75e521fff6c0] Potential changes detected in cluster after metadata refresh (view_id=0)
2024-09-05 21:28:22 metadata_cache INFO [75e521fff6c0] Metadata for cluster 'N7QNMCluster' has 3 member(s), single-primary:
2024-09-05 21:28:22 metadata_cache INFO [75e521fff6c0] mysql1:3306 / 33060 - mode=RO
2024-09-05 21:28:22 metadata_cache INFO [75e521fff6c0] mysql2:3306 / 33060 - mode=RO
2024-09-05 21:28:22 metadata_cache INFO [75e521fff6c0] mysql3:3306 / 33060 - mode=RO
And I can connect to the RO port; but get this error when I connect to the RW port:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1:6446' (111)
Anu ideas appreciated!