WSQL

.. image:: https://travis-ci.org/WebSQL/wsql.svg?branch=master :target: https://travis-ci.org/WebSQL/wsql

.. image:: https://coveralls.io/repos/WebSQL/wsql/badge.png?branch=master :target: https://coveralls.io/r/WebSQL/wsql?branch=master

WSQL is an asynchronous python connector to the popular MySQL_ database server based on WebScaleSQL_.

The design goals are:

• Compatibility with Python3 asyncio package
• Compliance with Python database API version 2.0 [PEP-0249]_
• Thread-safety
• Thread-friendliness (threads will not block each other)
• Support mysql-clusters like: Percona-XtraDB-Cluster, GaleraCluster

.. code:: python

import wsql.cluster.connect
# master:master(active:active)
connection = wsql.cluster.connect("master=localhost:3305#2,localhost:3306#2", database="test")
# master:slave(active:passive)
connection = wsql.cluster.connect("master=localhost;slave=localhost:3307#4", database="test")
# read-only
connection = wsql.cluster.connect("slave=localhost:3307#4;database=test;")

MySQL-5.5 and newer and Python-3.4 and newer are currently supported.

Setup dependencies

• cmake version 2.8.11 or higher
• openssl-devel version 1.0 or higher
• python3-devel
• zlib-devel
• gcc

WSQL is Free Software_.

Documentation_.

Developed by using CLion_.

.. _MySQL: http://www.mysql.com/ .. _Free Software: http://www.gnu.org/ .. _WebScaleSQL: http://webscalesql.org/ .. _[PEP-0249]: http://www.python.org/peps/pep-0249.html .. _Percona-XtraDB-Cluster: http://www.percona.com/software/percona-xtradb-cluster .. _GaleraCluster: http://galeracluster.com/products/ .. _Documentation: http://websql-websql.rhcloud.com/ .. _CLion: https://www.jetbrains.com/clion/