MySQL Replication — An Administrator’s Guide

About the Publisher

About the Book

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

The author, Russell Dyer was born in New Orleans and lived most of his life there, but now lives in Milan, Italy. Since his father died when he was only three, his mother remarried about five years later.

He graduated from Loyola University in New Orleans primarily with a degree in English, and went to Southeastern Louisiana University for a master's degree in English. When he was younger, he worked for over ten years in the investment business in various roles from a clerk to a broker to a corporate executive. He now works in the software business as a writer and editor, in which he has written hundreds of articles and several books on software.

Related to fiction writing, besides having written several short stories, he wrote a humorous novel called In Search of Kafka, which can be purchased on Amazon’s site. This novel is his second one published. However, he started another one before it called, Not a Step. It’s nearly finished and should be published in early 2018.


Reader Statistics

Below are statistics related to visitors of this site.

visits for month
visitors: 3549
pages: 26400
popular pages
writing tools: equipment and software (882 hits)
remembering the point (815 hits)
how to write a novel, part iii (planning) (767 hits)
how to write a novel, part i (getting started) (764 hits)
how to write a novel, part ii (writing at length) (762 hits)
top countries

Other Books by Author

Below are a few other books written by the same author. Click on the book cover image to go to a site where you can buy it.

In Search of Kafka

A High-Tech. Comical Thriller about a Computer Programmer who tangles with Homeland Security, Eastern European Hackers, and Starbucks.

I Have No Friends

Story of a woman who finds herself alone and feels unloved. She has no friends. She is content with this, but others see things differently for her.

The Loneliness of Lena [Russian]

Story of a woman who finds herself alone and feels unloved. She has no friends. She is content with this, but others see things differently for her.

The Loneliness of Lena

Story of a woman who finds herself alone and feels unloved. She has no friends. She is content with this, but others see things differently for her.