16.1.1 How to Set Up Replication

16.1.1.1 Setting the Replication Master Configuration
16.1.1.2 Setting the Replication Slave Configuration
16.1.1.3 Creating a User for Replication
16.1.1.4 Obtaining the Replication Master Binary Log Coordinates
16.1.1.5 Creating a Data Snapshot Using mysqldump
16.1.1.6 Creating a Data Snapshot Using Raw Data Files
16.1.1.7 Setting Up Replication with New Master and Slaves
16.1.1.8 Setting Up Replication with Existing Data
16.1.1.9 Introducing Additional Slaves to an Existing Replication Environment
16.1.1.10 Setting the Master Configuration on the Slave

This section describes how to set up complete replication of a MySQL server. There are a number of different methods for setting up replication, and the exact method to use depends on how you are setting up replication, and whether you already have data within your master database.

There are some generic tasks that are common to all replication setups:

Once you have configured the basic options, you will need to follow the instructions for your replication setup. A number of alternatives are provided:

If you will be administering MySQL replication servers, we suggest that you read this entire chapter through and try all statements mentioned in Section 13.4.1, “SQL Statements for Controlling Master Servers”, and Section 13.4.2, “SQL Statements for Controlling Slave Servers”. You should also familiarize yourself with the replication startup options described in Section 16.1.4, “Replication and Binary Logging Options and Variables”.

Note

Note that certain steps within the setup process require the SUPER privilege. If you do not have this privilege, it might not be possible to enable replication.