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

Roman Podoliaka rpodolyaka at mirantis.com
Mon Jul 21 15:55:04 UTC 2014


Aha, makes sense. Yeah, this means we miss such a check at least in
Neutron and should add one to the test suite. Thanks!

On Mon, Jul 21, 2014 at 6:34 PM, Clark Boylan <clark.boylan at gmail.com> wrote:
>
> 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
>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>



More information about the OpenStack-dev mailing list