[openstack-dev] [oslo][oslo.db] MySQL Cluster support

Octave J. Orgeron octave.orgeron at oracle.com
Thu Feb 2 03:33:38 UTC 2017

Hi Folks,

I'm working on adding support for MySQL Cluster to the core OpenStack 
services. This will enable the community to benefit from an 
active/active, auto-sharding, and scale-out MySQL database. My approach 
is to have a single configuration setting in each core OpenStack service 
in the oslo.db configuration section called mysql_storage_engine that 
will enable the logic in the SQL Alchemy or Alembic upgrade scripts to 
handle the differences between InnoDB and NDB storage engines 
respectively. When enabled, this logic will make the required table 
schema changes around:

  * Row character length limits 65k -> 14k
  * Proper SQL ordering of foreign key, constraints, and index operations
  * Interception of savepoint and nested operations

By default this functionality will not be enabled and will have no 
impact on the default InnoDB functionality. These changes have been 
tested on Kilo and Mitaka in previous releases of our OpenStack 
distributions with Tempest. I'm working on updating these patches for 
upstream consumption. We are also working on a 3rd party CI for 
regression testing against MySQL Cluster for the community.

The first change set is for oslo.db and can be reviewed at:




Oracle <http://www.oracle.com/>
Octave J. Orgeron | Sr. Principal Architect and Software Engineer
Oracle Linux OpenStack

Certified Oracle Enterprise Architect: Systems Infrastructure 
Green Oracle <http://www.oracle.com/commitment> Oracle is committed to 
developing practices and products that help protect the environment

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20170201/46c1f926/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oracle_sig_logo.gif
Type: image/gif
Size: 658 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20170201/46c1f926/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oea_logo.jpg
Type: image/jpeg
Size: 2398 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20170201/46c1f926/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: green-for-email-sig_0.gif
Type: image/gif
Size: 356 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20170201/46c1f926/attachment-0001.gif>

More information about the OpenStack-dev mailing list