[Kea-users] Back-end database recommendations?

Thomas Markwalder tmark at isc.org
Wed Aug 3 10:41:10 UTC 2016


On 8/3/16 3:26 AM, Shane Kerr wrote:
> 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
>
>
> _______________________________________________
> Kea-users mailing list
> Kea-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/kea-users

Hi Shane!


Release 1.1 catches the PostgreSQL backend upto with MySQL complete with
full HR support.  The current tip has all of this functioning now, see
Trac #4277.


Cheers,


Thomas


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20160803/cdeb4041/attachment.htm>


More information about the Kea-users mailing list