tag:blogger.com,1999:blog-9144505959002328789.post4753574959223139269..comments2024-03-28T11:39:50.622+01:00Comments on Karlsson on databases and stuff: Automatically restarting MySQL slaves the easy way.Karlssonhttp://www.blogger.com/profile/04874338187076980133noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-9144505959002328789.post-70103587407449452612011-06-02T23:31:35.395+02:002011-06-02T23:31:35.395+02:00Thanx Matt. I'll fix that.
Andrew: Yes, I ass...Thanx Matt. I'll fix that.<br /><br />Andrew: Yes, I assumed that maatkit has something like this, but I hope I have added something to it at least.<br /><br />Cheers<br />/KarlssonKarlssonhttps://www.blogger.com/profile/04874338187076980133noreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-29319037630959103192011-06-02T23:14:50.908+02:002011-06-02T23:14:50.908+02:00@Andrew: sometimes people like to write their own ...@Andrew: sometimes people like to write their own scripts. Maatkit has some good scripts but they don't always do exactly what you need for your specific environment, or you want something more portable that doesn't require perl or etc etc etc. Might as well as why we're not using Oracle instead of MySQL.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-49643453028284199952011-06-02T23:12:48.736+02:002011-06-02T23:12:48.736+02:00on line 220 you might want to have it issue "...on line 220 you might want to have it issue "stop slave; set global sql_slave_skip_counter=1;slave start;". Omitting the stop slave command might make the script barf when trying to issue a skip counter in some (not all) error situations. Better to be sure it's fully stopped as sometimes only the SQL or IO thread will be stopped due to an error and they both have to be OFF for the skip counter to work.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-52484309389406155902011-06-02T22:24:18.456+02:002011-06-02T22:24:18.456+02:00Why not maatkit's mk-slave-restart? :)Why not maatkit's mk-slave-restart? :)Andrewhttps://www.blogger.com/profile/01066694104880792602noreply@blogger.com