Not Happy with Your Moodle Performance? Here's How to Maximise Your Server Resources
To run a clustered Moodle system efficiently, one has to allocate sufficient resources to the essential services required by Moodle. This is not an easy task, and it requires a lot of ongoing tuning until...
Using Redis to Offload Galera Cluster from Session Management Data in Moodle
There is a huge demand for a highly available Moodle system to have a Galera Cluster as the database backend due to its growing popularity and robustness. Galera Cluster turns the popular MySQL and MariaDB...
PGTune Alternatives – ClusterControl PostgreSQL Configuration
If you are new to PostgreSQL the most common challenge you face is about how to tune up your database environment. When PostgreSQL is installed it automatically produces a basic postgresql.conf file. This configuration file...
Tips for Delivering MySQL Database Performance – Part Two
The management of database performance is an area that businesses when administrators often find themselves contributing more time to than they expected. Monitoring and reacting to the production database performance issues is one of the...
Database Performance Tuning for MariaDB
(Updated on 17 September 2024) Ever since MySQL was originally forked to form MariaDB it has been widely supported and adopted quickly by a large audience in the open source database community. Originally a drop-in...
How to Optimize Performance of ClusterControl and Its Components
Monitoring and management are critical to any production environment because performance matters. Slow user interfaces that lag or do not respond, delayed alerts, and cluster job timeouts when the server is starved of resources are...
Webinar Replay: MySQL & MariaDB Performance Tuning for Dummies
Thanks to everyone who participated in this week’s webinar on Performance Tuning for MySQL & MariaDB! If you’ve missed the live session or would like to watch it again, it is now available online to...
A Performance Cheat Sheet for PostgreSQL
Performance is one of the most important and most complex tasks when managing a database. It can be affected by the configuration, the hardware or even the design of the system. By default, PostgreSQL is...
Understanding the MySQL Query Tuning Process
Query tuning is something that a DBA does on a daily basis - analyse queries and updates, how these interact with the data and schema, and optimize for performance. This is an extremely important task...
MySQL Configuration: Tuning for Performance
A database server needs CPU, memory, disk and network in order to function. Understanding these resources is important for a DBA, as any resource that is weak or overloaded can become a limiting factor and...