Relational database with MariaDB
Calculate the optimal InnoDB buffer pool size based on available RAM, configure the parameter in my.cnf, and restart MyS…
Set up a primary and a replica node using MariaDB 11.4 on Ubuntu 24.04. Configure binary logging, grant replication priv…
Configure a primary MariaDB server and a replica to accept read queries only. Follow these steps to enable read-only mod…
Configure binary logging in MariaDB 11.4 to enable point-in-time recovery. Set global variables, restart the server, and…
Install MySQL Server 8.4 on AlmaLinux 9 using the official repository. Configure the service, create a root password, an…
Enable the slow query log, set the threshold, and configure rotation for MariaDB on Ubuntu 24.04.
Enable binary logging in MariaDB to capture all data changes. Follow these steps to configure the server, restart it, an…
Set up a master-slave replication cluster and install the MHA manager on a separate node to enable automatic failover.
This guide explains how to load a .sql backup file into MariaDB 11.4 using the mysql client. Follow these steps to impor…
Create a FULLTEXT index to enable full-text search queries in MariaDB 11.4. This guide covers prerequisites, index creat…
This guide installs MariaDB 11.2 on Ubuntu 24.04 (Noble) using the official repository. It covers repository setup, serv…