[openstack-dev] [oslo] Openstack and SQLAlchemy

Matt Riedemann mriedem at linux.vnet.ibm.com
Mon Jul 7 19:57:28 UTC 2014



On 7/2/2014 8:23 PM, Mike Bayer wrote:
>
> I've just added a new section to this wiki, "MySQLdb + eventlet = sad",
> summarizing some discussions I've had in the past couple of days about
> the ongoing issue that MySQLdb and eventlet were not meant to be used
> together.   This is a big one to solve as well (though I think it's
> pretty easy to solve).
>
> https://wiki.openstack.org/wiki/OpenStack_and_SQLAlchemy#MySQLdb_.2B_eventlet_.3D_sad
>
>
>
> On 6/30/14, 12:56 PM, Mike Bayer wrote:
>> Hi all -
>>
>> For those who don't know me, I'm Mike Bayer, creator/maintainer of
>> SQLAlchemy, Alembic migrations and Dogpile caching.   In the past month
>> I've become a full time Openstack developer working for Red Hat, given
>> the task of carrying Openstack's database integration story forward.
>> To that extent I am focused on the oslo.db project which going forward
>> will serve as the basis for database patterns used by other Openstack
>> applications.
>>
>> I've summarized what I've learned from the community over the past month
>> in a wiki entry at:
>>
>> https://wiki.openstack.org/wiki/Openstack_and_SQLAlchemy
>>
>> The page also refers to an ORM performance proof of concept which you
>> can see at https://github.com/zzzeek/nova_poc.
>>
>> The goal of this wiki page is to publish to the community what's come up
>> for me so far, to get additional information and comments, and finally
>> to help me narrow down the areas in which the community would most
>> benefit by my contributions.
>>
>> I'd like to get a discussion going here, on the wiki, on IRC (where I am
>> on freenode with the nickname zzzeek) with the goal of solidifying the
>> blueprints, issues, and SQLAlchemy / Alembic features I'll be focusing
>> on as well as recruiting contributors to help in all those areas.  I
>> would welcome contributors on the SQLAlchemy / Alembic projects directly
>> as well, as we have many areas that are directly applicable to Openstack.
>>
>> I'd like to thank Red Hat and the Openstack community for welcoming me
>> on board and I'm looking forward to digging in more deeply in the coming
>> months!
>>
>> - mike
>>
>>
>>
>> _______________________________________________
>> OpenStack-dev mailing list
>> OpenStack-dev at lists.openstack.org
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>

Regarding the eventlet + mysql sadness, I remembered this [1] in the 
nova.db.api code.

I'm not sure if that's just nova-specific right now, I'm a bit too lazy 
at the moment to check if it's in other projects, but I'm not seeing it 
in neutron, for example, and makes me wonder if it could help with the 
neutron db lock timeouts we see in the gate [2].  Don't let the bug 
status fool you, that thing is still showing up, or a variant of it is.

There are at least 6 lock-related neutron bugs hitting the gate [3].

[1] https://review.openstack.org/59760
[2] https://bugs.launchpad.net/neutron/+bug/1283522
[3] http://status.openstack.org/elastic-recheck/

-- 

Thanks,

Matt Riedemann




More information about the OpenStack-dev mailing list