[no subject]

> 
> Stored Procedures is also another nice feature of Postgress.  One thing
> I want to do is have backup databases.
> 
> In the MySQL realm all that was done with a Master -> Slave and done
> with binary data.  I'm not looking for Master->Slave.  I've have had so
> many problems getting the Master->Slave working and continue to work
> under MySQL.  I want backup databases and possible even load balancing. 
> Where I can have 2 database servers and then my application can contact
> the first one available.

Mysql has (at least) 3 free clustering approaches on Linux:

* drbd as the backing store under the db + heartbeat - that's an HA only 
solution
* master + slave(s) + a load balancer - that's distributed reads, single 
writes. Semi-load-balanced
* the new mysql cluster stuff - probably closest to what you want, but your 
db has to fit entirely in memory on each node, so it may or may not be 
suitable for your db size / hardware budget

later,
chris


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00281" href="msg00281.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> jrickman at gmail.com (Jonathan Rickman)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00253" href="msg00253.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> jkinney at localnetsolutions.com (James P. Kinney III)</li></ul></li>
<li><strong><a name="00256" href="msg00256.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> dcorbin at machturtle.com (David Corbin)</li></ul></li>
<li><strong><a name="00259" href="msg00259.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Christopher Fowler)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00262.html">[ale] database conversion</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00264.html">[ale] OT:  Netflix issues</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00259.html">[ale] database conversion</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00281.html">[ale] database conversion</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00263"><strong>Date</strong></a></li>
<li><a href="threads.html#00263"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>