RHEL 8

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

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

Percona XtraBackup is an open-source hot backup utility for MySQL and Percona Server that performs physical backups without locking tables or interrupting active queries on InnoDB tables. Unlike mysqldump, which produces logical SQL dumps, XtraBackup copies InnoDB data files directly and replays the transaction log to bring the backup to a consistent state, making it […]

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

How to Configure MariaDB Galera Cluster on RHEL 8

MariaDB Galera Cluster is a synchronous multi-primary replication solution that allows writes to be accepted by any node in the cluster simultaneously. Unlike standard MySQL asynchronous replication, Galera ensures that a transaction is committed on all nodes before it is acknowledged to the application, eliminating replication lag and the risk of data loss during failover. […]

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

How to Install ClickHouse Columnar Database on RHEL 8

ClickHouse is an open-source columnar database management system designed for real-time analytical queries over large datasets. Unlike row-oriented databases such as MySQL or PostgreSQL, ClickHouse stores data by column, allowing it to scan only the columns needed for a query and apply aggressive compression, resulting in query performance orders of magnitude faster for analytical workloads. […]

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

How to Configure Redis Cluster and Sentinel on RHEL 8

Redis provides two high-availability mechanisms: Sentinel for automatic failover on a primary-replica setup, and Cluster for horizontal partitioning across multiple nodes. Both are production-grade solutions supported on RHEL 8 through the EPEL 8 repository or directly from the Redis package. Understanding when to use each helps you design a topology that meets your durability and […]

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

How to Install Elasticsearch on RHEL 8

Elasticsearch is a distributed, RESTful search and analytics engine capable of handling large volumes of structured and unstructured data in near real time. It is the core component of the Elastic Stack, widely used for log aggregation, full-text search, and observability pipelines. On RHEL 8, installing Elasticsearch requires adding the official Elastic repository and configuring […]

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

How to Install and Configure SQLite on RHEL 8

SQLite is a serverless, file-based relational database engine that requires no installation of a separate server process and no ongoing administration. It stores an entire database — tables, indexes, and data — in a single cross-platform file, making it ideal for development environments, embedded applications, configuration stores, and lightweight production workloads that do not need […]

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

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

PostgreSQL provides two complementary tools for database backups: pg_dump and pg_basebackup. pg_dump takes logical backups of individual databases or selected objects and can restore to a different PostgreSQL version or host. pg_basebackup takes a physical, byte-for-byte copy of the entire data directory, which is the foundation of streaming replication and point-in-time recovery. This tutorial covers […]

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

How to Set Up PostgreSQL Streaming Replication on RHEL 8

PostgreSQL streaming replication continuously ships Write-Ahead Log (WAL) records from a primary server to one or more standby replicas in near real time. The standby can serve as a warm failover target or, in hot-standby mode, accept read-only queries to offload reporting traffic from the primary. This tutorial configures a two-node streaming replication setup on […]

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

How to Configure PostgreSQL Remote Access and SSL on RHEL 8

A default PostgreSQL installation on RHEL 8 only accepts connections from the local machine over a Unix socket. To allow client applications on other hosts to connect, you must configure the server to listen on a network interface, update the host-based authentication file, open the firewall port, and enable SSL so that credentials and data […]

Read more
How to Secure MySQL on RHEL 8 — step-by-step RHEL 8 tutorial on Progressive Robot

How to Secure MySQL on RHEL 8

MySQL ships with several default settings and accounts that must be hardened before the server handles production data. On RHEL 8, the combination of mysql_secure_installation, strict privilege grants, TLS enforcement, and the audit log plugin provides a strong baseline. This tutorial walks through each layer of MySQL security so that nothing is left at its […]

Read more
CHAT