sqlippool and MySQL/InnoDB: Useable for production?

Alan DeKok aland at deployingradius.com
Thu Feb 13 15:12:38 CET 2014

Sebastian Inacker wrote:
> Is the module sqlippool useable for production if MySQL is used with
> InnoDB tables?


> I found the information, that transaction support of your SQL backend
> is important, but MySQL seems to support transactions with InnoDB. I'm
> asking because I was told, that there is still an issue if you use
> sqlippool with more one NAS: The same IP addresses could be given to
> different clients if you use MySQL - even with InnoDB.

  That doesn't happen.

> What is your experience? Would you advise to use a different SQL
> backend (PostgreSQL for example)? Would you advise, not to use
> sqlippool at all?

  Use what you're familiar with.  If you don't know either MySQL or
PostgreSQL, choose Postgres.  It's a real SQL database.

> How do you handle a pool of ip addresses if you have more than one NAS
> and it's not possible to handle the pool on each NAS?

  Use SQL IP Pools.

  Alan DeKok.

More information about the Freeradius-Users mailing list