Powering WordPress with Auto-Scaling AWS Aurora RDS

I recently inherited a pretty massive site. With over 100,000 posts, 200,000 attachments, and site loads reaching 4000+ visitors and anywhere from 5–9 logged-in authors at any one time, it’s been one of the largest projects I’ve tackled.

While a proper reverse-proxy solution can mitigate the majority of the front-end load on a project like this, handling even just a few logged-in users becomes a bit of a process. You can’t cache those sessions and requests, and some of the uglier and slower queries baked into WordPress core and plugins like Yoast start to rear their ugly heads.

Until the proper query optimizations can be made, I needed to configure the site’s database solution to roll out replicas in response to increasing load. AWS’s auto-scaling Aurora RDS turned out to be a great solution for this. Here’s how it works…

READ THE FULL STORY BY CLICKING HERE