536 Part V (Web design conference) . Advanced Performance Recall the
536 Part V . Advanced Performance Recall the current table contents for the ecommerceexample database (shown in Figure 18-10 for convenience). These values are taken from the slave server. Figure 18-10: The current contents of the products table I now insert a value on the new master server as shown: INSERT INTO product values ( , Clear and Present Danger , Harrison Ford , 19.99 , 3 , 2 , Harrison Ford in one of the Clancy Jack Ryan series. , 2 ); It is important to note that I updated this value on the new master server. If I inserted or performed any changes on the old master server, the slave or slaves would not see them. Keep this in mind for any applications that update or work with data. If you change replication master servers, those applications must be informed of the update so they send their information to the correct master server. Examining the table contents of the product table on the slave server again reveals the new product in the database, as shown in Figure 8-11. Ignore the missing ninth value in the idcolumn. This was expected and correct behavior. I made a slight mistake behind the scenes and had to delete a row. Therefore even the auto_incrementcarried over correctly. Maybe it wasn t a mistake after all, I wanted to show that auto_increment columns even worked when changing master servers. Figure 18-11: The new values in the product table show that replication is working from the new master.
Looking for affordable and reliable webhost to host and run your business application? Then look no more and go to servlet web hosting services.