by Avinash Vallarapu | Jun 1, 2025 | Insight for DBAs, PostgreSQL
This blog was originally written in September 2018 and was updated in March 2025. In this post, we cover the methods used to achieve an enterprise-grade PostgreSQL backup strategy. We’ll explore options like pg_basebackup and WAL archiving to enable PostgreSQL...
by Avinash Vallarapu | Dec 21, 2018 | Insight for DBAs, PostgreSQL
pg_basebackup is a widely used PostgreSQL backup tool that allows us to take an ONLINE and CONSISTENT file system level backup. These backups can be used for point-in-time-recovery or to set up a slave/standby. You may want to refer to our previous blog posts,...
by Tim Vaillancourt | Jun 13, 2018 | Insight for DBAs, MongoDB, Security, Webinars
Please join Percona’s Sr. Technical Operations Architect, Tim Vaillancourt as he presents MongoDB Backup and Recovery Field Guide on Thursday, June 14, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now This talk will cover backup and recovery solutions...
by Marcelo Altmann | Feb 26, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look at how to execute a MySQL single table Point-In-Time Recovery. I recently wrote a blog post describing a different way of doing Point-In-Time Recovery (PITR). If you want to know the step by step, please visit the mentioned blog...
by Emily Ikuta | Aug 15, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s, Technical Services Manager, Jervin Real as he presents Lock, Stock and Backup: Data Guaranteed on Wednesday, August 16, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7). Reserve Your Spot Backups are crucial in a world where data is digital and uptime is...
by Miguel Angel Nieto | Jan 19, 2016 | MySQL
Data corruption! It can happen. Maybe because of a bug or storage problem that you didn’t expect, or MySQL crashes when a page checksum’s result is different from what is expected. Either way, corrupted InnoDB data can and does occur. What do you do then?...