# Deployment & Scaling

Published articles for Deployment & Scaling.

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

## Advanced Partitioning Strategies for PostgreSQL OLTP and Analytics Datasets at Scale

DevFeed: [Advanced Partitioning Strategies for PostgreSQL OLTP and Analytics Datasets at Scale](<https://devfeed.tech/articles/advanced-partitioning-strategies-for-postgresql-oltp-and-analytics-datasets-at-scale-19107.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/advanced-partitioning-strategies-for-postgresql-oltp-and-analytics-datasets-at-scale/>)

Author: Sucahyo Ardy Prasetiyo

Published: 2026-06-04T09:15:00Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [Database](<https://devfeed.tech/topics/database.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [Optimization](<https://devfeed.tech/topics/optimization.md>)

Tags: [datasets](<https://devfeed.tech/tags/datasets.md>), [declarative](<https://devfeed.tech/tags/declarative.md>), [deployment-scaling](<https://devfeed.tech/tags/deployment-scaling.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [partitioning](<https://devfeed.tech/tags/partitioning.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [range](<https://devfeed.tech/tags/range.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [scale](<https://devfeed.tech/tags/scale.md>)

### AI overview

This practical article explains how PostgreSQL partitioning helps manage very large OLTP and analytics datasets. It covers range, list, and hash partitioning, declarative partitioning, partition pruning, maintenance, retention, vacuuming, and operational scalability, while noting that partitioning does not compensate for poor queries or missing indexes.

### Source excerpt

When PostgreSQL tables are still relatively small, most tasks seem straightforward. You can run queries without thinking too much about indexes, retention jobs are manageable, and even vacuum operations usually stay under control. But things change pretty quickly once tables start growing into hundreds of millions or billions of rows. At that scale, even simple [...] The post Advanced Partitioning Strategies for PostgreSQL OLTP and Analytics Datasets at Scale appeared first on Severalnines.

## Active-Active MySQL Group Replication Best Practices

DevFeed: [Active-Active MySQL Group Replication Best Practices](<https://devfeed.tech/articles/active-active-mysql-group-replication-best-practices-19106.md>)

Original publisher: [Read original article](<https://severalnines.com/blog/active-active-mysql-group-replication-best-practices/>)

Author: Paul Namuag

Published: 2026-03-11T12:54:52Z

Content type: tutorial

Language: en

Sources: [SeveralNines](<https://devfeed.tech/sources/severalnines.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [Availability](<https://devfeed.tech/topics/availability.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>)

Tags: [availability](<https://devfeed.tech/tags/availability.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [consensus](<https://devfeed.tech/tags/consensus.md>), [consistency](<https://devfeed.tech/tags/consistency.md>), [deployment-scaling](<https://devfeed.tech/tags/deployment-scaling.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [mgr](<https://devfeed.tech/tags/mgr.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-group-replication](<https://devfeed.tech/tags/mysql-group-replication.md>), [replication](<https://devfeed.tech/tags/replication.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

This article explains active-active MySQL Group Replication, where multiple primary members accept concurrent writes that are synchronously replicated and coordinated through consensus and write-set certification. It discusses scalability limits, transaction conflicts, rollback surges, and operational considerations for production deployments.

### Source excerpt

In MySQL Group Replication (MGR) or Group Replication, an active-active configuration allows multiple group members to accept concurrent write transactions. These writes are coordinated through a consensus-based group communication system (GCS) and validated via write-set certification to preserve global transactional consistency as defined by the Group Replication protocol. active-active mode is designed for write scalability. [...] The post Active-Active MySQL Group Replication Best Practices appeared first on Severalnines.