Insight for DBAs

Securing MongoDB: Top Five Security Concerns

securing mongodb

“I think most of the time hackers behind the attacks do it just for fun, because they can and because it’s very simple”, — says Diachenko. Source: “Meowing” attack completely destroyed more than 1000 databases
These are the words of Bob Diachenko, one of the most respected cybersecurity researchers in relation to the last “Meowing” […]

Read more

MySQL 8.x DDL Rewriter and Query Rewriter Plugins: Implementation and Use Cases

MySQL 8 DDL Rewriter and Query Rewriter

Rewriting a MySQL query for performance is an important process that every DBA should be aware of so they can fix the wrong queries on runtime without code changes on the application end. ProxySQL has great support for rewriting the queries, which Alkin Tezuysal already explored in his excellent blog ProxySQL Query Rewrite Use Case.
So […]

Read more

Finding a Regression in MySQL Source Code: A Case Study

finding regression in mysql source

At the Percona engineering team, we often receive requests to analyze changes in MySQL/Percona Server for MySQL behavior from one version to another, either due to regression or a bug fix (when having to point out to a customer that commit X has fixed their issue and upgrading to a version including that fix […]

Read more

Why the Heck Are So Many Databases Being Breached, Leaked, and Hacked?

database security

How many times have we seen this headline lately: “X million records leaked in data breach”? The answer is, too many! 
In fact, because “millions of records” are starting to leak so frequently, larger news outlets are not covering the “smaller” leaks as often as they were a few years ago. These days it’s all […]

Read more

Compiling a Percona Monitoring and Management v2 Client in ARM Architecture

Percona Monitoring and Management ARM

In this blog, we are going to see how to compile a Percona Monitoring and Management 2 (PMM v2) client in ARM. For this, we are going to use an AWS EC2 ARM instance with Amazon Linux 2.
Installing Dependencies
First, let’s get some basic packages out of the way, which probably are installed in your […]

Read more