# Replication - [Replication Overview](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-overview.md): Explore the core concepts of MariaDB standard replication. Learn about the primary-replica architecture, data redundancy strategies, and how to scale read operations effectively. - [Choosing a Replication Strategy](https://mariadb.com/docs/server/ha-and-performance/standard-replication/choosing-a-replication-strategy.md) - [Replication Statements](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-statements.md): Access the complete reference of SQL statements used to manage replication. This guide covers commands for controlling primaries, configuring replicas, and monitoring status. - [Setting Up Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/setting-up-replication.md): Complete guide to MariaDB replication setup. Complete walkthrough for primary-replica topology with binary logging and GTID configuration. - [Global Transaction ID](https://mariadb.com/docs/server/ha-and-performance/standard-replication/gtid.md): Complete GTID replication reference: CHANGE MASTER master\_use\_gtid=current\_pos|slave\_pos, gtid\_slave\_pos table (InnoDB), START REPLICA UNTIL master\_gtid\_pos. - [Read-Only Replicas](https://mariadb.com/docs/server/ha-and-performance/standard-replication/read-only-replicas.md): Learn how to configure replicas as read-only instances. This ensures data integrity by preventing accidental writes on the replica while allowing it to process replication events. - [Multi-Source Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/multi-source-replication.md): Discover how to replicate data from multiple primaries to a single replica. This guide covers the configuration for aggregating data from different sources into one MariaDB instance. - [Multi-Master Ring Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/multi-master-ring-replication.md): Explore the ring topology where each server acts as both primary and replica. Learn the configuration steps and caveats for setting up a circular replication environment. - [Delayed Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/delayed-replication.md): Learn to configure a time lag for your replica. Delayed replication helps recover from human errors on the primary, such as accidental drop commands, by preserving older states. - [Parallel Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/parallel-replication.md): Boost MariaDB Server replication performance with parallel replication. This section explains how to configure replicas to apply events concurrently, reducing lag and improving throughput. - [Semisynchronous Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/semisynchronous-replication.md): Enhance data consistency with semisynchronous replication. Ensure that the primary waits for at least one replica to acknowledge receipt of a transaction before committing. - [Row-based Replication With No Primary Key](https://mariadb.com/docs/server/ha-and-performance/standard-replication/row-based-replication-with-no-primary-key.md): Understand the performance implications and best practices for replicating tables without primary keys when using row-based logging, including how to avoid full table scans. - [Unsafe Statements for Statement-Based Replication](https://mariadb.com/docs/server/ha-and-performance/standard-replication/unsafe-statements-for-statement-based-replication.md): Identify SQL statements that are non-deterministic and unsafe for statement-based replication. Learn why these queries cause divergence and how to switch to row-based logging. - [Replication Filters](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-filters.md): Learn how to filter specific databases or tables from being replicated. This guide covers configuration options to replicate only the data you need on specific replicas. - [Replication Threads](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-threads.md): Gain insight into the background threads that drive replication. Understand the roles of the I/O thread, SQL thread, and binlog dump thread in moving data between servers. - [Replication and Foreign Keys](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-foreign-keys.md): Understand how foreign key constraints interact with replication. Learn best practices for managing cascading deletes and updates across primary and replica servers. - [Replication and Binary Log System Variables](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md): Complete Replication and Binary Log System Variables reference for MariaDB. Complete guide for configuration values, scope settings, and performance impact. - [Replication and Binary Log Status Variables](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-status-variables.md): View the status variables used to monitor replication health. Learn how to interpret metrics regarding log positions, connection status, and event counts. - [Binlog Event Checksum Interoperability](https://mariadb.com/docs/server/ha-and-performance/standard-replication/binlog-event-checksum-interoperability.md): Learn about checksum compatibility between different MariaDB versions. Ensure older replicas can correctly verify binary log events generated by newer primaries. - [Binlog Event Checksums](https://mariadb.com/docs/server/ha-and-performance/standard-replication/binlog-event-checksums.md): Configure checksums to detect data corruption in binary logs. Learn how to enable verification to ensure the integrity of replication events during transmission and storage. - [Changing a Replica to Become the Primary](https://mariadb.com/docs/server/ha-and-performance/standard-replication/changing-a-replica-to-become-the-primary.md): Follow the procedure to promote a replica to a primary role. This guide details the steps for planned failovers or topology reorganization with minimal downtime. - [Replication When the Primary and Replica Have Different Table Definitions](https://mariadb.com/docs/server/ha-and-performance/standard-replication/replication-when-the-primary-and-replica-have-different-table-definitions.md): Understand the rules and limitations when replicating between tables with differing structures. Learn how attribute promotion and column handling work in row-based replication. - [START TRANSACTION ... WITH CONSISTENT SNAPSHOT](https://mariadb.com/docs/server/ha-and-performance/standard-replication/enhancements-for-start-transaction-with-consistent-snapshot.md): Learn how to start a consistent transaction for backups or replication setup. This command ensures a consistent view of the database without locking tables unnecessarily. - [Restricting Speed of Reading Binlog from Primary by a Replica](https://mariadb.com/docs/server/ha-and-performance/standard-replication/restricting-speed-of-reading-binlog-from-primary-by-a-replica.md): Configure throughput limits for replication traffic. Learn to throttle the binlog download speed to prevent replication from consuming all available network bandwidth. - [Running Triggers on the Replica for Row-based Events](https://mariadb.com/docs/server/ha-and-performance/standard-replication/running-triggers-on-the-replica-for-row-based-events.md): Understand how triggers behave under row-based replication. Learn when and why triggers are not executed on the replica and how to manage complex logic in this mode. - [Obsolete Replication Information](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information.md): Access documentation for deprecated or removed replication features. Review this historical context when upgrading legacy systems or migrating to newer MariaDB versions. - [LOAD DATA FROM MASTER (removed)](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/load-data-from-master-removed.md) - [LOAD TABLE FROM MASTER (removed)](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/load-table-from-master-removed.md) - [MariaDB 5.2 Replication Feature Preview](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/mariadb-52-replication-feature-preview.md) - [XtraDB option --innodb-release-locks-early](https://mariadb.com/docs/server/ha-and-performance/standard-replication/obsolete-replication-information/xtradb-option-innodb-release-locks-early.md) --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mariadb.com/docs/server/ha-and-performance/standard-replication.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.