LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Blogs > Pyplate
User Name
Password

Notices


This blog is about the development of my various Linux based web sites, starting with raspberrywebserver.com, Banoffee Pi Server and Linux Web Servers.
Rate this Entry

DB Cluster Utils - a Python script for managing a MySQL cluster

Posted 10-28-2014 at 05: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.
Posted in Uncategorized
Views 880 Comments 0
« Prev     Main     Next »
Total Comments 0

Comments

 

  



All times are GMT -5. The time now is 06:48 PM.

Main Menu
Advertisement
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration