I've a (large?) FreeRadius database with MySQL 5.0.51.
When the database was set up, MyISAM engine was used. Since now we're experiencing some
performance problems, I was considering the migration to InnoDB, which I read should be
MySQL is a master/master replica setup. Since the ALTER TABLE will take some minutes (I
did a test run on a separate db), and one of the two database while still active is not
publicly accessible, I tought I could run the alter on the "offline" db first using the
ALTER TABLE ... ENGINE=InnoDB;
then switch the online db and run the same on the second node.
From what I've read around, and basicly here , the main adivces are about disk storage,
but not much more...
My questions are:
* will I really gain in performance by switching to Innodb?
* is the above procedure a good schedule?
* is there anything else I should care about, before starting?
Lorenzo Milesi - lorenzo.milesi@stripped
GPG/PGP Key-Id: 0xE704E230 - http://keyserver.linux.it