On Mon, 2012-02-27 at 20:20 +0700, Fajar A. Nugraha wrote: > 2012/2/27 Antonio Modesto <[email protected]>: > > 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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
