532 Part V . Advanced Performance Note The values for many of the columns in Figure 18-2 will be different in your output. The important column is the Slave_running column. This column should be Yes. If the Slave_running column in your output is Noor if all values are zero or 0, then the slave didn t start. Examine the error log for MySQL on the slave usually .err for clues. For instance, when I added a third server to the replication set (for another example), I neglected to add a privilege for that user from the new host. I received the error message shown in Figure 18-3. Once I added the user to the master, all was well. Replication on the slave automatically started itself when it retried in 60 seconds. Figure 18-3: An error on the slave server shows I forgot to add the replication user account on the master. Once replication is configured, MySQL automatically transfers a copy of the databases for replication. If these are large databases, you may want to transfer the databases manually via utility commands such as ftpor scp,which allows compression of the datafiles for quicker transfer. When the initial database transfer is complete, any changes made on the master will be automatically and instantly replicated to a connected slave including inserts, updates, and deletions. For example (in Figure 18-4), I issue a simple SELECT statement on a slave server which puts seven products into the table. Figure 18-4: A listing of items in the product table on a slave server
Searching for affordable and proven webhost to host and run your servlet applications? Go to Linux Web Hosting services and you will find it.
This entry was posted
on Tuesday, May 27th, 2008 at 3:57 am and is filed under Domain.
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.