SingleStore Managed Service

Python Client Library Setup Instructions

The following instructions are intended for a Red Hat Enterprise Linux Based Distribution, but the concepts may be applied elsewhere.

The first step is to install a Python client library. There are a few choices depending on your requirements.

Note: When using the GSSAPI authentication functionality, you must use a library that links against the MariaDB 10.1.11 or greater C bindings.

mysqlclient

mysqlclient-python

pip install mysqlclient

Recommended for SQLAlchemy users.

PyMySQL

PyMySQL

pip install PyMySQL

Note: Because this is a pure python implementation, it will not work with GSSAPI / Kerberos.

MySQL Connector/Python

MySQL Connector/Python

yum install https://dev.mysql.com/get/Downloads/Connector-Python/mysql-connector-python-8.0.15-1.el7.x86_64.rpm
yum install https://dev.mysql.com/get/Downloads/Connector-Python/mysql-connector-python-cext-8.0.15-1.el7.x86_64.rpm

Caution

The MySQL Connector/Python library is not recommended.

SingleStore recommends the PyMySQL and mysqlclient libraries.

Other Python Options