You can do what Sunil mentioned using heartbeat [1]. However, MySQL also has replication built into it and you can also use heartbeat to automatically turn a slave into a master very quickly without any need for shared storage. This way you could also use the slave to do load balancing of reads and provide backups without interrupting access on the master when all the tables and databases get locked.
Brian [1] http://linux-ha.org Sunil Mushran <sunil.mush...@oracle.com> 2009-08-25 17:14: > Can you describe the mount lock? > > You don't have to limit the mount to just one node. Have both > nodes mount the volume but run mysql only on one node only. > > Sunil > > James Devine wrote: > > I am trying to make a mysql standby setup with 2 machines, one primary > > and one hot standby, which both share disk for the data directory. I > > used tunefs.ocfs2 to change the number of open slots to 1 since only > > one machine should be accessing it at a time. This way it is fairly > > safe to assume one shouldn't clobber the other's data. Only problem > > is, if one node dies, the mount lock still persists. Is there a way > > to clear that lock so the other node can mount the share? > > > > _______________________________________________ > > Ocfs2-users mailing list > > Ocfs2-users@oss.oracle.com > > http://oss.oracle.com/mailman/listinfo/ocfs2-users > > > > > _______________________________________________ > Ocfs2-users mailing list > Ocfs2-users@oss.oracle.com > http://oss.oracle.com/mailman/listinfo/ocfs2-users _______________________________________________ Ocfs2-users mailing list Ocfs2-users@oss.oracle.com http://oss.oracle.com/mailman/listinfo/ocfs2-users
