Hi all,

OpenStack-Ansible has been configuring the default database collation as
'utf8_unicode_ci'.
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
Newton.
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.

Also,
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?

Thanks

[1] https://bugs.launchpad.net/cinder/+bug/1594195
[2] https://review.openstack.org/#/c/331786/
[3] https://review.openstack.org/#/c/333733/
__________________________________________________________________________
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