[openstack-dev] [oslo.db] PyMySQL review

Morgan Fainberg morgan.fainberg at gmail.com
Thu Jan 29 17:05:16 UTC 2015


On Thursday, January 29, 2015, Roman Podoliaka <rpodolyaka at mirantis.com>
wrote:

> Hi all,
>
> Mike, thanks for summarizing this in
> https://wiki.openstack.org/wiki/PyMySQL_evaluation !
>
> On PyMySQL: this is something we need to enable testing of oslo.db on
> Python 3.x and PyPy. Though, I doubt we want to make PyMySQL the
> default DB API driver for OpenStack services for Python 2.x. At least,
> not until PyMySQL provides C-speedups for hot spots in the driver code
> (I assume this can be done in eventlet/PyPy friendly way using cffi).
> Otherwise, PyMySQL would be much slower than MySQL-Python for the
> typical SQL queries we do (e.g. ask for *a lot* of data from the DB).
>
> On native threads vs green threads: I very much like the Keystone
> approach, which allows to run the service using either eventlet or
> Apache. It would be great, if we could do that for other services as
> well.
>
>
I have heard that a few of the very large deployments out there use Apache
or nginx and mod_wsgi / equiv for nginx for all of the services. I
personally think this deployment model  is the way I'd like to see all
OpenStack API services go. For cases like conductor or nova compute it may
not be as good of a deployment option (not exactly traditional wsgi apps).

--Morgan


Thanks,
> Roman
>
> On Thu, Jan 29, 2015 at 5:54 PM, Ed Leafe <ed at leafe.com <javascript:;>>
> wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > On 01/28/2015 06:57 PM, Johannes Erdfelt wrote:
> >
> >> Not sure if it helps more than this explanation, but there was a
> >> blueprint and accompanying wiki page that explains the move from twisted
> >> to eventlet:
> >
> > Yeah, it was never threads vs. greenthreads. There was a lot of pushback
> > to relying on Twisted, which many people found confusing to use, and
> > more importantly, to follow when reading code. Whatever the performance
> > difference may be, eventlet code is a lot easier to follow, as it more
> > closely resembles single-threaded linear execution.
> >
> > - --
> >
> > - -- Ed Leafe
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v2.0.14 (GNU/Linux)
> >
> > iQIcBAEBAgAGBQJUyle8AAoJEKMgtcocwZqLRX4P/j3LhEhubBOJmWepfO6KrG9V
> > KxltAshKRvZ9OAKlezprZh8N5XUcxRTDxLhxkYP6Qsaf1pxHacAIOhLRobnV5Y+A
> > oF6E6eRORs13pUhLkL+EzZ07Kon+SjSmvDDZiIo+xe8OTbgfMpo5j7zMPeLJpcr0
> > RUSS+knJ/ewNCMaX4gTwTY3sDYFZTbVuGHFUtjSgeoJP0T5aP05UR73xeT7/AsbW
> > O8dOL4tX+6GcxIHyX4XdFH9hng1P2vBZJ5l8yV6BxB6U8xsiQjlsCpwrb8orYJ0r
> > f7+YW0D0FHOvY/TV4dzsLC/2NGc2AwMszWL3kB/AzbUuDyMMDEGpbAS/VHDcyhZg
> > l7zFKEQy+9UybVzWjw764hpzcUT/ICPbTBiX/QuN4qY9YTUNTlCNrRAslgM+cr2y
> > x0/nb6cd+Qq21RPIygJ9HavRqOm8npF6HpUrE55Dn+3/OvfAftlWNPcdlXAjtDOt
> > 4WUFUoZjUTsNUjLlEiiTzgfJg7+eQqbR/HFubCpILFQgOlOAuZIDcr3g8a3yw7ED
> > wt5UZz/89LDQqpF2TZX8lKFWxeKk1CnxWEWO208+E/700JS4xKHpnVi4tj18udsY
> > AHnihUwGO4d9Q0i+TqbomnzyqOW6SM+gDUcahfJ92IJj9e13bqpbuoN/YMbpD/o8
> > evOz8G3OeC/KaOgG5F/1
> > =1M8U
> > -----END PGP SIGNATURE-----
> >
> >
> __________________________________________________________________________
> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150129/dcce6a68/attachment.html>


More information about the OpenStack-dev mailing list