How native ProxySQL stands in failover support (both v2.0.15 and v2.1.0) In recent times I have been designing several solutions focused on High Availability and Disaster Recovery. Some of them using Percona Server for MySQL with group replication, some using Percona XtraDB Cluster (PXC). What many of them had in common was the use of [&]

https://www.percona.com/blog/2020/11/30/support-for-percona-xtradb-cluster-in-proxysql-part-one/

Please join Barrett Chambers, Percona Solutions Engineer, for an engaging webinar on MongoDB vs. Open Source. Many organizations require Enterprise subscriptions for the coverage and features that it provides. However, many are unaware that there is an open source alternative offering all the features and benefits of a MongoDB Enterprise subscription without the licensing fees. [&]

https://www.percona.com/blog/2020/11/30/webinar-december-15-the-open-source-alternative-to-paying-for-mongodb/

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 [&]

https://www.percona.com/blog/2020/11/23/uncommon-sense-mysql-when-explain-can-trash-your-database/

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-5fbf73c7cd5dd292927892-i/] configuration to the operator. But what would [&]

https://www.percona.com/blog/2020/11/23/recover-percona-xtradb-cluster-in-kubernetes-from-wrong-mysql-config/

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, [&]

https://www.percona.com/blog/2020/11/23/impact-of-percona-monitoring-and-management-get-latest-command-change/

Its 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. Todays post [&]

https://www.percona.com/blog/2020/11/23/demultiplexing-fix-for-percona-backup-for-mongodb-redesign-lock-ddl-per-table-in-percona-xtrabackup-release-roundup-november-23-2020/

Dont 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. Hell 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, hell [&]

https://www.percona.com/blog/2020/11/20/webinar-december-9-how-to-measure-linux-performance-wrong/

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 [&]

https://www.percona.com/blog/2020/11/19/a-blog-shamelessly-bribing-you-to-review-percona-monitoring-and-management/

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 [&]

https://www.percona.com/blog/2020/11/17/wondering-how-to-run-percona-xtradb-cluster-on-kubernetes-try-our-operator/

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. [&]

https://www.percona.com/blog/2020/11/17/optimize-your-database-for-high-traffic-events-black-friday/

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 [&]

https://www.percona.com/blog/2020/11/13/kubernetes-scaling-capabilities-with-percona-xtradb-cluster/

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 [&]

https://www.percona.com/blog/2020/11/12/measuring-openebs-local-volume-performance-overhead-in-kubernetes/

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. Lets assume you followed the instructions to [&]

https://www.percona.com/blog/2020/11/10/restore-a-replica-set-to-a-new-environment-with-percona-backup-for-mongodb/

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 [&]

https://www.percona.com/blog/2020/11/09/openebs-for-the-management-of-kubernetes-storage-volumes/

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 [&]

https://www.percona.com/blog/2020/11/09/deep-dive-into-postgresql-indexes-free-course-at-percona-university-online/

Its 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. Todays post [&]

https://www.percona.com/blog/2020/11/09/updated-percona-distribution-for-mongodb-buffer-calculation-fix-in-percona-server-for-mysql-release-roundup-november-9-2020/

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 [&]

https://www.percona.com/blog/2020/11/06/various-backup-compression-methods-using-mysqlpump/

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 [&]

https://www.percona.com/blog/2020/11/05/chaosmesh-to-create-chaos-in-kubernetes/

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 doesnt have access to the public Internet, so pulling the image from the Docker hub is not possible. Fortunately, there are a [&]

https://www.percona.com/blog/2020/11/05/deploying-percona-monitoring-and-management-2-without-access-to-the-internet/

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, well see what it is. What is a Hidden Index A [&]

https://www.percona.com/blog/2020/11/05/new-in-mongodb-4-4-hidden-index/