Back to Project List

py-mysql-lock

MySQL Backed Locking Primitive

Repository Video ▶️

py-mysql-lock provides locking primitive based on MySQL's GET_LOCK

Though there are mature locking primitives provided by systems like Zookeeper and etcd, when you have an application which is primarily dependent on MySQL for its uptime and health, added resiliency provided by systems just mentioned doesn't add much benefit. py-mysql-lock helps when you have multiple application instances which are backed by a common mysql instance and you want only one of those application instances to hold a lock and do certain tasks.

Demo google drive: https://drive.google.com/drive/folders/1XDa0OXVfoAcY4RQt5Zmb_MpZxutvqTx-?usp=sharing

Sanket Patel

that's a wrap. managed to add couple more feature today and published 0.2.0 on pypi and uploaded the video.

forgot to include one feature but that;s ok I think. upload takes too much time :/

September 13, 2020

v0.0.1 live on pypi

pip install PyMySQLLock
September 12, 2020

CI setup/ 91+% cod cov

:party_parrot:

Screen-Shot-2020-09-12-at-9-30-00-PM

September 12, 2020

PyMySQLLock now supported the three most popular mysql libraries and optionally can take a custom connect function as an argument.

September 12, 2020

Docs live (though not completely populated) at https://py-mysql-lock.readthedocs.io/en/latest/

Base code and classes ready with approriate docstrings.

September 12, 2020

Bare minimum library ready with functionality. (an MVP?) Lot to do still though

September 12, 2020

Repo created: https://github.com/sanketplus/py-mysql-lock

September 12, 2020

Project created by Sanket Patel

September 4, 2020