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
- MySQL Optimization and Performance Tips
- Compressing mysqldump output – mysql, gzip, bzip2 and LZMA (7z)
- MySQL 5.0 Release Candidate
- Crack Windows Password
Popular Related Items »
Incoming search terms
- mysql dual master
- mysql dual master replication
- mysql replication howto
- mysql replication dual master
- ubuntu mysql replication
- dual master mysql
- doctrine replication
- mysql dual replication
- mysql master master replication howto
- freebsd mysql replication
- mysql multi master replication
- mysql replication ubuntu
- mysql replication freebsd
- dual master replication mysql
- puppet mysql replication
- mysql multi master
- mysql replication windows
- dual master replication
- mysql replication master master
- mysql multimaster howto
- lenny mysql replication
- mysql master master replication
- mysql replication on windows
- mysql master master windows
- mysql master master howto
- dual master mysql replication
- mysql replication windows to linux
- multi master replication mysql
- mysql multi master howto
- dual-master mysql replication
- Dual-Master mysql
- replicacion mysql windows
- windows mysql replication
- mysql replication in ubuntu
- mysql dual master replication howto
- multi master mysql replication
- doctrine mysql replication
- mysql replication master master windows
- mysql multi-master replication
- freebsd mysql multimaster
- mysql replication howto windows
- mysql replica windows
- master master replication mysql problem
- how to mysql replication freebsd
- master master mysql replication
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