MySQL

A hybrid cloud database is a mix of active database hosts residing on both on-premises and cloud infrastructures in a single operational system. In this blog, we’ll use ClusterControl to deploy a hybrid cloud MySQL database.

Hybrid environments database setups are not uncommon and are usually used for reasons like scalability, flexibility, high availability, disaster recovery. The blog describes how the MySQL replication can be used in mixed, on-prem and cloud environments.

This blog guides you on the things you have to keep in mind when deploying your Percona Server to a Hybrid Cloud. There's no differentiation with deploying on the regular ones, but there are drivers that you have to consider when deploying on a Hybrid Cloud.

Data is an essential part of a running Chamilo LMS platform, and backups are one of the most important things to take care of. In this blog we are going to look into how to backup your Chamilo data using ClusterControl.

With the increased usage of LMS systems, IT teams are struggling with the increased demand on their Moodle database. In this blog we will show you how to scale the Moodle MySQL database to increase performance.

Chamilo is a platform that allows educational institutions to transfer their educational activities to the internet. In this blog we will show you how to use ClusterControl to deploy a highly available MySQL database for the Chamilo LMS platform.

The Moodle MySQL database requires high-availability, especially when it's accessed by a large number of users. If your primary or master database crashes, an automatic failover must take over but managing your automatic failover requires careful planning and checks before finalizing the triggers for failover. This blog covers the solutions you can use to manage your database failover for MySQL and how to use them.

This blog post covers how to perform a benchmark of your Moodle site, allowing us to understand how our Moodle site performs in a given period of time. In a clustered setup, the performance of a Moodle cluster can be influenced by various factors like hardware resources, virtualization overhead, network latencies between servers, firewalls, caching and many more, and performing benchmarks is a solid way to test and estimate the Moodle performance before it goes live in production.

High availability Moodle requires a highly available database, and automatic failover plays a central role in minimizing the time to recover from a database failure. In this blog post, we will discuss how you can implement automatic failover for MySQL.

Data is an essential part of running a Moodle platform, and backups are one of the most important things to take care of while managing its databases. In this blog we are going to look into how to backup your Moodle data using ClusterControl.

Prior to MySQL 5.5, MyISAM was the default storage engine. In this blog post we will cover when, how, and why should you use MyISAM for MySQL.

In this blog, we are going to explain what you need to monitor the MySQL Moodle database and how you can do it easier using ClusterControl.

Open edX is one of most used open source learning management systems. In this blog we will show you how to deploy the Open edX MySQL database for high availability to ensure the performance of uptime of the database cluster.

More online users for Moodle means scaling the Moodle servers as well as the database backend. In this blog post we will discuss how to migrate from a standalone database to a highly available Moodle database based on MySQL Replication.

Character sets determine what characters are valid in a query string. In this blog, we discuss the importance and performance implications of choosing different character sets in MySQL.

Moodle is the top open source LMS out there but Covid19 has put a strain on many Moodle setups. This blog explains how you can easily scale out a Moodle MySQL database by using additional slave servers.

In this blog post we discuss how we can make use of advanced InnoDB settings in order to improve the performance of MySQL.

In this blog post we will help you figure out how to monitor the performance of your MySQL databases using ClusterControl.

Partitioning is a database design technique in which a database splits data into multiple tables, but still treats the data as a single table by the SQL layer. In this blog post, we discuss the advantages and disadvantages of partitioning in MySQL.

Backups are important in all Disaster Recovery Plans, but they don’t have any value if they are not usable. In this blog, we will see how to verify if your MySQL Backup is good to use in an easy way by using ClusterControl.

In this blog post, we are going to highlight the Query Outlier feature available in ClusterControl and see how it can help us improve the database performance.