Ste Wright the Web Developer
So far, I’ve covered overclocking your Raspberry Pi, preparing to run your Raspberry Pi as a web server, installing Apache, PHP and MySQL and installing PhpMyAdmin. I’m assuming you’ve at least set your hostname and installed Apache, PHP and MySQL on your Raspberry Pi for this tutorial.
Before we go ahead and install WordPress, we need to ensure that outgoing email can be sent from your Raspberry Pi. In this tutorial, I’ll cover installing Postfix, which is a mail transport agent.
Good news all! I’m launching Dingleberry DNS, a free DNS service to allow you to point a domain to your Raspberry Pi. This service will allow you to access your Raspberry Pi remotely, run a website from your Raspberry Pi and much more.
Here’s what you need to qualify for free DNS:
- A registered domain, ie example.com
- A Raspberry Pi connected to the Internet
- A Static IP address (unfortunately I can’t support dynamic IP addresses yet).
Contact me to apply, all I’ll need is some information about your project and I’ll get the DNS set up. Hosted email can also be provided for a small fee.
In case you didn’t know, this site is hosted on a Raspberry Pi computer. The purpose of this project has been to establish whether or not the £30 computer was capable of reliably hosting a WordPress site, and so far the results have been promising.
PhpMyAdmin is a handy web interface for managing local MySQL databases, and can make database queries, management and backups easy.
In this tutorial, I’m going to talk you through installing PhpMyAdmin on your Raspberry Pi powered web server. I’m assuming you’ve got Raspbian installed, and you’ve followed my tutorial: install Apache, PHP and MySQL on Raspberry Pi.
The fundamental services required to turn your Raspberry Pi into a web server consist of Apache (the web server itself), PHP (scripting language) and MySQL (database server). When installed on a Linux based system, the collective term for these is LAMP.
There are other secondary services which aren’t quite as important at this stage to provide FTP and outbound mail, but that’ll be covered in a separate tutorial.
In this tutorial, you’ll learn how to squeeze as much performance as possible out of your Raspberry Pi, and prepare it ready to become a live functioning web server. Be sure to follow Installing Apache, PHP and MySQL on your Raspberry Pi once you’re done.
I’m assuming you know your way around Terminal, and you’ve got Raspian installed.
Over on the foundation web site, they’ve introduced Turbo mode, which is an update to configuration which allows up to 50% power gain without voiding your warrenty (unfortunately I’ve already adjusted CPU voltage on mine so no warranty for me!). It’s basically a firmware update and configuration that works by applying a ‘turbo configuration’ when the SoC reaches 85°C. Here’s how to apply the turbo configuration to your Raspberry Pi:
As you know I’ve been testing the boundaries of the basic hardware that makes up the Raspberry Pi. In my recent post I overclocked my Pi to 1GHz with some great results. Although under mathematical bench marks a considerable power gain was noted, I felt this didn’t make a huge improvement to the overall speed of the RPi as a web server.
Update: View my tutorial to safely overclock your Raspberry Pi using Raspi-config.
In a bid to squeeze more performance out of the Raspberry Pi that runs this web site, I experimented with over clocking. The results have been positive, although it is running noticeably hotter – more so than expected. As well as over-clocking the CPU the SDRAM speed was increased, and I knocked down the performance of the GPU in a bid to keep the chip cooler. It’s not unheard of for these to go to 1.2GHz, but I’m not going to push mine as much as that!