Re: replication with redhat clustering

[zafar malik]

Hi Rick,

We are using it for load balancing and mysql clustering does not support referential intigrity, due to this we switched to redhat clustering.

Please suggest what is the best way of real time db backup and also we can use it for read only statements.

Structure is as per below-

# 2 nodes for mysql service (active/passive)
# data directory on different server (both node's mysql services (which will be active) will connect to this data directory.

Thanks,
Zafar