[Openstack-operators] feedback on pymysql

Kris G. Lindgren klindgren at godaddy.com
Thu Nov 17 22:16:20 UTC 2016

In one of our cells we are running nova with pymsql.  It actually helped when we had some db connectivity issues that we were trying to figure out.  This is because it wouldn’t block the entire green thread for x seconds while it waits for the db to time out.  For us what would happen is db connectivity would be impacted, we would log an error, then shortly after nova would log a bunch of rabbitmq heartbeat failures.  Switching to pymsql stopped the heartbeat failures from happening/being logged.

Kris Lindgren
Senior Linux Systems Engineer

From: Matt Fischer <matt at mattfischer.com>
Date: Thursday, November 17, 2016 at 3:11 PM
To: "openstack-operators at lists.openstack.org" <openstack-operators at lists.openstack.org>
Subject: [Openstack-operators] feedback on pymysql

As a part of our upgrades to Newton we are transitioning our services to use pymysql rather than the deprecated MySQL-Python [1]. I believe pymsql has been the default in devstack and the gate for sometime now and that MySQL-Python is essentially untested and not updated, hence our desire to switch.

devstack is one thing, but I'm curious if anyone has experience operating in production with this, especially if there are issues. I've not seen anything in testing but if anyone else has I'd love to know positive or negative.

[1] https://wiki.openstack.org/wiki/PyMySQL_evaluation#MySQL-Connector-Python
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20161117/629523bc/attachment.html>

More information about the OpenStack-operators mailing list