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...
by Peter Zaitsev | Apr 6, 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 three can be found here. 7. Get More Memory Complexity: Low Potential Impact: High If your data does not fit into...
by Peter Zaitsev | Apr 3, 2020 | Database Trends, Insight for DBAs, MySQL
This is a three-part blog series. Part two is located here, and part three can be found here. There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems...
by Vadim Tkachenko | Apr 3, 2020 | MongoDB, MySQL, Percona Software
We recently released an experimental version of percona-dbaas command-line tool with the goal of significantly simplifying the deployment of database instances in Kubernetes. We have Kubernetes Operators for Percona XtraDB Cluster and Percona Server for MongoDB, which...
by Walter Garcia | Apr 2, 2020 | MySQL, ProxySQL, Security
In this blog, we will test a new security feature added in ProxySQL 2.0.9. Since a time ago, we have had the ability to block queries using mysql_query_rules table matching a group of queries using reg exp like a blacklist. Check out a previous blog for how to config...
by Tibor Korocz | Apr 1, 2020 | MySQL, Open Source
Recently I was looking for some simple way to analyze and create graphs from data stored in MySQL tables. I know Grafana can also plot graphs from MySQL tables, but somehow it felt like overkill and you are not using the traditional SQL syntax there. So I was...
by Brian Sumpter | Apr 1, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I...
by Vadim Tkachenko | Mar 31, 2020 | MySQL
Working on a weekend project, I became familiar with the SQL keyword “LATERAL”, which I had not used before because it was only introduced recently in MySQL 8.0.14, so I wanted to share how it can be used. Some references on this topic: Lateral Derived Tables...
by Peter Zaitsev | Mar 30, 2020 | Monitoring, MySQL, Percona Software
In my Webinar on Using Percona Monitoring and Management (PMM) for MySQL Troubleshooting, I showed how to use direct queries to ClickHouse for advanced query analysis tasks. In the followup Webinar Q&A, I promised to describe it in more detail and share some...
by Ananias Tsalouchidis | Mar 30, 2020 | Benchmarks, Cloud, Insight for DBAs, MySQL, Percona Software
More and more people are nowadays thinking of cloud migration. The question of “Which cloud provider performs better for my MySQL workload?” is really common but cannot always be easily answered. However, there are ways to come up with an answer. This question also...
by Carlos Tutte | Mar 26, 2020 | Insight for DBAs, MySQL, Percona Software
Disclaimer: The following blog post does not try to provide a solution for split-brain situations, and the example provided is for demonstrative purposes only. Inconsistencies resulting from a split-brain scenario might possibly be more complex than the one shown, so...
by Marco Tusa | Mar 26, 2020 | Benchmarks, MySQL, Open Source
What You May Not Know About Random Number Generation in Sysbench Sysbench is a well known and largely used tool to perform benchmarking. Originally written by Peter Zaitsev in early 2000, it has become a de facto standard when performing testing and benchmarking....
by Peter Zaitsev | Mar 25, 2020 | Monitoring, MySQL, Percona Software
Last week I did a webinar on MySQL Troubleshooting and Performance Optimization with Percona Monitoring And Management v2 (PMM2). There was a tremendous amount of interest and many more questions than I could answer, so I’m answering them in this blog post instead. Q:...
by Borys Belinsky | Mar 19, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Percona is happy to announce the experimental release of Percona XtraDB Cluster 8.0. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This is the second experimental release that combines the updated and feature-rich Galera...
