Replication/Tutorial
Contents |
[edit] MySQL Replication Tutorial
This tutorial was created by the MySQL Replication Team.
Even though setting up MySQL Replication is a relatively simple task, there are several things that can be configured. In this tutorial, the developers behind MySQL Replication start by explaining the architecture and concepts and walk you through a configuration to show what you can do with it.
After getting an understanding of the setup, the tutorial continues with examples of using more advanced features like row-based replication, cluster replication, tricks of using the mysqlbinlog client program on the binary log, and fail-over solutions.
The tutorial ends with a brief summary of the new features that are being developed and how they can be used.
[edit] Preparations before the tutorial
In order to experiment with replication yourself, you can do the following preparations before the tutorial. It is, however, not necessary in order to follow the tutorial.
- Create a directory for the tutorial. It will be called reptut/ in the actual presentation.
- Download a distribution of the server using links from the download section. You should download a binary distribution without an installer.
- Unpack the distribution in server in the replication tutorial directory so that you have the distribution in a subdirectory.
- Download the utilities scripts (not available yet) and unpack them in the tutorial directory
[edit] Download Slides
You can download the slides from MySQL User Conference 2008: Replication Tutorial
[edit] Download Software
Unpack these in the replication tutorial directory.
- Linux download of server for Linux users at http://dev.mysql.com/downloads/mysql/5.1.html#linux
- Windows download of server for Windows user at http://dev.mysql.com/downloads/mysql/5.1.html#win32
- Replication tutorial package for both Linux and Windows users here. This requires Perl 5.6.0 or later to run correctly, plus basic modules. I have tried to stay away from modules that might not be available in the usual distribution, but you might have to check that you have all modules available. (Try running perl -wc scripts/server-adm from the replication tutorial directory.)