by Sergey Pronin | Jan 20, 2021 | Cloud, Open Source, Percona Software, Security
What is Node Draining? Anyone who ever worked with containers knows how ephemeral they are. In Kubernetes, not only can containers and pods be replaced, but the nodes as well. Nodes in Kubernetes are VMs, servers, and other entities with computational power where pods...
by Matt Yonkovit | Jan 20, 2021 | Database Trends, Open Source
Last week Elastic announced that they were “Doubling Down” on open source by changing their licensing to a non-open license – MongoDB’s Server Side Public License, or SSPL. Let me clarify in my opinion this is not doubling down – unless, as our good...
by Marco Tusa | Jan 20, 2021 | Insight for DBAs, Insight for Developers, MySQL
As many of you have seen already, MySQL 8.0.23 is available for download (release notes). Today our dear LeFred thanked all the numerous contributors to bug fixes. About this: let me mention our two people involved in bug fixing, Venkatesh Prasad Venugopal and Kamil...
by Pep Pla | Jan 19, 2021 | Benchmarks, Insight for DBAs, MySQL, Percona Software
Large replication topologies are quite common nowadays, and this kind of architecture often requires a quick method to rebuild a replica from another server. The Clone Plugin, available since MySQL 8.0.17, is a great feature that allows cloning databases out of the...
by Sri Sakthivel | Jan 15, 2021 | Insight for DBAs, Insight for Developers, MySQL
The “SHOW PROCESSLIST” command is very famous and very useful for MySQL DBAs. It will help you to understand the ongoing thread activities and their current states. By default, the “show processlist” output details will be collected from the thread manager, and...
by Matt Yonkovit | Jan 13, 2021 | Database Trends, MongoDB, MySQL, PostgreSQL
The Percona team provided the community with some excellent content and several new releases in 2020. I wanted to highlight some of your favorites (based on popularity) if you missed them. First up is our most-read blog from last year, which ironically was published...
by David Quilty | Jan 12, 2021 | Monitoring, MySQL, Percona Software, Webinars
Join us as Michael Coburn, Percona Product Manager, discusses two methods to identify and troubleshoot problematic MySQL queries using the RED Method and Percona Monitoring and Management (PMM) Query Analytics. He will also highlight specific Dashboards in PMM that...
by Sri Sakthivel | Jan 11, 2021 | MySQL, Open Source, Percona Software
In this blog, I am going to explain the different ways of electing the PRIMARY node in MySQL group replication. Before MySQL 8.0.2, primary election was based on the member’s UUID, with the lowest UUID elected as the new primary in the event of a failover. From...
by Marco Tusa | Jan 11, 2021 | Cloud, MySQL, Percona Software, ProxySQL
The aim of Percona Operator for MySQL based on Percona XtraDB Cluster is to be a special type of controller introduced to simplify complex deployments. The Operator extends the Kubernetes API with custom resources. The Operator solution is using Percona XtraDB Cluster...
by Marco Tusa | Jan 11, 2021 | Cloud, MySQL, Percona Software, ProxySQL
Percona Operator for MySQL based on Percona XtraDB Cluster comes with two different proxies, HAProxy and ProxySQL. While the initial version was based on ProxySQL, in time, Percona opted to set HAProxy as the default Proxy for the operator, without removing ProxySQL. ...
by Fernando Mattera | Jan 8, 2021 | Insight for DBAs, MySQL, Percona Software
Today we are going to present you with another way to make a database copy between servers using our Percona XtraBackup utility. What is the difference with many others existing on the web? Not many, but they are interesting in terms of performance and availability....
by Michael Patrick | Jan 8, 2021 | Insight for DBAs, Insight for Developers, MySQL, Open Source
It has been some time since I have posted updates to my plugins. After the initial version, I decided to split the plugins into categories of metrics. This will allow users to choose whether they want to install all of the plugins or only select ones they care...
by Brian Sumpter | Jan 7, 2021 | Database Trends, MySQL, Percona Services, Security
In previous TAM Enterprise Experiences posts, we have outlined typical aspects of utilizing MySQL in an Enterprise environment. One thing we have not yet covered is the topic of database encryption, both from the standpoint of business requirements as well as some of...
by Stephen Thorn | Jan 6, 2021 | Cloud, Insight for DBAs, MySQL, Webinars
Earlier in November, we had a chance to present the “Google Cloud Platform: MySQL at Scale with Reliable HA.” We discussed different approaches to hosting MySQL in Google Cloud Platform with the available options’ pros and cons. This webinar was recorded and can...
by Brian Sumpter | Jan 5, 2021 | Database Trends, Insight for DBAs, Open Source, Percona Services
One of the great things about being a Technical Account Manager (TAM, for short) at Percona is having the opportunity to see a wide variety of issues across many clients, and having the space to identify the common threads that seem to bind many of these issues. While...
by Lalit Choudhary | Jan 4, 2021 | Insight for DBAs, Insight for Developers, Percona Software
Here 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...
by Marcelo Altmann | Dec 28, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
A lot of elements take part in a good backup strategy. Two of them are: Where to store your backups – Never on the same server. Preferable not in the same datacenter. Ideally far enough so you can restore in case of a natural disaster (region flood, extended...
by Puneet Kala | Dec 23, 2020 | Insight for DBAs, Monitoring, Percona Software
Percona Monitoring and Management (PMM) v2.12.0 comes with a lot of improvements and one of the most talked-about is the usage of VictoriaMetricsDB. The reason we are doing this comparison is that PMM 2.12.0 is a release in which we integrate VictoriaMetricsDB and...
by Marcelo Altmann | Dec 22, 2020 | Insight for DBAs, MySQL, Percona Software
MySQL 5.7, alongside other many improvements, brought bulk load for creating an index (WL#7277 to be specific), which made ADD INDEX operations much faster by disabling redo logging and making the changes directly to tablespace files. This change requires extra care...
by Ivan Groenewold | Dec 21, 2020 | Cloud, Insight for DBAs, MySQL, Percona Services
As mentioned in the AWS discussion forum back in October, Amazon has started the end of life (EOL) process for RDS MySQL version 5.5. What this means is: AWS will upgrade RDS instances to MySQL 5.7 starting February 9 2021 00:00 UTC during your next defined...
