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 GoDaddy From: Matt Fischer <m...@mattfischer.com> Date: Thursday, November 17, 2016 at 3:11 PM To: "openstack-operators@lists.openstack.org" <openstack-operators@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
_______________________________________________ OpenStack-operators mailing list OpenStack-operators@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
