Paperback: 296 pages
Publisher: McGraw-Hill Education; 1 edition (October 16, 2012)
Product Dimensions: 6.2 x 0.6 x 9 inches
Shipping Weight: 15.2 ounces (View shipping rates and policies)
Average Customer Review: 4.6 out of 5 stars See all reviews (8 customer reviews)
Best Sellers Rank: #1,216,135 in Books (See Top 100 in Books) #155 in Books > Computers & Technology > Databases & Big Data > MySQL #386 in Books > Computers & Technology > Databases & Big Data > Data Warehousing #578 in Books > Computers & Technology > Databases & Big Data > Data Modeling & Design
Effective MySQL: Replication Techniques in DepthRonald BradfordOracle Press270 pagesRonald Bradford has a way of distilling a great deal of information into eight chapters unlike any otehr author on MySQL. Replication has been one of the more popular features of MySQL, allowing it to blossom into environments ranging from the simplest to the awesomely complex. Usually replication is simple, predictable, and easy to manage. But this book is written for the MySQL DBA on the front lines looking for better, more resilient way of keeping data flowing. This is the latest of a series of books that cover one aspect of MySQL in a concise, no-fluff fashion. But what is this book like?The first chapter is titled The Five Minute DBA and it shows how to identify and correct problems. The second chapter expands on the lessons from the first chapter by examining the architecture and then delves into more generic problems. The third chapter covers improvements past asynchronous replication and securing the servers via SSL. New features in the MySQL 5.6 DMR are covered.The forth chapter is on Multi-Master Replication which leads directly into a chapter on MySQL Replication tools from many vendors -- Openark Kit, Percona Toolkit, MySQL Workbench Untilites -- and how to use them effectively to manage replication. MySQL MHA, MMM, Cluster Control, and Flipper are introduced as fail over managers.Chapter 6 -- Extending Replication for Practical Needs will be of great help for those exploring beyond tradition MySQL Replication. Ronald covers MySQL Cluster and Galera Cluster. He notes correctly that MySQL Cluster is a different product than the MySQL Server.
Effective MySQL Replication Techniques in Depth is a must have for any shop running MySQL replication. I've never written a review before, but felt compelled to write one for this book because it's that good. I've been a MySQL DBA for over 7 years and have been using replication since day 1 of our installation. I am in charge of over 25 MySQL and Oracle databases, running 6 MySQL masters and 15 MySQL slaves. We have various versions and flavors, from MySQL community 5.0.45 to Oracle and Percona Server 5.5. Up until a few months ago we had only been doing basic replication. Now we are also replicating to the cloud. This book would've helped tremendously with SSL replication, I wish I had it then. And wouldn't you know it, the first paragraph on SSL replication mentions how more organizations are implementing cloud services.The book is very well laid out. It shows real-world scenarios, across multiple versions of MySQL (including 5.6 DMR!). The language is clear, and there are easy to follow diagrams to help with explanations and one of the most important things, in my opinion, to have, the actually input of commands and its results. Make no mistake, this isn't just a book from Oracle Press with a corporate juggernaut behind it and some marketing scheme, Ronald & Chris also talk about Percona Toolkit and other software and tools from other developers and how to use them. It's a no-nonsense, in-depth talk about MySQL replication.Now, onto why I bought this book.