List:General Discussion« Previous MessageNext Message »
From:Kevin Cowley Date:February 11 2005 2:57pm
Subject:RE: Two versions of MySQL on same machine
View as plain text  
You need to install each version into its own directory/path structure -
if you have a default install of Mysql then you also need to take this
into account. 

For each version you need to setup a my.cnf and if you want full
separation different database directories. In the my.cnf you specify
different ports/sockets.

For any given user you then need to ensure they pickup the correct
binaries and libraries(if they're building applications).

If you're auto starting Mysql at boot you either need to write a script
which provides each version separately or write a generice script which
finds and starts/stops/shutsdown each installed version.

Then you'll need to work out migrations strategies, user admin between
versions, etc.

Welcome to the world of system/database admin.

Kevin Cowley
R&D
 
Tel: 0118 902 9099 (direct line)
Email: kevin.cowley@stripped
Web: http://www.alchemetrics.co.uk

> -----Original Message-----
> From: Ben Clewett [mailto:Ben.Clewett@stripped]
> Sent: 11 February 2005 14:12
> To: mysql@stripped
> Subject: Two versions of MySQL on same machine
> 
> Dear MySQL,
> 
> I require two versions of MySQL on the same machine.
> 
> [Specifically part of an HACMP array where services are portable and
> move from server to server, using AIX 5.1].
> 
> The machine I have will have to support MySQL 4.0.11 and 4.1.8.
> 
> I have three questions:
> 
> 1. Are there any server libs?
> 
> I can see these on a Linux box, none of which look like server libs,
so
> I might be lucky?
> 
> librt.so.1
> libz.so.1
> libdl.so.2
> libpthread.so.0
> libcrypt.so.1
> libnsl.so.1
> libm.so.6
> libc.so.6
> 
> 2. If there are and server libs, will the server libs conflict between
> the two versions?
> 
> 2. If they conflict, is there a way of compiling MySQL to it's
specific
> libs from the standard package, without static compilation?
> 
> Any help, however honest or candied, would be extremely useful.
> 
> Regards,
> 
> Ben Clewett.
> 
> --
> Ben Clewett
> Road Tech Computer System Ltd
> Ben.Clewett@stripped
> http://www.roadrunner.uk.com
> +44(0)1923 460000
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1



**************************************************************************************
ALCHEMETRICS LIMITED (ALCHEMETRICS)
Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
Tel:  +44 (0) 118 902 9000    Fax:  +44 (0) 118 902 9001
This e-mail is confidential and is intended for the use of the addressee only.
If you are not the intended recipient, you are hereby notified that you must 
not use, copy, disclose, otherwise disseminate or take any action based on 
this e-mail or any information herein.
If you receive this transmission in error, please notify the sender
immediately by reply e-mail or by using the contact details above and then
delete this e-mail.
Please note that e-mail may be susceptible to data corruption, interception 
and unauthorised amendment.  Alchemetrics does not accept any liability for 
any such corruption, interception, amendment or the consequences thereof.
**************************************************************************************

Thread
Two versions of MySQL on same machineBen Clewett11 Feb
RE: Two versions of MySQL on same machineKevin Cowley11 Feb
RE: Two versions of MySQL on same machineMichael L USAATC Dean11 Feb
RE: Two versions of MySQL on same machineKevin Cowley11 Feb
  • Re: Two versions of MySQL on same machineBen Clewett11 Feb
    • Re: Two versions of MySQL on same machineEric Bergen11 Feb
RE: Two versions of MySQL on same machineKevin Cowley11 Feb
  • Re: Two versions of MySQL on same machineBen Clewett11 Feb