Marcelo Altmann has joined Percona as a member of Support Team late in 2016. Prior to joining Percona , he worked as a MySQL DBA at Ireland's CCTLD, and worked as a DBA/PHP developer in Brazil. He holds a degree in Systems for Internet.
Databases play a key part of business infrastructure. To ensure you are prepared in case of a disaster, it is crucial to make sure your database and data are always available.
In this talk, DBA's and sysadmins will get exposed to the different types of backups.
- When a physical vs. logical backup is more appropriate
- How to make complete, partial and incremental backups and how to restore a single table from a physical backup
- Where backups should be stored
- How important it is to test the restoration of a backup
- How to include point-in-time-recovery on backup routines
- How to encrypt backups and why
- Which tools and techniques can be used to ensure the actual backup has consistent data
.IE (IEDR - Ireland's CCTLD) will share how they implement the topics above on their backup life-cycle.
By the end of this talk, the audience will have a clear picture of the key points of an actual backup.
As a support engineer, everyday we get dozens of pt-stalk captures from our customers containing samples of iostat, vmstat, top, ps, SHOW ENGINE INNODB STATUS, SHOW PROCESSLIST and a multitude of other diagnostics outputs.
These are the tools of the trade for performance and troubleshooting, and we must learn to digest these outputs in an effective and systematic way to allow us to provide high quality service to a large volume of customers, and that is the knowledge we want to share through this presentation.
We will learn to setup, capture data, write plugins to trigger collection and to capture custom data, look at our systematic approach and learn what data to read first and how to unwind the tangled threads of pt-stalk.
By the end of this presentation you will have expert knowledge on how to capture diagnostic metrics at the right time and will have a generic approach to digest the captured data, allowing you to work on a large number of problems common to MySQL setups.
Producing backups can be a complex task to achieve. Full backup, incremental backup, streaming backups, restore backups and encrypt backups. There are many factors to take into consideration.
This talk covers the best practices for backups using Percona XtraBackup.