When organizing things helps to simplify life. In the previous article, we start to explore dynamic privileges and the interaction with static ones. We also saw how to remove SUPER privilege from a DBA account.  What we did was go by subtraction. But in real life, we should act differently. We should ADD only what [&]

https://www.percona.com/blog/2021/06/15/mysql-static-and-dynamic-privileges-part-2/

When trying to make things better, make it very complicated. I was working on a Security Threat Tool script when I had to learn more about the interaction between static and dynamic privileges in MySQL 8. Dynamic privileges is a “new” thing added in MySQL 8 to easily extend the privileges definition, and at the [&]

https://www.percona.com/blog/2021/06/15/mysql-static-and-dynamic-privileges-part-1/

Percona Monitoring and Management (PMM) recently introduced the Integrated Alerting feature as a technical preview. This was a very eagerly awaited feature, as PMM doesnt need to integrate with an external alerting system anymore. Recently we blogged about the release of this feature. PMM includes some built-in templates, and in this post, I am going [&]

https://www.percona.com/blog/2021/06/14/mongodb-integrated-alerting-in-percona-monitoring-and-management/

The practice of running databases in containers continues to grow in popularity.  As a Technical Account Manager at Percona, I get asked regularly about our Percona Distribution for MySQL Operator.  Additionally, I’m asked what I’m seeing in the industry in terms of adoption.  In most cases, the questions stem around new deployments.  Our DBaaS tool (currently [&]

https://www.percona.com/blog/2021/06/14/migrating-into-kubernetes-running-the-percona-distribution-for-mysql-operator/

A couple of weeks ago, Jobin and I did a short presentation during Percona Live Online bearing a similar title as the one for this post: “PostgreSQL HA With Patroni: Looking at Failure Scenarios and How the Cluster Recovers From Them”. We deployed a 3-node PostgreSQL environment with some recycled hardware we had lying around [&]

https://www.percona.com/blog/2021/06/11/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/

MongoDB supports multiple authentication mechanisms, including the default one SCRAM, LDAP, Kerberos, and x.509 Certificate Authentication. In the X.509 system, which will be the main point of this blog post, an organization can identify its entities using a pair of certificates and private keys signed and trusted by some Certificate Authority (CA). This model is [&]

https://www.percona.com/blog/2021/06/10/distributed-grant-management-using-mongodbauthorizationgrant/

In the previous release of our Percona Distribution for MySQL Operator, we implemented one interesting feature, which can be seen as “self-healing”: https://jira.percona.com/browse/K8SPXC-564. I do not think it got enough attention, so I want to write more about this. As it is well known, a 3-node cluster can survive a crash of one node (or [&]

https://www.percona.com/blog/2021/06/10/self-healing-feature-in-percona-distribution-for-mysql-operator/

In my previous post Back From a Long Sleep, MyDumper Lives!, I told you that Fast Index Creation was in the queue and (after fixing several bugs) it will package in release 0.10.7 next month. But why am I so excited about it? Well, this feature opens new opportunities, what Im going to call Restore [&]

https://www.percona.com/blog/2021/06/08/restore-strategies-with-mydumper/

Percona Server for MongoDB (PSMDB) has provided a hot backup of its underlying data db directory files using WiredTiger library methods since v3.4. When you use the { createBackup: & } command it will copy them to whichever other filesystem directory or object store bucket location you specify. createBackup partially freezes the WiredTiger *.wt Btree [&]

https://www.percona.com/blog/2021/06/07/experimental-feature-backupcursorextend-in-percona-server-for-mongodb/

Its release roundup time again 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. This [&]

https://www.percona.com/blog/2021/06/07/percona-monitoring-and-management-updated-percona-distribution-for-mongodb-release-roundup-june-7-2021/

The combination of the information obtained from the “pt-summaries” discussed in the previous posts of this series (Part 1: The Percona Support Way, Part 2: Knowing the Server, Part 3: What MySQL?) helps us come up with the first impression of a MySQL server. However, apart from the quick glance we get at two samples [&]

https://www.percona.com/blog/2021/06/04/inspecting-mysql-servers-part-4-an-engine-in-motion/

Join our expert team for a live demo of the Percona Monitoring and Management (PMM) platform and witness the power of Percona support! Bring your questions to the table in a live, open forum discussion.  Brian Walters, Sr. Director of Solution Engineering, and Iwo Panowicz, Technical Support Engineer, will highlight features and pain points of Percona Monitoring [&]

https://www.percona.com/blog/2021/06/03/webinar-july-17-open-mic-on-open-source-percona-monitoring-and-management/

This week, I had an interesting case whereas one of our customers was facing the issue: [crayon-60bd3d5c06e07015379352/] Studying this issue and discussing it with my colleagues I had to chance to explore in detail how the logical sessions in MongoDB are handled. First, a brief explanation of how the entire process workers and what is [&]

https://www.percona.com/blog/2021/06/03/mongodb-message-cannot-add-session-into-the-cache-toomanylogicalsessions/

In the previous post of this series, we looked at the hardware specifications and operating system settings of the host server through the lenses of a pt-summary report. Now that we know the foundation on which the database is running, we can turn our focus to MySQL itself. The second of our triad of tools [&]

https://www.percona.com/blog/2021/06/03/inspecting-mysql-servers-part-3-what-mysql/

It’s exciting times in the PostgreSQL world with the version 14 beta released a few days ago. It’s now time to look under the hood and find out what has changed from version 13, see what has improved, and what behaviors are changed that we should be aware of. Putting it all in a single [&]

https://www.percona.com/blog/2021/06/02/postgres_fdw-enhancement-in-postgresql-14/

In part 1 of this series, we introduced you to the approach used by the Percona Support team to inspect MySQL servers, which is based on a triad of tools from the Percona Toolkit used to gather diagnostic information. In this article, we will be focusing on the first of these tools, the pt-summary. pt-summary [&]

https://www.percona.com/blog/2021/06/02/inspecting-mysql-servers-part-2-knowing-the-server/

One of the main topics we have today is surely about security. On a daily routine, this can pass unnoticed, but sooner or later, we have to implement or work on some security guidelines. And today, we are going to discuss one of them, which is Field Encryption.  Feature Introduction Discussing the feature per se, [&]

https://www.percona.com/blog/2021/06/02/using-the-mongodb-field-encryption-feature/

Creating and maintaining an inventory file is one of the common tasks we have to deal with when working with Ansible. When dealing with a large number of hosts, it can be complex to handle this task manually. There are some plugins available to automatically generate inventory files by interacting with most cloud providers APIs. [&]

https://www.percona.com/blog/2021/06/01/how-to-generate-an-ansible-inventory-with-terraform/

After Oracle released MySQL version 8.0.24 on April 20, 2021, our engineering team got started right away with merging our enhancements to prepare the corresponding 8.0.24 version of Percona Server for MySQL. However, Oracle released MySQL version 8.0.25 shortly afterward on May 11, 2021, to fix a critical bug that we also observed during our [&]

https://www.percona.com/blog/2021/06/01/skipping-percona-server-for-mysql-version-8-0-24-and-releasing-8-0-25-next/

When I joined the Percona Support team in early 2013, MySQL 5.6 was being launched. I remember all the buzz and euphoria surrounding its release: it was a big step from the 5.5 series, carrying important changes in the MySQL architecture and internals that brought highly anticipated features such as the (still incipient) multi-threaded replication [&]

https://www.percona.com/blog/2021/06/01/inspecting-mysql-servers-part-1-the-percona-support-way/