Database

How to Monitor MySQL with Percona Monitoring and Management on RHEL 7 — step-by-step RHEL 7 tutorial on Progressive Robot

How to Monitor MySQL with Percona Monitoring and Management on RHEL 7

How to Monitor MySQL with Percona Monitoring and Management on RHEL 7 Percona Monitoring and Management (PMM) is a free, open-source platform for monitoring MySQL, MariaDB, PostgreSQL, and MongoDB. It combines Grafana dashboards, Prometheus metrics collection, and Query Analytics (QAN) into a single integrated UI. Unlike generic monitoring tools, PMM understands database internals and surfaces […]

Read more
Common Problems 118111

Ubuntu 18.04 MySQL InnoDB Crash Recovery Loop

🟡 Medium   ⏱ 5–30 min  Last verified: 16 September 2021 📖 ~1 min read Table of contents Symptom & Impact Environment & Reproduction Root Cause Analysis Quick Triage Step-by-Step Diagnosis Solution – Primary Fix Solution – Alternative Approaches Verification & Acceptance Criteria Rollback Plan Prevention & Hardening Related Errors & Cross-Refs References & Further […]

Read more
How to Install MySQL via AIX Toolbox on IBM AIX 7.2 — step-by-step IBM AIX 7.2 tutorial on Progressive Robot

How to Install MySQL via AIX Toolbox on IBM AIX 7.2

Introduction IBM AIX 7.2 is the latest release of IBM’s enterprise-grade UNIX operating system, running on IBM Power Systems hardware. Known for its reliability, security, and performance in mission-critical environments, AIX 7.2 introduces enhanced virtualization, security hardening, and cloud integration features. This guide covers how to install mysql via aix toolbox on ibm aix 7.2 […]

Read more
How to Install MariaDB on FreeBSD 13 — step-by-step FreeBSD 13 tutorial on Progressive Robot

How to Install MariaDB on FreeBSD 13

Introduction This guide explains how to Install MariaDB on FreeBSD 13 on FreeBSD 13. FreeBSD uses the pkg(8) binary package manager, rc.conf(5) for service startup configuration, and pf(4) as its primary packet filter. There is no SELinux or AppArmor — instead, FreeBSD provides the MAC (Mandatory Access Control) framework and Capsicum for fine-grained privilege separation. […]

Read more
How to Set Up Prometheus and Grafana Monitoring on Windows Server 2016 — step-by-step Windows Server 2016 tutorial on Progressive Robot

How to Set Up Prometheus and Grafana Monitoring on Windows Server 2016

How to Monitor Windows Server with Prometheus and Grafana on Windows Server 2016 Prometheus and Grafana form a powerful open-source monitoring stack widely used in both Linux and Windows environments. Prometheus is a time-series metrics database that scrapes exporters at regular intervals. Grafana is a visualization platform that queries Prometheus and renders dashboards. On Windows […]

Read more
How to Secure MySQL on FreeBSD 13 — step-by-step FreeBSD 13 tutorial on Progressive Robot

How to Secure MySQL on FreeBSD 13

Introduction FreeBSD 13 is a UNIX-derived operating system renowned for its network stack performance, ZFS integration, and Jail isolation primitives. Setting up secure mysql on freebsd 13 on FreeBSD 13 follows the rc.conf/service(8) paradigm rather than systemd, which means enabling a service and configuring its startup options are done differently from any Linux distribution. This […]

Read more
How to Configure Ruby via AIX Toolbox on IBM AIX 7.2 — step-by-step IBM AIX 7.2 tutorial on Progressive Robot

How to Configure Ruby via AIX Toolbox on IBM AIX 7.2

Introduction IBM AIX 7.2 is the latest release of IBM’s enterprise-grade UNIX operating system, running on IBM Power Systems hardware. Known for its reliability, security, and performance in mission-critical environments, AIX 7.2 introduces enhanced virtualization, security hardening, and cloud integration features. This guide covers how to configure ruby via aix toolbox on ibm aix 7.2 […]

Read more
How to Set Up a Local Container Registry with Harbor on RHEL 8 — step-by-step RHEL 8 tutorial on Progressive Robot

How to Set Up a Local Container Registry with Harbor on RHEL 8

Harbor is an enterprise-grade, open-source container registry that extends the base OCI registry specification with role-based access control, project isolation, image vulnerability scanning powered by Trivy, and cross-datacenter image replication. Running your own Harbor instance on RHEL 8 gives your team a private, auditable registry with no bandwidth costs or rate-limiting imposed by Docker Hub. […]

Read more
Common Problems 117522

Ubuntu 20.04 LTS PostgreSQL Won’t Start After Crash Recovery

🟠 High   ⏱ 5–30 min  Last verified: 3 September 2021 Affected versions: 20.04 LTS 📖 ~1 min read Table of contents Symptom & Impact Environment & Reproduction Root Cause Analysis Quick Triage Step-by-Step Diagnosis Solution – Primary Fix Solution – Alternative Approaches Verification & Acceptance Criteria Rollback Plan Prevention & Hardening Related Errors & […]

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

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

How to Use Percona XtraBackup for MySQL Hot Backups on RHEL 7 Taking reliable backups of a live MySQL or MariaDB database without interrupting application traffic is a fundamental requirement for any production system. mysqldump works for small databases but locks tables and can run for hours on large datasets. Percona XtraBackup solves this problem […]

Read more
CHAT