In April 2021, I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented.  Anyhow, in that article I have shown how an online DDL was de facto locking the [&]

https://www.percona.com/blog/online-ddl-with-group-replication-in-mysql-8-0-27/

Working with hundreds of different customers I often face similar problems around running queries. One very common problem when trying to optimize a database environment is index usage. A query that cannot use an index is usually a long-running one, consuming more memory or triggering more disk iops. A very common case is when a [&]

https://www.percona.com/blog/mysql-8-0-functional-indexes/

Nowadays we are seeing a lot of customers starting to use our Percona Distribution for MongoDB Kubernetes Operator. The Percona Kubernetes Operators are based on best practices for the configuration of a Percona Server for MongoDB replica set or the sharded cluster. The main component in MongoDB is the wiredTiger cache which helps to define [&]

https://www.percona.com/blog/configure-wiredtiger-cachesize-inside-percona-distribution-for-mongodb-kubernetes-operator/

With modern application design, systems are becoming more diverse, varied and have more components than ever before. Developers are often forced to become master chefs adding the ingredients from dozens of different technologies and blending them together to create something tasty and amazing. But with so many different ingredients, it is often difficult to understand [&]

https://www.percona.com/blog/application-and-database-design-small-things-can-have-a-big-impact/

Recently we were asked to check the performance of the new family of AMD EPYC processors when using MySQL in Google Cloud Virtual Machines. This was motivated by a user running MySQL in the N1 machines family and willing to upgrade to N2D generation considering the potential cost savings using the new AMD family.  The [&]

https://www.percona.com/blog/comparing-amd-epyc-performance-with-intel-xeon-in-gcp/

Security will always be a main focal point of a companys data. A common question I get from clients is, how do I enable encryption? Like every good consulting answer, it depends on what you are trying to encrypt. This post is a high-level summary of the different options available for encryption in Percona Server [&]

https://www.percona.com/blog/percona-server-for-mysql-encryption-options-and-choices/

Following my post MySQL/ZFS Performance Update, a few people have suggested I should take a look at BTRFS (butter-FS, b-tree FS) with MySQL. BTRFS is a filesystem with an architecture and a set of features that are similar to ZFS and with a GPL license. It is a copy-on-write (CoW) filesystem supporting snapshots, RAID, and [&]

https://www.percona.com/blog/taking-a-look-at-btrfs-for-mysql/

One of the reasons for using MongoDB is its simplicity in scaling its structure,  either as Replicaset(scale-up) or as Sharded Cluster(scale-out). Although a bit tricky in Sharded environments, the reverse process is also feasible. From the possibilities, you can: Reduce the number of shards from your Sharded Cluster as documented here. You can also reduce the [&]

https://www.percona.com/blog/mongodb-converting-replica-set-to-standalone/

Its the first release roundup of the New Year! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our [&]

https://www.percona.com/blog/release-roundup-january-3-2022/

In Percona Support we spend a few hours per week doing Labs: short collective projects, not directly related to the tickets. One of our last labs was about to get ready for the winter holiday season which means preparing the tree and decorating it. To do it we used our favorite tools: MySQL, and ASCII [&]

https://www.percona.com/blog/percona-support-team-new-year-greetings/

Recently, I got some of our customers doing an upgrade to v4.x from v3.0 (Yeah, still could see older MongoDB versions and we suggest everyone do the upgrade to stay with the current GA!). There were some pain points in the upgrade process, and especially before migrating to v3.4, you will need to change from [&]

https://www.percona.com/blog/mongodb-config-server-upgrade-from-sccc-to-csrs-replicaset/

Percona Monitoring and Management 2 (PMM2) is the database monitoring suite assembled and developed by Percona. It is based on standard open source components and custom-made software integrations. PMM2 helps you reduce complexity, optimize performance, and improve the security of your business-critical database environments, no matter where they are located or deployed. This blog post [&]

https://www.percona.com/blog/percona-monitoring-and-management-2-test-drive-using-virtualbox-and-ssh-tunnels/

First I want to thank everyone who attended my November 16, 2021 webinar “MySQL Performance for DevOps“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide during the webinar. Q: Hi! We have troubles with DELETE queries. We have to [&]

https://www.percona.com/blog/q-a-on-webinar-mysql-performance-for-devops/

In this blog post, we will compare the performance of performing a backup from a MySQL database using mysqldump, MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. All these available options are open source and free to use for the entire community. To start, lets see the results of the test. Benchmark [&]

https://www.percona.com/blog/dump-performance-comparison-mysqldump-vs-mysql-shell-utilities-vs-mydumper/

If you have ever used backups with Percona Distribution for MongoDB Operator, you should already know that backed-up data is stored outside the Kubernetes cluster  on Amazon S3 or any S3-compatible storage. Storage types not compatible with the S3 protocol were supported indirectly in the case of an existing S3 wrapper/gateway. A good example [&]

https://www.percona.com/blog/azure-blob-storage-support-for-percona-distribution-for-mongodb-operator/

As we all know, security is very important these days and we read about many data leaks. Security has many aspects, but one of the most important is securing data since it is a vital asset to companies. When we speak about data, it can be encrypted at rest (transparent data encryption  TDE, full [&]

https://www.percona.com/blog/data-at-rest-encryption-support-in-percona-distribution-for-mongodb-operator/

The recent release of Percona Monitoring and Management 2.25.0 (PMM) includes a fix for bug PMM-6937: before that, PMM expected all monitoring connections to PostgreSQL servers to be made using the default postgres database. This worked well for most deployments, however, some DBaaS providers like Heroku and DigitalOcean do not provide direct access to the [&]

https://www.percona.com/blog/pmm-now-supports-monitoring-of-postgresql-instances-connecting-with-any-database-name/

Its release roundup time again here at Percona! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. [&]

https://www.percona.com/blog/release-roundup-december-20-2021/

2022 is coming! While we look forward to it, it is time to summarize the results of this year to find out what content was the most viewed, and raised the most interest, during the past months. Percona’s HOSS (Head of Open Source Strategy) Matt Yonkovit hosts an amazing podcast with tech talks on all [&]

https://www.percona.com/blog/2021-hoss-talks-foss-most-popular-podcast-episodes/

Percona Security has been tracking an evolving issue over the weekend and into the beginning of this week. The Log4J vulnerability, also sometimes referred to as Log4JShell, can be exploited to allow for the complete takeover of the target to run any arbitrary code. This affects versions of log4j 2.0-beta9 through 2.14.1  the current [&]

https://www.percona.com/blog/log4jshell-vulnerability-update/