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...
by Vadim Tkachenko | Apr 14, 2020 | MySQL, Percona Software
Percona XtraDB Cluster 8.0 is on the final stretch before GA release, and we have pre-release packages available for testing. 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 Peter Zaitsev | Apr 14, 2020 | Benchmarks, MySQL, ProxySQL
When I run a benchmark and want to measure the CPU efficiency of something, I find it’s often a good choice to run a benchmark program, as well as the database, on the same server. This is in order to eliminate network impact and to look at single-thread...
by Peter Zaitsev | Apr 13, 2020 | Benchmarks, MySQL, Percona Software
When connecting to a local MySQL instance, you have two commonly used methods: use TCP/IP protocol to connect to local address – “localhost” or 127.0.0.1 – or use Unix Domain Socket. If you have a choice (if your application supports both methods), use...
by Vadim Tkachenko | Apr 10, 2020 | Benchmarks, MySQL
In this post, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections. While this setup is identical to that in my post “Evaluating Group Replication Scaling Capabilities in...
by Manish Chawla | Apr 10, 2020 | MySQL, Percona Software
The backup and restore of a complete database is an extensive exercise. But what if you need to restore just one table which has been mistakenly modified by an incorrect query? Help is at hand with Percona XtraBackup. For our purpose, we will take a test database...
by Vadim Tkachenko | Apr 9, 2020 | Benchmarks, MySQL
In this blog, I want to evaluate Group Replication Scaling capabilities to handle several writers, that is, when the read-write connection is established to multiple nodes, and in this case, two nodes. This setup is identical to my previous post, Evaluating Group...
by Sveta Smirnova | Apr 9, 2020 | Insight for DBAs, MySQL, Open Source
March is not only the month when a pandemic closed all borders and people had to stay home on the quarantine; it’s also the month when daylight saving time change happens. For some regions, this is not only a time change but also a switch to a different...
by Vadim Tkachenko | Apr 8, 2020 | Benchmarks, MySQL
In this blog, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections. For testing, I will deploy multi-node bare metal servers, where each node and client are dedicated to an individual...
by Peter Zaitsev | Apr 8, 2020 | MySQL, Percona Software, ProxySQL
This article describes how to install ProxySQL from the Percona Software Repositories. Percona Software Repositories contain a ProxySQL version that has passed rigorous Percona tests and is known to be compatible with other Percona Software. We recommend using those...
by Peter Zaitsev | Apr 7, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here, and part two can be found here. 13. Configure MySQL Server Properly Complexity:Medium Potential Impact: High A poorly...
by Zsolt Parragi | Apr 6, 2020 | MySQL, Percona Software
Percona Server for MySQL 8.0.19 includes the experimental simple LDAP authentication plugin, which allows for direct authentication using an LDAP server. Similarly to the data masking plugin added in 8.0.18, this plugin was also added as a community contribution from...
![[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)
