:: DEVELOPER ZONE
MySQL Reference Manual :: 6 Replication in MySQL
Search the MySQL manual:
- Preface
- 1 General Information
- 2 Installing MySQL
- 3 MySQL Tutorial
- 4 Using MySQL Programs
- 5 Database Administration
- 6 Replication in MySQL
- 6.1 Introduction to Replication
- 6.2 Replication Implementation Overview
- 6.3 Replication Implementation Details
- 6.4 How to Set Up Replication
- 6.5 Replication Compatibility Between MySQL Versions
- 6.6 Upgrading a Replication Setup
- 6.7 Replication Features and Known Problems
- 6.8 Replication Startup Options
- 6.9 Replication FAQ
- 6.10 Troubleshooting Replication
- 6.11 Reporting Replication Bugs
- 7 MySQL Optimization
- 8 MySQL Client and Utility Programs
- 9 Language Structure
- 10 Character Set Support
- 11 Column Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 MySQL Storage Engines and Table Types
- 15 The InnoDB Storage Engine
- 16 MySQL Cluster
- 17 Introduction to MaxDB
- 18 Spatial Extensions in MySQL
- 19 Stored Procedures and Functions
- 20 Triggers
- 21 Views
- 22 The INFORMATION_SCHEMA Information Database
- 23 Precision Math
- 24 MySQL APIs
- 25 MySQL Connectors
- 26 Error Handling in MySQL
- 27 Extending MySQL
- A Problems and Common Errors
- B Credits
- C MySQL and the Future (the TODO)
- D MySQL Change History
- E Porting to Other Systems
- F Environment Variables
- G MySQL Regular Expressions
- H GNU General Public License
- I MySQL FLOSS License Exception
- Index
Additional languages
Additional formats
Table of Contents
- 6.1. Introduction to Replication
- 6.2. Replication Implementation Overview
- 6.3. Replication Implementation Details
- 6.4. How to Set Up Replication
- 6.5. Replication Compatibility Between MySQL Versions
- 6.6. Upgrading a Replication Setup
- 6.7. Replication Features and Known Problems
- 6.8. Replication Startup Options
- 6.9. Replication FAQ
- 6.10. Troubleshooting Replication
- 6.11. Reporting Replication Bugs
Replication capabilities allowing the databases on one MySQL server to be duplicated on another were introduced in MySQL 3.23.15. This chapter describes the various replication features provided by MySQL. It introduces replication concepts, shows how to set up replication servers, and serves as a reference to the available replication options. It also provides a list of frequently asked questions (with answers), and troubleshooting advice for solving problems.
For a description of the syntax of replication-related SQL statements, see Section 13.6, “Replication Statements”.
We suggest that you visit our Web site at http://www.mysql.com often and read updates to this chapter. Replication is constantly being improved, and we update the manual frequently with the most current information.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.