Updating documents on MongoDB prior to version 4.2 was quite limited. It was not possible to set values to a conditional expression, combine fields, or update a field based on the value of another field on the server-side. Tracing a parallel to the SQL update statements, for example, it wasn’t possible to do something like [&]

https://www.percona.com/blog/mongodb-modifying-documents-using-aggregation-pipelines-and-update-expressions/

Recently I wanted to play with the latest and greatest Percona Distribution for MongoDB Operator which had a bug fix I was interested in. The bug fix was merged in the main branch of the git repository, but no version of the Operator that includes this fix was released yet. I started the Operator by [&]

https://www.percona.com/blog/building-and-testing-percona-distribution-for-mongodb-operator/

We have several PostgreSQL versions that support logical decoding to replicate data changes from a source database to a target database, which is a cool and very powerful tool that gives the option to replicate all the tables in a database, only one schema, a specific set of tables or even only some columns/rows, also [&]

https://www.percona.com/blog/postgresql-logical-replication-using-an-rds-snapshot/

Fiserv, a Percona customer, will discuss the business case and results they achieved working with Percona to run MongoDB.  Register for a Fireside Chat taking place on Tuesday, July 27, 1 PM EDT! If you use MongoDB to build business applications that need to scale quickly, the chances are that your company is paying dearly [&]

https://www.percona.com/blog/2021/07/23/free-webinar-july-27-why-fiserv-moved-to-percona-to-run-mongodb/

Good database maintenance includes not only performing the standard adding, updating, and deleting records, etc., but periodic edits to the table schema too. Operations such as adding, editing, and removing table columns are part of todays life-cycle reality too as new functionality is constantly being added. In quieter, and less demanding times, one could get [&]

https://www.percona.com/blog/performing-etl-using-inheritance-in-postgresql/

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

https://www.percona.com/blog/new-features-in-percona-server-for-mysql-updated-percona-proxysql-admin-tool-release-roundup-july-19-2021/

In Kubernetes, all resources have a status field separated from their spec. The status field is an interface both for humans or applications to read the perceived state of the resource. When you deploy our Percona Kubernetes Operators   Percona Distribution for MongoDB Operator or Percona Distribution for MySQL Operator  in your Kubernetes cluster, [&]

https://www.percona.com/blog/cluster-statuses-in-percona-kubernetes-operators/

The Problem State Snapshot Transfer can be a very long and expensive process, depending on the size of your Percona XtraDB Cluster (PXC)/Galera cluster, as well as network and disk bandwidth. There are situations where it is needed though, like after long enough node separation, where the gcache on other members was too small to [&]

https://www.percona.com/blog/how-to-recover-percona-xtradb-cluster-5-7-node-without-sst/

Problem Statement Having backups of binary logs is fairly normal these days. The more recent binary logs are copied offsite, the better RPO (Recovery Point Objective) can be achieved. I was asked multiple times recently if something could be done to “stream” the binary logs to S3 as close to real-time as possible. Unfortunately, there [&]

https://www.percona.com/blog/streaming-mysql-binlogs-to-s3-or-any-object-storage/

As some of you likely know, I have a favorable view of ZFS and especially of MySQL on ZFS. As I published a few years ago, the argument for ZFS was less about performance than its useful features like data compression and snapshots. At the time, ZFS was significantly slower than xfs and ext4 except [&]

https://www.percona.com/blog/mysql-zfs-performance-update/

Percona Server for MongoDB supports two different ways of authenticating against an LDAP service: operating system libraries (aka Native LDAP) saslauthd (aka LDAP proxy) Weve talked about the LDAP proxy option many times already. In this post, I am going to discuss the Native LDAP approach. Note: for the purposes of the examples, I am [&]

https://www.percona.com/blog/2021/07/08/authenticate-percona-server-for-mongodb-users-via-native-ldap/

A 1st Stab at Correcting Bad Shard Key Selections MongoDB is designed to scale and handle very large data sets. You can scale vertically in your replica sets by adding resources such as CPUs, RAM, and disks. However, many applications today require more resources than can be added to a single server.  The next level [&]

https://www.percona.com/blog/refining-shard-keys-in-mongodb-4-4-and-above/

Calling all MongoDB users and enthusiasts!  MongoDB 5.0 has been out as a release candidate for a short while, and the production release should be coming soon. Take advantage of a unique opportunity to get the scoop on what’s in MongoDB 5.0 at 11 am EDT TODAY! Join The Discussion Join our live stream event [&]

https://www.percona.com/blog/breaking-news-take-a-sneak-peek-into-mongodb-5-0-with-percona/

“It would be nice to have an option, that would allow to suppress the DEFINER statement in the CREATE VIEW statements generated by mysqldump. This would help when transferring data structures between databases with different security models.”  TLDR; Use mysqlpump with option[crayon-60ea140763bfb832115226-i/] instead of [crayon-60ea140763c05786943898-i/]. The Story This was requested as MySQL Bug #24680 on [&]

https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/

In the previous posts of this series, I presented how the Percona Support team approaches the analysis and troubleshooting of a MySQL server using a tried-and-tested method supported by specific tools found in the Percona Toolkit: Inspecting MySQL Servers Part 1: The Percona Support Way Inspecting MySQL Servers Part 2: Knowing the Server Inspecting MySQL [&]

https://www.percona.com/blog/inspecting-mysql-servers-part-5-percona-monitoring-and-management/

This article was written with the main purpose of showing you how to determine zones on a shard when using compound shard keys. Defining Zones in Shards means pre-defining where certain chunks will be stored and amongst which set of particular shards they will be balanced according to the shard key definition. MongoDB 4.4 brings [&]

https://www.percona.com/blog/sharding-with-zones-based-on-compound-shard-keys-on-mongodb-4-4/

Percona Monitoring and Management (PMM2) Server runs as a Docker container, a Virtual appliance, or as an instance on Amazon or Azure cloud services. Here Ill show how to move the PMM Server and its data from one type to another. Note, this is only for PMM2 to PMM2—you cant migrate data from PMM Server [&]

https://www.percona.com/blog/move-percona-monitoring-and-management-server-data-from-one-instance-type-to-another/

The new MyDumper 0.10.7 version, which includes many new features and bug fixes, is now available.  You can download the code from here. For this release, we have added several features like WHERE support that is required for partial backups. We also added CHECKSUM for tables which help to speed up the restore of large [&]

https://www.percona.com/blog/mydumper-0-10-7-is-now-available/

If you love using MongoDB databases, you’ll want to tune in to this live-stream event ‘Percona and Friends React to MongoDB live’ at 11:00 AM EDT on July 15. Watch or listen as industry experts from Percona, Southbank Software, and Qarbine respond to MongoDB’s conference announcements. The team will consider: New features and other announcements [&]

https://www.percona.com/blog/mongodb-5-0-is-coming-in-hot-what-do-database-experts-across-the-community-think/

One of the new features introduced in MySQL 8.0.24 was the ability to log all SQL statements that are issued in the MySQL Shell to the system log. This is a useful feature that can greatly assist in tracking who did what on the system. Usage The simplest way to utilize the new Shell logging [&]

https://www.percona.com/blog/mysql-shell-101-system-log/