[Kea-users] KEA MySQL Database Backend Tips

[egor.grijuc at orange.com]

Hi.
We are using main-backup scenario. Also we use cobfig.backend in mysql. Configuration of kea is made through api.We dont use db redundancy, when we make chabges in config we send api calls to both servers and we have a tool that makes verifications of configuration of server1 = config of server2.
Also from cron we use mysqldump of all tables exept log table(it dumps in another routine). Also fast way of dumping config is api call config-get. The result of config-get call can be used in config-set call that pushes config to new server. So in case if you need fast server restore on new hardware you must setup api interface and maoe api call.
Api of kea is very fast.
So i recomend usage of all tools for backup:mysqldump, config-get/config-set/text config backup(kea-dhcp4,kea-dhcp6,keactl...)
The fastest way of restoring kea on new harware is uploading kea text config from backup and config-set from api. Also if you use leases backend and you upload leases information before starting services-you will have also leases info and when devices will try to renew lease-they will not have problems



-------- Исходное сообщение --------
От: Cody Shultz via Kea-users <kea-users at lists.isc.org>
Дата: 21.11.2023 16:27 (GMT+02:00)
Кому: kea-users at lists.isc.org
Тема: [Kea-users] KEA MySQL Database Backend Tips

-------- Исходное сообщение --------
От: Cody Shultz via Kea-users <kea-users at lists.isc.org>
Дата: 21.11.2023 16:27 (GMT+02:00)
Кому: kea-users at lists.isc.org
Тема: [Kea-users] KEA MySQL Database Backend Tips

Hey everyone!

               We have a single KEA DHCP server instance using a single MySQL database server for its lease database storage. We want to setup another KEA DHCP server and MySQL database server for redundancy, and I’ve found a decent document here: https://gitlab.isc.org/isc-projects/kea/-/wikis/designs/High-Availability-Design

               Does anyone have advice on setting up MySQL database replication or any alternatives?

[cid:image001.png at 01D9EB0F.CE2DB8C0]<https://www.glps.net/>

Cody Shultz
Broadband Network Engineer
Greeneville Energy Authority
1200 W. Andrew Hwy Greeneville, TN 37745
O: 423-636-6293


____________________________________________________________________________________________________________
Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees et ne doivent donc
pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par erreur, veuillez le signaler
a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant susceptibles d'alteration,
Orange decline toute responsabilite si ce message a ete altere, deforme ou falsifie. Merci.

This message and its attachments may contain confidential or privileged information that may be protected by law;
they should not be distributed, used or copied without authorisation.
If you have received this email in error, please notify the sender and delete this message and its attachments.
As emails may be altered, Orange is not liable for messages that have been modified, changed or falsified.
Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20231121/4bf81d06/attachment.htm>