MySQL Replication System on CentOS 8 with MySQL 8.0
MySQL replication is a process of copying data changes from a primary server (master) to one or more secondary servers (slaves). This creates a redundant…
Read article
Load balancing in mysql 8.0 using HAPROXY
Introduction to HAPROXY: HAProxy, or High Availability Proxy, is an open-source load balancer and proxy server for TCP and HTTP applications. It’s well-known for its…
Stop Catalog Bloat: Boost PostgreSQL Performance by Replacing Temporary Tables
Recently, we encountered an issue where catalog queries executed by the drivers during session creation were taking significantly longer than expected. These queries, managed by…
High Availability in MySQL 8.0 using INNODB Cluster in CentOS-08
High Availability (HA) in MySQL refers to a collection of options and solutions meant to keep the MySQL database system operational even during times of…
PostgreSQL 17’s New Backup Feature: Incremental Backups
Introduction With the release of PostgreSQL 17, a game-changing feature has arrived: incremental backups. In prior versions, such as PostgreSQL 16 and earlier, users could…
Protect Your Data with Point-In-Time Recovery (PITR) in MySQL
Point-in-time recovery (PITR) helps to recover data from unintentional deletions and modifications. Ways to recover the data Recover the complete database, backup or export it…
