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: https://review.openstack.org/427970 Thanks, Octave -- Oracle <http://www.oracle.com/> Octave J. Orgeron | Sr. Principal Architect and Software Engineer Oracle Linux OpenStack Certified Oracle Enterprise Architect: Systems Infrastructure <http://www.oracle.com/us/solutions/enterprise-architecture/index.html> 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>
