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 Replication
Preface and Legal Notices
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 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 with More Columns on Master or Slave
Replication of Columns Having Different Data Types
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
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
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
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
Related Documentation
MySQL 5.5 Reference Manual
MySQL 5.5 Release Notes
Download this Excerpt
PDF (US Ltr)
- 0.9Mb
PDF (A4)
- 0.9Mb
HTML Download (TGZ)
- 278.3Kb
HTML Download (Zip)
- 293.1Kb
version 5.5
8.0 current
5.7
5.6
MySQL Replication
/ Replication Notes and Tips
Chapter 4 Replication Notes and Tips
Table of Contents
[
+/-
]
4.1 Replication Features and Issues
[
+/-
]
4.1.1 Replication and AUTO_INCREMENT
4.1.2 Replication and BLACKHOLE Tables
4.1.3 Replication and Character Sets
4.1.4 Replication and CHECKSUM TABLE
4.1.5 Replication of CREATE SERVER, ALTER SERVER, and DROP SERVER
4.1.6 Replication of CREATE ... IF NOT EXISTS Statements
4.1.7 Replication of CREATE TABLE ... SELECT Statements
4.1.8 Replication of CURRENT_USER()
4.1.9 Replication with Differing Table Definitions on Master and Slave
4.1.10 Replication and DIRECTORY Table Options
4.1.11 Replication of DROP ... IF EXISTS Statements
4.1.12 Replication and Floating-Point Values
4.1.13 Replication and FLUSH
4.1.14 Replication and System Functions
4.1.15 Replication of Invoked Features
4.1.16 Replication and LIMIT
4.1.17 Replication and LOAD DATA
4.1.18 Replication and the Slow Query Log
4.1.19 Replication and max_allowed_packet
4.1.20 Replication and MEMORY Tables
4.1.21 Replication of the mysql System Database
4.1.22 Replication and the Query Optimizer
4.1.23 Replication and Partitioning
4.1.24 Replication and REPAIR TABLE
4.1.25 Replication and Reserved Words
4.1.26 SET PASSWORD and Row-Based Replication
4.1.27 Replication and Master or Slave Shutdowns
4.1.28 Slave Errors During Replication
4.1.29 Replication and Server SQL Mode
4.1.30 Replication and Temporary Tables
4.1.31 Replication Retries and Timeouts
4.1.32 Replication and TIMESTAMP
4.1.33 Replication and Time Zones
4.1.34 Replication and Transactions
4.1.35 Replication and Triggers
4.1.36 Replication and TRUNCATE TABLE
4.1.37 Replication and Variables
4.1.38 Replication and Views
4.2 Replication Compatibility Between MySQL Versions
4.3 Upgrading a Replication Setup
4.4 Troubleshooting Replication
4.5 How to Report Replication Bugs or Problems
PREV
HOME
UP
NEXT
Related Documentation
MySQL 5.5 Reference Manual
MySQL 5.5 Release Notes
Download this Excerpt
PDF (US Ltr)
- 0.9Mb
PDF (A4)
- 0.9Mb
HTML Download (TGZ)
- 278.3Kb
HTML Download (Zip)
- 293.1Kb