Video: Deploying Wordpress on Multiple Load-Balanced Servers on Amazon EC2

I gave this brief talk about deploying a high-traffic Wordpress site on EC2 in Fall 2011 at the Gainesville Hackerspace. The content discussed here can be considered a follow-up to my post on solving a file-synchronization issue when deploying Wordpress across multiple servers on EC2.

Deploying Wordpress: Syncing Files in a Multi-Server Installation

Recently, some of my company’s WordPress sites have become so popular that I chose to migrate them onto a multiple-webserver deployment system in order to keep up with the traffic.  I encountered some interesting challenges while setting this up, so I figured I’d document them here.

Amazon EC2 Instance cannot Connect to Amazon RDS Database Server

While designing a new deployment system for my company with Amazon’s AWS, I stumbled onto a problem that cost me some time - I could not get my EC2 instances to connect to our Amazon RDS database servers. I figured I’d document the solution here for the sake of those to follow.

I had created two webservers, and a MultiAZ instance of an RDS server with which they were to transact. I could connect to each webserver and the RDS server directly, but I could not get the webservers to connect to the RDS. The issue ultimately ended up being related to my security groups configuration.