by Dimitri Vanoverbeke | Aug 15, 2023 | Insight for DBAs, MySQL
This blog was originally published in February 2017 and was updated in September 2023. In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works, its benefits and challenges, as well as reviewing some of the MySQL...
by David Quilty | Sep 13, 2019 | Percona Software, Webinars
Please join Percona Senior Support Engineer Juan Pablo Arruti as he presents his talk “Percona XtraBackup vs Mariabackup vs MySQL Enterprise Backup” on Tuesday, September 17th, 2019 at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). View the Recording There are few ways...
by Hrvoje Matijakovic | May 30, 2017 | Insight for DBAs, MySQL, Percona Software
Percona announces the GA release of Percona XtraBackup 2.4.7-2 on May 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 Hrvoje Matijakovic | Apr 18, 2017 | MySQL, Percona Software
Percona announces the release of Percona XtraBackup 2.3.8 on April 18, 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 Alexey Stroganov | Mar 30, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll look at the performance of SST data transfer using encryption. In my previous post, we reviewed SST data transfer in an unsecured environment. Now let’s take a closer look at a setup with encrypted network connections between the...
by Hrvoje Matijakovic | Feb 22, 2017 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona XtraBackup 2.4.6 on February 22, 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 Hrvoje Matijakovic | Feb 22, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona XtraBackup 2.3.7 on February 22, 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 Peter Zaitsev | Jan 27, 2017 | Cloud, MongoDB, MySQL, Percona Events, Percona Services, Percona Software, Webinars
This blog post is a summary of the webinar Percona Software News and Roadmap Update – Q1 2017 given by Peter Zaitsev on January 12, 2017. Over the last few months, I’ve had the opportunity to meet and talk with many of Percona’s customers. I love these meetings,...
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 Hrvoje Matijakovic | Nov 29, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona XtraBackup 2.3.6 on November 29, 2016. 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 Jay Janssen | Aug 20, 2015 | MySQL, Percona Software
State Snapshot Transfer (SST) at a glance PXC uses a protocol called State Snapshot Transfer to provision a node joining an existing cluster with all the data it needs to synchronize. This is analogous to cloning a slave in asynchronous replication: you take a full...
by David Busby | May 6, 2015 | MySQL, Security
Contents Summary Analysis Mitigating factors P.O.C Acknowledgments Summary During a code audit performed internally at Percona, we discovered a viable information disclosure attack when coupled with a MITM attack in which percona-toolkit and xtrabackup perl components...
by Hrvoje Matijakovic | Nov 25, 2013 | Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.6 on November 25th, 2013. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.1 series....
by Frederic Descamps | Jun 28, 2013 | MySQL, Percona Software
With the last Percona XtraDB Cluster (PXC) release, two major features were added: * a new command to bootstrap the cluster was added to the init script * SST via Xtrabackup now supports Xtrabackup 2.1 features In this post, I want to explain the benefits of these...
by Raghavendra | Jun 17, 2013 | MySQL, Percona Software
The aim of this post is to enumerate real-world usage of Percona XtraDB Cluster (PXC), and also to solicit use cases from the readers. One of the prominent usages in the production environment that we have come across (and our Percona consultants have assisted) is...
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 Hrvoje Matijakovic | Dec 21, 2012 | Percona Software
Percona is glad to announce the latest stable release of Percona XtraBackup 1.6.7 on December 20th, 2012 (Downloads are available here). This release is purely composed of bug fixes to the previous stable release of Percona XtraBackup. New users should head for...
by Stewart Smith | Feb 10, 2012 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 1.6.5 on 10 February, 2012 (Downloads are available here and from the Percona Software Repositories). This release is purely composed of bug fixes and is the current stable release of Percona XtraBackup....
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 Vadim Tkachenko | Jul 31, 2009 | Percona Software
The feature I announced some time ago https://www.percona.com/blog/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now I am going to show how to use it (the video will be...
