Hi I am running ispconfig using MySQL4, however I would like to implement MySQL5 on another port in order to be able to utilise some of the new features (views etc) for an application I want to upgrade. I realise that if MySQL5 were running concurrently then ispconfig would have no jurisdiction over it and any users / databases would need to be added manually, and that isn't an issue for me. However, I would really like some advice if possible regarding installation of the separate instance. I'm running Fedora Core 4, set up for ispconfig as outlined in the howtoforge article "The Perfect Setup - Fedora Core 4" Any help would be much appreciated.
You must install the new MySQL manually because if you use yum it will try to replace the current MySQL version. In the my.cnf file you must specify a different port (other than 3306) and MySQL socket. http://dev.mysql.com/doc/refman/5.0/en/installing-source.html