The Ultimate Guide to High Availability with MariaDB

Comments - error : (408595) Lost connection to the master server

4 years, 9 months ago mi saki
Re: error : (408595) Lost connection to the master server

it's not work

+-----------------------------+----------+
| Variable_name               | Value    |
+-----------------------------+----------+
| connect_timeout             | 30       |
| deadlock_timeout_long       | 50000000 |
| deadlock_timeout_short      | 10000    |
| delayed_insert_timeout      | 300      |
| innodb_flush_log_at_timeout | 1        |
| innodb_lock_wait_timeout    | 120      |
| innodb_rollback_on_timeout  | OFF      |
| interactive_timeout         | 300      |
| lock_wait_timeout           | 86400    |
| net_read_timeout            | 30       |
| net_write_timeout           | 60       |
| slave_net_timeout           | 60       |
| thread_pool_idle_timeout    | 60       |
| wait_timeout                | 300      |
+-----------------------------+----------+
14 rows in set (0.00 sec)
 
4 years, 9 months ago Markus Mäkelä
Re: error : (408595) Lost connection to the master server [Answer]

Try increasing it to a higher value:

SET GLOBAL wait_timeout=3600;

That should allow MaxScale enough time to keep the connection alive with the default connection_keepalive of 300 seconds.

 
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.