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@lists.freeradius.org [mailto:freeradius-users-bounces+davidp=wirelessconnections.net@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@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