MySQL Replication Simplified: Easy step-by-step examples to establish, troubleshoot and monitor replication

Name: MySQL Replication Simplified: Easy step-by-step examples to establish, troubleshoot and monitor replication
Rating: 3.75 (4 reviews)

Sribatsa Das

May 2014 · Sribatsa Das

3.8

4 reviews

Ebook

204

Pages

Eligible

Ratings and reviews aren’t verified Learn More

About this ebook

MySQL Replication Simplified explains how the replication process works and what the benefits are. Then, it provides detailed step-by-step east to understand examples with visuals to set up a variety of replication configurations including the process of copying master to replica, making configuration changes and commands to establish replication. This book offers ways to troubleshoot, especially to interpret errors and to repair broken replication. In the end, it provides a mechanism to monitor working replication to alert on the event of replication issues.
This book covers the following topics.

• What is MySQL Replication
• Benefits of replication
• How replication process works
• Replication configurations
• Components of Replication system
• Approach to replication
• Copying master to replica
• MySQL configuration parameters
• Commands useful to establish replication
• Setting up of replication user account
• Establishing various replication configurations
• Skipping SQL Errors
• Using SQL_Slave_Skip_Counter
• Experimenting with auto increment variables
• Interpreting show slave status output
• Understanding shows processlist
• Including & excluding databases & tables in replication
• Interpreting binary and relay log files using mysqlbinlog
• Troubleshooting and repairing broken replication
• Monitoring MySQL replication

Additional information can be found at http://mysqlreplicationsimplified.com.

Ratings and reviews

3.8

4 reviews

Andrew Glass

April 29, 2015

Whilst this book looked ideal for my needs, the grammar and style of writing is terrible. It reads like a robot with words missing from statements. A very difficult book to read as a result.

A Google user

December 9, 2016

Very useful book for MYsql replication .

Anil Das

November 29, 2020

AAA

About the author

Sribatsa Das holds a Bachelors and Masters in Computer Science. He holds an MBA from New York University’s Leonard N. Stern School of Business in Finance and Strategy.

Sribatsa’s passion is technology. He strives at bringing technological innovative products to life every day leveraging his long technology career and finance education. Sribatsa started as a DBA and application developer in his early career. After 20+ years long stint in IT and consulting, he embarked upon entrepreneurship

He launched Business Compass® LLC mobile app start-up venture in 2008. This start-up has launched 200+ mobile apps. MBA Sidekick, Mobile Statistics Professor® and Altman Z-Score+ are his key innovations. MBA Sidekick offers a full array of analytical tools to MBA students and professionals. MBA Statistics Professor provides tools to carry out college and MBA level statistical analysis. Altman Z-Score+ analyzes credit risk of companies worldwide including bond rating equivalent and up to 10 years of default probability. This product is available on Bloomberg Terminal via APPS ALTMAN <GO> command.

Business Compass LLC’s web sites are http://businesscompassllc.com and http://altmanzscoreplus.com.

Additional information about this book can be found at http://mysqlreplicationsimplified.com. Training is available to purchase at http://businesscompassllc.com/training.

Rate this ebook

Tell us what you think.

Reading information

Smartphones and tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and computers

You can listen to audiobooks purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.

Report illegal content