[OFF-TOPIC] Freeradius and MySQL Cluster

[Antonio Modesto]

On Mon, 2012-02-27 at 20:20 +0700, Fajar A. Nugraha wrote:
> 2012/2/27 Antonio Modesto <modesto at isimples.com.br>:
> > Good Morning,
> >
> > I am doing some tests with MySQL Cluster, and I want to migrate my backend
> > to it. But I am having some "troubles/doubts" with it. When I use a empty
> > radius database, it works ok. But when I try to import my current database
> > to MySQL with the NDBCLUSTER engine, I got this error:
> >
> > ERROR 1114 (HY000) at line 143: The table 'radacct' is full
> 
> Is your cluster full?

I am not using the cluster, it was inactive, I just set it up, did some
tests, then I tried to import the actual radius database to it.

> 
> >
> > I think that I must do some tuning to adjust MySQL cluster to my
> > requirements, but I don't know exactly what to change, below is my
> > config.ini:
> 
> mysql cluster is a different beast altogether. My best advice, if you
> go down that route, is to get the help of an expert. Seriously. If you
> DO get it running though, it will worth every effort.
> 
> Some things you could try to check:
> - is the db full? mysql cluster is limited by how much amount of
> memory you allocate to the data nodes. Don't be surpised if you ended
> up with only 1 or 2 GB usable space.
> - try splitting the import into smaller transaction. It's a hassle, I
> know. But if you try to insert/update/delete a large number of rows
> (e.g. 1 million rows) at once, then mysql cluster will complain.
> Splitting it manually into a small number (e.g. 1k rows) on each
> transaction should work.
> 
> Again, if you still can't get it to work, hire an expert. Or ask in
> mysql list/forums, as this is not really radius-specific. Any huge
> write in one transaction should cause the same problem.
> 

I didn't know about the memory limit. So if I have a 10GB database, Must
I have, at least, 10GB configured for each cluster node?

Thanks.