Replication is an excellent way to protect data and ensure uninterrupted service. For systems administrators who know the basics of MySQL, this book can help them to learn about MySQL Replication and assist them in keeping replication running or to get it running again when it inevitably stops. Despite its moderate size, this book contains a great deal. It contains three parts, as well as some very useful appendices: Part I lays out the replication process and how to prepare a server for replication. Understanding the process is essential to solving problems. Part II presents the steps for initializing a slave server and then shown how to start replication and make sure it's running. Part II covers on-going administration related to replication servers. This includes making backups of databases and how to restore them, smoothly. The last chapter covers the basics of load balancing methods. The reference information in the appendices will be one of the reasons to keep this book handy for a long time: Appendix A provides explanations and examples of the MySQL functions related to replication. Appendix B explains the MySQL replication states, the primary clues when replication fails and won't restart. Appendix C lists the options for mysqld related to replication and information on setting them well, and covers a few other command-line utilities that are invariably used in replication.

About the Author

Russell Dyer, a writer who specializes in open-source software, in particular in MySQL database software, was the editor of the MySQL Knowledge Base for over five years. He has written hundreds of articles on MySQL and also wrote MySQL in a Nutshell for O'Reilly Media, which has been translated to several languages and is now in its second edition.

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Seller's business information

Edward Bowditch Ltd
Exstowe, Exton, Exeter, EX3 0PP, United Kingdom

Sale & Shipping Terms

Terms of Sale

Legal entity name: Edward Bowditch Ltd
Legal entity form: Limited company
Business correspondence address: Exstowe, Exton, Exeter, EX3 0PP
Company registration number: 04916632
VAT registration: GB834241546
Authorised representative: Mr. E. Bowditch

Shipping Terms

Orders usually dispatched within two working days. Please note that at this time all domestic United Kingdom orders are sent by trackable UPS courier, we choose not to offer a lower cost alternative.

Shipping rates from United Kingdom to U.S.A.

Shipping rates from United Kingdom to U.S.A.
Order quantity	7 to 14 business days	2 to 3 business days
First item	US$ 13.15	US$ 19.73

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.