Username Password
Bookmark and Share

MySQL Replication

Word of warning

A not carfully planned and configured replication may destroy your data!

Do read a lot of documentation before using these techniques on a production site. 

Setup replication

  1. Setting up MySQL replication is an easy way to keep live backups between a production and development or hotspare. Here are some resources for doing this:

The my.ini file to edit is in /data/wre/etc/my.ini. If you are using innodb tables, you may want to also set the following options:

  # Per manual section


  1. We may need to look at turning off replication when running the script. The OnLAMP article explains how to do this towards the end.

Keywords: mysql

Search | Most Popular | Recent Changes | Wiki Home
© 2023 Plain Black Corporation | All Rights Reserved