Tips and Tricks for Implementing Database Role-Based Access Controls for MariaDB
In a database management system (DBMS), role-based access controls (RBAC), is a restriction on database resources based on a set of pre-defined groups of privileges and has become one of the main methods for advanced...
Monitoring MariaDB Performance in a Hybrid Cloud
Performance in our MariaDB database is one of the areas we want to closely monitor and observe in a production environment and its timely running condition. It can be extremely demanding for time, work, and...
Running MariaDB in a Hybrid Cloud Setup
The term “hybrid” is popular nowadays. Hybrid is used for vehicles, applications, financials, and also cloud. For example, in the vehicle's use case, the hybrid means combining the power of the gasoline engine with an...
How to Backup Your Moodle MariaDB Database
Previously, we had blogged about backing up your Moodle MySQL Database. This time, it's all about backing up your Moodle MariaDB Database. In fact, it shares the same approach when backing up your Moodle MySQL...
How to Deploy the Chamilo MariaDB Database for High Availability
Learning Management System (LMS) platforms allow you to learn/teach remotely, something that is really important due to the current situation around the world. That being said, we can also say High Availability is a must...
How to Automatically Manage Failover of the MySQL Database for Moodle
In our previous blogs, we made justification for why you need a database failover and have explained how a failover mechanism works. I’m sharing this in case you have questions on why you should set...
Boosting Performance by Using Read Write Splitting of Database Traffic with Moodle 3.9
Moodle is a very well known Learning Management System which is intended to help educational organizations organize their online learning activities. As you can imagine, given the online shift in 2020 caused by the COVID-19,...
Tips for Storing Your MariaDB Backups in the Cloud
Having a good Disaster Recovery Plan is a must in all companies to prevent data loss or reduce downtime in case of failure. For this, backups are a basic point here, and it is essential...
Database Design 101: Partitions in MySQL
In this blog post we are going to be discussing one of the most widely used features of MySQL - partitions. What is Partitioning? In MySQL, partitioning is a database design technique in which a...
What is a Query Outlier and How to Fix It
The MySQL database workload is determined by the number of queries that it processes. There are several situations in which MySQL slowness can originate. The first possibility is if there are any queries that are...
How to Deploy MariaDB Cluster 10.5 for High Availability
MariaDB Cluster 10.5 deployment has been supported in ClusterControl since version 1.8.1. MariaDB 10.5 is equipped with: More Granular Privileges InnoDB Performance Improvements Full GTID Support for Galera Cluster More Metadata for Replication and...
An Overview of ProxySQL Clustering in ClusterControl
ProxySQL is a well known load balancer in MySQL world - it comes with a great set of features that allow you to take control over your traffic and shape it however you see it...