opensubscriber
   Find in this group all groups
 
Unknown more information…

c : cluster@lists.mysql.com 21 May 2012 • 10:04PM -0400

Re: Calculating Maximum cluster size
by Alex/AT

REPLY TO AUTHOR
 
REPLY TO GROUP




> I work at an ISP and we're going to put a mysql-cluster in production
> as our Freeradius backend, as you know the radius database always keeps
> growing because of the accounting, and I want to estimate the maximum
> size it could reach, how can I know how much my cluster can store?

I may recommend you to make multilevel accounting archive (we do). Store  
active sessions in Cluster and after they close, move them to archive  
(presumably partitioned InnoDB). Of course, this will require some  
modifications to billing/accounting/tech systems to select data from both  
the Cluster and archive, but it's worth the effort.

--
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster
To unsubscribe:    http://lists.mysql.com/cluster


Bookmark with:

Delicious   Digg   reddit   Facebook   StumbleUpon

Related Messages

opensubscriber is not affiliated with the authors of this message nor responsible for its content.