Percona's MySQL & InnoDB performance and scalability blog
91k followers 0 件/週
MySQL Connection Security With Connection Control Plugins

As a database administrator, have you ever been in a situation when your database confronted a brute force attack? A brute force attack can be launched against a user account in MySQL. MySQL replies with success or error based on supplied credentials, and the time required for the verification is almost the same in either case. Hence, an attacker can...

Tue May 16, 2023 17:23
Backup and Restore with MyDumper on Docker

At the end of 2021, I pushed the first Docker image to This was the first official image and since then, we have been improving our testing and packaging procedures based on Docker, CircleCI, and GitHub Actions. However, when I’m coding,  I’m not testing in Docker. But a couple of weeks ago, when I was reviewing an issue, I realized...

Tue May 16, 2023 15:35
MongoDB 4.2 EOL… And Its Implications

Enjoy it while it lasts, as everything has its end.Maricon454688973982390893280398289038302380283’2233’832’23, CC BY-SA 4.0, via Wikimedia CommonsIt sounded a bit more cryptic than it was planned, but I hope that it gets the attention it needs, as it’s important to know that MongoDB 4.2 in April has reached its End of Life (EOL), and more versions are...

Mon May 15, 2023 17:48
Proof of Concept: Horizontal Write Scaling for MySQL With Kubernetes Operator

Historically MySQL is great in horizontal READ scale. The scaling, in that case, is offered by the different number of Replica nodes, no matter if using standard asynchronous replication or synchronous replication.However, those solutions do not offer the same level of scaling for writes operation.Why? Because the solutions still rely on writing in...

Mon May 15, 2023 14:16
Understanding Linux IOWait

I have seen many Linux Performance engineers looking at the “IOWait” portion of CPU usage as something to indicate whenever the system is I/O-bound. In this blog post, I will explain why this approach is unreliable and what better indicators you can use.Let’s start by running a little experiment – generating heavy I/O usage on the system:sysbench --threads=8...

Wed May 10, 2023 15:17
Restoring a Snapshot of a Sharded MongoDB Cluster to a Kubernetes-Based MongoDB Environment

Many MongoDB clusters use storage-level snapshots to provide fast and reliable backups. In this blog post, you’ll learn how to restore such a snapshot from a traditional VM-based sharded MongoDB cluster to a freshly deployed Percona Operator for MongoDB cluster on Kubernetes.Background storyI recently worked with a company running a large four-shard...

Tue May 9, 2023 16:49


14 日間のトライアルをはじめましょう。クレジットカードは不要です。