How to handle switching MySQL slave server service in python?

Is there a generally accepted way to handle MySQL db server skew in python code?

Are there any good wrappers for SQLAlchemy connection pools (or other approaches) that are aware of replicas and can automatically switch to them? Is there a standard wrapper around DB-API cursors that can do this?

I remember using the PHP Memcached library which implemented this behavior (you gave it a list of memcached hosts and it will keep track of which hosts were unavailable). Are there any accepted ways to do this with python and MySQL that I am missing?

+3


source to share





All Articles