by Peter Zaitsev | Nov 2, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Understanding how MySQL uses memory is key to tuning it for optimal performance as well as troubleshooting cases of unexpected memory usage, i.e. when you have MySQL Server using a lot more than you would expect based on your configuration settings. Early in MySQL...
by David Busby | Oct 30, 2020 | Insight for DBAs, MySQL, Percona Software
Galera replication technology, a key component of Percona XtraDB Cluster, suffered from a remote code execution vulnerability. Percona has been working with the vendor since early September on this issue and has made releases available to address the problem....
by Lalit Choudhary | Oct 30, 2020 | Insight for DBAs, Insight for Developers, Percona Software
At Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form,...
by Marcelo Altmann | Oct 28, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
In a perfect world, we expect all software to run flawlessly and never have problems such as bugs and crashes. We also know that this perfect world doesn’t exist and we better be as prepared as possible to troubleshoot those types of situations. Historically,...
by Paul Jacobs | Oct 26, 2020 | Insight for DBAs, Insight for Developers, Monitoring, Percona Software
Percona is making changes in its documentation processes for Percona Monitoring and Management (PMM) to make it easier and more welcoming for community members to contribute to our documentation. Percona Monitoring and Management (PMM) is a free, open-source database...
by David Quilty | Oct 26, 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 Marcelo Altmann | Oct 23, 2020 | Insight for DBAs, MySQL, Percona Software
Earlier this week, Oracle released their Q4 releases series. As on the previous releases, backward compatibility has been broken with previous versions of the server. This time on both MySQL 5.7 and 8.0: MySQL 5.7.32 While our QA team was performing an extensive test...
by David Busby | Oct 23, 2020 | MongoDB, MySQL, Percona Software
CVE-2020-26542 When using the SimpleLDAP authentication in conjunction with Microsoft’s Active Directory, Percona has discovered a flaw that would allow authentication to complete when passing a blank value for the account password, leading to access against the...
by Vadim Tkachenko | Oct 22, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
One of the most exciting storage-related features in Kubernetes is Volume snapshot and clone. It allows you to take a snapshot of data volume and later to clone into a new volume, which opens a variety of possibilities like instant backups or testing upgrades. This...
by Steve Hoffman | Oct 22, 2020 | Insight for DBAs, Monitoring, Percona Software
About the Author – This blog was written as a collaboration with my colleague Jiri Ctvrtka. Jiri is a senior software developer from Brno, Czech Republic, and has been partnering with Percona for almost a year working on various components of our Percona...
by Diana Muina | Oct 20, 2020 | Insight for DBAs, Percona Services, Percona Software
There is an on-going shift within many organizations where the focus placed on application engineers is expanding while at the same time infrastructure teams within the DBA landscape are being trimmed back. The result is application engineers with little to no...
by Rick Golba | Oct 19, 2020 | Open Source, Percona Software, PostgreSQL
Percona is pleased to announce the release of Percona Distribution for PostgreSQL 13. This release is available for immediate download and includes all of the latest features of PostgreSQL 13 Core Distribution. Reduce Resource Usage This release includes enhancements...
by Carlos Tutte | Oct 16, 2020 | Insight for DBAs, MySQL, Percona Software
Changing the default value (3) of log_error_verbosity in MySQL/Percona Server for MySQL 5.7 can have a hidden unintended effect! What does log_error_verbosity do exactly? As per the documentation: “The log_error_verbosity system variable specifies the verbosity for...
by Mike Grayson | Oct 16, 2020 | Insight for DBAs, MongoDB, Percona Software
MongoDB is one of the most popular databases and is one of the easiest NoSQL databases to set up for a DBA. Oftentimes, relational DBAs will inherit MongoDB databases without knowing all there is to know about MongoDB. I encourage you to check out our Percona blogs...
by Peter Zaitsev | Oct 14, 2020 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
I am very passionate about database observability, and I believe query performance observability is the most important insight you can get in your database. Why? Because if you look from an application developer’s point of view, once a database is provisioned and you...
by David Quilty | Oct 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 Vadim Yalovets | Oct 12, 2020 | Insight for DBAs, Monitoring, Percona Software
From time to time we are asked how to limit users to viewing only some dashboards or servers in Percona Monitoring and Management (PMM). Here are some hints on how to do this. Let’s imagine you want the following: Users user1 and user2 are only allowed to see...
by Stephen Thorn | Oct 8, 2020 | Cloud, MongoDB, 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 Rituja Borse | Oct 8, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is a free and open source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL databases. In this blog, we will look at troubleshooting MySQL issues and performance bottlenecks with the help of PMM. We can start...
by Przemysław Malkowski | Oct 8, 2020 | Insight for DBAs, MySQL, Percona Software
Recently I was dealing with an unexpected issue raised by our Support customer, in which data became inconsistent after a schema change was applied. After some investigation, it turned out that affected tables had a special word in the comments of some columns, which...
