Comments - error : (408595) Lost connection to the master server
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
The idle value for all of those was around 300 seconds, what is the wait_timeout value configured on the backend servers? That error is likely caused by the server closing idle connections and the master connection was not used in the last 300 seconds.
You can set the value of connection_keepalive for the readwritesplit service to 60 seconds to keep the connection alive:
it's not work
Try increasing it to a higher value:
That should allow MaxScale enough time to keep the connection alive with the default connection_keepalive of 300 seconds.