*MySQL Install multiple instances.*
Create a folder called Conf with Instance.1.ini, Instance.2.ini, and
Instance.3.ini.
The Port each are listening on should all differ, as well as having a
different data directory.
I named these
C:\Program Files\MySQL\MySQL Server 5.0\MySQLData\Instance1
mysqld --install "Mysql-Instance-1" --defaults-file="C:\Program
Files\MySQL\MySQL Server 5.0\Conf\Instance.1.ini"
mysqld --install "Mysql-Instance-2" --defaults-file="C:\Program
Files\MySQL\MySQL Server 5.0\Conf\Instance.2.ini"
mysqld --install "Mysql-Instance-3" --defaults-file="C:\Program
Files\MySQL\MySQL Server 5.0\Conf\Instance.3.ini"
in the ini file the commands to set these are:
* port=3306
* datadir="C:\Program Files\MySQL\MySQL Server 5.0\MySQLData\Instance1"
* port=3307
* datadir="C:\Program Files\MySQL\MySQL Server 5.0\MySQLData\Instance2"
* port=3308
* datadir="C:\Program Files\MySQL\MySQL Server 5.0\MySQLData\Instance3"
After creating the folders, settings and executing the command lines to
install mysql as a service. I found that all the services successfully
started up and then terminated itself and in the folder
".\MySQLData\Instance1" etc, you should notice the following files,
ib_logfile0, ib_logfile1, ibdata1 and %SystemName%.err, which displays the
following error on each instance.
051220 22:16:28 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
Which simply means it cannot find the system tables. A quick resolve is to
copy the entire data directory into each instance folder (Ensure that the
standard instance is disabled if you wish to leave this service alone). Then
the service should hopefully startup for all 3 services.
xcopy data "MySQLData/Instance1"
xcopy data "MySQLData/Instance2"
xcopy data "MySQLData/Instance3"
net start "Mysql-Instance-1"
net start "Mysql-Instance-2"
net start "Mysql-Instance-3"
PS. To remove the instances enter the following commands.
mysqld --remove "Mysql-Instance-1"
mysqld --remove "Mysql-Instance-2"
mysqld --remove "Mysql-Instance-3"
source: http://ajohnstone.com/archives/mysql-install-multiple-instances
On Sat, Feb 6, 2010 at 10:08 PM, Vikram A <vikkiatb...@yahoo.in> wrote:
> I tried to install once again mysql at vista? but deducts the previous
> installation. and it is ask for the modify , repire and remove options
>
> You said that we can install any number of setups in a same system.
>
> Is there any other way to install?
>
> Please help me
>
> thank you
>
>
>
>
>
>
> ________________________________
> From: Thiyaghu CK <theyaho...@gmail.com>
> To: Vikram A <vikkiatb...@yahoo.in>
> Sent: Sat, 6 February, 2010 3:05:25 PM
> Subject: Re: MY SQL Slave Server
>
> Hi Vikram,
>
> Ya sure, slave can be in vista. Yes, you can install 2 or more setups in
> same system but port has to be different, and if its linux platform change
> the sock name too.
>
> Regards,
> Thiyaghu CK
> www.mafiree.com
>
>
> On Sat, Feb 6, 2010 at 2:09 PM, Vikram A <vikkiatb...@yahoo.in> wrote:
>
> Dear Thiyagu!
> >
> >Thank you for the information. I will do the experiment. and let you know
> the further details.
> >
> >Is it possible making slave at windows vista? As per your information, th
> emysql has to be installed once again another port; Is it possible to
> install 2 setups in a same system?
> >
> >Thank you
> >
> >VIKRAM A
> >
> >
> >
> >
> >
> >
> ________________________________
> From: Thiyaghu CK <theyaho...@gmail.com>
> >To: Vikram A <vikkiatb...@yahoo.in>
> >Cc: mysql@lists.mysql.com
> >Sent: Sat, 6 February, 2010 1:03:34 PM
> >Subject: Re: MY SQL Slave Server
> >
> >
> >Hi Vikram,
> >
> >So as my understanding you need to have a master slave setup in a single
> >>machine(FEDORA 11).
> >
> >1. Make the already running mysql instance as Master
> >2. Install a new mysql in the same machine in different port which will be
> >your slave
> >3. Replicate
> >4.You can also add more slave in same machine or in different machine and
> >>make more copy.
> >
> >Note: Slave should be of same version or higher.
> >
> >For replication steps you can refer http://www.mafiree.com/docs.html
> >or http://www.howtoforge.com/mysql_database_replication
> >
> >Let me know for more details.
> >
> >Regards,
> >Thiyaghu
> > CK
> >www.mafiree.com
> >
> >On Sat, Feb 6, 2010 at 12:33 PM, Vikram A <vikkiatb...@yahoo.in> wrote:
> >
> >> Dear Experts,
> >>
> >> I would like to configure the slave for my main server. My server is
> >> running in the FEDORA 11.
> >> I would like to make another mirror of the DB in the same server/ The
> copy
> >>> of the DB can be kept at win server / another Fedora server.
> >>
> >> Can you suggest how to do the above?
> >>
> >> Thank you
> >>
> >> VIKKI A
> >>
> >>
> >> The INTERNET now has a personality. YOURS! See your Yahoo!
> Homepage.
> >>> http://in.yahoo.com/
> >
> >________________________________
>
> >>The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
>
>
>
> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> http://in.yahoo.com/
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
