I have not looked into replication yet (will do now).<br><br>If it was realtime that would be amazing, but daily would be sufficient. When you mention replication is a problem with a poor connection I was looking more into what would happen if it went down. The internet connection is a good one, but you never know what will happen.
<br>jason<br><br><div><span class="gmail_quote">On 8/10/07, <b class="gmail_sendername">Brock Noland</b> &lt;<a href="mailto:brockn@gmail.com">brockn@gmail.com</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;">
At least with Mysql 4, replication is a hassle to &quot;sync&quot; when the<br>connection drops or a server crashes.&nbsp;&nbsp;If your expecting a someone<br>unreliable connection, I doubt that will work.<br><br>How current does the remote location need to be?
<br><br>Brock<br><br>On 8/10/07, Andrew Zbikowski &lt;<a href="mailto:andyzib@gmail.com">andyzib@gmail.com</a>&gt; wrote:<br>&gt; Have you looked into MySQL Replication or Clustering?<br>&gt;<br>&gt; <a href="http://dev.mysql.com/doc/refman/5.0/en/replication-intro.html">
http://dev.mysql.com/doc/refman/5.0/en/replication-intro.html</a><br>&gt;<br>&gt; <a href="http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html">http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html</a><br>&gt;<br>
&gt;<br>&gt; --<br>&gt; Andrew S. Zbikowski | <a href="http://andy.zibnet.us">http://andy.zibnet.us</a><br>&gt; SELECT * FROM users WHERE clue &gt;0;<br>&gt; 0 rows returned<br>&gt;<br>&gt; _______________________________________________
<br>&gt; TCLUG Mailing List - Minneapolis/St. Paul, Minnesota<br>&gt; <a href="mailto:tclug-list@mn-linux.org">tclug-list@mn-linux.org</a><br>&gt; <a href="http://mailman.mn-linux.org/mailman/listinfo/tclug-list">http://mailman.mn-linux.org/mailman/listinfo/tclug-list
</a><br>&gt;<br><br>_______________________________________________<br>TCLUG Mailing List - Minneapolis/St. Paul, Minnesota<br><a href="mailto:tclug-list@mn-linux.org">tclug-list@mn-linux.org</a><br><a href="http://mailman.mn-linux.org/mailman/listinfo/tclug-list">
http://mailman.mn-linux.org/mailman/listinfo/tclug-list</a><br></blockquote></div><br>