<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Just FYI I hit this problem too in the past when trying to set up HA (with some 0.9 beta version).<div class="">I solved it by setting up a mysql master on every kea node and pointing kea to 127.0.0.1, not optimal but good enough. With high traffic it wouldn't work, though, because of deadlocks and collisions.</div><div class=""><br class=""></div><div class="">Kea should probably support some sort of connection pool with reconnect and keepalive (SELECT 1;), no idea how that works now...</div><div class=""><br class=""></div><div class="">Jan</div><div class=""><br class=""></div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 2 Jan 2017, at 10:27, Samuel Hameau <<a href="mailto:samuel.hameau@withings.com" class="">samuel.hameau@withings.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><div class=""><div class="">Hi,<br class=""><br class=""></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 class=""><br class=""></div>For mysql failover, I am using a virtual IP balanced between the 2 mysql nodes.<br class=""><div class=""><div class=""><div class="">Everytime the virtual IP moves to the other host, i got a fatal error, and kea stops running with that kind of error :<br class=""></div><div class=""><br class=""><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 class=""></blockquote><div class=""><br class=""></div><div class="">Would it be possible to modify this behavior to make kea retry to connect to the mysql server a few times before dying ?<br class=""></div><br class="">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 class=""><br class=""></div><div class="">Best regards,<br class=""></div><div class="">Samuel</div></div></div></div></div>
_______________________________________________<br class="">Kea-users mailing list<br class=""><a href="mailto:Kea-users@lists.isc.org" class="">Kea-users@lists.isc.org</a><br class="">https://lists.isc.org/mailman/listinfo/kea-users<br class=""></div></blockquote></div><br class=""></div></body></html>