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@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
_______________________________________________
OpenStack-dev mailing list
OpenStack-dev@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
_______________________________________________
OpenStack-dev mailing list
OpenStack-dev@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev