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-boun...@lists.isc.org> on behalf of Cody Shultz via
Kea-users <kea-users@lists.isc.org>
Date: Tuesday, November 21, 2023 at 9:27 AM
To: kea-users@lists.isc.org <kea-users@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@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
--
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
