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.0 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
Replication Implementation
Replication Formats
Advantages and Disadvantages of Statement-Based and Row-Based Replication
Usage of Row-Based Logging and Replication
Determination of Safe and Unsafe Statements in Binary Logging
Replication Channels
Commands for Operations on a Single Channel
Compatibility with Previous Replication Statements
Startup Options and Replication Channels
Replication Channel Naming Conventions
Replication Threads
Monitoring Replication Main Threads
Monitoring Replication Applier Worker Threads
Relay Log and Replication Metadata Repositories
The Relay Log
Replication Metadata Repositories
How Servers Evaluate Replication Filtering Rules
Evaluation of Database-Level Replication and Binary Logging Options
Evaluation of Table-Level Replication Options
Interactions Between Replication Filtering Options
Replication Channel Based Filters
Replication Security
Setting Up Replication to Use Encrypted Connections
Encrypting Binary Log Files and Relay Log Files
Scope of Binary Log Encryption
Binary Log Encryption Keys
Binary Log Master Key Rotation
Replication Privilege Checks
Privileges For The Replication PRIVILEGE_CHECKS_USER Account
Privilege Checks For Group Replication Channels
Recovering From Failed Replication Privilege Checks
Replication Solutions
Using Replication for Backups
Backing Up a Replica Using mysqldump
Backing Up Raw Data from a Replica
Backing Up a Source or Replica by Making It Read Only
Handling an Unexpected Halt of a Replica
Monitoring Row-based Replication
Using Replication with Different Source and Replica Storage Engines
Using Replication for Scale-Out
Replicating Different Databases to Different Replicas
Improving Replication Performance
Switching Sources During Failover
Switching Sources and Replicas with Asynchronous Connection Failover
Asynchronous Connection Failover for Sources
Asynchronous Connection Failover for Replicas
Semisynchronous Replication
Installing Semisynchronous Replication
Configuring Semisynchronous Replication
Semisynchronous Replication Monitoring
Delayed Replication
Replication Notes and Tips
Replication Features and Issues
Replication and AUTO_INCREMENT
Replication and BLACKHOLE Tables
Replication and Character Sets
Replication and CHECKSUM TABLE
Replication of CREATE SERVER, ALTER SERVER, and DROP SERVER
Replication of CREATE ... IF NOT EXISTS Statements
Replication of CREATE TABLE ... SELECT Statements
Replication of CURRENT_USER()
Replication with Differing Table Definitions on Source and Replica
Replication and DIRECTORY Table Options
Replication of DROP ... IF EXISTS Statements
Replication and Floating-Point Values
Replication and FLUSH
Replication and System Functions
Replication and Fractional Seconds Support
Replication of Invoked Features
Replication of JSON Documents
Replication and JavaScript Stored Programs
Replication and LIMIT
Replication and LOAD DATA
Replication and max_allowed_packet
Replication and MEMORY Tables
Replication of the mysql System Schema
Replication and the Query Optimizer
Replication and Partitioning
Replication and REPAIR TABLE
Replication and Reserved Words
Replication and Row Searches
Replication and Source or Replica Shutdowns
Replica Errors During Replication
Replication and Server SQL Mode
Replication and Temporary Tables
Replication Retries and Timeouts
Replication and Time Zones
Replication and Transaction Inconsistencies
Replication and Transactions
Replication and Triggers
Replication and TRUNCATE TABLE
Replication and User Name Length