A MySQL database index is a data structure that improves the speed of operations in a table. In this post, we discuss the benefits and the drawbacks of using indexes in MySQL.

HAProxy is one of the most popular HA, load balancing, and proxy solutions available in the market. It works with Layer 4 (TCP) and Layer 7 (HTTP), but what makes it worth is that it's lightweight, very flexible, and can be configured by throttling the numbers of connections requested to the HAProxy server(s). In this blog, we simplify how this is handled and how it can be achieved in a simple manner.

HAProxy is free, open source software that provides a high availability load balancer and proxy server for TCP and HTTP-based applications that spreads requests across multiple servers. In this blog we look at what’s new in it’s latest release.

Load balancers can be deployed into a number of topologies to achieve high availability for the database service with zero single-point-of-failure (SPOF). This blog post covers the pros and cons of distributed or centralized setup for your database load balancers.

In this blog, we will show you how to achieve high availability for PostgreSQL  using HAProxy and PgBouncer on top of your PostgreSQL cluster.

GridFs is an abstraction layer in MongoDB used in the storage and recovery of large files like videos, audios, and images. This blog will show you how to use this new feature.

A database Load Balancer is a middleware service that stands between applications and databases and it distributes the workload across multiple database servers running behind it.

Performance for PostgreSQL is one of the fundamentals when managing your database cluster especially for production workload. This blog covers tunable parameters that adds performance boost plus how HAProxy can add extra performance boost for your PostgreSQL database cluster.

Managing and Monitoring is a must in all applications/systems, and Moodle is not an exception, taking an important role nowadays in pandemic times. In this blog, we will take a look at what you need to manage and monitor in a Moodle Database, and how you can do it easier using ClusterControl.

Moodle may be easy to scale, but its database backend is not. In this blog we share some tips on how you can horizontally scale out Moodle’s database.

The new MongoDB 4.4 has several new features and functions, most of which are based on direct feedback from developers and members of the MongoDB community. In this blog we take a look at these new features.

The e-learning platform Moodle supports PostgreSQL as an option for the underlying database. In this blog we will show you how to deploy a highly available PostgreSQL cluster for the Moodle application.

MySQL Replication can be used as the database for Moodle implementations. In this blog we will show you how to deploy a highly available Moodle database using a master/slave MySQL setup.

Moodle supports using MariaDB as its database, either as a replication setup or using MariaDB Cluster. In this blog we will show you how to deploy a highly available Moodle database using both of these options

The multi-cloud approach for databases, despite being harder to manage, is growing in popularity as it helps architect against failure and mitigates the risk of cloud lock-in.