<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Folks,<br>
<br>
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:<br>
<ul>
<li>Row character length limits 65k -> 14k<br>
</li>
<li>Proper SQL ordering of foreign key, constraints, and index
operations</li>
<li>Interception of savepoint and nested operations</li>
</ul>
<p>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.<br>
</p>
<p>The first change set is for oslo.db and can be reviewed at: <br>
</p>
<p><a class="moz-txt-link-freetext" href="https://review.openstack.org/427970">https://review.openstack.org/427970</a><br>
</p>
<p>Thanks,<br>
Octave<br>
</p>
<div class="moz-signature">-- <br>
<br>
<p>
<a href="http://www.oracle.com/" target="_blank"><img
src="cid:part1.08040904.07040308@oracle.com" alt="Oracle"
border="0" height="26" width="114"></a><br>
<font color="#666666" size="2" face="Verdana, Arial, Helvetica,
sans-serif">Octave J. Orgeron | Sr. Principal Architect and
Software Engineer<br>
<font color="#ff0000">Oracle</font> Linux OpenStack<br>
<br>
<a
href="http://www.oracle.com/us/solutions/enterprise-architecture/index.html"><img
src="cid:part3.00080904.00020206@oracle.com"
alt="Certified Oracle Enterprise Architect: Systems
Infrastructure" border="0" height="42" width="182"></a><br>
<a href="http://www.oracle.com/commitment" target="_blank"><img
src="cid:part5.03080903.04050108@oracle.com" alt="Green
Oracle" align="absmiddle" border="0" height="28"
width="44"></a>
<font color="#4B7D42" size="1" face="Verdana, Arial,
Helvetica, sans-serif">Oracle is committed to developing
practices and products that help protect the environment</font>
</font></p>
<font color="#666666" size="2" face="Verdana, Arial, Helvetica,
sans-serif">
</font></div>
</body>
</html>