Re: multiple instances in win 7 -- any idea

[Claudio Nanni]

Hi Charles,

it is very easy to run multiple mysql instances and of different versions
as well on the same server, including windows.

You just have to download the .zip version, NOT the installer.

The archive you get is basically a separate independent mysql instance that
can live fully in its own directory.

Unzip the archive/s in separate folders and create/copy the my.ini in the
root of that folder changing just two parameters:

ex:

c:\mysql3331

c:\mysql3332


Instance #1
-
file:c:\mysql3331\my.ini

[client]
port = 3331
socket = /tmp/mysql3331.sock
[mysqld]
port = 3331
socket = /tmp/mysql3331.sock
basedir = c:\mysql3331

Instance #2
-
file:c:\mysql3332\my.ini

[client]
port = 3332
socket = /tmp/mysql3332.sock
[mysqld]
port = 3332
socket = /tmp/mysql3332.sock
basedir = c:\mysql3332

set the right paths and enjoy.

you can quickly test if the server starts normally  by going into each
basedir with the prompt and running   bin\mysqld.exe

then on different terminals bin\mysql.exe -urootto login

Cheers

Claudio


2012/5/14 Shawn Green 

> On 5/13/2012 6:53 PM, Brown, Charles wrote:
> > I'm trying to install multiple instances of mysql on windows 7, 64bit.
> 3hrs into the job, I'm not making progress. Does anyone have an idea?
>
> 1) The installers are designed to work on single-instance installs or
> upgrades.
>
> 2) You only need one install to run multiple copies of the same release.
> The trick is to configure the necessary parts to be unique values between
> the instances
>
> 3) Each instance needs its own copy of unique data. No two active
> instances can share data.
>
> 4) The list of other items that must be unique per instance is listed here:
> http://dev.mysql.com/doc/**refman/5.5/en/multiple-**servers.html
>
> 5) (mailing list rule) - avoid hijacking other threads
>
> 6) (general support advice) - when having a problem, try to provide
> descriptive details regarding what you are trying to do, any commands you
> are using, and what types of failures you are encountering (including any
> error messages you are receiving). This usually allows anyone trying to
> help you to respond in a more focused and less general way.
>
> Warmest regards,
> --
> Shawn Green
> MySQL Principal Technical Support Engineer
> Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
> Office: Blountville, TN
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>


-- 
Claudio

Re: multiple instances in win 7 -- any idea

[Shawn Green]

On 5/13/2012 6:53 PM, Brown, Charles wrote:
> I'm trying to install multiple instances of mysql on windows 7, 
64bit. 3hrs into the job, I'm not making progress. Does anyone have an idea?


1) The installers are designed to work on single-instance installs or 
upgrades.


2) You only need one install to run multiple copies of the same release. 
The trick is to configure the necessary parts to be unique values 
between the instances


3) Each instance needs its own copy of unique data. No two active 
instances can share data.


4) The list of other items that must be unique per instance is listed here:
http://dev.mysql.com/doc/refman/5.5/en/multiple-servers.html

5) (mailing list rule) - avoid hijacking other threads

6) (general support advice) - when having a problem, try to provide 
descriptive details regarding what you are trying to do, any commands 
you are using, and what types of failures you are encountering 
(including any error messages you are receiving). This usually allows 
anyone trying to help you to respond in a more focused and less general 
way.


Warmest regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

multiple instances in win 7 -- any idea

[Brown, Charles]

I'm trying to install multiple instances of mysql on windows 7, 64bit. 3hrs 
into the job, I'm not making progress. Does anyone have an idea?


This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql