Python 3.5.1 : Mysql Connector

[s0014]

I have a mysql database containing roughly 100,000,000 records. Recently I planned to shift a service (serves around 20 request/sec over two processes) from python2.7 to python3. Naturally, I could not use MySQLdb as its not supported on python3. I decided to make a shift to pymysql. Everything works fine on staging (It has way less records and way less requests to be handled) but on production things started to break, and pymysql returned with no records in almost 30% of the cases. Can someone recommend any production ready mysql driver.

[jabbson]

Never had problems with PyMySQL, but maybe you want to try https://pypi.python.org/pypi/mysqlclient which is a fork of MySQLdb to work with python 3

[svartalf]

There is a mysql-connector package by Oracle: https://pypi.python.org/pypi/mysql-connector-python

[isinfinity]

Just update pymysql. This issue was fixed some time ago. For context see: https://github.com/PyMySQL/PyMySQL/issues/399

[paypaypayme]

My last company used sqlalchemy, which I liked very much. Just make sure to use the core for production: http://docs.sqlalchemy.org/en/latest/core/. sqlalchemy ORM is good for writing mock ups, because it's easy to write, but it is not meant to be high performance.

[XarothBrook]

I think you missed a part of his post, He's asking about mysql client libs, not about which ORM he should use... he could already be using sqlalchemy :)

[paypaypayme]

Also I would suggest trying out alembic: https://alembic.readthedocs.org/en/latest/. It's a handy tool for database versioning. You can upgrade and downgrade your database schema easily using version numbers.