At 15:46 -0400 5/18/04, Robert A. Rosenberg wrote:I have a site that is being hosted by an ISP which is running version 3.23.52. When I questioned why that downlevel version and not a 4.0 version (such as 4.0.18 or the just released 4.0.20), I was told "Unfortunately, when versions change on MySQL, they also drop features and change security settings. This can cause many problems system wide." Before I go further with my discussion and renew my request for a 4.0 Database, I would like to know if it is even possible to have more than one level active (and if so, what is involved in the set-up).
It's perfectly possible. I have dozens of versions installed, though not all necessarily running at the same time. :-)
http://dev.mysql.com/doc/mysql/en/Multiple_servers.html
Thank you for your reply. I am passing it on to the ISP in the hope that they will use it to provide an option to offer current level support to those who need/want it (by just adding the new port number to the Host Name in MySQL connection request).
I have one suggestion to be added to the base code to assist in running multiple levels - Allow the --port=port_number parameter to take a list as opposed to only one number (so the server monitors more than one port and treats them as if they were the same). This would allow a migration to the newer versions to proceed by having the base port number as well as the alternate one be available for the use after the migration while those who were using the alternate port number in their calls are removing the number so as to again use the standard port number. Initially, the downlevel version would have ownership of the standard port as well as a private port (for those who do not want to be migrated after the move) which would be reassigned on "Roll Day" to the newer version. The alternate port could then be scheduled to be removed after a period of time to allow for its removal from the Host Name calls by those who were using the newer version prior to the Roll.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
