Replication of data between two MySQL databases -

we going use 2 mysql databases same application. 1 of database going main database , other going fail on database. database not going locate @ same location. main database going active 1 handles traffic, second database going used if happens main server, getting damage or nonfunctional, used if main database getting hammered traffic should workload (yes have load balancer in place).

now real question, how best create data replication between 2 database? 2 method have thought is: • using shared disks • replication cluster have hard time decide solution best use. please give me cons , pros. if know , smart method i’m not aware off, please tell me.

if project success, going more mysql databases, of them use nfs mounts, information chance decision? if yes, why?