Moodle Cluster on OCI with MySQL database service

The this architecture contains a public load balancer, two moodle application server on Apache, two read-write shareable storages for html files, and a database tier with MySQL Database Service.

Architecture Review

• A virtual cloud network with a public and a private subnet to avoid direct access from the public internet, hence you will have a public load balancer. Because you will not want to expose your application servers, just a thought.
• Your application servers will run in the private network
• Two read-write shareable block storages for your cluster files.
• MySQL, enterprise-level database cloud service running on OCI in the private subnet.
• A bastion server will grant your access wish to your application servers and MySQL Database service.

Deploy using Resource Manager

1. If you have your cloud tenancy running ready and ready to start with this deployment on using resource manager stack, which is automated terraform manager click here and will re-direct you to OCI.
2. Login to your Oracle cloud tenancy with appropriate credentials.
3. Review and accept Oracle Terms of Use.
4. Enter a name for this deployment and choose target compartment, then click next
5. Follow the on-screen prompts and instructions to create the stack.
6. Once stack is created, click on Terraform Actions, and choose Plan.
7. Wait for the plan job to be completed. Click on Terraform Actions again, this time choose Apply.
8. Check out apply job output and wait until it finishes.

Clone to your local machine

If you want to run this terraform from your local machine, use below commands to clone it.

git clone https://github.com/hol-workshop/moodle.git
cd moodle
ls

Environment parameters

variable "tenancy_ocid" {}
variable "region" {}
variable "compartment_ocid" {}

Create the Resources

Once you are in your downloaded diretory, run the following commands:

terraform init
terraform plan
terraform apply

Test

Now it's time to check your connectivity. Open your web browser and enter output of Moodle_LB_IP_address slash moodle.

For example, following was my output:

• http://132.145.227.203/

You will have to simply follow the wizard here and update some parameters:

• Database host, this is your MysqlDB_Private_IP output
• Database name, moodle
• Database user, moodle
• Database password, MoodleAdm1n_
• Tables prefix, mdl_
• Database port, 3306

It will take you 1-2 mins for completing wizard and you will have fully working moodle environment afterwards. Goodluck!

https://youtu.be/fCxtCtD7S28