Directory Layout Start by building a dedicated structure for storing scripts, dump files, and logs: mkdir -p /mysql/backup/{scripts,files,logs} Full Backup Script Create the executable that handles database dumps: vi /mysql/backup/scripts/backup_full.sh Paste the logic below. It connects to MySQL, d...
Every reliable backup system is built around five fundamental components: the data source, the backup destination, the transport network, the backup engine, and the backup schedule. Users define what to protect, specify a storage target, transmit the data over a chosen network, run the backup engine...
Introduction to Percona XtraBackup Percona XtraBackup is an open-source tool for performing physical backups of MySQL databases. It supports hot backups, meaning data can be backed up without interrupting active transactions. This makes it iddeal for large databases where traditional logical backup...
Background After setting up a new Nexus OSS private repository in our data center, we noticed that the existing office-based repository contains significantly more content than the new one. This document outlines the complete process of backing up and migrating the old Nexus server to the new infra...
Reliable data protection is essential in database operations, particularly under high-scale workloads. MySQL supports physical and logical backup strategies; logical backups are widely adopted due to their flexibility and zero cost. The primary tool for logical backups is mysqldump, which can export...