[Ocfs2-users] Clear Node

[Brian Kroth]

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.mushran at 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 at oss.oracle.com
> > http://oss.oracle.com/mailman/listinfo/ocfs2-users
> >   
> 
> 
> _______________________________________________
> Ocfs2-users mailing list
> Ocfs2-users at oss.oracle.com
> http://oss.oracle.com/mailman/listinfo/ocfs2-users