by Brandon Fleisher | Dec 18, 2020 | Insight for DBAs, Monitoring, Open Source, Percona Software
As strange as it sounds, there are types of software applications that are designed for users to NOT spend each minute of every day within the application (where the goal of so many software applications is to attract as many “eyeballs” for as long as possible to...
by Matt Yonkovit | Dec 17, 2020 | Insight for DBAs, Monitoring, Open Source, Percona Software
Hello everyone! I wanted to outline a new program we are trying out. We are calling it, Percona Open Source Expert Missions. So, you might be asking… What the heck is that? An Expert Mission is a challenge or a contest of skill. Here at Percona, we are always looking...
by Peter Zaitsev | Dec 16, 2020 | Insight for DBAs, Monitoring, Percona Software
Starting with Percona Monitoring and Management (PMM) 2.12, we use VictoriaMetrics instead of Prometheus as a metrics store. This blog is written as an FAQ to explain our reasoning for this change as well as to provide answers to various questions on what it may mean...
by Sri Sakthivel | Dec 16, 2020 | Insight for DBAs, MySQL, Open Source
MySQL Shell is an advanced client tool that has many features and is easy to use. The recent MySQL release (MySQL 8.0.22) has the utility “exportTable()”, which supports exporting the data into a file from a table using MySQL shell. The exported data file can be...
by Matt Yonkovit | Dec 15, 2020 | Database Trends, Insight for DBAs, Open Source
Covid-19 has had a significant impact on most aspects of our lives in 2020. Although some companies saw unexpected growth due to offering in-demand tools or services, I think most of us will be happy to draw a line under 2020 and hope for a better 2021. In the spirit...
by Peter Zaitsev | Dec 7, 2020 | MySQL, Open Source, Security
As you may know, MySQL 5.6 will reach EOL (“End of Life”) in February 2021. This means in about two months, there will be no more updates, and more importantly, no more security fixes for discovered vulnerabilities. You may be well ahead of the curve...
by Charly Batista | Dec 4, 2020 | MySQL, Open Source, Security
Getting MySQL working with self-signed SSL certificates is pretty simple. Having it working with a certificate signed by a trusted authority is also very simple, we just need to set the correct path and privileges to the file. The problem comes when we need to make...
by Vinicius Grippa | Dec 2, 2020 | Insight for DBAs, MySQL, Percona Software
The benefits of jemalloc versus glibc memory allocator for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) there is less memory fragmentation, and thus more efficient resource management of the server memory. For...
by Marco Tusa | Nov 30, 2020 | MySQL, Open Source, Percona Software, ProxySQL
How scheduler and script stand in supporting failover (Percona and Marco example) In part one of this series, I had illustrated how simple scenarios may fail or have problems when using Galera native support inside ProxySQL. In this post, I will repeat the same...
by Marco Tusa | Nov 30, 2020 | MySQL, Open Source, Percona Software, ProxySQL
How native ProxySQL stands in failover support (both v2.0.15 and v2.1.0) In recent times I have been designing several solutions focused on High Availability and Disaster Recovery. Some of them using Percona Server for MySQL with group replication, some using Percona...
by Peter Zaitsev | Nov 23, 2020 | Insight for DBAs, Insight for Developers, MySQL
If I ask you if running EXPLAIN on the query can change your database, you will probably tell me NO; it is common sense. EXPLAIN should show us how the query is executed, not execute the query, hence it can’t change any data. Unfortunately, this is the case where...
by Sergey Pronin | Nov 23, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Kubernetes operators are meant to simplify the deployment and management of applications. Our Percona Kubernetes Operator for Percona XtraDB Cluster serves the purpose, but also provides users the flexibility to fine-tune their MySQL and proxy services configuration....
by Daniil Bazhenov | Nov 19, 2020 | Monitoring, Percona Software
We would love you to help us spread the word about Percona Monitoring and Management (PMM) to make sure even more people are aware of it and adopting it. And we are not afraid to offer (modest) bribes! If you already use PMM please write an independent review of its...
by Fernando Laudares Camargos | Nov 17, 2020 | Cloud, MySQL, Open Source, Percona Software
Kubernetes has been a big trend for a while now, particularly well-suited for microservices. Running your main databases on Kubernetes is probably NOT what you are looking for. However, there’s a niche market for them. My colleague Stephen Thorn did a great job...
by Rick Vasquez | Nov 17, 2020 | Database Trends, Insight for DBAs, Open Source, Percona Services
It’s that time of year! The Halloween decorations have come down and the leaves have started to change and the Black Friday/Cyber Monday buying season is upon us! For consumers, it can be a magical time of year, but for those of us that have worked in e-commerce or...
by Sergey Pronin | Nov 13, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Our recent survey showed that many organizations saw unexpected growth around cloud and data. Unexpected bills can become a big problem, especially in such uncertain times. This blog post talks about how Kubernetes scaling capabilities work with Percona Kubernetes...
by Mani Paluru | Nov 6, 2020 | Insight for DBAs, Insight for Developers, MySQL
Mysqlpump is a client program that was released with MySQL 5.7.8 and is used to perform logical backups in a better way. Mysqlpump supports parallelism and it has the capability of creating compressed output. Pablo already wrote a blog about this utility (The...
by Vadim Tkachenko | Nov 5, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
In my talk on Percona Live (download the presentation), I spoke about how we can use Percona Kubernetes Operators to deploy our own Database-as-Service, based on fully OpenSource components and independent from any particular cloud provider. Today I want to mention an...
by Ivan Groenewold | Nov 5, 2020 | MongoDB, Monitoring, MySQL, Percona Software, PostgreSQL
Normally it is quite easy to deploy Percona Monitoring and Management (PMM) Server as a Docker container as per the official documentation. However, when working in very restrictive environments, it is possible the server doesn’t have access to the public...
by Sergey Pronin | Nov 4, 2020 | Cloud, MySQL, Percona Software, Security
Kata containers are containers that use hardware virtualization technologies for workload isolation almost without performance penalties. Top use cases are untrusted workloads and tenant isolation (for example in a shared Kubernetes cluster). This blog post describes...
