In this blog, I am going to explain the different ways of electing the PRIMARY node in MySQL group replication. Before MySQL 8.0.2, primary election was based on the members UUID, with the lowest UUID elected as the new primary in the event of a failover. From MySQL 8.0.2: We can select the node to [&]

https://www.percona.com/blog/2021/01/11/mysql-group-replication-how-to-elect-the-new-primary-node/

The aim of Percona Kubernetes Operator for Percona XtraDB Cluster is to be a special type of controller introduced to simplify complex deployments. The Operator extends the Kubernetes API with custom resources. The Operator solution is using Percona XtraDB Cluster (PXC) behind the hood to provide a highly available, resilient, and scalable MySQL service in [&]

https://www.percona.com/blog/2021/01/11/full-read-consistency-within-percona-kubernetes-operator-for-percona-xtradb-cluster/

Percona Kubernetes Operator for Percona XtraDB Cluster comes with two different proxies, HAProxy and ProxySQL. While the initial version was based on ProxySQL, in time, Percona opted to set HAProxy as the default Proxy for the operator, without removing ProxySQL.  While one of the main points was to guarantee users to have a 1:1 compatibility [&]

https://www.percona.com/blog/2021/01/11/percona-kubernetes-operator-for-percona-xtradb-cluster-haproxy-or-proxysql/

Today we are going to present you with another way to make a database copy between servers using our Percona XtraBackup utility.  What is the difference with many others existing on the web?  Not many, but they are interesting in terms of performance and availability. We will combine the xbstream utility with the power of [&]

https://www.percona.com/blog/2021/01/08/streaming-mysql-backups-with-percona-xtrabackup-another-alternative/

It has been some time since I have posted updates to my plugins.  After the initial version, I decided to split the plugins into categories of metrics.  This will allow users to choose whether they want to install all of the plugins or only select ones they care about. Since the installation process is unfamiliar [&]

https://www.percona.com/blog/2021/01/08/updated-mysql-osmetrics-plugins/

In this post, we will be discussing what to do when you add more memory to your MongoDB deployment, a common practice when you are scaling resources. Why Might You Need to Add More Memory? Scaling resources is a way of adding more resources to your environment.  There are two main ways this can be [&]

https://www.percona.com/blog/2021/01/08/mongodb-101-how-to-tune-your-mongodb-configuration-after-upgrading-to-more-memory/

In previous TAM Enterprise Experiences posts, we have outlined typical aspects of utilizing MySQL in an Enterprise environment. One thing we have not yet covered is the topic of database encryption, both from the standpoint of business requirements as well as some of the more technical aspects of encryption. In this post, we will cover: [&]

https://www.percona.com/blog/2021/01/07/tam-enterprise-experiences-data-encryption/

For the third time in the last five years, PostgreSQL took home the Database of the Year award from DB-Engines. If you have not checked out DB-Engines before, they track databases’ popularity by looking at job openings, blog posts, search traffic, and more. Congratulations to the PostgreSQL community, its contributors, and its users! There is [&]

https://www.percona.com/blog/2021/01/07/postgresql-db-engines-coms-database-of-the-year/

Many organizations require an Enterprise subscription of MongoDB for the support coverage and additional 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 and the vendor lock-in. In this joint NessPRO webinar geared at [&]

https://www.percona.com/blog/2021/01/07/webinar-january-19-maximize-the-benefits-of-using-open-source-mongodb-with-percona-distribution-for-mongodb/

Earlier in November, we had a chance to present the “Google Cloud Platform: MySQL at Scale with Reliable HA.” We discussed different approaches to hosting MySQL in Google Cloud Platform with the available options pros and cons. This webinar was recorded and can be viewed here at any time. We had several great questions, which [&]

https://www.percona.com/blog/2021/01/06/google-cloud-platform-mysql-at-scale-with-reliable-ha-webinar-qa/

So far, Percona Kubernetes Operator for Percona Server for MongoDB (PSMDB) has supported only managing replica sets, but from version 1.6.0 it is possible to start a sharding cluster, although at the moment only with one shard. This is a step toward supporting full sharding, with multiple shards being added in a future release. Components [&]

https://www.percona.com/blog/2021/01/06/one-shard-support-in-kubernetes-operator-for-percona-server-for-mongodb/

Dont miss out! Join Peter Zaitsev, Percona CEO, as he discusses MariaDB observability! A broken MariaDB means a broken application, so maintaining insights in MariaDB operational performance is critical. Thankfully MariaDB offers a lot in terms of observability to quickly resolve problems and get great insights into optimization opportunities. In this webinar, we will cover [&]

https://www.percona.com/blog/2021/01/06/webinar-january-20-mariadb-observability/

As with any database platform, MongoDB performance is of paramount importance to keeping your application running quickly.   In this blog post, we’ll show you five configuration options that can impact the performance for your MongoDB Deployment and will help keep your database fast and performing at its peak. MongoDB Performance Overview MongoDB performance consists of [&]

https://www.percona.com/blog/2021/01/05/mongodb-101-5-configuration-options-that-impact-performance-and-how-to-set-them/

One of the great things about being a Technical Account Manager (TAM, for short) at Percona is having the opportunity to see a wide variety of issues across many clients, and having the space to identify the common threads that seem to bind many of these issues. While the challenges vary as widely as the [&]

https://www.percona.com/blog/2021/01/05/tam-enterprise-experiences-troubleshooting-methodology/

We had great attendance, questions, and feedback from our “Converting MongoDB to Percona Server for MongoDB” webinar, which was recorded and can be viewed here. You can view another Q&A from a previous webinar on “Converting MongoDB to Percona Server for MongoDB” here. Without further ado, here are your questions and their responses.   Q: [&]

https://www.percona.com/blog/2021/01/04/converting-mongodb-to-percona-server-for-mongodb-webinar-qa/

Here at Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might [&]

https://www.percona.com/blog/2021/01/04/percona-monthly-bug-report-december-2020/

When we are talking about database security, it encompasses different modules of different areas. It is a very vast topic because, with databases, we need need to secure the whole ecosystem, not just the database node. The figure below shows the major breakdown of the parts which need to be secure. It is clearly evident [&]

https://www.percona.com/blog/2021/01/04/postgresql-database-security-what-you-need-to-know/

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/2021/01/04/tech-previews-in-percona-monitoring-and-management-percona-distribution-for-mysql-8-0-21-release-roundup-january-4-2021/

A lot of elements take part in a good backup strategy. Two of them are: Where to store your backups  Never on the same server. Preferable not in the same datacenter. Ideally far enough so you can restore in case of a natural disaster (region flood, extended local power outage, etc&). Retention period  [&]

https://www.percona.com/blog/2020/12/28/percona-xtrabackup-introducing-support-for-storage-class-in-xbcloud/

Percona Monitoring and Management (PMM) v2.12.0 comes with a lot of improvements and one of the most talked-about is the usage of VictoriaMetricsDB. The reason we are doing this comparison is that PMM 2.12.0 is a release in which we integrate VictoriaMetricsDB and replace Prometheus as its default method of data ingestion. A reason for [&]

https://www.percona.com/blog/2020/12/23/observations-on-better-resource-usage-with-percona-monitoring-and-management-v2-12-0/