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

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


Hi Mike,

I've sent out another email that gives some more insight into how this 
will work for the other OpenStack services. The hook in the oslo.db 
namespace gives a global configuration point for enabling the patches 
elsewhere.

Thanks,
Octave

On 2/2/2017 9:24 AM, Mike Bayer wrote:
>
>
> On 02/02/2017 10:25 AM, Monty Taylor wrote:
>> On 02/01/2017 09:33 PM, Octave J. Orgeron wrote:
>>> 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
>>
>> Yay!
>>
>> (You may not be aware, but there are several of us who used to be on the
>> MySQL Cluster team who are now on OpenStack. I've been wanting good NDB
>> support for a while. So thank you!)
>
> as I noted on the review it would be nice to have some specifics of 
> how this is to be accomplished as the code review posted doesn't show 
> anything of how this would work.
>
>
>
>
>>
>>
>> __________________________________________________________________________ 
>>
>> OpenStack Development Mailing List (not for usage questions)
>> Unsubscribe: 
>> OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>>
>
> __________________________________________________________________________ 
>
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: 
> OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>

-- 

Oracle <http://www.oracle.com/>
Octave J. Orgeron | Sr. Principal Architect and Software Engineer
Oracle Linux OpenStack
Mobile: +1-720-616-1550 <tel:+17206161550>
500 Eldorado Blvd. | Broomfield, CO 80021
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/20170202/b00106a0/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/20170202/b00106a0/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/20170202/b00106a0/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/20170202/b00106a0/attachment-0001.gif>


More information about the OpenStack-dev mailing list