<p>How are you doing your traffic shaping? Can you post your script? There are dozens of ways to set up traffic shaping, and most of them are not optimal for your serup.</p>
<p><blockquote type="cite">On Nov 6, 2009 6:08 PM, "Silas Martinez" <<a href="mailto:silasm@gmail.com">silasm@gmail.com</a>> wrote:<br><br>Hey there,<br><br>I'm afraid I'm not going to be much help in directly solving the problem, but perhaps there is another approach? <br>
<br>If clients are mostly doing read activity, for example, perhaps replication is a potential solution? Clients could do read activity without interruption (the data feed to the local slave may be interrupted, so the data may not be up-to-the-moment, but connections wouldn't arbitrarily drop, either), and a connection would only be required at the moment for write activity (to the remote master) - and even that isn't a strict requirement, depending on the sensitivity of the data, and the app itself. <br>
<br>Replication can be configured to be tolerant of losing connectivity to the master with few issues:<br><a href="http://dev.mysql.com/doc/refman/5.1/en/replication-faq.html#qandaitem-16-3-4-1-1" target="_blank">http://dev.mysql.com/doc/refman/5.1/en/replication-faq.html#qandaitem-16-3-4-1-1</a><br>
<br>Unfortunately, outside of traffic shaping, which you've already considered, I'm not aware of a better fix. Perhaps someone will be more mysql-clueful than I. <br><br>Best of luck!<br><br>Silas.<br><br><div class="gmail_quote">
<p><font color="#500050">On Fri, Nov 6, 2009 at 5:32 PM, Jim Ockers <<a href="mailto:ockers@ockers.net">ockers@ockers.net</a>> wrote:
</font></p><blockquote class="gmail_quote" style="border-left:1px solid rgb(204, 204, 204);margin:0pt 0pt 0pt 0.8ex;padding-left:1ex"><p><font color="#500050">>
> Hi CLUEbies,
>
> We have a Windows MySQL client on one end of a 1Mbps serial PPP connection and ...</font></p>_______________________________________________<br>
clue-tech mailing list<br>
<a href="mailto:clue-tech@cluedenver.org" target="_blank">clue-tech@cluedenver.org</a><br>
<a href="http://www.cluedenver.org/mailman/listinfo/clue-tech" target="_blank">http://www.cluedenver.org/mailman/listinfo/clue-tech</a><br></blockquote></div><br>
<br>_______________________________________________<br>
clue-tech mailing list<br>
<a href="mailto:clue-tech@cluedenver.org">clue-tech@cluedenver.org</a><br>
<a href="http://www.cluedenver.org/mailman/listinfo/clue-tech" target="_blank">http://www.cluedenver.org/mailman/listinfo/clue-tech</a><br></blockquote></p>