You could use something like sqlrelay (<a href="http://sqlrelay.sourceforge.net/">http://sqlrelay.sourceforge.net/</a>) or pgpool (for PostgreSQL) to implement failover. Both of those applications provide failover features.
<br><br><div><span class="gmail_quote">On 3/11/06, <b class="gmail_sendername">Rosario Pingaro</b> &lt;<a href="mailto:rpingar@italycom.it">rpingar@italycom.it</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="direction: ltr;">






<div><font face="Arial" size="2">is it possible to configure a second mysql server 
for backup?</font></div>
<div><font face="Arial" size="2"></font>&nbsp;</div>
<div><font face="Arial" size="2">if yes how?</font></div>
<div><font face="Arial" size="2">Thanks</font></div></div><div style="direction: ltr;"><span class="sg">
<div>&nbsp;<font face="Arial" size="2">Rosario</font></div>

</span></div><br>_______________________________________________<br>Serusers mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://mail.iptel.org/mailman/listinfo/serusers" target="_blank">
http://lists.iptel.org/mailman/listinfo/serusers</a><br><br><br></blockquote></div><br>