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...
by Tibor Korocz | Apr 28, 2020 | MySQL, Percona Software, ProxySQL
In this blog post I would like to give an overview of the most common failover scenarios and operations when using MySQL Group Replication 8.0.19 (aka GR) and Percona XtraDB Cluster 8 (PXC) (which is based on Galera), and explain how each technology handles each...
by David Quilty | Apr 27, 2020 | MySQL, Webinars
During this joint webinar our speakers, Alkin Tezuysal, Technical Expert at Percona and Sugu Sougoumarane, Co-Founder and CTO at PlanetScale, will provide attendees with hands-on experience using Vitess using Kubernetes. They will start by providing a quick overview...
by Uday Varagani | Apr 24, 2020 | Insight for DBAs, Monitoring, MySQL
A couple of weeks ago, one of our customers reached us asking about the WARNING messages in their MySQL error log. After a while, there were a few more requests from some other customers asking whether to worry about these messages or not. In this post, I am going to...
by Tibor Korocz | Apr 21, 2020 | Insight for DBAs, MySQL, Percona Software
by David Quilty | Apr 20, 2020 | MySQL, Webinars
Although MySQL is now more than two decades old, it continues to power some of the world’s largest internet applications. In this presentation, we’ll look at the history and evolution of distributed MySQL deployments. We’ll explore the original...
by Peter Zaitsev | Apr 16, 2020 | MySQL
Recently, I got access to the list of MySQL bug reports from bugs.mysql.com which someone crawled and stored in a MySQL database. I thought it would be interesting to see who the heroes are of MySQL bug reporting! Top MySQL Bug Reporters Ever Shell select rank()...
by Vadim Tkachenko | Apr 16, 2020 | MySQL, Percona Software
Percona XtraDB Cluster 8.0 is in the final stretch before GA release and we have pre-release packages available for testing, and I wanted to see how Percona XtraDB Cluster 8.0 performs in CPU and IO-bound scenarios, like in my previous posts about MySQL Group...
by Mike Benshoof | Apr 15, 2020 | Cloud, MySQL, Percona Services, Security
The other day on a call, a client asked me an interesting question. We were discussing some testing they were doing in Amazon Relational Database Service (RDS). The question came up “since RDS is managed, how can I prove to my security team that the data is actually...
by Rahul malik | Apr 15, 2020 | MySQL, Percona Software
Databases are complicated software made to handle the concurrent load while making specific guarantees about data consistency and availability. There are many scenarios which should be tested that can only happen under concurrent conditions. Pstress is...
![[Warning] InnoDB: Difficult to Find Free Blocks in the Buffer Pool](https://www.percona.com/blog/wp-content/uploads/2020/04/InnoDB-Buffer-Pool.png)
