Replication 18 1818 CHAPTER An area that has (Web host sites)
Replication 18 1818 CHAPTER An area that has received a lot of attention from the MySQL development team has been replication. Replication refers to the automated copying of changes made to databases and data between two or more MySQL servers. The MySQL development team has made replication in MySQL a robust and stable feature. As part of my daily routine, I manage a fairly large-scale database that is replicated across five states in real time using MySQL replication. The system has been operational for two years with very little difficulty. Even two years ago, replication in MySQL was stable. The stability and added features of today s MySQL replication make it a good choice for redundancy and mission-critical applications alike. This chapter looks at MySQL replication, including how to install and configure replication between two or more MySQL servers. MySQL AB has gone to great lengths to make replication configuration easy as you ll see in the following pages. Planning and Preparing for Replication Before undertaking the tasks involved in actually setting up replication, take some time to plan and prepare for those tasks. The planning includes making sure replication is right for your implementation, deciding what databases or tables will be replicated, how many servers will participate in the replication, and how you will monitor replication. Preparing for replication includes ensuring that all participating servers are running on the same MySQL version. …. In This Chapter Getting ready for replication Setting your configurations for replication Keeping an eye on replication Using replication shortcuts ….
We recommend you use shared web hosting services, because many users agree that it is cheap, reliable and customer-satisfying webhost.