[no subject]

SQL Relay doesn't support front end replication (though it is on the
TODO list).  Currently, it can distribute load across a cluster or other
set of replicated databases, but it assumes that they are synchronized
somehow by themselves.

All of the commercial DB's support replication and I believe there are
projects for MySQL, PostgreSQL and Interbase/Firebird to support
replication too, though I'm not sure how mature any of them are.

Most people who require clustering/replication seem to like to set up a
master database with multiple slaves and define 2 instances of SQL
Relay: one that distributes load across the slaves and one that connects
directly to the master.  Then they write their apps to connect to use
slave instance for select-only transactions and the master instance for
transactions with insert/update/delete's in them.  The slaves are kept
synchronized using a variety of methods, depending on what's appropriate
for the app.  I've seen everything from real-time replication to batch
processes that run every night and copy the database files between the
machines.

Dave
david.muse at firstworks.com

On Wed, 9 Feb 2005 11:08:55 +0000
Tony Carter <tcarter at entrusion.com> wrote:

> On Wednesday 09 February 2005 14:02, Chris Ricker wrote:
&gt; &gt; sqlrelay &lt;<a  rel="nofollow" href="http://sqlrelay.sourceforge.net/";>http://sqlrelay.sourceforge.net/</a>&gt; might be usable for the
&gt; &gt; write mirroring across 2 different dbs? I think the author may even
&gt; &gt; be on this list
&gt; &gt;
&gt; &gt; later,
&gt; &gt; chris
&gt; 
&gt; I don't think sqlrelay will handle replication (writes across multiple
&gt; databases) for you. Look likes its main fiuunctionality is connection
&gt; pooling or load balancing  up read operations..
&gt;  
&gt; 
&gt; -Tony
&gt; _______________________________________________
&gt; Ale mailing list
&gt; Ale at ale.org
&gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt; 


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--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="00262" href="msg00262.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> kaboom at gatech.edu (Chris Ricker)</li></ul></li>
<li><strong><a name="00283" href="msg00283.html">[ale] database conversion</a></strong>
<ul><li><em>From:</em> tcarter at entrusion.com (Tony Carter)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00299.html">[ale] very funny comments by Microsoft security specialist</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00301.html">[ale] very funny comments by Microsoft security specialist</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00283.html">[ale] database conversion</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00343.html">[ale] database conversion</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00300"><strong>Date</strong></a></li>
<li><a href="threads.html#00300"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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