Database

How to Deploy a Django Application with Gunicorn and Nginx on RHEL 8 — step-by-step RHEL 8 tutorial on Progressive Robot

How to Deploy a Django Application with Gunicorn and Nginx on RHEL 8

Django is one of the most popular Python web frameworks, and deploying it in production requires more than the built-in development server. The recommended production stack on RHEL 8 pairs Django with Gunicorn as the WSGI application server and Nginx as a reverse proxy that handles static files, TLS termination, and connection management. This tutorial […]

Read more
How to Configure PHP-FPM with Nginx on RHEL 8 — step-by-step RHEL 8 tutorial on Progressive Robot

How to Configure PHP-FPM with Nginx on RHEL 8

PHP-FPM (FastCGI Process Manager) is the recommended interface between Nginx and PHP on RHEL 8, replacing the older mod_php approach with a more flexible and performant process pool model. Rather than embedding PHP inside the web server, PHP-FPM runs as a separate systemd-managed service that Nginx communicates with over a Unix socket, isolating the two […]

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

How to Install Symfony on RHEL 8

Symfony is a mature, enterprise-grade PHP framework and a collection of reusable components that power many of the world’s largest PHP applications, including Drupal and parts of Laravel itself. It emphasises strict standards, comprehensive testing support, and long-term support releases that align well with RHEL 8’s stability-first philosophy. This tutorial covers installing the Symfony CLI […]

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

How to Install Laravel on RHEL 8

Laravel is the most popular PHP framework in the world, offering an elegant syntax, a powerful ORM (Eloquent), built-in authentication scaffolding, and a rich ecosystem of first-party packages. Installing Laravel on RHEL 8 involves a few more steps than on a generic Linux distribution because of SELinux and the systemd-managed PHP-FPM service. This tutorial guides […]

Read more
How to Configure Database Connection Pooling with PgBouncer on RHEL 8 — step-by-step RHEL 8 tutorial on Progressive Robot

How to Configure Database Connection Pooling with PgBouncer on RHEL 8

PgBouncer is a lightweight connection pooler for PostgreSQL that sits between your application and the database server, reusing a small pool of backend connections across many client requests. Without a connection pooler, PostgreSQL must fork a new backend process for every client connection, consuming memory and CPU as connection counts grow. On RHEL 8, PgBouncer […]

Read more
How to Monitor MySQL with Prometheus mysqld_exporter on RHEL 8 — step-by-step RHEL 8 tutorial on Progressive Robot

How to Monitor MySQL with Prometheus mysqld_exporter on RHEL 8

Prometheus is a popular open-source monitoring system that collects metrics by scraping HTTP endpoints called exporters. The mysqld_exporter binary exposes MySQL server metrics in Prometheus format so you can build dashboards, set alerts, and track database health over time. In this tutorial you will create a dedicated MySQL monitoring user with least-privilege grants, deploy mysqld_exporter […]

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

How to Install and Configure Memcached on RHEL 8

Memcached is a high-performance, distributed memory object caching system used to speed up dynamic web applications by reducing database load. On RHEL 8, Memcached is available directly from the AppStream repository, making installation straightforward. In this tutorial you will install Memcached, tune its configuration, restrict network access to trusted hosts only, and verify the setup […]

Read more
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 Set Up ProxySQL for MySQL Load Balancing on Debian 12 — step-by-step Debian 12 tutorial on Progressive Robot

How to Set Up ProxySQL for MySQL Load Balancing on Debian 12

Introduction How to Set Up ProxySQL for MySQL Load Balancing on Debian 12 is a fundamental operation for any administrator maintaining a Debian 12 Bookworm server. Debian 12 Bookworm ships with the Linux 6.12 kernel, updated toolchains, and a fully refreshed package archive — meaning version numbers, configuration file paths, and some dependency chains differ […]

Read more
CHAT