MySQL Repilcation: Articles, Blogs, Docs, FAQs

[Edwin DeSouza]

Docs:
http://dev.mysql.com/doc/refman/5.1/en/replication.html

How To Set Up Database Replication In MySQL
http://www.howtoforge.org/mysql_database_replication

Advanced Replication Techniques for MySQL 5.0
http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html

MySQL 5.5: SemiSynch Replication
- http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html
- http://mysqlha.blogspot.com/2009/12/mysql-55-and-semi-sync-replication-are.html
- http://harrison-fisk.blogspot.com/2010/03/semi-sync-replication-testing.html
- http://datacharmer.blogspot.com/2010/11/testing-mysql-55-semi-synchronous.html

MySQL Replicant:
http://mysqlmusings.blogspot.com/2010/02/mysql-replicant-library-class-design-in.html
http://mysqlmusings.blogspot.com/2009/12/mysql-replicant-library-for-controlling.html

MySQL Master Master Repliction Tutorial
http://www.howtoforge.org/mysql_master_master_replication

MySQL multi-master replication (circular replication with two nodes)
http://capttofu.livejournal.com/1752.html

MySQL Multi-Master – Single-Slave – Replication (Episode 2)
http://shinguz.blogspot.com/2008/10/mysql-multi-master-single-slave.html

Master-Master Replication Example using MMM
http://blog.kovyrin.net/2007/04/23/master-master-replication-example-using-mmm/
http://blog.kovyrin.net/mysql-master-master-replication-manager/master-master-replication-example/
http://blog.kovyrin.net/mysql-master-master-replication-manager/use-cases/
http://blog.kovyrin.net/mysql-master-master-replication-manager/

Yahoo: HA for MySQL Replication Masters
http://mysqlguy.net/blog/2010/08/03/mysql-master-ha-yahoo

MySQL Replication Tips:
http://crazytoon.com/2008/02/29/mysql-how-do-you-set-up-mastermaster-replication-in-mysql-centos-rhel-fedora/
http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/
http://crazytoon.com/2008/04/21/mysql-replication-replicate-by-choice/

MySQL Replication Failures
http://www.pythian.com/blogs/1273/mysql-replication-failures

MySQL: RENAME TABLE on Transactional Tables Can Jeopardize Slave Data
http://www.pythian.com/blogs/1285/mysql-rename-table-on-transactional-tables-can-jeopardize-slave-data

How to check MySQL replication integrity continually
http://www.xaprb.com/blog/2008/10/04/how-to-check-mysql-replication-integrity-continually/

MySQL Table Checksum: Ensure slaves have the same data as their master
http://www.xaprb.com/blog/2007/05/05/mysql-table-checksum-110-released/

How MySQL replication got out of sync
http://www.xaprb.com/blog/2007/11/08/how-mysql-replication-got-out-of-sync/

How to sync tables in master-master MySQL replication
http://www.xaprb.com/blog/2008/02/29/how-to-sync-tables-in-master-master-mysql-replication/

How to Keep Binlogs in Sync?
http://blog.onefreevoice.com/2008/06/24/how-to-keep-binlogs-in-sync/

Resyncing table on MySQL Slave
http://www.mysqlperformanceblog.com/2008/06/29/resyncing-table-on-mysql-slave/

Online Verification that MySQL Master and MySQL Slaves are in Sync
http://www.pythian.com/news/4397/online-verification-that-master-and-slaves-are-in-sync/

Fighting MySQL Replication Lag
http://www.mysqlperformanceblog.com/2008/09/22/fighting-mysql-replication-lag/
http://www.mysqlperformanceblog.com/2007/10/12/managing-slave-lag-with-mysql-replication/

Syncing a New Slave:
http://www.paragon-cs.com/wordpress/?p=114

Cause of Replication Delay? I/O or SQL Thread?
http://dba-mysql.blogspot.com/2008/06/cause-of-replication-delay-io-or-sql.html

Slave Setup:
http://www.paragon-cs.com/wordpress/?p=113

MySQL Slave Delay Explained And 7 Ways To Battle It
http://beerpla.net/2008/09/05/mysql-slave-delay-explained-and-7-ways-to-battle-it/

Active/active fail over cluster with MySQL Replication
http://shinguz.blogspot.com/2008/09/activeactive-fail-over-cluster-with.html

Filtering binary logs with MySQL Sandbox and replication
http://datacharmer.blogspot.com/2010/11/filtering-binary-logs-with-mysql.html

MySQL Row-based Replication (RBR): Decoding binlog entries
http://datacharmer.blogspot.com/2008/09/dsclosing-binlog-entries-with-row-based.html

Troubleshooting Relay Log Corruption in MySQL
http://www.mysqlperformanceblog.com/2008/08/02/troubleshooting-relay-log-corruption-in-mysql/

When SHOW SLAVE STATUS and the error log Disagree
http://www.pythian.com/blogs/876/when-show-slave-status-and-the-error-log-disagree

Using MMM to ALTER huge tables
http://www.mysqlperformanceblog.com/2008/03/27/using-mmm-to-alter-huge-tables/

A quick tour of DRBD (-vs- Local RAID -vs- MySQL Replication)
http://mysqldump.azundris.com/archives/56-A-quick-tour-of-DRBD.html

How To Monitor MYSQL Replication In Real Time With SNMP
http://www.softwaresecretweapons.com/jspwiki/Wiki.jsp?page=HowToMonitorMYSQLReplicationInRealTimeWithSNMP
http://jeremy.zawodny.com/mysql/managing-mysql-replication.html
http://xn.pinkhamster.net/blog/tech/monitoring_mysql_replication_slaves.html

MySQL Replication Roadmap:
http://mysqldump.azundris.com/archives/71-Replication-now-and-then.html
http://larsthalmann.com/blog/wp-content/uploads/2006/07/060727.LarsThalmann.FutureOfMySQLReplication.pdf

MySQL Proxy: Replication into Memcached
http://jan.kneschke.de/2008/5/18/mysql-proxy-replicating-into-memcache

MySQL Proxy: Binlog Storage Engine:
http://jan.kneschke.de/2009/5/4/binlog-storage-engine-mysql-proxy-edition

MySQL Circular Replication: Restoring a backup
http://mysqldba.blogspot.com/2009/04/restoring-backup-of-circular.html

MySQL replication monitoring with Python
http://tech.tomgoren.com/archives/86


http://www.markleith.co.uk/2015/08/04/quickly-tell-who-is-writing-to-a-mysql-replica/



Edited 27 time(s). Last edit at 08/02/2016 02:46PM by Edwin Desouza.