In this article, we see how to offload Moodle's read queries to MySQL HeatWave Read Replicas

If you want to deploy Moodle on OCI, you can use Ampere compute instances as application server and MySQL HeatWave Database Service to store the data.

Depending on your requirements, MySQL HeatWave can provide High Availability and Query Acceleration.

In this post, we will see the easiest and fasted way to deploy the following basic architecture:

In OCI to quickly deploy an architecture and all the required resources, it’s recommended to use a Stack (Terraform recipes and modules).

So deploy all the resources we need (VCN, Subnets, Security Lists, Internet Gateways, Compute Instances…) we just need to click on the following button:

…

Moodle is an open-source learning management system (LMS) that provides a platform for educators and learners to create, manage, and participate in online courses and educational activities. Moodle is widely used in schools, universities, and other educational institutions to facilitate online learning, course management, and collaboration. Moodle and MySQL have always been a very powerful […]

In this article, you will learn how to easily and quickly deploy Moodle, the most popular open source learning management system, on OCI using an Ampere compute instance and MySQL HeatWave Database Service.

I know, we just released version 8.1, so isn’t it a bit early to think about version 10 now? But 5.7 has almost reached its end of life, and MySQL engineers are already working on 8.2 and 8.3. With this speed, we can expect to get to version 10 within a few years. And what […]

I appreciate you visiting my corner of the internet and giving me your time. This week’s OpenLampTech developer newsletter is no less epic so you are spending your time wisely. Thank you!

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

This week in OpenLampTech issue #85, we have curated content on:

• Securing Laravel’s writer developer interview
• MySQL 5.7 EOL
• WordPress reusable blocks …

This post was originally published in July 2018 and was updated in July 2023.

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL?  What are the differences between Aurora and RDS? How do I choose which one to use?

In this blog, we will answer all of these important questions and provide a general overview comparing the two database services, Aurora vs RDS.

Understanding DBaaS

DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. But …

Using MySQL Shell, we can dump and load databases across cloud providers. In this post, we will discuss how to dump a MySQL database running in Azure to an Azure storage container and then load that data into a MySQL HeatWave instance running in Oracle Cloud Infrastructure.

Starting with MySQL Shell 8.0.33, it’s possible to fully enable SSL/TLS certificate-based authentication seamlessly across an InnoDB Cluster, ClusterSet or, ReplicaSet setup. Let’s dive into the details of the new features with complete examples of how to set up the strongest encryption configuration possible. Certificate Based Authentication For Intra-node Communication To secure and validate users for the […]

In a recent post I talked about how we can move data from MySQL running in AWS to a MySQL HeatWave Database instance running in Oracle Cloud Infrastructure (OCI) with just two commands using MySQL Shell. In this post, I will show how we can use a similar process to move data from Microsoft Azure to OCI. Prerequisites There are a few […]