MySQL Versions 4.x/5.x on CentOS 5.4

4 posts / 0 new
Topic locked
Last post
#1 Sun, 02/14/2010 - 14:18
gl3ny

MySQL Versions 4.x/5.x on CentOS 5.4

The MySQL version running is 5.0.77. I'd like to use v4.x for one particular virtual server. Is it possible to install multiple versions and make them selectable for each VS?

Sun, 02/14/2010 - 14:42
andreychek

Howdy,

Well, while it's probably possible to do all the above, there's no built-in or easy way to go about it :-)

This is a bit of a hack, but the best I can think of would be to manually install another MySQL version, and run it on a different port, or point the socket it uses to an alternate location.

Then, you could configure the php.ini file for that particular Virtual Server to use the alternate MySQL version.

-Eric

Sun, 02/14/2010 - 16:40
gl3ny

Ok great that good to know...

The easy way would be to install a version of CentOS already with the mySQL/php versions I require right?

Even better install xen and have multiple OS with different versions?

Sun, 02/14/2010 - 17:58
andreychek

Well, the first choice would probably be to see if the app could be modified to use MySQL 5.x :-)

Barring that, the simplest thing to do would be to have a separate server or VPS to run an alternate database version on.

It's certainly possible to run two MySQL instances on one server, but that takes some effort to setup and maintain as compared to just running a separate server.

-Eric

Topic locked