mysql8 3 node cluster, mysqlrouter is having time to time issue making web slow
Budget: $25 – $50 USD
I am running MySQL cluster v8.
I have installed MySQL router in the webserver.
I am getting time to time errors on DB connections and webs is slow due to it.
error log:
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] Potential changes detected in cluster 'EU_CLUSTER' after metadata refresh
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] Metadata for cluster 'EU_CLUSTER' has 1 replicasets:
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] 'default' (3 members, single-master)
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] eudb1:3306 / 33060 - mode=RW
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] eudb2:3306 / 33060 - mode=RO
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] eudb3:3306 / 33060 - mode=RO
2021-07-16 12:14:16 routing INFO [7f0fa17aa700] Routing routing:EU_CLUSTER_x_rw listening on 64460 got request to disconnect invalid connections: metadata change
2021-07-16 12:14:16 routing INFO [7f0fa17aa700] Routing routing:EU_CLUSTER_rw listening on 6446 got request to disconnect invalid connections: metadata change
2021-07-16 12:14:16 routing INFO [7f0fa17aa700] Routing routing:EU_CLUSTER_x_ro listening on 64470 got request to disconnect invalid connections: metadata change
2021-07-16 12:14:16 routing INFO [7f0fa17aa700] Routing routing:EU_CLUSTER_ro listening on 6447 got request to disconnect invalid connections: metadata change
2021-07-16 12:14:47 metadata_cache WARNING [7f0fa17aa700] Updating the router last_check_in in metadata failed: Error executing MySQL query "UPDATE mysql_innodb_cluster_metadata.v2_routers set last_check_in = NOW() where router_id = 8": Lost connection to MySQL server during query (2013)
2021-07-16 12:15:25 metadata_cache WARNING [7f0fa17aa700] Updating the router last_check_in in metadata failed: Error executing MySQL query "UPDATE mysql_innodb_cluster_metadata.v2_routers set last_check_in = NOW() where router_id = 8": Lost connection to MySQL server during query (2013)
can you fix it?
I have installed MySQL router in the webserver.
I am getting time to time errors on DB connections and webs is slow due to it.
error log:
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] Potential changes detected in cluster 'EU_CLUSTER' after metadata refresh
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] Metadata for cluster 'EU_CLUSTER' has 1 replicasets:
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] 'default' (3 members, single-master)
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] eudb1:3306 / 33060 - mode=RW
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] eudb2:3306 / 33060 - mode=RO
2021-07-16 12:14:16 metadata_cache INFO [7f0fa17aa700] eudb3:3306 / 33060 - mode=RO
2021-07-16 12:14:16 routing INFO [7f0fa17aa700] Routing routing:EU_CLUSTER_x_rw listening on 64460 got request to disconnect invalid connections: metadata change
2021-07-16 12:14:16 routing INFO [7f0fa17aa700] Routing routing:EU_CLUSTER_rw listening on 6446 got request to disconnect invalid connections: metadata change
2021-07-16 12:14:16 routing INFO [7f0fa17aa700] Routing routing:EU_CLUSTER_x_ro listening on 64470 got request to disconnect invalid connections: metadata change
2021-07-16 12:14:16 routing INFO [7f0fa17aa700] Routing routing:EU_CLUSTER_ro listening on 6447 got request to disconnect invalid connections: metadata change
2021-07-16 12:14:47 metadata_cache WARNING [7f0fa17aa700] Updating the router last_check_in in metadata failed: Error executing MySQL query "UPDATE mysql_innodb_cluster_metadata.v2_routers set last_check_in = NOW() where router_id = 8": Lost connection to MySQL server during query (2013)
2021-07-16 12:15:25 metadata_cache WARNING [7f0fa17aa700] Updating the router last_check_in in metadata failed: Error executing MySQL query "UPDATE mysql_innodb_cluster_metadata.v2_routers set last_check_in = NOW() where router_id = 8": Lost connection to MySQL server during query (2013)
can you fix it?