[OFF-TOPIC] Freeradius and MySQL Cluster

[David Peterson]

This is about the best tool for MySQL cluster for tuning your DB. 

http://www.severalnines.com/cluster-configurator/

David

-----Original Message-----
From:
freeradius-users-bounces+davidp=wirelessconnections.net at lists.freeradius.org
[mailto:freeradius-users-bounces+davidp=wirelessconnections.net at lists.freera
dius.org] On Behalf Of Fajar A. Nugraha
Sent: Monday, February 27, 2012 8:20 AM
To: FreeRadius users mailing list
Subject: Re: [OFF-TOPIC] Freeradius and MySQL Cluster

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
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html