LinuxQuestions.org
Visit the LQ Articles and Editorials section
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

Scaling out my Banana Pi server cluster

Posted 12-19-2014 at 08:36 AM by Pyplate
Updated 12-19-2014 at 03:14 PM by Pyplate

I've updated Pyplate to support multiple sites on a single server. Each site has its own Pyplate CMS directory, its own web root directory and its own set of tables in the database. The tables for each site are prefixed with the domain name of the site (with '_' replacing '.').

The database is stored on a MySQL database cluster using master/slave replication, so the tables for each site are accessible from each database server node.

I've dropped the idea of using...
LQ Newbie
Posted in Uncategorized
Views 93 Comments 0 Pyplate is offline
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 139 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 157 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 279 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 356 Comments 0 Pyplate is offline

  



All times are GMT -5. The time now is 10:37 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