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.5 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
High Availability and Scalability
Replication
Replication Configuration
How to Set Up Replication
Setting the Replication Master Configuration
Setting the Replication Slave Configuration
Creating a User for Replication
Obtaining the Replication Master Binary Log Coordinates
Creating a Data Snapshot Using mysqldump
Creating a Data Snapshot Using Raw Data Files
Setting Up Replication with New Master and Slaves
Setting Up Replication with Existing Data
Introducing Additional Slaves to an Existing Replication Environment
Setting the Master Configuration on the Slave
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 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 Log Options and Variables
Common Replication Administration Tasks
Checking Replication Status
Pausing Replication on the Slave
Replication Implementation
Replication Implementation Details
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
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
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 Master and Slave
Replication and DIRECTORY Table Options
Replication of DROP ... IF EXISTS Statements
Replication and Floating-Point Values
Replication and FLUSH
Replication and System Functions
Replication of Invoked Features
Replication and LIMIT
Replication and LOAD DATA INFILE
Replication and the Slow Query Log
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
SET PASSWORD and Row-Based Replication
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 TIMESTAMP
Replication and Time Zones
Replication and Transactions
Replication and Triggers
Replication and TRUNCATE TABLE
Replication and Variables
Replication and Views
Replication Compatibility Between MySQL Versions
Upgrading a Replication Setup
Troubleshooting Replication
How to Report Replication Bugs or Problems
MySQL NDB Cluster 7.2
Partitioning
Stored Programs and Views
INFORMATION_SCHEMA Tables
MySQL Performance Schema
Connectors and APIs
Extending MySQL
MySQL Enterprise Edition
MySQL Workbench
MySQL 5.5 Frequently Asked Questions
Errors, Error Codes, and Common Problems
Restrictions and Limits
Indexes
MySQL Glossary
Related Documentation
MySQL 5.5 Release Notes
Download this Manual
PDF (US Ltr)
- 27.2Mb
PDF (A4)
- 27.2Mb
PDF (RPM)
- 25.8Mb
HTML Download (TGZ)
- 6.5Mb
HTML Download (Zip)
- 6.6Mb
HTML Download (RPM)
- 5.6Mb
Man Pages (TGZ)
- 158.5Kb
Man Pages (Zip)
- 262.0Kb
Info (Gzip)
- 2.6Mb
Info (Zip)
- 2.6Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL NDB Cluster 7.2
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
version 5.5
8.0 current
5.7
5.6
5.6 Japanese
MySQL 5.5 Reference Manual
/
Replication
/ Replication Notes and Tips
17.4 Replication Notes and Tips
[
+/-
]
17.4.1 Replication Features and Issues
17.4.2 Replication Compatibility Between MySQL Versions
17.4.3 Upgrading a Replication Setup
17.4.4 Troubleshooting Replication
17.4.5 How to Report Replication Bugs or Problems
PREV
HOME
UP
NEXT
Related Documentation
MySQL 5.5 Release Notes
Download this Manual
PDF (US Ltr)
- 27.2Mb
PDF (A4)
- 27.2Mb
PDF (RPM)
- 25.8Mb
HTML Download (TGZ)
- 6.5Mb
HTML Download (Zip)
- 6.6Mb
HTML Download (RPM)
- 5.6Mb
Man Pages (TGZ)
- 158.5Kb
Man Pages (Zip)
- 262.0Kb
Info (Gzip)
- 2.6Mb
Info (Zip)
- 2.6Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL NDB Cluster 7.2
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
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.