mysql8 3 node cluster, mysqlrouter is having time to time issue making web slow
$25-50 USD / hour
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?
Project ID: #30866093
About the project
Awarded to:
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() whe More
8 freelancers are bidding on average $35/hour for this job
hajur namaskaar hai. Maile mysql cluster ma kaam gareko chhu sayad help garna sakchhu ki. Discuss garna sakinchha. Dhanyebaad
hello . I just looked at the error log in your details. As a MySQL expert, I have enough skills to correct any errors you've encountered. I will wait for you. dear
Hi Friend, I have read your description and I can complete it. I can use the Node and MySQL to complete your project. I have done this kind of work several times so I know how to do this. If you hire me, I will do More