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@lists.isc.org>
Дата: 21.11.2023 16:27 (GMT+02:00)
Кому: kea-users@lists.isc.org
Тема: [Kea-users] KEA MySQL Database Backend Tips
-------- Исходное сообщение --------
От: Cody Shultz via Kea-users <kea-users@lists.isc.org>
Дата: 21.11.2023 16:27 (GMT+02:00)
Кому: kea-users@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@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.
RAW
Description: RAW
-- ISC funds the development of this software with paid support subscriptions. Contact us at https://www.isc.org/contact/ for more information. To unsubscribe visit https://lists.isc.org/mailman/listinfo/kea-users. Kea-users mailing list Kea-users@lists.isc.org https://lists.isc.org/mailman/listinfo/kea-users
