<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3086" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=924030814-01062007><FONT face=Arial size=2>I am curious if
anyone knows the best practices for this? Several use cases
include</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial size=2>Note: We are
choosing to use a vip for the two nodes to make the failover change transparent
to the application side.</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial size=2>1) Node 1 (master)
dies</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial
size=2> -How do we enable "sticky"
failover so that it does not then fail back to Node 1</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial
size=2> -Is Node 2 active all the time
or is the service completely shut off? And if its off, how would replication
happen?</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007>
<FONT face=Arial size=2>-How do failover domains work in this
case?</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial size=2>2) Node 2 (Master)
Node 1 recovered</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007>
<FONT face=Arial size=2>-How does replication continue
again?</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007>
<FONT face=Arial size=2>-How does the master slave relationship change? Is this
automated, or does it require manual intervention? Should we be using
DRDB?</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial size=2>3) Node 1 (master)
Node 2 (slave) - network connectivity dies on node 1</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007>
<FONT face=Arial size=2>-There is an IP resource available, but how does this
monitor and handle failover?</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007>
<FONT face=Arial size=2>-How can I move the vip in the event of a failure? Do I
need to manually script this?</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial size=2>With the vip
failover, do I attach the vip resource to the mysql resource in the failover
domain for those two nodes? What happens if I do this?</FONT></SPAN></DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=924030814-01062007><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial>
<DIV><SPAN class=981281519-26042007>
<DIV align=left><FONT face=Tahoma size=2><STRONG>
<DIV><SPAN class=981281519-26042007>
<DIV align=left><FONT face=Tahoma size=2><STRONG>Robert
Gil</STRONG></FONT></DIV>
<DIV align=left><FONT face=Tahoma size=2><STRONG>Linux Systems
Administrator</STRONG></FONT></DIV>
<DIV align=left><SPAN class=981281519-26042007><FONT face=Tahoma
size=2><STRONG>American Home Mortgage</STRONG></FONT></SPAN></DIV>
<DIV align=left><FONT face=Tahoma size=2><STRONG>Phone:
631-622-8410</STRONG></FONT></DIV>
<DIV align=left>Cell: 631-827-5775</DIV>
<DIV align=left><FONT face=Tahoma size=2><STRONG>Fax:
516-495-5861</STRONG></FONT></DIV></SPAN></DIV></STRONG></FONT></DIV></SPAN></DIV></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT> </DIV></BODY></HTML>