Hey all,

Morgan was stabbing himself in the eyes yesterday dealing with a database issue in keystone related to datetimes and subsecond precision. As usually happens when people want to stab MySQL I got roped in and my first thought was "dude, we landed the subsecond precision patches in Drizzle back in 2008 - they can't possible not be in mainline by now."

Turns out - they are, which is great. EXCEPT ... drum roll ...

We don't explicitly declare a minimum supported MySQL version, so updating the DDL to just set datetime subsecond precision fields seems like a thing we can't do.

We do imply a minimum version via our distro support policy - but we don't really say anything about version of externally managed database tiers.

With that - I would like to suggest we explicitly declare that the minimum supported version of any given database is the minimum found in the union of our supported distros, which is the latest RHEL/CentOS and latest LTS of Ubuntu.

For the MySQL family, that currently resolves to MariaDB 5.5 / MySQL 5.7.11, the upside being that it should be safe to depend, in any MySQL drivers, on any features that are included in MariaDB 5.5 or MySQL 5.7.11.

I have submitted a patch to governance to add this to our description of base services:

https://review.openstack.org/493932

Thoughts or objections?

Monty

__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Reply via email to