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 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 David Quilty | Apr 13, 2020 | Percona Services, Percona Software
It’s release roundup time here at Percona! Our Release Roundups showcase the latest software updates, tools, and features to help you manage and deploy our software, with highlights and critical information, as well as links to the full release notes and direct...
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 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 Steve Hoffman | Apr 7, 2020 | Monitoring, Percona Software
Last month, our new Director of Product wrote a blog about all the cool things she learned about how we track Percona Monitoring and Management (PMM) adoption and even went into what conclusions we can draw from that. As you can imagine, I was excited she geeked out...
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 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 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 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 David Quilty | Mar 30, 2020 | Percona Services, Percona Software
It’s release roundup time here at Percona! Our Release Roundups showcase the latest software updates, tools, and features to help you manage and deploy our software, with highlights and critical information, as well as links to the full release notes and direct...
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 Brian Sumpter | Mar 27, 2020 | Percona Services, Percona Software
This is usually one of the first questions asked by clients when discussing the possibility of adding a TAM (Technical Account Manager) to their Percona Support contract. Although the TAM role in a general sense has been around for many years, there are often...
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 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 Fernando Laudares Camargos | Mar 25, 2020 | Insight for DBAs, Percona Software, PostgreSQL
We recently helped migrate a production PostgreSQL database running on a given DBaaS platform… to another DBaaS platform. When it comes to vendor “lock-in”, some providers are easier (and even friendlier) to deal with than others, but it is never a...
by Alexey Palazhchenko | Mar 23, 2020 | Monitoring, Percona Software
Percona Monitoring and Management 2.4.0 (PMM), released several days ago, added support for custom extensions of the Prometheus configuration file. Before explaining what that is and how to use it, let me tell you a bit of history. PMM 1.4.0, released 2.5 years ago,...
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...
by Tyler Duzan | Mar 18, 2020 | Insight for DBAs, MongoDB, MySQL, Percona Software
Percona has been investing in building and releasing Operators for Kubernetes to run traditional databases in a cloud-native fashion. The first two Kubernetes operators were for Percona Server for MongoDB and Percona XtraDB Cluster, chosen because they both feature...
by David Quilty | Mar 18, 2020 | Monitoring, Percona Software, Webinars
Planning for your next high traffic event? If your databases need to be running at peak performance with no downtime – this webinar is for you. Prepare for High Traffic Events (HTE) such as Black Friday, Cyber Monday, or any peak your organization manages. Learn...
