Re: MY SQL Slave Server
Hi Vikram, Download some other version and install. Use the higher version as slave. Regards, Thiyaghu CK On Sat, Feb 6, 2010 at 10:08 PM, Vikram A 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 > *To:* Vikram A > *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 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 >> *To:* Vikram A >> *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 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<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/> >> . >> > > > -- > Your Mail works best with the New Yahoo Optimized IE8. Get it > NOW!<http://in.rd.yahoo.com/tagline_ie8_new/*http://downloads.yahoo.com/in/internetexplorer/> > . >
Re: MY SQL Slave Server
*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 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 > To: Vikram A > 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 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 > >To: Vikram A > >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 wrote: > > > >> Dear Experts, > >> > >> I would like to configure the slave for my main server. My server is > >> run
Re: MY SQL Slave Server
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 To: Vikram A 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 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 >To: Vikram A >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 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/
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 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/
MY SQL Slave Server
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/
