Disney web site - Chapter 18 . Replication 533 In Figure 18-5,
Chapter 18 . Replication 533 In Figure 18-5, I send the following SQL statement to put a new product on the master server: INSERT INTO product values ( , Next Friday , Ice Cube , 19.99 , 34 , 2 , Follow up to Friday. Another great Ice Cube movie. , 2 ); Figure 18-5: The INSERT statement, performed on the master server Figure 18-6 shows the same query from Figure 18-4 on the slave server. Note that the new insert that was performed on the master is propagated to the slave. Figure 18-6: The INSERT statement on the slave that propagated automatically from the master as part of the slave s replication update If a slave becomes disconnected for a normal reason, such as a SLAVE STOP command, the slave remembers its position and can catch up with any updates once it restarts. If the slave stops for an abnormal reason such as a system crash, the slave may not be able to correctly re-initialize and find its position to catch up with updates. I ve seen either outcome from situations in which the MySQL server was killed abruptly on the slave upon restart, sometimes the slave process caught up successfully, and sometimes it could not find its place. Multiple slave replication Configuring replication for multiple slaves is as simple as repeating the steps for configuring a basic replication. On the master, make sure that the replication user is granted the FILE privilege from the new slave host. Add the lines to the configuration file of the new slave host, just as you did for the first slave.
You need excellent and relaible webhost company to host your web applications? Then pay a visit to Inexpensive Web Hosting services.