18 messages in com.mysql.lists.clusterRe: Database Storage Capacity. (adden...
FromSent OnAttachments
Faraz Khan29 Aug 2004 22:59 
Olivier Kaloudoff30 Aug 2004 00:09 
Mikael Ronström30 Aug 2004 00:39 
Faraz Khan30 Aug 2004 00:50 
Sundeep Narravula30 Aug 2004 00:57 
Olivier Kaloudoff30 Aug 2004 04:17 
Tomas Ulin31 Aug 2004 00:36 
Mikael Ronström31 Aug 2004 04:50 
Sundeep Narravula31 Aug 2004 09:08 
Devananda31 Aug 2004 13:01 
Devananda31 Aug 2004 13:07 
Clint Byrum31 Aug 2004 13:35 
Faraz Khan31 Aug 2004 22:14 
John David Duncan31 Aug 2004 22:38 
Mikael Ronström31 Aug 2004 23:21 
Faraz Khan31 Aug 2004 23:30 
Devananda02 Sep 2004 08:49 
Douglas K. Fischer04 Sep 2004 11:29 
Subject:Re: Database Storage Capacity. (addendum)
From:Devananda (deva@neopets.com)
Date:08/31/2004 01:07:56 PM
List:com.mysql.lists.cluster

FYI, we just looked into putting a 75-100GB table into the cluster, but figured out that we can house the same table by load balancing traditional InnoDB databases across ~4 servers, rather than across ~16 with the cluster.

Realized that I didn't mention something which is imporant here - this table, though large, doens't handle more than 6,000 queries / second. If it needed to handle much more than that, we would probably need to put it into a cluster since we seem to be pushing our qps limit with it right now.