> Markdown version of https://www.artie.com/learn/topic/change-data-capture-replication. Site index for AI agents: https://www.artie.com/llms.txt # The Data Almanac Learn about change data capture, replication, and modern data systems. Search the Data Almanac Article type ## Change Data Capture & Replication 28 articles * [Explainer Change Data Capture in SQL Server: Setup, Limits, Streaming Enable change data capture in SQL Server, read changes by LSN, plan for 3-day retention and log growth, and stream CDC into a warehouse.](https://www.artie.com/learn/sql-server-change-data-capture) * [Explainer Real-Time Data Streaming Architecture: Components, Patterns and Examples Learn how a real-time data streaming architecture works: the layers of a streaming data pipeline, CDC patterns, Lambda vs. Kappa, and worked examples.](https://www.artie.com/blogs/real-time-data-streaming-architecture) * [How-to How to Stream Data from Postgres to BigQuery in Real Time Replace hourly batch loads with CDC: the Postgres setup, how changes merge into BigQuery, the failure modes that break pipelines, and how to validate the data.](https://www.artie.com/learn/postgres-to-bigquery) * [Explainer Data Stream Processing: How It Works, Use Cases & Key Benefits How data stream processing works, where stateful event-time computation earns its cost, and when fresh warehouse tables are the simpler choice.](https://www.artie.com/learn/data-stream-processing) * [Explainer Real-Time Data Ingestion: Architecture, Methods & How It Works Learn how real-time data ingestion works, when CDC is the right approach, and the operational challenges of running a pipeline at scale.](https://www.artie.com/learn/real-time-data-ingestion) * [Roundup 7 Best Tools for Snowflake Replication in Real Time in 2026 Compare seven real-time Snowflake replication tools and evaluate CDC latency, schema evolution, source impact, and operational ownership.](https://www.artie.com/learn/best-tools-for-snowflake-replication-in-real-time) * [Explainer PostgreSQL 17 Logical Failover Slots: How CDC Survives a Primary Promotion A bullet-point guide to PostgreSQL 17 logical failover slots, the required configuration, and a tested CDC failover drill.](https://www.artie.com/blogs/postgresql-17-logical-failover-slots-cdc) * [Explainer How Real-Time Data Synchronization Works and Why It Matters in 2026 How real-time data synchronization uses CDC to keep warehouses current with production databases in under a minute.](https://www.artie.com/learn/real-time-data-synchronization) * [Explainer Database Backfill Without Downtime: How Online Backfills Work How online CDC backfills keep destination tables fully usable during a resync, using dual-write staging and atomic table swaps.](https://www.artie.com/blogs/online-database-backfill) * [Explainer ClickHouse Integration: A Practical Guide for Data Teams in 2026 Learn how to integrate ClickHouse Cloud with Postgres, MySQL, and more using CDC. Covers table engines, batching, and real-time pipeline setup.](https://www.artie.com/blogs/clickhouse-integration-guide) * [How-to AI Data Integration: How to Build Real-Time Pipelines for AI Systems Real-time AI data integration: how CDC-based pipelines eliminate stale data in AI agents, RAG systems, and fraud detection models.](https://www.artie.com/blogs/ai-data-integration) * [Explainer Stream DynamoDB to Redshift with CDC Learn how to stream DynamoDB to Redshift with CDC for real-time analytics, faster reporting, and scalable pipelines for all teams.](https://www.artie.com/blogs/stream-dynamodb-to-redshift-with-cdc) * [Explainer MySQL to Redshift Replication: Zero-ETL, DMS, or CDC Compare 4 ways to get MySQL into Redshift: AWS zero-ETL, DMS, S3 export + COPY, and binlog CDC. When zero-ETL is enough, its limits, and setup steps.](https://www.artie.com/learn/replicate-mysql-to-redshift) * [Explainer PostgreSQL to Snowflake Replication Stream PostgreSQL to Snowflake in real time with CDC, schema evolution, and low-latency replication using Artie.](https://www.artie.com/blogs/postgresql-snowflake-replication) * [How-to MySQL Replication Best Practices: Security, Performance, and Safe Failover Learn MySQL replication best practices for security, performance, schema changes, lag reduction, and safe GTID-based failover.](https://www.artie.com/blogs/mysql-replication-best-practices) * [Explainer PostgreSQL Replication Slots: Create, Monitor, and Drop Learn how to create, monitor, and drop PostgreSQL replication slots. Includes SQL examples for checking WAL size, replica identity, and slot troubleshooting.](https://www.artie.com/blogs/postgresql-replication-slots) * [Explainer Unbounded WAL Growth in Idle AWS RDS Logical Replication Unbounded WAL growth on idle AWS RDS: why logical replication slots fill storage and how to prevent it.](https://www.artie.com/blogs/unbounded-wal-growth-in-idle-aws-rds-logical-replication) * [How-to How to Build Audit Logs Using CDC and SCD Type 2 Build audit logs with CDC and SCD Type 2. Learn a step-by-step approach to track every change with full history.](https://www.artie.com/blogs/how-to-build-audit-logs-using-cdc-and-scd-type-2) * [How-to Postgres Replication Slot 101: How to Capture CDC Without Breaking Production Learn how to use Postgres replication slots for CDC safely without risking storage issues or production failures.](https://www.artie.com/blogs/postgres-replication-slot-101-how-to-capture-cdc-without-breaking-production) * [How-to Why TOAST Columns Break Postgres CDC and How to Fix It TOAST columns can break Postgres CDC. Learn why jsonb turns NULL and how to fix it without bloating WAL.](https://www.artie.com/blogs/why-toast-columns-break-postgres-cdc-and-how-to-fix-it) * [Explainer Postgres CTID Scanning for Faster Backfills Postgres CTID scanning enables 10x faster backfills for large tables. Learn how CTID works and boosts performance.](https://www.artie.com/blogs/postgres-ctid-scanning) * [Explainer Postgres Write-Ahead Logs Postgres write-ahead logs explained: how WAL works, key settings, and best practices for logical replication.](https://www.artie.com/blogs/postgres-write-ahead-logs) * [How-to MySQL Cascading Changes and Best Practices Learn MySQL cascading changes and best practices to maintain referential integrity across related tables.](https://www.artie.com/blogs/mysql-cascading-changes-and-why-you-shouldnt-use-them) * [Explainer Postgres Table Replica Identity Understand Postgres table replica identity, how it impacts logical replication, and why it matters for CDC.](https://www.artie.com/blogs/postgres-table-replica-identity) * [Explainer History Table Learn how History Tables capture every CDC change with timestamps and operation types for full audit and replay.](https://www.artie.com/blogs/history-table) * [Explainer Introduction to Database Replication Introduction to database replication: ensure data accuracy, low latency, redundancy, and reliable access.](https://www.artie.com/blogs/introduction-to-database-replication) * [Explainer Prevent WAL Growth on AWS Postgres RDS Prevent WAL growth on AWS Postgres RDS. Learn how to avoid replication slot overflow and storage issues.](https://www.artie.com/blogs/preventing-wal-growth-on-postgres-db-running-on-aws-rds) * [Explainer Why ELTs Are Here to Stay Why ELTs are here to stay: how modern data stacks shift transformations into the warehouse for flexibility.](https://www.artie.com/blogs/why-elts-are-here-to-stay) ## Watch your data replicate live [Start for free](https://app.artie.com/signup) [Book a demo](https://www.artie.com/contact)