[openstack-dev] [Infra] MyISAM as a default storage engine for MySQL in the gate

Clark Boylan clark.boylan at gmail.com
Mon Jul 21 15:34:36 UTC 2014


On Jul 21, 2014 8:28 AM, "Roman Podoliaka" <rpodolyaka at mirantis.com> wrote:
>
> Hi all,
>
> To my surprise I found that we default to using MyISAM in the gate
> [1], while InnoDB would be a much more suitable choice, which people
> use in production deployments (== we should test it in the gate). This
> means, that every table, for which we haven't explicitly specified to
> use InnoDB, will be created using MyISAM engine, which is clearly not
> what we want (and we have migration scripts at least in Neutron which
> don't specify InnoDB explicitly and rely on MySQL configuration
> value).
>
> Is there any specific reason we default to MyISAM? Or I should submit
> a patch changing the default storage engine to be InnoDB?
>
We want projects to force the use of innodb over myisam. To test this the
gate defaults to myisam and should check that innodb is used instead by the
projects. So this is very intentional.

Are we missing those checks in places?
>
> Thanks,
> Roman
>
> [1]
https://github.com/openstack-infra/config/blob/master/modules/openstack_project/manifests/slave_db.pp#L12
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Clark
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140721/e982c591/attachment.html>


More information about the OpenStack-dev mailing list