by Daniel Guzmán Burgos | Jul 9, 2020 | Cloud, MySQL, Percona Software
You got yourself a Kubernetes cluster and are now testing our Percona Kubernetes Operator for Percona XtraDB Cluster. Everything is working great and you decided that you want to increase the number of Percona XtraDB Cluster (PXC) pods from the default 3, to let’s...
by Steve Hoffman | Jul 7, 2020 | Insight for DBAs, Monitoring, Percona Software
Many years ago I was banned from touching anything of critical importance as far as production infrastructure goes…something about “the leadership curse”, so the multiple layers of monitoring and notifications I once wrestled with were now overkill for my needs....
by Sergey Kuzmichev | Jul 6, 2020 | Insight for DBAs, Monitoring, Percona Software
I wanted to start this post with the words “eBPF is the hot new thing”, but I think it’s already too late to write that. Running eBPF programs in production is becoming less of a peculiarity and more of a normal way to operate. Famously, Facebook runs about 40 BPF...
by David Quilty | Jul 6, 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 Daniel Guzmán Burgos | Jul 3, 2020 | Cloud, MySQL, Percona Software, ProxySQL
The Percona Kubernetes Operator for Percona XtraDB Cluster(PXC) comes with ProxySQL as part of the deal. And to be honest, the behavior of ProxySQL is pretty much the same as in a regular non-k8s deployment of it. So why bother to write a blog about it? Because what...
by David Quilty | Jul 1, 2020 | Monitoring, Percona Software, Security, Webinars
Data breaches seem to be a daily occurrence, so much so that seeing an article about the latest company to fall victim draws little attention outside of those immediately impacted. That is of course unless that company is yours and data security is your...
by Marco Tusa | Jul 1, 2020 | MySQL, Percona Software, ProxySQL
In real life, there are frequent cases where getting a running application to work correctly is strongly dependent on consistent write/read operations. This is no issue when using a single data node as a provider, but it becomes more concerning and challenging when...
by Przemysław Malkowski | Jun 29, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server for MySQL, by discussing binlog_space_limit option. Today, I am going to discuss another important type of log available in MySQL that is enhanced in Percona...
by Artem Gavrilov | Jun 29, 2020 | Insight for Developers, Monitoring, Percona Software, Security
Security Threat Tool (STT) is the new Percona Monitoring and Management (PMM) feature. It provides the ability to run automated security checks across all of your databases and detect potential security problems. For example: empty or default passwords, weak security...
by Brian Sumpter | Jun 29, 2020 | Insight for DBAs, Percona Services, Percona Software
In 2006, a small company formed, specializing in MySQL database consulting at a time when very few companies had fully embraced open source. This small company quickly grew, riding the wave of open source adoption within the greater enterprise market and became the...
by Vadim Tkachenko | Jun 25, 2020 | Benchmarks, Insight for DBAs, MongoDB, Percona Software
In my recent post Evaluating MongoDB Under Python TPCC 1000W Workload with MongoDB benchmarks, I showed an average throughput for a prolonged period of time (900sec or 1800sec), and the average throughput tended to smooth and hide problems. But if we zoom in to 1-sec...
by Vadim Tkachenko | Jun 24, 2020 | Benchmarks, Insight for DBAs, MongoDB, Percona Software
Following my blog post Evaluating the Python TPCC MongoDB Benchmark, I wanted to evaluate how MongoDB performs under workload with a bigger dataset. This time I will load a 1000 Warehouses dataset, which in raw format should equal to 100GB of data. For the comparison,...
by Fernando Laudares Camargos | Jun 23, 2020 | Monitoring, MySQL, Percona Software
by Lalit Choudhary | Jun 23, 2020 | Insight for DBAs, Percona Software
At Percona, we operate on the premise that full-transparency makes a product better. We strive to build not only 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 Rick Golba | Jun 23, 2020 | Insight for DBAs, MySQL, Percona Software
Percona is pleased to announce the release of Percona Distribution for MySQL. Following our recent releases of Percona Distribution for MongoDB and Percona Distribution for PostgreSQL, we have assembled the best and most critical enterprise components for MySQL,...
by David Quilty | Jun 22, 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 Carlos Tutte | Jun 19, 2020 | Insight for DBAs, Monitoring, Percona Software
Disclaimer: This blog post is about migrating Percona Monitoring and Management 2 (PMM) data between PMM2 versions, and not for migrating data from PMM1 to PMM2. Restoring data from PMM1 to PMM2 is NOT supported since there were many architectural changes. I...
by Peter Zaitsev | Jun 17, 2020 | Monitoring, MySQL, Percona Software
The RED Method (Rate, Errors, Duration) is one of the more popular performance monitoring approaches. It is often applied to Monitoring Microservices though there is nothing that prevents it from being applied to databases like MySQL. In Percona Monitoring and...
by Tom Basil | Jun 16, 2020 | Open Source, Percona Services, Percona Software
All Percona products are free and open-source. If you use Percona software, provide us with your feedback and help make a larger audience aware at the same time. This helps drive our software development forward – without costing you anything. You can do this...
by Vadim Tkachenko | Jun 15, 2020 | Benchmarks, MongoDB, Percona Software
I was looking for a tool that could evaluate MongoDB performance under a complex workload, besides simple key-value operations that benchmarks like YCSB provides. That’s why the paper “Adapting TPC-C Benchmark to Measure Performance of Multi-Document Transactions in...
