by Sveta Smirnova | Feb 16, 2017 | MySQL
In this blog post, we’ll look at a workaround for MySQL bug 72804. Recently I worked on a ticket where a customer performed a point-in-time recovery PITR using a large set of binary logs. Normally we handle this by applying the last backup, then re-applying all...
by Przemysław Malkowski | Feb 1, 2017 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
In this blog, we’ll discuss how to use concurrency to help with WAN latency when using synchronous clusters. WAN Latency Problem Our customers often ask us for help or advice with WAN clustering problems. Historically, the usual solution for MySQL WAN...
by Dave Avery | Jan 17, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s Chief Evangelist Colin Charles on Wednesday, January 18, 2017, at 7:00 am (PST) / 10:00 am (EST) (UTC-8) as he presents “Lessons from Database Failures.” MySQL failures at scale can teach a great deal. MySQL failures can lead to a...
by Manjot Singh | Jan 11, 2017 | Hardware and Storage, MySQL, Percona Software
In this blog post, we’ll look at how to replace MySQL with Percona Server for MySQL on a CPanel, WHM VPS or dedicated server. In general, CPanel and WHM have been leaning towards support of MariaDB over other flavors. This is partly due to the upstream repos...
by Rick Golba | Jan 6, 2017 | Insight for DBAs, MongoDB, MySQL
This post discusses archiving MySQL and MongoDB data and determining what, when and how to archive data. Many people store infrequently used data. This data is taking up storage space and might make your database slower than it could be. Archiving data can be a huge...
by Peter Zaitsev | Dec 28, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll find out how to use Percona XtraBackup on a MySQL instance with a large number of tables. As of Percona Xtrabackup 2.4.5, you are required to have enough open files to open every single InnoDB tablespace in the instance you’re trying to...
by Tom Diederich | Jul 9, 2015 | MySQL, Percona Events, Percona Live
The conference and tutorial schedule for Percona Live Europe 2015, September 21-23 in Amsterdam, was published this morning and this year’s event will focus on MySQL, NoSQL and Data in the Cloud. Conference sessions, which will follow each morning’s keynote addresses,...
by Christian.Rober | Sep 24, 2013 | MySQL
Last week I described TokuDB’s new Hot Backup feature. This week we are going to briefly discuss the same feature, but as it was added to TokuMX, our version of MongoDB. Since the Hot Backup library is essentially a shim between MySQL and the Linux kernel,...
by Christian.Rober | Sep 19, 2013 | MySQL
In my last post, I discussed the existing backup solutions for MySQL. At the end I briefly discussed why the backup solutions for InnoDB do not apply to TokuDB. Now I’m going to outline the backup solution we created. Our solution works for both TokuDB and...
by Christian.Rober | Sep 12, 2013 | MySQL
There are multiple ways to backup a MySQL database. Some are more painful than others. In this two part blog we are going to discuss why the new hot backup system in TokuDB is special amidst the existing solutions. First let’s look at existing backup solutions for...
by Martin.FarachColton | Jun 11, 2013 | MySQL
As promised, the Enterprise Edition of TokuDB®, Version 7, is ready. TokuDB Version 7, Enterprise Edition, introduces Hot Backup. You can now back up all your TokuDB tables directly from MySQL or MariaDB, with no down time. In addition, TokuDB Enterprise Edition comes...
by Stewart Smith | Apr 10, 2013 | Cloud, Insight for DBAs, MySQL, Percona Software
We just released our first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability to encrypt backups on the fly (full documentation here). This feature is different than simply piping the backup stream through the openssl or gpg binaries, which...
by Morgan Tocker | Nov 8, 2010 | Insight for DBAs, MySQL
I have a 5G mysqldump which takes 30 minutes to restore from backup. That means that when the database reaches 50G, it should take 30×10=5 hours to restore. Right? Wrong. Mysqldump recovery time is not linear. Bigger tables, or tables with more indexes...
by Morgan Tocker | Jul 21, 2009 | Insight for DBAs
We’ve written about replication slaves lagging behind masters before, but one of the other side effects of the binary log being serialized, is that it also limits the effectiveness of using it for incremental backup. Let me make up some numbers for the...
