List:Cluster« Previous MessageNext Message »
From:Jonathan Haddad Date:November 14 2007 6:39am
Subject:Cluster performance in web environment
View as plain text  
Has anyone on the list set up cluster for use in a web environment?  How
does the performance compare to innodb for selects based off an index?

How well does cluster perform with a lot of mixed reads / writes?  (say 20
to 1?)  If a table is constantly having rows inserted, are there any locking
issues we should be aware of?  Usually we deal with this by  partitioning
our tables into multiple machines.  Is this necessary anymore?

Initially, there won't be much on here, but I'm expecting it to be running
this on 6x 16GB dual core boxes for the  data nodes - will 1 table with 500
million rows and several hundred concurrent selects / inserts per second be
an issue?

Thanks,
Jon
-- 
Jon Haddad
jon@stripped
Letsgetnuts.com

Thread
Cluster performance in web environmentJonathan Haddad14 Nov
  • Re: Cluster performance in web environmentJohn David Duncan15 Nov
    • RE: Cluster performance in web environmentMuraliPD@GMail16 Nov
      • Re: Cluster performance in web environmentJohn David Duncan16 Nov
        • RE: Cluster performance in web environmentMuraliPD@GMail16 Nov
          • Re: Cluster performance in web environmentMikael Ronström16 Nov
            • RE: Cluster performance in web environmentMuraliPD@GMail16 Nov
              • Re: Cluster performance in web environmentMikael Ronström16 Nov
          • Re: Cluster performance in web environmentJon Stephens16 Nov
  • RE: Cluster performance in web environmentMuraliPD@GMail16 Nov
  • Re: Cluster performance in web environmentMikael Ronström16 Nov