[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