<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body dir="auto">
Hi.
<div dir="auto">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.</div>
<div dir="auto">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.</div>
<div dir="auto">Api of kea is very fast.</div>
<div dir="auto">So i recomend usage of all tools for backup:mysqldump, config-get/config-set/text config backup(kea-dhcp4,kea-dhcp6,keactl...)</div>
<div dir="auto">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</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<!-- originalMessage -->
<div>-------- Исходное сообщение --------</div>
<div>От: Cody Shultz via Kea-users <kea-users@lists.isc.org> </div>
<div>Дата: 21.11.2023 16:27 (GMT+02:00) </div>
<div>Кому: kea-users@lists.isc.org </div>
<div>Тема: [Kea-users] KEA MySQL Database Backend Tips </div>
<div><br>
</div>
<div align="left" dir="auto" style="font-size:100%;color:#000000">
<div>-------- Исходное сообщение --------</div>
<div>От: Cody Shultz via Kea-users <kea-users@lists.isc.org> </div>
<div>Дата: 21.11.2023 16:27 (GMT+02:00) </div>
<div>Кому: kea-users@lists.isc.org </div>
<div>Тема: [Kea-users] KEA MySQL Database Backend Tips </div>
<div><br>
</div>
</div>
<div class="WordSection1">
<p class="MsoNormal">Hey everyone!</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> 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: <a href="https://gitlab.isc.org/isc-projects/kea/-/wikis/designs/High-Availability-Design">
https://gitlab.isc.org/isc-projects/kea/-/wikis/designs/High-Availability-Design</a></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> Does anyone have advice on setting up MySQL database replication or any alternatives?
</p>
<p class="MsoNormal"> </p>
<table border="0" cellpadding="0" cellspacing="4" class="MsoNormalTable">
<tbody>
<tr>
<td style="padding:4.5pt 4.5pt 4.5pt 4.5pt">
<p style="line-height:105%" class="MsoNormal"><a href="https://www.glps.net/"><span style="font-size:13.5pt; line-height:105%; font-family:"Times New Roman",serif; color:blue; text-decoration:none"></span></a><span style="color:#1F497D"></span></p>
</td>
<td style="padding:3.5pt 3.5pt 3.5pt 3.5pt">
<p style="line-height:105%" class="MsoNormal"><span style="font-size:14.0pt; line-height:105%; font-family:"Helvetica",sans-serif; color:#2E8F3C">Cody Shultz</span><span style="font-size:12.0pt; line-height:105%; font-family:"Arial",sans-serif; color:#A40C34"><br>
</span><span style="font-family:"Helvetica",sans-serif; color:black">Broadband Network Engineer<br>
</span><span style="font-family:"Helvetica",sans-serif; color:#2E8F3C">Greeneville Energy Authority<br>
</span><span style="font-family:"Helvetica",sans-serif; color:#1F497D">1200 W. Andrew Hwy Greeneville, TN 37745<br>
</span><b><span style="font-size:10.0pt; line-height:105%; font-family:"Helvetica",sans-serif; color:#2E8F3C">O:
</span></b><span style="font-family:"Helvetica",sans-serif; color:black">423-636-6293</span><span style="color:#1F497D"></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"> </p>
</div>
<pre>_________________<wbr>______________________________<wbr>______________________________<wbr>______________________________<wbr>_
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.</pre></body>
</html>