# Insight for DBAs

Published articles for Insight for DBAs.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Group Replication Beyond a Single Cluster: DC-DR with Percona (PS MySQL) Operator

DevFeed: [Group Replication Beyond a Single Cluster: DC-DR with Percona (PS MySQL) Operator](<https://devfeed.tech/articles/group-replication-beyond-a-single-cluster-dc-dr-with-percona-ps-mysql-operator-35041.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/group-replication-beyond-a-single-cluster-dc-dr-with-percona-ps-mysql-operator/>)

Author: Anil Joshi

Published: 2026-09-17T06:43:32Z

Content type: tutorial

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Replication](<https://devfeed.tech/topics/replication.md>), [export](<https://devfeed.tech/topics/export.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>), [configuration](<https://devfeed.tech/topics/configuration.md>), [Server](<https://devfeed.tech/topics/server.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [featured](<https://devfeed.tech/tags/featured.md>), [innodb-clusterset](<https://devfeed.tech/tags/innodb-clusterset.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [kubernetes-operators](<https://devfeed.tech/tags/kubernetes-operators.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-group-replication](<https://devfeed.tech/tags/mysql-group-replication.md>), [mysql-high-availability](<https://devfeed.tech/tags/mysql-high-availability.md>), [mysql-replication](<https://devfeed.tech/tags/mysql-replication.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [operator](<https://devfeed.tech/tags/operator.md>), [percona-kubernetes-operators](<https://devfeed.tech/tags/percona-kubernetes-operators.md>), [percona-operator-for-mysql](<https://devfeed.tech/tags/percona-operator-for-mysql.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [percona-software](<https://devfeed.tech/tags/percona-software.md>), [replication](<https://devfeed.tech/tags/replication.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [yaml](<https://devfeed.tech/tags/yaml.md>)

### AI overview

This tutorial explains how to configure cross-site replication between two Percona Operator for MySQL clusters to create a ClusterSet environment for disaster recovery and switchover between data-center and disaster-recovery members. It covers deploying the clusters, retrieving endpoints and cluster names, transferring credentials, and initializing the DR cluster.

### Source excerpt

A while ago, we discussed the cross-site replication feature of the Percona PXC operator. Recently, a similar cross-site replication feature was introduced in the Percona (PS MySQL) operator v1.2.0, a topology based on Group Replication/InnoDB Cluster. In this blog post, we will explore how to add a DR Cluster to an existing DC Cluster to ... Continued The post Group Replication Beyond a Single Cluster: DC-DR with Percona (PS MySQL) Operator appeared first on Percona.

## Percona and HexaCluster: Faster, Safer Oracle Migration

DevFeed: [Percona and HexaCluster: Faster, Safer Oracle Migration](<https://devfeed.tech/articles/percona-and-hexacluster-faster-safer-oracle-migration-26240.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/percona-and-hexacluster-faster-safer-oracle-migration/>)

Author: Percona Team

Published: 2026-09-14T22:19:16Z

Content type: article

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Tooling](<https://devfeed.tech/topics/tooling.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [database-migration](<https://devfeed.tech/tags/database-migration.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [migration](<https://devfeed.tech/tags/migration.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [partners](<https://devfeed.tech/tags/partners.md>), [percona](<https://devfeed.tech/tags/percona.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>), [tooling](<https://devfeed.tech/tags/tooling.md>), [validation](<https://devfeed.tech/tags/validation.md>)

### AI overview

Percona and HexaCluster describe a partnership for moving organizations from Oracle, SQL Server, DB2, and Sybase ASE to supported open source databases, primarily PostgreSQL. HexaCluster provides assessment and migration engineering through DMAT and HexaRocket, while Percona provides distributions, operators, and long-term support. HexaRocket combines schema migration, data migration, validation, change data capture, live replication, and reverse replication in one platform.

### Source excerpt

Percona and HexaCluster have partnered to remove the hardest part of an open source database migration: getting off Oracle, SQL Server, DB2 or Sybase ASE with confidence, on a predictable timeline, without a multi-year consulting program. Percona brings open source expertise, its own distributions, operators and enterprise support. HexaCluster brings the assessment and migration engineering ... Continued The post Percona and HexaCluster: Faster, Safer Oracle Migration appeared first on Percona.

## Enabling TLS in PXC without Downtime

DevFeed: [Enabling TLS in PXC without Downtime](<https://devfeed.tech/articles/enabling-tls-in-pxc-without-downtime-14095.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/enabling-tls-in-pxc-without-downtime/>)

Author: Juan Arruti

Published: 2026-09-09T23:32:15Z

Content type: tutorial

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [TLS (Transport Layer Security)](<https://devfeed.tech/topics/tls.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Security](<https://devfeed.tech/topics/security.md>), [Network](<https://devfeed.tech/topics/network.md>), [openssl](<https://devfeed.tech/topics/openssl.md>)

Tags: [galera](<https://devfeed.tech/tags/galera.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [pxc](<https://devfeed.tech/tags/pxc.md>), [replication](<https://devfeed.tech/tags/replication.md>), [security](<https://devfeed.tech/tags/security.md>), [ssl](<https://devfeed.tech/tags/ssl.md>), [tls](<https://devfeed.tech/tags/tls.md>), [tls-handshake](<https://devfeed.tech/tags/tls-handshake.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

This tutorial explains how to enable TLS for replication traffic in Percona XtraDB Cluster without a full cluster restart. Using Galera's socket.dynamic option, operators can perform two rolling restarts: first allowing encrypted and plaintext connections, then enforcing TLS-only communication.

### Source excerpt

Starting with Percona XtraDB Cluster (PXC) 8.0, replication traffic encryption is enabled by default. That said, it's common to find clusters running without TLS that suddenly need it: a new compliance requirement, an audit finding, a network segment that is no longer considered trusted. PXC has a variable for exactly that case, pxc-encrypt-cluster-traffic, which handles ... Continued The post Enabling TLS in PXC without Downtime appeared first on Percona.

## Rotating Expiring X.509 Certificates in Percona Server for MongoDB with Minimal Service Interruption

DevFeed: [Rotating Expiring X.509 Certificates in Percona Server for MongoDB with Minimal Service Interruption](<https://devfeed.tech/articles/rotating-expiring-x-509-certificates-in-percona-server-for-mongodb-with-minimal-service-interruption-14114.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/rotating-expiring-x-509-certificates-in-percona-server-for-mongodb-with-minimal-service-interruption/>)

Author: Ivan Groenewold

Published: 2026-08-31T11:48:11Z

Content type: tutorial

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [TLS (Transport Layer Security)](<https://devfeed.tech/topics/tls.md>), [Authentication](<https://devfeed.tech/topics/authentication.md>), [configuration](<https://devfeed.tech/topics/configuration.md>)

Tags: [authentication](<https://devfeed.tech/tags/authentication.md>), [certificates](<https://devfeed.tech/tags/certificates.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [private-key](<https://devfeed.tech/tags/private-key.md>), [rotation](<https://devfeed.tech/tags/rotation.md>), [security](<https://devfeed.tech/tags/security.md>), [tls](<https://devfeed.tech/tags/tls.md>), [x509](<https://devfeed.tech/tags/x509.md>)

### AI overview

This tutorial explains how to renew same-CA X.509 certificates in Percona Server for MongoDB with minimal service interruption. It covers reloading TLS material with rotateCertificates, certificate and private-key configuration, limitations, validation, and cases where hot reload should not be used.

### Source excerpt

Expired TLS certificates can prevent new client connections and, when X.509 is used for Percona Server for MongoDB internal authentication, also prevent members of a replica set or sharded cluster from authenticating to one another. In this post we will discuss performing a same-CA renewal: replacement certificates for server, member, and client leaf are issued ... Continued The post Rotating Expiring X.509 Certificates in Percona Server for MongoDB with Minimal Service Interruption appeared first on Percona.

## Navigating the Walled Gardens of PostgreSQL: Hidden Risks of Postgres Vendor Lock-in

DevFeed: [Navigating the Walled Gardens of PostgreSQL: Hidden Risks of Postgres Vendor Lock-in](<https://devfeed.tech/articles/navigating-the-walled-gardens-of-postgresql-hidden-risks-of-postgres-vendor-lock-in-14100.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/migrating-postgres-solving-a-puzzle-that-shouldnt-be-hard/>)

Author: Robert Bernier

Published: 2026-08-26T14:07:50Z

Content type: opinion

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [vendor lock-in](<https://devfeed.tech/topics/vendor-lock-in.md>), [Database Migration](<https://devfeed.tech/topics/database-migration.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [database-migration](<https://devfeed.tech/tags/database-migration.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [insight-for-developers](<https://devfeed.tech/tags/insight-for-developers.md>), [migration](<https://devfeed.tech/tags/migration.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [vendor-lock-in](<https://devfeed.tech/tags/vendor-lock-in.md>)

### AI overview

The article examines how commercial ecosystems built around PostgreSQL can create walled-garden effects and constrain the portability of PostgreSQL-compatible systems. It highlights migration complexity, switching costs, and potential data-integrity risks when leaving such ecosystems.

### Source excerpt

These days there's been a lot of talk about Postgres having an impact on "everything". Whether it's replacing legacy systems, creating a new greenfield project or even implementing it as a back-end to an agentic AI, Postgres is today's poster child for innovation. So performing something as dull and straightforward as a database migration should ... Continued The post Navigating the Walled Gardens of PostgreSQL: Hidden Risks of Postgres Vendor Lock-in appeared first on Percona.

## Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit

DevFeed: [Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit](<https://devfeed.tech/articles/replication-lag-on-aws-fsx-the-hidden-ec2-single-flow-bandwidth-limit-14112.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/replication-lag-on-aws-fsx-the-hidden-ec2-single-flow-bandwidth-limit/>)

Author: Pablo Svampa

Published: 2026-08-25T21:00:16Z

Content type: article

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Amazon EC2](<https://devfeed.tech/topics/amazon-ec2.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [cloud-infrastructure](<https://devfeed.tech/topics/cloud-infrastructure.md>), [Network](<https://devfeed.tech/topics/network.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>)

Tags: [aws](<https://devfeed.tech/tags/aws.md>), [database](<https://devfeed.tech/tags/database.md>), [ec2](<https://devfeed.tech/tags/ec2.md>), [hardware-and-storage](<https://devfeed.tech/tags/hardware-and-storage.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [network](<https://devfeed.tech/tags/network.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [replication](<https://devfeed.tech/tags/replication.md>), [storage](<https://devfeed.tech/tags/storage.md>)

### AI overview

This Percona case study examines PostgreSQL replication lag on an EC2 instance using Amazon FSx over NFS. Although AWS reported healthy storage with substantial provisioned capacity remaining, vmstat showed persistent I/O blocking and wait, indicating a bottleneck somewhere across the storage and network path, including an EC2 single-flow bandwidth limit.

### Source excerpt

A recent case in our Percona Support team started with a familiar complaint. A PostgreSQL standby lagging behind its primary. Although the problem was simple, it brought a specific flavor that's worth sharing. The customer had already reached out to AWS Support about the storage layer behind the database, an Amazon FSx filesystem mounted over ... Continued The post Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit appeared first on Percona.