A reliable backup strategy is essential for maintaining the availability and integrity of database systems. Different backup methods serve different purposes and operate at different levels within the database infrastructure. This article explains the differences between infrastructure backups and client backups, outlining when each approach should be used.
The focus is on Point-in-Time Recovery (PITR) using Binary Logs as a server-level backup mechanism and SQL dumps as logical backups created at the database or table level. While these technologies address different recovery objectives, they complement each other as part of a comprehensive backup strategy.
The article also introduces the lnbrt Backup Tool by Linetz, which simplifies the centralized management and restoration of SQL dump backups for MariaDB, MySQL, and PostgreSQL, making it a valuable complement to server-level infrastructure backup solutions.
