At 3:03 -0300 7/26/02, miguel solorzano wrote:
>At 19:07 25/7/2002 -0700, Bhavin Vyas wrote:
>Hi,
>
>>From what little I know of MySql on Windows, it runs as a service and you
>>can't run multiple services on the same Win Server.
>
><cut>
>
>From 4.0.2 release you are able to run several services. For example:
>
>For to run two services: the first one using mysqld-nt.exe and the
>second one using the mysqld-max-nt.exe.
>
>Installing mysqld-nt.exe
>
>command at the prompt:
>mysqld-nt --install
>
>or
>
>mysqld-nt --install-manual
>
>Installing mysqld-max-nt.exe
>
>command at the prompt:
>
>mysqld-max-nt --install mysqldopt
>
>or
>
>mysqld-max-nt --install-manual mysqldopt
>
>Now you have the default service called mysql for to run mysqld-nt.exe
>and the service mysqldopt for to run mysqld-max-nt.exe.
>
>Now you edit the /winnt/my.ini file:
>
>[mysqld] #for to set the server mysqld-nt.exe
>port=3306
>basedir=c:/mysql
>datadir=c:/mysql/data
>
>.....
>
>[mysqldopt] #for to set the server mysqld-max-nt.exe the same name of
> #the service
>port=3307
>basedir=c:/mysql
>datadir=d:/mysqldopt/data
>skip-innodb
>skip-bdb
>.....
Thanks, Miguel. This sounds promising. I don't see anything about this
in the 4.0.2 change notes, and I have some questions about how this works:
- What does the argument after the --install argument represent? Is it a
service name? Does it cause the server to use a different default named
pipe name? Is this value case sensitive?
- When an argument is given after --install, that argument becomes the name
of the option file group that the server reads from option files? Does it
still read [mysqld], or *only* [mysqlopt]?
- How do you remove the service? Do you give the same argument after --remove,
for example: mysqld-max-nt --remove mysqldopt
>
>Notes:
>
>1- You can use the same basedir but not the same executable.
>2- You must to have a different datadir (the whole directory) for
> each server. You can't to mix the mysql database and the working
> databases.
>3- You need to have a different port.
>
>In this way for example you can use one server as master and the other
>as slave on the same machine; of course both handling the same type of
>tables. In the example above only MyISAM tables.
>
>
>
>Regards,
>--
>For technical support contracts, visit https//order.mysql.com
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Miguel Angel Solórzano
> <miguel@stripped>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
>/_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil
> <___/ www.mysql.com
