LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Blogs
User Name
Password

Notices



Old

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

Automated MySQL backups

Posted 09-15-2009 at 01:50 PM by jkzfixme
Updated 09-15-2009 at 04: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....
Member
Posted in Uncategorized
Views 1169 Comments 0 jkzfixme is offline
Old

Learning new things - Mysql, Apache, PHP

Posted 03-03-2009 at 07:26 PM by mwlaursen@aol.com
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 2095 Comments 1 mwlaursen@aol.com is offline

  



All times are GMT -5. The time now is 04:45 AM.

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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration