MySQL automatically checks and starts a small way to slave threads to improve operational efficiency

1. Problem

Some company database architecture is two master multi-slave, double live across IDC room, so there is a problem. The synchronization of databases across computer rooms will inevitably

There is a network jitter, an exception that is caused by the slave Io,slave SQL thread shutdown situation.

2. Solution to the thinking

1) Write a script to monitor the slave status regularly

2) Use Shell to write

3) Use crontab per minute to check, judge, and then execute the start slave according to judgment.

The specific wording, need everyone to write their own, only in this way can be promoted.

Knowledge points

1) crontab usage, check every number of minutes

2) shell if [] then judge to complete.

This article is from the "ROIDBA" blog, make sure to keep this source http://roidba.blog.51cto.com/12318731/1887163

MySQL automatically checks and starts a small way to slave threads to improve operational efficiency