[Kea-users] Kea 1.5 : 2 servers and one mysql database ?

Xavier BEAUDOUIN xbeaudouin at hotcity.lu
Mon Aug 26 13:56:22 UTC 2019


Hello There,

I am with my colleages in the process to migrate from isc dhcp to kea 1.5.0.

Our setup is quite simple :

- 2 Kea 1.5.0 servers (on freebsd, with freebsd ports)
- 1 galera cluster for all this 2 servers.

For some « interessing » reason (read : the logs of whole platform says nothing), the first kea server decided to give up because it cannot connect to the database for less than 2 seconds….

Logs :
2019-08-24 20:53:24.460 ERROR [kea-dhcp4.dhcp4/14823] DHCP4_DB_RECONNECT_ATTEMPT_FAILED database reconnect failed: Can't connect to MySQL server on 'dbvip <http://dbvip.prod.hotcity.lu/>' (60)
2019-08-24 20:53:24.460 INFO  [kea-dhcp4.dhcp4/14823] DHCP4_DB_RECONNECT_ATTEMPT_SCHEDULE scheduling attempt 2 of 10 in 2000 milliseconds
2019-08-24 20:53:24.460 ERROR [kea-dhcp4.alloc-engine/14823] ALLOC_ENGINE_V4_RECLAIMED_LEASES_DELETE_FAILED deletion of expired-reclaimed leases failed: fatal database errror or connectivity lost
2019-08-24 20:53:26.560 INFO  [kea-dhcp4.dhcpsrv/14823] DHCPSRV_MYSQL_DB opening MySQL lease database: host=dbvip <http://dbvip.prod.hotcity.lu/> max-reconnect-tries=10 name=*** password=***** port=3306 reconnect-wait-time=2000 type=mysql universe=4 user=***
2019-08-24 20:53:31.630 ERROR [kea-dhcp4.dhcp4/14823] DHCP4_DB_RECONNECT_ATTEMPT_FAILED database reconnect failed: Can't connect to MySQL server on 'dbvip <http://dbvip.prod.hotcity.lu/>' (60)
2019-08-24 20:53:31.630 INFO  [kea-dhcp4.dhcp4/14823] DHCP4_DB_RECONNECT_ATTEMPT_SCHEDULE scheduling attempt 10 of 10 in 2000 milliseconds
2019-08-24 20:53:33.730 INFO  [kea-dhcp4.dhcpsrv/14823] DHCPSRV_MYSQL_DB opening MySQL lease database: host=dbvip <http://dbvip.prod.hotcity.lu/> max-reconnect-tries=10 name=*** password=***** port=3306 reconnect-wait-time=2000 type=mysql universe=4 user=***
2019-08-24 20:53:38.760 ERROR [kea-dhcp4.dhcp4/14823] DHCP4_DB_RECONNECT_ATTEMPT_FAILED database reconnect failed: Can't connect to MySQL server on ‘dbvip <http://dbvip.prod.hotcity.lu/>' (60)
2019-08-24 20:53:38.760 ERROR [kea-dhcp4.dhcp4/14823] DHCP4_DB_RECONNECT_RETRIES_EXHAUSTED maximum number of database reconnect attempts: 10, has been exhausted without success, server is shutting down!
2019-08-24 20:53:38.761 INFO  [kea-dhcp4.dhcp4/14823] DHCP4_SHUTDOWN server shutdown

Also the second servers stay mostly idle and didn’t had the idea to reply to our DHCP requests. 

We raized the « timeout » to 30 seconds, but this doesn’t make up relax about this random issue on our side.

So basicaly, the questions are :

- does several servers + one central mysql database IS supported ?
- do we need to have one db per kea servers and use HA to make this redondant ?

Kind regards,



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190826/caf2eb18/attachment.htm>


More information about the Kea-users mailing list