Uncommon Sense MySQL – When EXPLAIN Can Trash Your Database
6 days ago, percona

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 common sense does not apply to […]...

Recover Percona XtraDB Cluster in Kubernetes From Wrong MySQL Config
6 days ago, percona

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. The document Changing MySQL Options describes how to provide custom [crayon-5fbbf7ef80d2a698888219-i/] configuration to the operator. But what would […]...

Impact of Percona Monitoring and Management “Get Latest” Command Change
6 days ago, percona

In the first quarter of 2021 (expected late January), Percona is slated to release a version of Percona Monitoring and Management (PMM) v2 that will include all of the critical functionality users of PMM v1 have come to know and love over the years. While PMM v2 has some major improvements over its v1 sibling, […]...

Demultiplexing Fix for Percona Backup for MongoDB, Redesign –lock-ddl-per-table in Percona XtraBackup: Release Roundup November 23, 2020
6 days ago, percona

It’s release roundup time here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Today’s post […]...

Webinar December 9: How to Measure Linux Performance Wrong
1 week ago, percona

Don’t miss out! Join Peter Zaitsev, Percona CEO, as he discusses Linux Performance measurement. In this webinar, Peter will look at typical mistakes measuring or interpreting Linux Performance. He’ll discuss whether you should use LoadAvg to assess if your CPU is overloaded or Disk Utilization to see if your disks are overloaded. In addition, he’ll […]...

A Blog Shamelessly Bribing You to Review Percona Monitoring and Management!
1 week ago, percona

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 pros and cons on the […]...

Wondering How to Run Percona XtraDB Cluster on Kubernetes? Try Our Operator!
1 week ago, percona

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 explaining this in The Criticality of a Kubernetes Operator for Databases. If […]...

Tame Black Friday Gremlins — Optimize Your Database for High Traffic Events
1 week ago, percona

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 retail, it usually brings up…different emotions. […]...

Kubernetes Scaling Capabilities with Percona XtraDB Cluster
2 weeks ago, percona

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 Operator for Percona XtraDB Cluster (PXC Operator) and can help you to control the bill. Resources […]...

Measuring OpenEBS Local Volume Performance Overhead in Kubernetes
2 weeks ago, percona

I wrote about the usage of OpenEBS to manage local storage in Kubernetes in my previous posts: Deploying Percona Kubernetes Operators with OpenEBS Local Storage OpenEBS for the Management of Kubernetes Storage Volumes The primary reason to use the local storage is performance and the logical question is then: How big is the performance overhead […]...

Restore a Replica Set to a New Environment with Percona Backup for MongoDB
2 weeks ago, percona

Percona Backup for MongoDB (PBM) is our open source tool for backing up MongoDB clusters. Initially, the tool was developed for restoring the backups in the same environment they are taken. In this post, I will show you how to restore a backup to a new environment instead. Let’s assume you followed the instructions to […]...

OpenEBS for the Management of Kubernetes Storage Volumes
2 weeks ago, percona

I recently wrote about OpenEBS in regard to local volumes in my post Deploying Percona Kubernetes Operators with OpenEBS Local Storage. And there are also my recent blog posts about Kubernetes, Percona Operators, and storage management problems: Using Volume Snapshot/Clone in Kubernetes ChaosMesh to Create Chaos in Kubernetes For me, working with my own deployment […]...

Deep Dive Into PostgreSQL Indexes – Free Course at Percona University Online
2 weeks ago, percona

Percona University Online has released its second free course, “A Deep Dive Into PostgreSQL Indexes” by Ibrar Ahmed, Senior Software Engineer at Percona. Indexes are a basic feature of relational databases. PostgreSQL offers a rich collection of index options for developers and designers. But users need to understand the basic concept of indexes, to be […]...

Updated Percona Distribution for MongoDB, Buffer Calculation Fix in Percona Server for MySQL: Release Roundup November 9, 2020
2 weeks ago, percona

It’s release roundup time here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Today’s post […]...

Various Backup Compression Methods Using Mysqlpump
3 weeks ago, percona

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 mysqlpump Utility), and in this blog, I am going to explore the […]...

ChaosMesh to Create Chaos in Kubernetes
3 weeks ago, percona

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 important tool that I use to test our Operators: ChaosMesh, which actually is […]...

Deploying Percona Monitoring and Management 2 Without Access to the Internet
3 weeks ago, percona

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 Internet, so pulling the image from the Docker hub is not possible. Fortunately, there are a […]...

New in MongoDB 4.4: Hidden Index
3 weeks ago, percona

We already presented a previous article on the index types available on MongoDB. MongoDB 4.4 was released a few months ago and introduced a new interesting feature: the hidden index. This feature is also available on Percona Server for MongoDB 4.4. In this article, we’ll see what it is. What is a Hidden Index A […]...

Webinar November 19: Converting MongoDB to Percona Server for MongoDB
3 weeks ago, percona

We invite you to join members of the Percona Solution Engineering Team as they walk through the task of migrating a MongoDB database to Percona Server for MongoDB (PSMDB). By the end of this hands-on workshop you should feel comfortable with: Uninstalling MongoDB Installing Percona Server for MongoDB Converting a stand-alone MongoDB server to Percona […]...

Running Percona Kubernetes Operator for Percona XtraDB Cluster with Kata Containers
3 weeks ago, percona

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 how to run Percona Kubernetes Operator for Percona XtraDB Cluster (PXC Operator) using Kata containers. Prepare Your Kubernetes Cluster Setting […]...

Next