Questions about Creating Load Balanced WP setup

steelliberty

I am planning on creating a DigitalOcean load-balancer and then creating an NFS and two wordpress droplets and I trying to decide whether to create a database box or use digitalocean's managed DB -- I want to use WO, of course, for all future applications. Has anyone had any experiencing do this ? Any advice -- Thank you.

corus9

i'm doing something similar with aws lightsail instance + lightsail db + s3 bucket

installed wo on lightsail instance
mysql lightsail
uploads on s3 bucket
this guide helped with remote sql : https://docs.wordops.net/how-to/remote-mysql-server/

sashman13

Not sure if a load balancer will really help that much if you are using a shared database. Most of the WP load is database and not really PHP or bandwidth. You also still have the single point of failure at the DB. In order to really benefit off of two servers you really need to set up two databases and sync them. master-master mysql galera cluster.

jond1

Sashman is correct. It really depends on the level of redudancy you want.

I had previously setup a horizontally and vertically scalable infra on AWS, where the DB was replicated across zones in a single DC, same with EC2 instances.

Totally doable.

The main choke point I ran into was that I had to create images every time I wanted to update the code, rolling out a new AMI across the images. It wasn't ideal, but it did allow me to serve up the same code to all front end servers.

It's absolutely doable, takes time to configure and setup.

At the end of the day, it's a lot to maintain and really depends on the business needs, or if it's for fun to learn, etc.

jond1

Further detailing out the main choke point, it was the WordPress files themselves. I couldn't share php files over EFS because the latency was too high. Had to be on the image itself.

I also used Redis for clustered caching