[bind10-dev] MySQL vs PosgreSQL data source flamewar - FIGHT!

[Shane Kerr]

All,

We knew SQLite had serious limitations from the beginning, and we are
now hitting up against them.

Mostly these are to do with poor handling of concurrent operations.
This is not a problem for smaller zones with minimal updates, but for
zones with a lot of updates - especially large ones - this is an issue.

Rather than spend a lot of efforts making hacks with more-or-less work
around the problem, we should spend this time implementing support for
an SQL data source that does not have these limitations. We intended
this from the very beginning.

The obvious choices are MySQL and PostgreSQL.

For the record, I am happy with either, and we will ultimately support
both.

Arguments for MySQL:

* We use it for the first DHCP lease database store.
* Developers tend to like it.

Arguments against MySQL:

* GPL license

Arguments for PostgreSQL:

* DBA tend to like it.
* BSD license.

Arguments against PostgreSQL:

* We are missing a bit of functionality:
  https://lists.isc.org/pipermail/bind10-dev/2012-October/003868.html
  We can work around this, but it is additional work.

10 years ago I found MySQL to be much faster for simple operations. 5
years ago I found PostgreSQL was actually slightly faster for these.
Jinmei's did an experiment that found not too much difference between
the two, so probably that is not a major factor:

https://lists.isc.org/pipermail/bind10-dev/2012-October/003866.html

Anyway, please give your opinion on how we should proceed.

Thanks!

--
Shane