Download your favorite Linux distribution at LQ ISO.
Go Back > Blogs
User Name


This blog is about the development of my various Linux based web sites, starting with, Banoffee Pi Server and Pyplate Python SQlite CMS.

Using SQLite on a Raspberry Pi

Posted 09-06-2013 at 07:54 AM by Pyplate

I've written an article on my site about using SQLite on a Raspberry Pi. I've only covered the bare essentials, but it's enough to get started.

I've used examples based on a database that could be used to log temperatures. I've already covered the use of a DS18B20 sensor, so I may as well build a temperature logging system.
LQ Newbie
Posted in Uncategorized
Views 724 Comments 0 Pyplate is offline

Explain Shell

Posted 09-04-2013 at 12:35 AM by Pyplate

I found a great site for decoding Linux commands:

You can type in commands and arguments, and it tells you what the options do.
LQ Newbie
Posted in Uncategorized
Views 1303 Comments 1 Pyplate is offline

Apache performance tuning

Posted 08-23-2013 at 07:10 PM by Pyplate

I've spent the last few days tuning Apache. I've achieved quite a good performance increase, mostly by disabling unused modules. In tests with siege, my cluster can now handle over 900 transactions per second. Here's the full article on server cluster tuning.
LQ Newbie
Posted in Uncategorized
Views 584 Comments 0 Pyplate is offline

Raspberry Pi Server Cluster Performance

Posted 08-15-2013 at 04:36 PM by Pyplate

I've done some testing on my cluster. 4 Pies is definitely better than one, there's a big difference in performance between a single Pi and a 4 node cluster. You can read more detail here: server cluster testing.

As you'd expect, a cluster of four Raspberry Pies isn't that powerful, but setting it up has been interesting. It can handle a surprising amount of traffic - I got 2800 visits from Reddit yesterday. The minimum page load time is over a second (as tested on my local network),...
LQ Newbie
Posted in Uncategorized
Views 1100 Comments 0 Pyplate is offline

Load balanced cluster with Raspberry Pies

Posted 08-13-2013 at 03:19 PM by Pyplate

I finally got around to doing it. I've set up a 4 node Raspberry Pi cluster. It's not that powerful, but setting it up has been good practice.

I used an old PC running Lubuntu as a load balancer. I just installed Apache and I'm using Apache's balancer module. I installed Lubuntu because I'm using a very old PC that has 512MB of RAM. The PC is more powerful than the cluster, but if I just used the PC as a server, I wouldn't have learned anything about load balancing.
LQ Newbie
Posted in Uncategorized
Views 465 Comments 0 Pyplate is offline


All times are GMT -5. The time now is 07:15 PM.

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