Sebastian Inacker wrote:
Is the module sqlippool useable for production if MySQL is used with InnoDB tables?
Yes.
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.