[openstack-dev] [Keystone][Nova] Why migrate_version not InnoDB?

Dolph Mathews dolph.mathews at gmail.com
Fri Jul 5 14:57:40 UTC 2013

On Mon, Jul 1, 2013 at 3:24 PM, David Ripton <dripton at redhat.com> wrote:

> On 07/01/2013 12:49 PM, Brant Knudson wrote:
>> 'Stackers -
>> I've got a review up in Keystone that converts tables from MyISAM to
>> InnoDB [0], which I patterned after a change in Nova. One of the
>> comments in the review is suggesting that the migrate_version table
>> should also be changed. The reason I didn't include migrate_version is
>> because that's the way Nova did it, but other than that I don't know why
>> migrate_version should not be converted. The Nova code is pretty
>> explicit that migrate_version isn't changed [1]. Maybe somebody who
>> knows MySQL or SQLAlchemy-migrate better than I do can come up with a
>> reason why migrate_version shouldn't be changed from MyISAM to InnoDB.
>> [0] https://review.openstack.org/#**/c/33102/<https://review.openstack.org/#/c/33102/>- Use InnoDB for MySQL
>> [1]
>> https://github.com/openstack/**nova/blob/master/nova/tests/**
>> db/test_migrations.py#L331<https://github.com/openstack/nova/blob/master/nova/tests/db/test_migrations.py#L331>
> sqlalchemy-migrate relies on the migrate_versions table, so modifying it
> from within a sqlalchemy-migrate script is scary.  And it's a tiny table
> that's only used during DB migrations, so I doubt you'd see any actual
> benefit.

+1; we don't explicitly create the migrate_versions table in migrations, so
we shouldn't be managing it either. If there's an issue in that table, I'd
say it's most likely on sqlalchemy-migrate or the deployer to fix, not
keystone's migrations.

> --
> David Ripton   Red Hat   dripton at redhat.com
> ______________________________**_________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.**org <OpenStack-dev at lists.openstack.org>
> http://lists.openstack.org/**cgi-bin/mailman/listinfo/**openstack-dev<http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20130705/034a46d3/attachment.html>

More information about the OpenStack-dev mailing list