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 <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer >/_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil > <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
