<div dir="ltr"><div dir="ltr"><div><div>Hi,<br><br></div>I am using Kea with
a mysql cluster of 2 master/master nodes using mysql replication (not a
nbd cluster) for leases and hosts reservation.<br><br></div>For mysql failover, I am usingĀ a virtual IP balanced between the 2 mysql nodes.<br><div><div><div>Everytime the virtual IP moves to the other host, i got a fatal error, and kea stops running with that kind of error :<br></div><div><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">DHCPSRV_MYSQL_FATAL_ERROR
Unrecoverable MySQL error occurred: unable to execute for <DELETE
FROM lease4 WHERE state = ? AND expire < ?>, reason: Lost
connection to MySQL server during query (error code: 2013). Server
exiting now!<br></blockquote><div><br></div><div>Would it be possible to modify this behavior to make kea retry to connect to the mysql server a few times before dying ?<br></div><br>Previously, i have also tried tu use haproxy with one mysql server being active, and the 2nd
one being in backup : I had the same problem when restarting
haproxy/ or changing the active mysql server in haproxy.<br><br></div><div>Best regards,<br></div><div>Samuel</div></div></div></div></div>