[OFF-TOPIC] Freeradius and MySQL Cluster

[Fajar A. Nugraha]

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 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.

-- 
Fajar