I have two Raspberry Pi's, and an old Linux box. Out of these three I want to create a reliable web server and a reliable MySQL server - however I need one of the Raspberry Pi's to be the main web server.
After having done some research, I have come up with a few scenarios that would provide both of those:
Primary Raspberry Pi hosting web, Second Raspberry Pi hosting MySQL, Linux box backing up both every 15 minutes.
Primary Raspberry Pi hosting web, Secondary Raspberry Pi hosting backup web, Linux box load balancing (some how?) and also hosting MySQL, then periodically backing MySQL up to an FTP server "in the cloud", should anything go wrong.
Which one of these two is the better idea, or can you think of something better yourself? How would I even start setting up a load balancer? I'd prefer to cut down CPU usage on the Linux box, as is is also used as a personal streaming server.
I also want to make the website as fast as possible, and would separating MySQL and Apache across a local network make that slower?
This is just for a personal site - I'm not expecting too much traffic. Thanks to anyone who can help.
I forgot to mention - I'm serving Dynamic content through PHP, which is what is connecting to MySQL. The specs of the Linux box are OK-ish - it was a media centre Windows PC from about 2004, so it can handle stuff like live transcoding for Plex Media Centre. As far as I can remember it's a Core 2 Duo with 512 MB of DDR2 RAM.