Moving WordPress Between AWS Regions – EC2 and RDS In previous articles, I’ve described how to set up WordPress in AWS using EC2 and RDS. In this article I’ll describe the steps I took to move the server between regions and get it working again – in my case from…
Fixing WordPress indexes, foreign keys and auto_increment fields
I recently migrated a number of WordPress websites and a custom PHP website from AWS RDS to MySQL on an EC2 instance using the AWS Database Migration Service. I didn’t know beforehand that secondary indexes, foreign keys, and auto_increment fields aren’t migrated – this made a heck of a mess,…
How to Migrate from RDS to MySQL on EC2
Introduction A year ago I moved all my websites to AWS using the free tier, using an EC2 t2.micro and the RDS relational database service. Now that my year of free tier is up I’d like to reduce my costs. I want to migrate from RDS to MySQL on EC2.…
Migrating WordPress Sites Into AWS – Part Three – Hosting WordPress on AWS Tutorial
Introduction This multi-part tutorial is a complete guide to setting up WordPress on AWS. This part of our tutorial helps set up Amazons RDS (Relational Database Service) as required for WordPress, install Wordpress, optionally install WordPress Multisite, and import your current WordPress site into WordPress single or multi site. Links to other parts…
Setting up AWS for WordPress with EC2, RDS, Nginx, HHVM – Part Two – Hosting WordPress on AWS Tutorial
Introduction This multi-part tutorial is a complete guide to Setting up WordPress on AWS. This part of our tutorial sets up an AWS Account, Relational Database Service, then installs the necessary system software such as Nginx, HHVM for PHP, SSMTP for email, and Monit for monitoring. Links to other parts of…