This blog is about the development of my various Linux based web sites, starting with raspberrywebserver.com, Banoffee Pi Server and Linux Web Servers.
DB Cluster Utils - a Python script for managing a MySQL cluster
Posted 10-28-2014 at 04:26 AM by Pyplate
I've been working on some code to manage a cluster of MySQL servers. I'm calling it DB Cluster Utils, and you can take a look at it in Github: https://github.com/Pyplate/db-cluster-utils. I've written documentation for it which you can see at http://banoffeepiserver.com/mysql/py...ement-utility/.
It's pretty basic at the moment, but it does everything I need. I can start and stop replication, demote the master server and promote a slave, and a few other things.
At the moment DB Cluster Utils only works with MySQL 5.5. At some point I'll develop support for MySQL 5.6, which uses Global Transaction IDs to simplify replication.
I'm in the process of building a Banana Pi powered cluster, and I plan on using DB Cluster Utils to manage the database cluster.
It's pretty basic at the moment, but it does everything I need. I can start and stop replication, demote the master server and promote a slave, and a few other things.
At the moment DB Cluster Utils only works with MySQL 5.5. At some point I'll develop support for MySQL 5.6, which uses Global Transaction IDs to simplify replication.
I'm in the process of building a Banana Pi powered cluster, and I plan on using DB Cluster Utils to manage the database cluster.
Total Comments 0