[Kea-users] KEA MySQL Database Backend Tips

[Geist, Dan (CCI-Atlanta)]

Hi, Cody. It depends on a lot of factors (related to the way Kea is using the db as well as the db engine itself):


  *   What are you trying to DO with the replica(s)?
     *   Offline analysis and reporting?
     *   Real-time hot-hot availability?
     *   Hot/warm standby?
     *   Multi-site diversity?
  *   What data are you putting there?
     *   Leases/config/both?
  *   How many services nodes are going to be accessing them (and which side is authoritative for the information).
  *   How important is performance in your setup? Do you have some performance overhead or are you trying to squeeze out every bit of compute power?
  *   Are you going to be supporting the replication internally with FOSS or are you open to a commercial solution?

PostgreSQL has some tempting advantages over MySQL with native data structures and the like but (IMHO) a little bit more of a learning curve for folks who aren’t already RDBMS admins. The best solution is usually the one you and your team have the ability to operate successfully that meets your needs, not necessarily the technically superior one.

Both MySQL and PostgreSQL have open as well as commercial clustering / HA options but how you want to intend to USE the overall system makes a huge difference.

Dan


From: Kea-users <kea-users-bounces at lists.isc.org> on behalf of Cody Shultz via Kea-users <kea-users at lists.isc.org>
Date: Tuesday, November 21, 2023 at 9:27 AM
To: kea-users at lists.isc.org <kea-users at lists.isc.org>
Subject: [EXTERNAL] [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<https://urldefense.com/v3/__https:/gitlab.isc.org/isc-projects/kea/-/wikis/designs/High-Availability-Design__;!!Hit2Ag!zjSTfbI80b9Iv6rreyzM1waerL6fGYmjsTX4Pk0q0rIn6cI879RWFrPf_aXoHmiUAlbdrMAr6UOUxgmPYLs$>

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

[cid:image003.png at 01DA1C5C.F9A59BC0]<https://urldefense.com/v3/__https:/www.glps.net/__;!!Hit2Ag!zjSTfbI80b9Iv6rreyzM1waerL6fGYmjsTX4Pk0q0rIn6cI879RWFrPf_aXoHmiUAlbdrMAr6UOU17xUP5g$>
Cody Shultz
Broadband Network Engineer
Greeneville Energy Authority
1200 W. Andrew Hwy Greeneville, TN 37745
O: 423-636-6293

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20231121/a08a28e3/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 16665 bytes
Desc: image003.png
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20231121/a08a28e3/attachment-0001.png>