Kevin,
I am pleased to hear this is probably possible. Now to give it a go and
see what happens.
Regards,
Ben.
Kevin Cowley wrote:
> If your libraries/executables in your autonomus portable directories are
> from the later version you shouldn't have problems - they're generally
> backwards compatible.
>
> You're also better off since you're running two 4.n.x versions. The
> problems really occur if you have 4.n.x and 3.n.x installed on the same
> machine and the 3.n.x are in the default path for system users. You then
> have to remember to explicitly reset the path every time you want to use
> any of the 4.n.x utilities as they'll try and use the 3.n.x libraries
> and fail.
>
> 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 15:54
>>To: Kevin Cowley
>>Cc: mysql@stripped
>>Subject: Re: Two versions of MySQL on same machine
>>
>>Thanks for the documentation, there are some interesting things in
>
> there.
>
>>I may however have to go further than this and have true autonomous
>>MySQL. Not sharing any /etc/my.cfg. Running everything from some '~'
>>directory:
>>
>>~/etc/mysql.conf
>>~/bin/mysql*
>>~/libexec/mysqld
>>~/logs/
>>~/var/
>>~/mysql.sock
>>~/start.sh
>>~/stop.sh
>>
>>(etc)
>>
>>Therefore having a truely portable service group. This is needed so
>>that I can shunt the service from machine to machine to control load
>
> and
>
>>handle outages.
>>
>>This bit seems farly simple. As long as I start it up very carefully
>
> so
>
>>as to avoid IP conflicts, read the correct mysql.conf file etc...
>>
>>But my worry still remains:
>>
>>I can make MySQL 'autonomous' in this way only to a point. They limit
>
> I
>
>>can see is where external libs are needed. These may conflict if
>>compiled from different versions with the same file name.
>>
>>I would be interested to know from any member whether this may be the
>>case.
>>
>>Whether there are any libs MySQL creates which will conflict from
>>different versions. Eg, does 4.0 and 4.1 use different
>>libmysqlclinet.so but have the same file name. Therefore one will
>
> work,
>
>>one will dump :(
>>
>>Or maybe I can create the libs in my autonomous portable directory:
>>
>>~/libs/libmysqlclient.so
>>
>>But many thanks for the documentation, this will be a great start to
>>finding my solution.
>>
>>Regards,
>>
>>Ben.
>>
>>
>>
>>
>>
>>
>>Kevin Cowley wrote:
>>
>>>AS I read the Mysql-multi stuff it works if you have multiple
>
> instances
>
>>>of the same version but not different version instances.
>>>With different version instances you (may) have differences in
>>>mysqld_safe, mysqld itself, and more than likely in the libraries
>>>themselves so you need to use the mysqld_safe version that
>
> corresponds
>
>>>to the version you want.
>>>
>>>Kevin Cowley
>>>R&D
>>>
>>>Tel: 0118 902 9099 (direct line)
>>>Email: kevin.cowley@stripped
>>>Web: http://www.alchemetrics.co.uk
>>>
>>>
>>>
>>>>-----Original Message-----
>>>>From: Dean, Michael L USAATC [mailto:michael.dean@stripped]
>>>>Sent: 11 February 2005 15:07
>>>>To: 'mysql@stripped'
>>>>Subject: RE: Two versions of MySQL on same machine
>>>>
>>>>This site may actually help out more:
>>>>http://dev.mysql.com/doc/mysql/en/mysqld-multi.html
>>>>
>>>>-----Original Message-----
>>>>From: Kevin Cowley [mailto:kevin.cowley@stripped]
>>>>Sent: Friday, February 11, 2005 9:58 AM
>>>>To: mysql@stripped
>>>>Subject: RE: Two versions of MySQL on same machine
>>>>
>>>>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.
>>>
>>>
>
> ************************************************************************
>
>>>**
>>>
>>>
>>>>**
>>>>**********
>>>>
>>>>
>>>>--
>>>>MySQL General Mailing List
>>>>For list archives: http://lists.mysql.com/mysql
>>>>To unsubscribe:
>>>>http://lists.mysql.com/mysql?unsub=1
>>>>
>>>>--
>>>>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.
>>
> ************************************************************************
> **
>
>>************
>>
>>>
>>--
>>Ben Clewett
>>Road Tech Computer System Ltd
>>Ben.Clewett@stripped
>>http://www.roadrunner.uk.com
>>+44(0)1923 460000
>
>
>
>
>
> **************************************************************************************
> 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.
>
> **************************************************************************************
>
>
--
Ben Clewett
Road Tech Computer System Ltd
Ben.Clewett@stripped
http://www.roadrunner.uk.com
+44(0)1923 460000
