MySQL 8 comes with a lot of good features, and recently I explored its password management systems. I wanted to put together a series of blogs about it, and this is the first part. In this post, I am going to explain the following topics in detail. Password Reuse Policy Random Password Generation Password Reuse [&]

https://www.percona.com/blog/enhanced-password-management-systems-in-mysql-8-part-1/

This article is meant to provide a high-level overview of how a web-based application is commonly structured nowadays. Keep in mind the topic presented is very simplified. It is meant as an introduction only and hopefully encourages the reader to investigate some of the concepts in more depth. Monolith vs Microservices With the rise of [&]

https://www.percona.com/blog/modern-web-based-application-architecture-101/

Primary Key design is an important thing for InnoDB performance, and choosing a poor PK definition will have an impact on performance and also write propagation in databases. When this comes to Aurora, this impact is even worse than you may notice. In short, we consider a poor definition of a Primary Key in InnoDB [&]

https://www.percona.com/blog/making-aurora-write-latency-15x-higher-or-more-by-choosing-a-bad-primary-key/

The new MyDumper 0.11.1 version, which includes many new features and bug fixes, is now available.  You can download the code from here. For this release, there are three main changes: 1) we added config file functionality which allows users to set session-level variables (one of the most requested features!), 2) we developed a better [&]

https://www.percona.com/blog/mydumper-0-11-1-is-now-available/

Nowadays, more and more companies are thinking about the migration of their infrastructure to Kubernetes. Databases are no exception. There were a lot of k8s operators that were created to simplify the different types of deployments and also perform routine day-to-day tasks like making the backups, renewing certificates, and so on.  If a few years [&]

https://www.percona.com/blog/migration-of-a-mysql-database-to-a-kubernetes-cluster-using-asynchronous-replication/

When doing migrations or failovers in MySQL, there is usually a need to do a topology change and repoint replica servers to obtain replication data from a different server. For example, given servers {A, B, and C} and the following topology: If you need to repoint C to be a replica of B, i.e: You [&]

https://www.percona.com/blog/repoint-replica-servers-in-mysql-percona-server-for-mysql-8-0/

Have a burning question about MongoDB? Database experts will be leading an open forum discussion based on attendees’ interests. Are you ahead of the curve? Just trying to keep up? Get the best of MongoDB. Live Stream: October 13 at 11:30 am CT (30 min) Watch this upcoming Open Mic on Open Source to learn [&]

https://www.percona.com/blog/october-13-2021-open-mic-on-open-source-takes-on-mongodb/

Here’s a second post focusing on the performance of MySQL on ZFS in cloud environments. In the first post, MySQL/ZFS Performance Update, we compared the performances of ZFS and ext4. This time we’ll look at the benefits of using ephemeral storage devices. These devices, called ephemeral in AWS, local in Google cloud, and temporary in [&]

https://www.percona.com/blog/mysql-zfs-in-the-cloud-leveraging-ephemeral-storage/

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-september-13-2021/

I recently came across an interesting case of performance issues during balancing in a MongoDB cluster. Digging through the logs, it became clear the problem was related to chunk moves taking a long time. As we know, the default maximum chunk size is 64 MB. So these migrations are supposed to be very fast in [&]

https://www.percona.com/blog/finding-undetected-jumbo-chunks-in-mongodb/

Thanks to everyone who attended last week’s webinar on Using Open Source Software to Optimize and Troubleshoot Your MySQL Environment; hopefully you’ve found the time we spent in Percona Monitoring and Management (PMM) useful. We had a record-breaking number of questions during the talk and unfortunately weren’t able to answer them all live, so we [&]

https://www.percona.com/blog/qa-on-webinar-using-open-source-software-to-optimize-and-troubleshoot-your-mysql-environment/

We explored the basic functionality of JSON within PostgreSQL in Part One of this series. Now we will look a little deeper into some things we may want to use regularly.  Most of the functionality we talked about in part one works well when you have a simple JSON format.  However, in real life, our [&]

https://www.percona.com/blog/storing-and-using-json-within-postgresql-part-two

Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker, on deploying Docker containers running open source databases, in this article, Ill demonstrate how to install PostgreSQL using Docker. Before proceeding, it is important to remind you of Peters warning from his article, which applies here as well:  The following instructions are [&]

https://www.percona.com/blog/installing-postgresql-using-docker/

Continuing our series on storing JSON directly within your database, we are now looking at the JSON functionality built into PostgreSQL.  You can see the first two posts in this series exploring MySQL’s JSON functionality with Storing JSON in Your Databases: Tips and Tricks For MySQL Part One and Storing JSON in Your Databases: Tips [&]

https://www.percona.com/blog/storing-and-using-json-within-postgresql-part-one/

Storing your data locally can impose security and availability risks. Major cloud providers have object storage services available to allow you to upload and distribute data across different regions using various retention and restore policies. Percona XtraBackup delivers the xbcloud binary  an auxiliary tool to allow users to upload backups to different cloud providers [&]

https://www.percona.com/blog/introducing-xbcloud-exponential-backoff-feature-in-percona-xtrabackup/

We’re excited to share that Marcelo Altmann from the Percona Server Engineering Team has just been promoted from Oracle ACE Associate to Oracle ACE. Congratulations! The Oracle ACE Program recognizes and rewards community members for their technical contributions to the Oracle community. Marcelo initially joined Percona as a senior support engineer in our global services [&]

https://www.percona.com/blog/congratulating-marcelo-altmann-on-his-promotion-to-oracle-ace/

Percona Monitoring and Management (PMM) has dashboards that cover a lot of ground, yet PMM Superpowers come from the fact you do not need to stick to dashboards that are included with the product! You also can easily install additional dashboards provided by the Community, as well as implement your own. In this blog post, [&]

https://www.percona.com/blog/percona-monitoring-and-management-additional-dashboards/

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. The first one, written by Peter Zaitsev, was Installing MySQL with Docker. Before proceeding, it is important to double warn by quoting [&]

https://www.percona.com/blog/installing-mongodb-with-docker/

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-august-30-2021/

MongoDB 5.0 has been released with a bunch of new features. An important one is the capability to completely redefine the shard key of a collection in a sharded cluster. Resharding was a feature frequently requested by the customers. In MongoDB 4.4 only the refining of the shard was available; from now on you can [&]

https://www.percona.com/blog/resharding-in-mongodb-5-0/