RHEL 9

How to Use Percona XtraBackup for MySQL Hot Backups on RHEL 9 — step-by-step RHEL 9 tutorial on Progressive Robot

How to Use Percona XtraBackup for MySQL Hot Backups on RHEL 9

Percona XtraBackup is the industry-standard open-source tool for online, non-blocking hot backups of MySQL and MariaDB InnoDB databases. Unlike mysqldump, which produces a logical SQL dump and requires more time for large databases, XtraBackup performs a physical backup — copying InnoDB data files directly while MySQL is running, without acquiring table locks that would block […]

Read more
How to Configure MariaDB Galera Cluster on RHEL 9 — step-by-step RHEL 9 tutorial on Progressive Robot

How to Configure MariaDB Galera Cluster on RHEL 9

MariaDB Galera Cluster is a synchronous multi-primary cluster for MariaDB/MySQL that provides true high availability with no single point of failure. Unlike standard primary-replica replication where only one node accepts writes and replicas are read-only, Galera Cluster allows writes to any node simultaneously — all nodes are always primary, always in sync, and always up-to-date. […]

Read more
How to Install ClickHouse Columnar Database on RHEL 9 — step-by-step RHEL 9 tutorial on Progressive Robot

How to Install ClickHouse Columnar Database on RHEL 9

ClickHouse is a column-oriented database management system (DBMS) designed for Online Analytical Processing (OLAP). Unlike row-oriented databases (MySQL, PostgreSQL) where each row is stored together — efficient for retrieving full records — ClickHouse stores each column separately, making it extremely efficient for aggregation queries that scan specific columns across billions of rows. ClickHouse can process […]

Read more
How to Configure Redis Cluster and Sentinel on RHEL 9 — step-by-step RHEL 9 tutorial on Progressive Robot

How to Configure Redis Cluster and Sentinel on RHEL 9

A single Redis instance has two failure modes: if the server goes down, all cached data is lost and every request hits the origin database; and if the dataset grows beyond a single server’s RAM, there’s no built-in way to distribute it. Redis provides two solutions: Redis Sentinel for high availability (automatic failover with a […]

Read more
How to Install Elasticsearch 8 on RHEL 9 — step-by-step RHEL 9 tutorial on Progressive Robot

How to Install Elasticsearch 8 on RHEL 9

Elasticsearch is a distributed, RESTful search and analytics engine built on Apache Lucene. It stores data as JSON documents in indices and provides near-real-time full-text search, log aggregation, metrics analysis, and complex aggregation queries through a simple HTTP/JSON API. Elasticsearch is the core component of the Elastic Stack (ELK Stack) — Elasticsearch stores and searches […]

Read more
How to Install and Configure SQLite on RHEL 9 — step-by-step RHEL 9 tutorial on Progressive Robot

How to Install and Configure SQLite on RHEL 9

SQLite is a self-contained, serverless, zero-configuration SQL database engine that stores an entire database in a single file on disk. Unlike MySQL, PostgreSQL, and MongoDB which require a running server process, SQLite is a library that is linked directly into the application — there is no network connection, no authentication, and no administration overhead. SQLite […]

Read more
How to Back Up PostgreSQL with pg_dump and pg_basebackup on RHEL 9 — step-by-step RHEL 9 tutorial on Progressive Robot

How to Back Up PostgreSQL with pg_dump and pg_basebackup on RHEL 9

PostgreSQL provides two complementary backup tools: pg_dump for logical backups of individual databases (SQL statements that can be restored to any PostgreSQL version) and pg_basebackup for physical backups of the entire database cluster (exact byte-for-byte copy of the data directory, used for streaming replication setup and point-in-time recovery). pg_dump is the right tool for most […]

Read more
How to Set Up PostgreSQL Streaming Replication on RHEL 9 — step-by-step RHEL 9 tutorial on Progressive Robot

How to Set Up PostgreSQL Streaming Replication on RHEL 9

PostgreSQL Streaming Replication sends WAL (Write-Ahead Log) records from a primary server to one or more standby servers in near-real-time, keeping standbys continuously synchronised with the primary. This provides high availability (automatic or manual failover when the primary fails), read scaling (queries can be distributed to hot standbys), and geographic redundancy. Unlike logical replication which […]

Read more
How to Configure PostgreSQL Remote Access and SSL on RHEL 9 — step-by-step RHEL 9 tutorial on Progressive Robot

How to Configure PostgreSQL Remote Access and SSL on RHEL 9

By default, PostgreSQL only accepts connections from localhost using peer or ident authentication. Enabling remote access requires two configuration changes: editing postgresql.conf to listen on a network interface, and editing pg_hba.conf to permit remote connections from specific hosts or subnets. Beyond network access, encrypting the connection with SSL/TLS is essential for any deployment where database […]

Read more
How to Secure MySQL: Remove Root Remote Login, audit_log on RHEL 9 — step-by-step RHEL 9 tutorial on Progressive Robot

How to Secure MySQL: Remove Root Remote Login, audit_log on RHEL 9

A default MySQL installation has several security weaknesses: a root account that may be accessible remotely, anonymous user accounts, a test database anyone can access, and no audit logging of who accessed what data. Securing MySQL is essential before any production deployment and covers four main areas: access control (who can connect from where), authentication […]

Read more
CHAT