Welcome to the most active Linux Forum on the web.
Go Back > Blogs
User Name



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: I've written documentation for it which you can see at

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...
LQ Newbie
Posted in Uncategorized
Views 655 Comments 0 Pyplate is offline
Rating: 4 votes, 3.00 average.

Automated MySQL backups

Posted 09-15-2009 at 12:50 PM by jkzfixme
Updated 09-15-2009 at 03:00 PM by jkzfixme

Lately I had two SQL servers crash and thankfully have implemented a pretty good backup solution using a script called AutoMySQLBackup, which uses mysqldump to create SQL dumps of your databases. Here is the play by play so you to can get back up and running with expedience. I am assuming the use of ubuntu in this tutorial as that is what I typically use, although the only real difference here is in the sudo command. If you are using a different distro just disregard any sudo's and login as root....
Posted in Uncategorized
Views 1332 Comments 0 jkzfixme is offline

Learning new things - Mysql, Apache, PHP

Posted 03-03-2009 at 06:26 PM by
Tags apache, mysql, php

Bought a book on this subject matter. I have a server with Red Hat on it that I am loading up with mysql, apache and PHP.

The mysql was a trick of sorts. I had loaded and then load apache, that worked and then load php. PHP was missing the mysql.sock file, it was not happy on the ./configure. Today found out that msyql was not really running. I was able to remove the package and re install. Then found received another mysql.sock error. This one I found on the internet, and told me...
LQ Newbie
Posted in Uncategorized
Views 2353 Comments 1 is offline


All times are GMT -5. The time now is 07:20 AM.

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