[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[no subject]



<a  rel="nofollow" href="http://www.oreilly.com/catalog/hpmysql/";>http://www.oreilly.com/catalog/hpmysql/</a>
<a  rel="nofollow" href="http://highperformancemysql.com/";>http://highperformancemysql.com/</a>

Gives some great detail on how to configure clusters base
on your applications specific needs, to include various
ways to parition your cluster for optimization. I found it
invaluable.

But to summarize, if your application is high volume reads
with proportionally low volume writes, then you should be
able to get away with slave copies clustered and one write
only master.

You have to play with your connection strings a bit but it
works well.

HTH


--- Jeb Barger &lt;jeb at rev-x.com&gt; wrote:

&gt; I'm actually trying to load balance for a web app.  Last
&gt; time, something 
&gt; I did got slashdotted, and it brought the webpage to it's
&gt; knees.  The 
&gt; mysql server is on the same box as apache, however, I
&gt; recently aquired 
&gt; to older machines that I thought would make a great mysql
&gt; cluster.
&gt; 
&gt; Christopher Fowler wrote:
&gt; &gt; On Sat, 2005-08-20 at 15:22, Chris Ricker wrote:
&gt; &gt; 
&gt; &gt;&gt;On Fri, 19 Aug 2005, Jeb Barger wrote:
&gt; &gt;&gt;
&gt; &gt;&gt;
&gt; &gt;&gt;&gt;I am thinking about setting up a little mysql cluster
&gt; with some spare
&gt; &gt;&gt;&gt;hardware i have.  Does anybody have a linkie or a doc
&gt; that will give me
&gt; &gt;&gt;&gt;some insight ?
&gt; &gt;&gt;
&gt; &gt;&gt;You really need to say more about what / why you're
&gt; wanting a cluster. 
&gt; &gt;&gt;There are lots of ways of clustering MySQL, and they
&gt; all have tradeoffs:
&gt; &gt;&gt;
&gt; &gt; 
&gt; &gt; 
&gt; &gt; Agreed.  I'm naive about the ways but I've tried t
&gt; master/slave and
&gt; &gt; found it only good for a backup storage of data.  You
&gt; can not do 
&gt; &gt; inserts to the slave.  
&gt; &gt; 
&gt; &gt; I was originally looking for a way to cluster 2+
&gt; servers and have anyone
&gt; &gt; of them step into place during failover.  The only
&gt; thing I could think
&gt; &gt; of was do inserts,deletes, modifications on all of
&gt; them.  So one insert
&gt; &gt; execution would do an insert on all databases in the
&gt; group.
&gt; &gt; 
&gt; &gt; 
&gt; &gt;&gt;* MySQL Cluster product
&gt; &gt;&gt;* High Availability active / passive clustering using
&gt; shared storage
&gt; &gt;&gt;* MySQL master / slave replication
&gt; &gt;&gt;
&gt; &gt;&gt;etc.
&gt; &gt;&gt;
&gt; &gt;&gt;later,
&gt; &gt;&gt;chris
&gt; &gt;&gt;_______________________________________________
&gt; &gt;&gt;Ale mailing list
&gt; &gt;&gt;Ale at ale.org
&gt; &gt;&gt;<a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt; &gt; 
&gt; &gt; 
&gt; &gt; _______________________________________________
&gt; &gt; Ale mailing list
&gt; &gt; Ale at ale.org
&gt; &gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt; &gt; 
&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; 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
<a  rel="nofollow" href="http://mail.yahoo.com";>http://mail.yahoo.com</a> 


</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="00319" href="msg00319.html">[ale] MySQL Cluster</a></strong>
<ul><li><em>From:</em> jeb at rev-x.com (Jeb Barger)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00322.html">[ale] Nvidia 7667 and SUSE 9.3 kernel update</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00324.html">[ale] Structured Documentation</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00319.html">[ale] MySQL Cluster</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00310.html">[ale] OpenOffice 2 default font</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00323"><strong>Date</strong></a></li>
<li><a href="threads.html#00323"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

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