How to do MySQL replication (dual-master / multi-master)
# Mysql node a
[mysqld]
server-id = 10
auto_increment_increment = 10
auto_increment_offset = 1
master-host = nodeb
master-user = replication
master-password = replication
# Mysql node b
[mysqld]
server-id = 20
auto_increment_increment = 10
auto_increment_offset = 2
master-host = nodea
master-user = replication
master-password = replication
Related posts:
- Howto: How to Reset the MySQL Root Password
- Optimize MySQL for Low Memory Use
- MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
- Sun acquires MySQL
- Optimize MySQL Performance With MySQLTuner
- MySQL: Remove Duplicate Entries
- Crack Windows Password
- MySQL Optimization and Performance Tips
- Compressing mysqldump output – mysql, gzip, bzip2 and LZMA (7z)
- Mysql Data Import
Popular Related Items »
Incoming search terms
- mysql dual master
- mysql dual master replication
- mysql replication howto
- ubuntu mysql replication
- mysql replication dual master
- dual master mysql
- doctrine replication
- mysql replication ubuntu
- freebsd mysql replication
- mysql multi master
- mysql dual replication
- dual master replication mysql
- mysql replication windows
- puppet mysql replication
- mysql replication master master
- mysql multimaster howto
- mysql replication freebsd
- dual master replication
- mysql multi master replication
- mysql master master replication
- lenny mysql replication
- multi master replication mysql
- mysql master master replication howto
- mysql master master howto
- mysql replication windows to linux
- mysql multi master howto
- replicacion mysql windows
- dual master mysql replication
- multi master mysql replication
- mysql replication in ubuntu
- doctrine mysql replication
- mysql multi-master replication
- mysql replication on windows
- windows mysql replication
- mysql replication on ubuntu
- mysql master master windows
- mysql dual
- multi-master replication mysql
- mysql replication multimaster
- mysql replication linux to windows
- mysql replication from linux to windows
- mysql replication xp
- mysql replication windows howto
- mysql replik mit multi master
- mysql replication howto windows
Cody said,
June 14, 2008 @ 3:14
Worked great for me! Thanks for posting such a good article.
Thanks,
Cody
http://www.ticket-vault.com
james said,
September 10, 2009 @ 3:51
This is also a useful link…
http://www.cervistech.com/index.php?option=com_content&view=article&id=55&Itemid=2