Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
July 24, 2020
MongoDB: Utilization of an Index on Subdocuments
MongoDB has a lot of possibilities for creating indexes. We have seen in previous articles some of the available index [...]
July 22, 2020
Percona Audit Log Plugin and the Percona Monitoring and Management Security Threat Tool
The Security Threat Tool has been available since Percona Monitoring and Management 2.6.0 (PMM) and starting from that first release [...]
July 22, 2020
Beyond Relational Databases: A Focus on Redis, MongoDB, and ClickHouse
Many of us use and love relational databases… until we try and use them for purposes that aren’t their strong [...]
July 20, 2020
Backing Up Percona Kubernetes Operator for Percona XtraDB Cluster Databases to Google Cloud Storage
The Percona Kubernetes Operator for Percona XtraDB Cluster can send backups to Amazon S3 or S3-compatible storage. And every now [...]
July 20, 2020
Backup and Restore of MongoDB Deployment on Kubernetes
Every database environment should require a robust backup strategy as its a fundamental requirement to running a successful and robust [...]
July 15, 2020
MySQL Query Performance Troubleshooting: Resource-Based Approach
When I speak about MySQL performance troubleshooting (or frankly any other database), I tend to speak about four primary resources [...]
July 9, 2020
binlog2sql: Binlog to Raw SQL Conversion and Point In Time Recovery
In this blog, I will look at the tool binlog2sql, designed by Cao Danfeng. The tool will help to decode [...]
July 7, 2020
MySQL Deadlocks Are Our Friends
Why another article on this, Marco? MySQL deadlocks is a topic covered many times, including here at Percona. I suggest [...]
July 7, 2020
Enable Email Sending in Percona Monitoring and Management 2
Many years ago I was banned from touching anything of critical importance as far as production infrastructure goes…something about “the [...]
July 6, 2020
MySQL 101: Linux Tuning for MySQL
When trying to do some Linux tuning for MySQL, there are a few options that will greatly influence the speed [...]
July 6, 2020
Adding eBPF-Based Metrics to Percona Monitoring and Management
I wanted to start this post with the words “eBPF is the hot new thing”, but I think it’s already [...]
July 1, 2020
Preventing MySQL Error 1040: Too Many Connections
One of the most common errors encountered in the MySQL world at large is the infamous Error 1040: [crayon-696b50bf040ad337464980/] [...]
June 30, 2020
Analyzing MySQL with strace
In this blog post, we will briefly explore the OS tool strace. It is not widely used due to its [...]
June 29, 2020
Percona Server for MySQL Highlights – Extended Slow Query Logging
Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server [...]
June 29, 2020
Are You The Next Great Percona TAM?
In 2006, a small company formed, specializing in MySQL database consulting at a time when very few companies had fully [...]
June 25, 2020
Top 7 Reasons Why Security Goes Wrong In A Database System
Today I’m going to talk about my favorite trope, “database security”. When done right, a good security policy not only [...]
June 25, 2020
MongoDB Checkpointing Woes
In my recent post Evaluating MongoDB Under Python TPCC 1000W Workload with MongoDB benchmarks, I showed an average throughput for [...]
June 24, 2020
MySQL Table Fragmentation: Beware of Bulk INSERT with FAILURE or ROLLBACK
Usually, database people are familiar with table fragmentation with DELETE statements. Whenever doing a huge delete, in most cases, they [...]
June 24, 2020
Evaluating MongoDB Under Python TPCC 1000W Workload
Following my blog post Evaluating the Python TPCC MongoDB Benchmark, I wanted to evaluate how MongoDB performs under workload with [...]