List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:February 11 2005 4:15pm
Subject:Re: Two versions of MySQL on same machine
View as plain text  
The clients are backwards compatible. Meaning if you put a 4.1 client
on the machine it will work for both 4.1 and 4.0 installations. The
only real trick to running two instances of mysqld on the same machine
is to specify the datadir on startup as in mysqld_safe
--datadir=/path/to/instance/one
in each datadir you will need to set up a my.cnf file with paths
specific to that instance. Example in instance/one/my.cnf you might
set
socket = /path/to/instance/one/mysqld.sock
port=3306

In instance two start mysqld_safe --datadir=/path/to/instance/two/
and set the variables
socket = /path/to/instance/two
port=3307

pid-file, log-error and a few other variables will need to be set in
the same way. A quick scan of one of the default my.cnf files should
tell you everything you need to change.

If you use the pre compiled statically linked binaries you won't have
to worry about versions of system libraries.


On Fri, 11 Feb 2005 15:53:55 +0000, Ben Clewett
<Ben.Clewett@stripped> wrote:
> 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
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
http://www.bleated.com
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