Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 9.7 Reference Manual
Preface and Legal Notices
General Information
Installing MySQL
Upgrading MySQL
Downgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Functions and Operators
SQL Statements
MySQL Data Dictionary
The InnoDB Storage Engine
Alternative Storage Engines
Replication
Configuring Replication
Binary Log File Position Based Replication Configuration Overview
Setting Up Binary Log File Position Based Replication
Setting the Replication Source Configuration
Setting the Replica Configuration
Creating a User for Replication
Obtaining the Replication Source Binary Log Coordinates
Choosing a Method for Data Snapshots
Setting Up Replicas
Setting the Source Configuration on the Replica
Adding Replicas to a Replication Environment
Replication with Global Transaction Identifiers
GTID Format and Storage
GTID Life Cycle
GTID Auto-Positioning
Setting Up Replication Using GTIDs
Using GTIDs for Failover and Scaleout
Replication From a Source Without GTIDs to a Replica With GTIDs
Restrictions on Replication with GTIDs
Stored Function Examples to Manipulate GTIDs
Changing GTID Mode on Online Servers
Replication Mode Concepts
Enabling GTID Transactions Online
Disabling GTID Transactions Online
Verifying Replication of Anonymous Transactions
MySQL Multi-Source Replication
Configuring Multi-Source Replication
Provisioning a Multi-Source Replica for GTID-Based Replication
Adding GTID-Based Sources to a Multi-Source Replica
Adding Binary Log Based Replication Sources to a Multi-Source Replica
Starting Multi-Source Replicas
Stopping Multi-Source Replicas
Resetting Multi-Source Replicas
Monitoring Multi-Source Replication
Replication and Binary Logging Options and Variables
Replication and Binary Logging Option and Variable Reference
Replication Source Options and Variables
Replica Server Options and Variables
Binary Logging Options and Variables
Global Transaction ID System Variables
Common Replication Administration Tasks
Checking Replication Status
Pausing Replication on the Replica
Skipping Transactions