| Troubleshooting |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | When the slave stops/dies/etc. |
||||||||||||
| – | Check the MySQL error log |
||||||||||||
| – | Run SHOW SLAVE STATUS |
||||||||||||
| – | Notice the query that is stuck |
||||||||||||
| – | Maybe skip the current query and move on? |
||||||||||||
| • | SET
GLOBAL SQL_SLAVE_SKIP_COUNTER = 1 |
||||||||||||
| – | Did all the slaves have the same problem, or |
||||||||||||
| just this one? |
|||||||||||||
