[Linux-cluster] Active Active Cluster
gordan at bobich.net
Thu Feb 4 09:30:50 UTC 2010
Muhammad Ammad Shah wrote:
> Is it possible to setup Active/Active cluster using two nodes, (i want
> to test this on MySQL and Oracle 11G). or it requires some other software?
Not sure how Oracle handles this use-case, but with MySQL you have three
1) Master-Master replication
Pros: Mature, fast.
Cons: There is an inherent race condition since the replication is
asynchronous. You'll have to thing about your application and see
whether that makes it an acceptable solution.
2) Shared data
Pros: Relatively straightforward to set up, just point your database
path to a shared GFS mount point and set locking type to external
Cons: Extremely slow if it's not a read-mostly database
3) MySQL Cluster
Pros: Faster than 2)
Cons: While it's running all data has to be in RAM, which limits the
size of the databases. Still slower than 1).
You can then only use RHCS to fail over IPs around.
More information about the Linux-cluster