means that you should never change thedata on a replication slave. If you dochangedata on a slave, the master and slave serversget out of synch, and you may lose data. Whenyou create a slave, you start with a copy of thedata as it exists on the master. MySQL lets you choose which tables you want toreplicate (you don t have to replicate all the tables ina database). That means that a single server can actas both a master and a slave, as long as it s a masterfor some tables and a slave for others. Setting up replication for a single slave and masterCreating a single-slave/single-master topology is easy, but you have to do a bit of work on both the masterand slave servers, as outlined in the following steps: 1.Log in to your MySQL server on the replicationmaster: # mysqlWelcome to the MySQL monitor. Commandend with ; or \g. Your MySQL connection id is 5 to serverversion 3.23.58Type help; or \h for help. Type \c to clear the buffer. mysql> 2.Create a new MySQL user account the repli- cation slave will log into the replication masterusing this account: mysql> GRANT FILE ON *.* TO repl_slave IDENTIFIED BY repl_pass ; Query OK, 0 rows affected (0.13 sec) 3.Exit MySQL and shut down the server: mysql> quit# service mysqld stop4.Create a backup of all the databases that youwant to replicate: # cd /var/lib/mysql# ls mysql prod devel# tar -zcvf data.tgz prod develprod/ prod/cust.frmprod/cust.MYIprod/cust.MYD… 5.Copy the archive (data.tgz) to the replicationslave: # scp data.tgz slave:/tmp/data.tgztest.tgz 100% 108.0KB/s 00:056.Edit the /etc/my.cnffile and find the sectionthat starts with[mysqld] datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock7.Add the following lines to the end of that section: log-binserver-id = 18.Restart the master server: # service mysqld startOn the replication slave(s), follow these steps: 1.Shut down the MySQL server: # service mysqld stop2.Edit the /etc/my.cnffile and find the sectionthat starts with[mysqld] datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock3.Add the following text to the end of that section: master-host = master-hostnamemaster-user = repl_slavemaster-password = repl_passserver-id = 24.Unpack the archive you made on the server: # cd /var/lib/mysql54_
You need excellent and relaible webhost company to host your web applications? Then pay a visit to Inexpensive Web Hosting services.

definition a loan of subprime

The breakthrough came after credit loans for installment poor Aviation Safety Agency (EASA) and the United Arab Emirates-based General Civil Aviation Authority (GCAA) granted full approval for the AeroMobile system to be used on Emirates.

This entry was posted on Thursday, March 20th, 2008 at 6:07 am and is filed under JBOSS. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.