Contact MySQL
|
Login
|
Register
The world's most popular open source database
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 5.7 Reference Manual
Preface and Legal Notices
General Information
Installing and Upgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Functions and Operators
SQL Statement Syntax
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 Master Configuration
Creating a User for Replication
Obtaining the Replication Master Binary Log Coordinates
Choosing a Method for Data Snapshots
Setting Up Replication Slaves
Adding Slaves 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
Restrictions on Replication with GTIDs
Stored Function Examples to Manipulate GTIDs
MySQL Multi-Source Replication
MySQL Multi-Source Replication Overview
Multi-Source Replication Tutorials
Multi-Source Replication Monitoring
Multi-Source Replication Error Messages
Changing Replication Modes on Online Servers
Replication Mode Concepts
Enabling GTID Transactions Online
Disabling GTID Transactions Online
Verifying Replication of Anonymous Transactions
Replication and Binary Logging Options and Variables
Replication and Binary Logging Option and Variable Reference
Replication Master Options and Variables
Replication Slave Options and Variables
Binary Logging Options and Variables
Global Transaction ID Options and Variables
Common Replication Administration Tasks
Checking Replication Status
Pausing Replication on the Slave
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 Implementation Details
Replication Channels
Commands for Operations on a Single Channel
Compatibility with Previous Replication Statements
Startup Options and Replication Channels
Replication Channel Naming Conventions
Replication Relay and Status Logs
The Slave Relay Log
Slave Status Logs
How Servers Evaluate Replication Filtering Rules
Evaluation of Database-Level Replication and Binary Logging Options
Evaluation of Table-Level Replication Options
Replication Rule Application
Replication Solutions
Using Replication for Backups
Backing Up a Slave Using mysqldump
Backing Up Raw Data from a Slave
Backing Up a Master or Slave by Making It Read Only
Handling an Unexpected Halt of a Replication Slave
Using Replication with Different Master and Slave Storage Engines
Using Replication for Scale-Out
Replicating Different Databases to Different Slaves
Improving Replication Performance
Switching Masters During Failover
Setting Up Replication to Use Encrypted Connections
Semisynchronous Replication
Semisynchronous Replication Administrative Interface
Semisynchronous Replication Installation and Configuration
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 ... IF NOT EXISTS Statements
Replication of CREATE TABLE ... SELECT Statements
Replication of CREATE SERVER, ALTER SERVER, and DROP SERVER
Replication of CURRENT_USER()
Replication of DROP ... IF EXISTS Statements
Replication with Differing Table Definitions on Master and Slave
Replication and DIRECTORY Table Options
Replication and Floating-Point Values
Replication and Fractional Seconds Support
Replication and FLUSH
Replication and System Functions
Replication of Invoked Features
Replication and LIMIT
Replication and LOAD DATA
Replication and max_allowed_packet
Replication and MEMORY Tables
Replication of the mysql System Database
Replication and the Query Optimizer
Replication and Partitioning
Replication and REPAIR TABLE
Replication and Reserved Words
Replication of Server-Side Help Tables
Replication and Master or Slave Shutdowns
Slave 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
Replication and Variables
Replication and Views
Replication Compatibility Between MySQL Versions
Upgrading a Replication Setup
Troubleshooting Replication
How to Report Replication Bugs or Problems
Group Replication
MySQL Shell
Using MySQL as a Document Store
InnoDB Cluster
MySQL NDB Cluster 7.5 and NDB Cluster 7.6
Partitioning
Stored Programs and Views
INFORMATION_SCHEMA Tables
MySQL Performance Schema
MySQL sys Schema
Connectors and APIs
Extending MySQL
MySQL Enterprise Edition
MySQL Workbench
MySQL 5.7 Frequently Asked Questions
Errors, Error Codes, and Common Problems
Restrictions and Limits
Indexes
MySQL Glossary
Related Documentation
MySQL 5.7 Release Notes
Download this Manual
PDF (US Ltr)
- 39.4Mb
PDF (A4)
- 39.4Mb
PDF (RPM)
- 38.8Mb
HTML Download (TGZ)
- 11.1Mb
HTML Download (Zip)
- 11.1Mb
HTML Download (RPM)
- 9.8Mb
Man Pages (TGZ)
- 214.2Kb
Man Pages (Zip)
- 323.4Kb
Info (Gzip)
- 3.6Mb
Info (Zip)
- 3.6Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL NDB Cluster 7.5
MySQL Secure Deployment Guide
version 5.7
8.0 current
5.6
5.5
5.6 Japanese
MySQL 5.7 Reference Manual
/
Replication
/ Replication Notes and Tips
16.4 Replication Notes and Tips
[
+/-
]
16.4.1 Replication Features and Issues
16.4.2 Replication Compatibility Between MySQL Versions
16.4.3 Upgrading a Replication Setup
16.4.4 Troubleshooting Replication
16.4.5 How to Report Replication Bugs or Problems
PREV
HOME
UP
NEXT
Related Documentation
MySQL 5.7 Release Notes
Download this Manual
PDF (US Ltr)
- 39.4Mb
PDF (A4)
- 39.4Mb
PDF (RPM)
- 38.8Mb
HTML Download (TGZ)
- 11.1Mb
HTML Download (Zip)
- 11.1Mb
HTML Download (RPM)
- 9.8Mb
Man Pages (TGZ)
- 214.2Kb
Man Pages (Zip)
- 323.4Kb
Info (Gzip)
- 3.6Mb
Info (Zip)
- 3.6Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL NDB Cluster 7.5
MySQL Secure Deployment Guide
User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up
Login
You must be logged in to post a comment.