sqlippool and MySQL/InnoDB: Useable for production?
Sebastian Inacker
inacker.work at gmail.com
Fri Feb 14 09:34:50 CET 2014
Hello Alan.
On 13 February 2014 15:12, Alan DeKok <aland at deployingradius.com> wrote:
> > Is the module sqlippool useable for production if MySQL is used with
> > InnoDB tables?
> Yes.
Good news. So the warning
# WARNING: MySQL has certain limitations that means it can
# hand out the same IP address to 2 different users.
in raddb/sqlippool.conf is obsolete if you follow the advice to use
MySQL with InnoDB, which can be found at the same place?
# We suggest using an SQL DB with proper transaction
# support, such as PostgreSQL, or using MySQL
# with InnoDB.
(Just for the record: raddb/sql/mysql/ippool.sql is useing "ENGINE=InnoDB".)
Thanks,
Sebastian
More information about the Freeradius-Users
mailing list