active-active clustering
MySQL Active - Active Clustering
Submitted by Shinguz on Tue, 2007-03-13 12:06It is possible to use an active - active shared-disk cluster in MySQL in some cases. For doing this you have to fulfil the following requirements:
- Works with MyISAM tables only.
- POSIX-locking compliant cluster file system on the device (such as OCFS2 or GFS).
- External locking must be enabled.
- The MySQL query cache must be turned off.
- The MySQL delay key write must be turned off.
- OS where file locking is supported in MySQL.

Interested?
