LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Blogs
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 Pyplate Python SQlite CMS.
Old

Setting up Ganglia on three small clusters

Posted 11-10-2014 at 09:52 AM by Pyplate
Updated 11-10-2014 at 09:57 AM by Pyplate

I've been studying clusters using Banana Pi boards, and I've got as far as developing a cluster of MySQL servers, a cluster using GlusterFS and a web server cluster.

At the moment the server cluster is operating on its own. Each node contains a copy of the Pyplate CMS with its own instance of an SQLite database. The next step is it to make all three clusters work together. I've updated Pyplate so that I can use MySQL instead of SQLite, and I've imported a Pyplate database into...
LQ Newbie
Posted in Uncategorized
Views 117 Comments 0 Pyplate is offline
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 128 Comments 0 Pyplate is offline
Old

Banana Pi MySQL and GlusterFS Clusters

Posted 10-04-2014 at 08:46 PM by Pyplate

I recently set up a Banana Pi MySQL cluster and a Banana Pi storage cluster using GlusterFS. Each cluster is built with four servers running Raspbian OS. The storage cluster has a hard disk connected to each node.

The MySQL cluster uses one node as a master, and the other three nodes are slaves. The first time I set up replication, I logged into each server via ssh and entered commands into the MySQL shell. I've been working on a script to automate the process. So far the...
LQ Newbie
Posted in Uncategorized
Views 257 Comments 0 Pyplate is offline
Old

MySQL with Pyplate on a Banana Pi cluster

Posted 09-02-2014 at 06:05 AM by Pyplate

I've modified the Pyplate CMS to use MySQL instead of SQLite, and some rough tests show that there's a significant improvement performance if the database is on a separate server than the web server. I haven't released this code yet, there's some more testing to do, and I need to make some changes to the install script.

I'm also working on setting up MySQL replication so that I can use a cluster of database servers with a cluster of web servers.

After that I plan to...
LQ Newbie
Posted in Uncategorized
Views 328 Comments 0 Pyplate is offline
Old

Banana Pi Cluster

Posted 08-01-2014 at 12:13 PM by Pyplate

A few days ago I launched a new site called Banoffee Pi Server. It's running on a cluster of four Banana Pi servers running Nginx. I built the site with Pyplate CMS, a Python CMS that I wrote myself.

I built the web site on one server, and I used rsync to connect to the other servers over ssh and synchronize them. Pyplate generates static pages when caching is enabled. On this site every page can be cached, so there's no need to synchronize the entire CMS and database, just the...
LQ Newbie
Posted in Uncategorized
Views 325 Comments 0 Pyplate is offline

  



All times are GMT -5. The time now is 03:31 PM.

Main Menu
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