[Kea-users] Back-end database recommendations?

[Shane Kerr]

Hello,

I'm about to set up my second Kea system, and would like
recommendations as to what back-end database to use.

I have a system running using PostgreSQL as a back-end today, but it
seems to be a 2nd-class citizen, with MySQL getting the most attention.
This makes sense since the developers have limited resources and need
to focus their attention on what is best for users (and sponsors).

I have a very slight preference for PostgreSQL, but I really don't care
that much. Various software that I have use PostgreSQL, MySQL, or even
SQLite as the back-end, and it's all fine. :)

So... my thinking now is that I should use MySQL as the back-end since
it gets new features first and seems like the best-supported. For
example, I'd like to use host reservations and this only seems to be
supported with MySQL.

I'm not opposed to using memfile if that is actually the best
supported, but it is kind of fun to have records in an SQL database. ;)

Finally, if I do use MySQL does anyone have experience with using
MariaDB or Percona? I'm leaning towards MariaDB since it is not owned
by evil corporate Oracle, but I am interested if anyone has real-world
advice....

Cheers,

--
Shane
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 181 bytes
Desc: OpenPGP digital signature
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20160803/e5159f24/attachment.bin>