[openstack-dev] [openstack-ansible] Change of default database collation

Jimmy McCrory jimmy.mccrory at gmail.com
Fri Jun 24 05:07:02 UTC 2016

Hi all,

OpenStack-Ansible has been configuring the default database collation as
We've recently run into an issue with new deployments during cinder
database migrations where a foreign key column had different a collation
between the parent and child table[1].

That's since been fixed, and we're now looking at changing the default
collation to match the default of MySQL/MariaDB's utf8 character set to
avoid the possibility of this same discrepancy with new deployments[2].

The question then comes to how to best handle upgrades from Mitaka to
Any input for the current proposal[3] from anyone that may have experience
with any project's database migration scripts, or MySQL-based databases in
general, would be appreciated.

Have any of the other deployment projects been effected by this?
Are there any in-progress efforts to help further enforce a standard
character set and collation through DB migration scripts?


[1] https://bugs.launchpad.net/cinder/+bug/1594195
[2] https://review.openstack.org/#/c/331786/
[3] https://review.openstack.org/#/c/333733/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20160623/f706704b/attachment.html>

More information about the OpenStack-dev mailing list