Raul Pessoa

Master-Slave Replication in MySQL: A Step-by-Step Guide

MySQL /

Introduction MySQL master‑slave replication remains a foundational technology for database scaling, high availability, and disaster recovery. As a Senior Database Administrator, I routinely design and maintain replication topologies that support mission‑critical workloads. In this post we dive into the practical steps required to set up a reliable master‑slave pair, address common pitfalls, and outline best […]

Master-Slave Replication in MySQL: A Step-by-Step Guide Read More »

Setting Up PostgreSQL Streaming Replication for HA

PostgreSQL /

Introduction Streaming replication is the cornerstone of modern PostgreSQL high‑availability solutions. Unlike file‑based WAL shipping, streaming sends WAL records over a TCP socket in real time, allowing a standby to stay close to the primary’s state. This post walks through every step you need to set up streaming replication, from basic configuration to advanced fail‑over

Setting Up PostgreSQL Streaming Replication for HA Read More »

Automating SQL Server Backups with PowerShell: Simplify Your DBA Workload

SQL Server /

Why Automate SQL Server Backups? In a production environment, a single missed backup can mean the difference between a quick recovery and a costly outage. Manual backup procedures are error‑prone, consume DBA time, and make it difficult to enforce consistency across multiple servers or databases. Automating backups with PowerShell offers: Reproducible, auditable processes. Centralized management

Automating SQL Server Backups with PowerShell: Simplify Your DBA Workload Read More »

Migrating Databases to Oracle ASM: A Step-by-Step Guide

Oracle /

Why Move to Oracle ASM? As a Senior Database Administrator, I often face the dilemma of scaling storage, optimizing I/O, and simplifying backup operations for large production databases. Oracle Automatic Storage Management (ASM) addresses these pain points by abstracting raw disks into a logical pool, delivering performance, reliability, and ease of maintenance. In this post,

Migrating Databases to Oracle ASM: A Step-by-Step Guide Read More »

Automating MongoDB Backups with mongodump & mongorestore

MongoDB /

Understanding MongoDB Backup Needs MongoDB’s flexible schema and high availability options make it a popular choice for modern applications. Yet, with that flexibility comes the responsibility of safeguarding data. While cloud providers offer managed backup services, many organizations prefer on‑premises control, especially when dealing with regulatory compliance or large datasets. The mongodump and mongorestore utilities,

Automating MongoDB Backups with mongodump & mongorestore Read More »

Automate MySQL Backups with Percona XtraBackup: A DBA Guide

MySQL /

Why Database Backup Automation Matters for Modern DBAs In an era where data is the new oil, the ability to recover quickly from corruption, hardware failure, or accidental deletion is paramount. A well‑structured backup strategy is one of the cornerstones of database reliability, and automating this process reduces human error, ensures consistency, and frees DBAs

Automate MySQL Backups with Percona XtraBackup: A DBA Guide Read More »

Automate PostgreSQL Backups with pgBackRest: A DBA Guide

PostgreSQL /

Automating PostgreSQL Backups with pgBackRest As a Senior Database Administrator, I’ve seen the pain that manual backup processes can cause—forgotten schedules, inconsistent retention policies, and, worst of all, data loss during a crisis. PostgreSQL’s native tools (pg_dump, pg_basebackup) are powerful, but they lack the orchestration, verification, and reporting needed for production environments. That’s where pgBackRest

Automate PostgreSQL Backups with pgBackRest: A DBA Guide Read More »

How to Configure logrotate on Linux (Daily & Size-Based, With Examples)

Operating System, Scripts /

Why logrotate matters Uncontrolled logs grow fast, eat disk, and break apps. logrotate keeps logs tidy by rotating, compressing, and pruning them on a schedule (daily/weekly) or when they reach a size threshold. Prerequisites Linux server with logrotate installed (most distros include it). Root or sudo privileges to place configs in /etc/logrotate.d/. The path to

How to Configure logrotate on Linux (Daily & Size-Based, With Examples) Read More »

SQL Server Always On Setup Guide

SQL Server /

Why Choose Always On Availability Groups? Always On Availability Groups (AG) are Microsoft’s native high‑availability and disaster‑recovery (HADR) solution for SQL Server. They provide: Automatic failover with synchronous‑commit replicas. Read‑only routing for reporting workloads. Granular failover at the database level, not the instance level. Support for up to eight secondary replicas (SQL Server 2019+). For

SQL Server Always On Setup Guide Read More »