Has anyone built a load-balanced Moodle cluster using Amazon EC2 and Amazon's Auto-Scaling yet? I am going to be setting up a Moodle site that could potentially see a large number of users (max is 100k) , but we don't have any metrics to give us an idea of what our initial load is going to be. I am initially thinking of setting it up with an elastic load balancer in front of 2 web servers and the MariaDB on a separate server. I am just wondering if anyone has done something similar to this.
I have not only because I dont have a good solution for a shared filesystem. How do you plan to implement shared files? Are you planning multiple web servers to horizontally scale performance or protection from failure?
I am still trying to plan this out. I am thinking of using an elastic load balancer in front and use multiple web-servers to horizontally scale to handle extra connections. The /moodledata folder I figured I would host on the server I host mysql on. I am still trying to work through how to set up the web servers to auto-scale and I also don't have a solution for auto-scaling MariaDB. I think I would need to manually set it up as a cluster.
You can scale with Galera, MariaDB is available as an option along with Percona and standard MySQL. We have been using it as from my previous posts.
Deploy with the ClusterControl for auto everything, really nice GUI with xtrabackup, auto recovery, node auto-join