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.…

Free HTTPS and HTTP2 for WordPress using Lets Encrypt on AWS – Part Five – 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 we’ll set up HTTPS and HTTP/2 using free Let’s Encrypt certificates, and update WordPress to work on the new URL. Links to other parts of our tutorial Part One, Introduction Part…