by Daniil Bazhenov | May 28, 2020 | Insight for DBAs, MySQL, Open Source, Percona Software
Open-source companies live by their community. Favorable buzz by community users is ultimately what’s made Percona software successful. Some users make further contributions in the form of expertise, source code, documentation, and more. As an open-source company in...
by Matthew Boehm | May 27, 2020 | MySQL, Percona Services, Percona Software
Here in Percona’s Training department, we like to think that we instruct our learners on the best practices for all things MySQL-related. In addition to performance tuning, query optimization, and replication configurations, another important topic is backups....
by David Quilty | May 26, 2020 | MySQL, Webinars
Join Alkin Tezusal, Percona Technical Expert, as he covers the past, present, and future of MySQL as an Open Source Database. During this webinar he will discuss: * Use cases of MySQL as well as edge cases of MySQL topologies using real-life examples and...
by Stephen Thorn | May 22, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Database backups are a fundamental requirement in almost every implementation, no matter the size of the company or the nature of the application. Taking a backup should be a simple task that can be automated to ensure it’s done consistently and on schedule....
by Matthew Boehm | May 21, 2020 | Database Trends, MySQL, Open Source, Percona Services
Percona Training Is Here for You! Percona’s Training and Education Department wants you! For the past three years, Percona has quietly been delivering world-class training all over the globe, to companies large and small. We are in full force and ready to spread...
by Marco Tusa | May 18, 2020 | MySQL, Percona Software
Percona has enforced stronger security in Percona XtraDB Cluster (PXC) 8, but this requires some attention during the rollout of the new server version, so let see the why and what. In PXC there are two different kinds of traffic: client-server exchange (ie:...
by David Quilty | May 15, 2020 | MySQL, Percona Software, Webinars
During this webinar, Tyler Duzan, Product Manager for MySQL and Cloud at Percona, will discuss Percona’s decision to delay Percona XtraDB Cluster 8.0 to ship it with Galera 4 instead of Galera 3, and why that matters. In addition, he’ll talk about the work...
by Vadim Tkachenko | May 15, 2020 | MySQL, Percona Software
Percona XtraDB Cluster 8.0 comes with an upgraded Galera 4.0 library, which provides a new feature – streaming replication. Let’s review what it is and when it might be helpful. Previous versions of Percona XtraDB Cluster with Galera 3.x had a limitation...
by Yves Trudeau | May 14, 2020 | Insight for DBAs, MySQL
In this post, the third in a series explaining the internals of InnoDB flushing, we’ll focus on tuning. (Others in the series can be seen at InnoDB Flushing in Action for Percona Server for MySQL and Give Love to Your SSDs – Reduce innodb_io_capacity_max!)...
by Tibor Korocz | May 13, 2020 | MySQL, Percona Software
I was testing the latest Percona XtraDB Cluster 8.0 (PXC) release which has the Galera 4 plugin, and I would like to share my experiences and thoughts on the Streaming Replication feature so far. What Is Streaming Replication, in One Sentence? In Galera 4, the large...
by David Ducos | May 13, 2020 | Insight for DBAs, MySQL, Percona Software
pt-online-schema-change emulates the way that MySQL alters tables internally, but it works on a copy of the table you wish to alter. It executes INSERT statements to import the data, that runs in a single connection to fill the new table. In this repository, there is...
by Stephen Thorn | May 7, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
As a Solutions Engineer at Percona, one of my responsibilities is to support our customers as they investigate new and emerging technologies. This affords me the opportunity to speak to many current and new customers who partner with Percona. The topic of Kubernetes...
by Jake Davis | May 7, 2020 | Insight for DBAs, MySQL
In Percona’s Managed Services, we start up and shut down MySQL servers all the time. Over the years, we’ve seen various issues occur due to the way servers are shut down. No matter if it is a situation where unexpected errors appear in the log or...
by Agustín | May 6, 2020 | MySQL, Percona Software
As Alkin and Ramesh have shown us in their Testing Percona XtraDB Cluster 8.0 with DBdeployer post, it is now possible to easily deploy an environment to test the features provided by the brand new release of Percona XtraDB Cluster 8.0. We have also worked on creating...
by Jericho Rivera | May 5, 2020 | Insight for DBAs, MySQL, Percona Software
by Alkin Tezuysal | May 4, 2020 | Insight for DBAs, MySQL, Percona Software
In the light of support for Percona XtraDB Cluster (PXC), the DBdeployer anniversary, and the newly released Percona XtraDB Cluster 8.0, I’m happy to announce that Giuseppe Maxia has recently updated DBdeployer to support Percona XtraDB Cluster 8.0. We at Percona,...
by David Quilty | May 4, 2020 | MySQL, Webinars
It is common knowledge that built-in asynchronous master-master (active-active) replication is not safe in MySQL. I remember times when the official MySQL User Reference Manual stated that such an installation is not recommended for production use. Some experts repeat...
by David Quilty | Apr 29, 2020 | MySQL, Webinars
Peter Zaitsev, Founder and CEO at Percona, presents a webinar focused on dealing with an unexpected high traffic event as it is happening. He’ll address the impact a traffic spike can have on your database – from poor query response time to replication lag...
by Rick Golba | Apr 29, 2020 | MySQL, Percona Announcements, Percona Software
April 29, 2020 – Percona is pleased to announce the release of Percona XtraDB Cluster 8.0. This release, based on Percona Server for MySQL 8.0 and Galera 4, brings together the best features of these and other products to deliver an open-source high availability MySQL...
by George O. Lorch III | Apr 28, 2020 | MySQL, Percona Software
Update: Percona XtraBackup 8.0.12 now supports backup and restore processing for versions of MySQL 8.x; previous versions of Percona XtraBackup will not work with MySQL 8.0.20 and higher. More information On Monday, April 27, 2020, Oracle released the highly...