by Marcelo Altmann | Feb 26, 2019 | MySQL, Percona Software
InnoDB keeps hot data in memory on its buffer named InnoDB Buffer Pool. For a long time, when a MySQL instance needed to bounce, this hot cached data was lost and the instance required a warm-up period to perform as well as it did before the service restart. That is...
by Borys Belinsky | Jan 18, 2019 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.4.13 on January 18, 2018. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies...
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 Alexander Rubin | Jul 4, 2018 | Cloud, Insight for DBAs, MySQL
Amazon RDS Aurora (MySQL) provides its own low latency replication. Nevertheless, there are cases where it can be beneficial to set up replication from Aurora to an external MySQL server, as Amazon RDS Aurora is based on MySQL and supports native MySQL replication....
by Dmitriy Kostiuk | Jun 25, 2018 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona XtraBackup 2.4.12 on June 22, 2018. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large...
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 Dmitriy Kostiuk | Apr 24, 2018 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona XtraBackup 2.4.11 on April 24, 2018. This release is based on MySQL 5.7.19. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries,...
by Tim Vaillancourt | Apr 18, 2018 | Insight for DBAs, MongoDB
In this article, we will explain how to restore a MongoDB logical backup performed via ‘mongodump’ to a mongod instance. MongoDB logical backup requires the use of the ‘mongorestore’ tool to perform the restore backup. This article focuses on...
by Dmitriy Kostiuk | Mar 30, 2018 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona XtraBackup 2.4.10 on March 30, 2018. This release is based on MySQL 5.7.19. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries,...
by Nickolay Ihalainen | Feb 22, 2018 | Hardware and Storage, Insight for DBAs, Monitoring, MySQL
The ability to restore MySQL logical backups is a significant part of disaster recovery procedures. It’s a last line of defense. Even if you lost all data from a production server, physical backups (data files snapshot created with an offline copy or with...
by Hrvoje Matijakovic | Nov 29, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona XtraBackup 2.3.10 on November 29, 2017. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with...
by Hrvoje Matijakovic | Nov 29, 2017 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona XtraBackup 2.4.9 on November 29, 2017. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large...
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 Dave Avery | Jul 25, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s, Architect, Manjot Singh as he presents Database Backup and Recovery Best Practices (with a Focus on MySQL) on Thursday, July 27, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now In the case of a failure, do you know how long it will take to...
by Manjot Singh | Jul 18, 2017 | Insight for DBAs, MySQL, Percona Services
In this post, we’ll look at strategies for backups and disaster recovery. Note: I am giving a talk on Backups and Disaster Recovery Best Practices on July 27th. Register Now When discussing disaster recovery, it’s important to take your business’...
by Adamo Tonete | Jul 7, 2017 | Insight for DBAs, MongoDB
In this blog post, I’ll look at how you can use a backup to start a secondary instance for MongoDB. Although the documentation says it is not possible to use a backup to start a secondary, sometimes this is the only possible way to start a new instance. In this...
by Dave Avery | Jun 20, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s Senior Operations Engineer, Daniel Kowalewski as he presents Deploying MySQL in Production on Thursday, June 22, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now MySQL is famous for being something you can install and get going in less than...
by Tim Vaillancourt | May 10, 2017 | Insight for DBAs, Insight for Developers, MongoDB
In this blog post, I will cover the Percona-Lab/mongodb_consistent_backup tool and the improvements in the 1.0.1 release of the tool. Percona-Lab/mongodb_consistent_backup mongodb_consistent_backup is a tool for performing cluster consistent backups on MongoDB...
by Dave Avery | Apr 20, 2017 | Open Source, Percona Live
Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database...
by Vlad Lesin | Apr 14, 2017 | MySQL
TokuDB Hotbackup is a solution that allows you to do backups on the fly. It works as a library that intercepts certain system calls that duplicate data written to already copied parts of files, so that at the end of the backup process the copied files contain the same...
