SQL, NoSQL, optimization
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…
Create a Timescale extension, add a hypertable to an existing table, and configure continuous aggregates for efficient t…
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.
Set up a MariaDB read-only replica on Ubuntu 24.04. Configure replication filters, enable read-only mode, and verify the…
Enable binary logging in MariaDB to capture all data changes. Follow these steps to configure the server, restart it, an…
Convert a standard PostgreSQL table into a TimescaleDB hypertable to enable efficient time-series storage and querying.…
Learn to split large tables into smaller chunks using declarative partitioning. This guide covers creating parent tables…
Set up a master-slave replication cluster and install the MHA manager on a separate node to enable automatic failover.