{"id":205,"date":"2012-04-11T11:51:13","date_gmt":"2012-04-11T02:51:13","guid":{"rendered":"http:\/\/lumieir.net\/blog\/?p=205"},"modified":"2012-04-11T11:51:13","modified_gmt":"2012-04-11T02:51:13","slug":"mysql%e3%81%aeslave%e3%81%a7%e3%82%a8%e3%83%a9%e3%83%bc%e3%82%92%e3%82%b9%e3%82%ad%e3%83%83%e3%83%97%e3%81%97%e3%81%9f%e3%81%84","status":"publish","type":"post","link":"http:\/\/lumieir.net\/blog\/2012\/04\/mysql%e3%81%aeslave%e3%81%a7%e3%82%a8%e3%83%a9%e3%83%bc%e3%82%92%e3%82%b9%e3%82%ad%e3%83%83%e3%83%97%e3%81%97%e3%81%9f%e3%81%84\/","title":{"rendered":"MySQL\u306eSLAVE\u3067\u30a8\u30e9\u30fc\u3092\u30b9\u30ad\u30c3\u30d7\u3057\u305f\u3044"},"content":{"rendered":"<p>1) show slave status;<br \/>\n\u3057\u3066\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u7531\u6765\u3059\u308b\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u6b62\u307e\u3063\u3066\u3044\u308b\u3088\u3046\u3060\u3063\u305f\u3089<\/p>\n<p>2) set global sql_slave_skip_counter=1;<br \/>\n\u3057\u3066<\/p>\n<p>3) start slave;<br \/>\n\u3059\u308b\u3068OK\u3002\u307e\u305f1\u3092\u3084\u3063\u3066\u307f\u3066\u4ed6\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u3044\u308b\u3088\u3046\u3060\u3063\u305f\u3089\u7e70\u308a\u8fd4\u3057\u3002<\/p>\n<h3 class='related_post_title'>\u95a2\u9023\u8a18\u4e8b:<\/h3><ul class='related_post'><li><a href=\"http:\/\/lumieir.net\/blog\/2012\/01\/my-cnf%e3%81%ab%e6%9b%b8%e3%81%8f%e6%96%87%e5%ad%97%e3%82%b3%e3%83%bc%e3%83%89%e8%a8%ad%e5%ae%9a\/\" title=\"my.cnf\u306b\u66f8\u304f\u6587\u5b57\u30b3\u30fc\u30c9\u8a2d\u5b9a\">my.cnf\u306b\u66f8\u304f\u6587\u5b57\u30b3\u30fc\u30c9\u8a2d\u5b9a<\/a><\/li><li><a href=\"http:\/\/lumieir.net\/blog\/2009\/07\/mysql%e3%81%ae%e3%83%ac%e3%83%97%e3%83%aa%e3%82%b1%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b3\/\" title=\"MySQL\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\">MySQL\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>1) show slave status; \u3057\u3066\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u7531\u6765\u3059\u308b\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u6b62\u307e\u3063\u3066\u3044\u308b\u3088\u3046\u3060\u3063\u305f\u3089 2) set global sql_slave_skip_counter=1; \u3057\u3066  &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"http:\/\/lumieir.net\/blog\/2012\/04\/mysql%e3%81%aeslave%e3%81%a7%e3%82%a8%e3%83%a9%e3%83%bc%e3%82%92%e3%82%b9%e3%82%ad%e3%83%83%e3%83%97%e3%81%97%e3%81%9f%e3%81%84\/\"> <span class=\"screen-reader-text\">MySQL\u306eSLAVE\u3067\u30a8\u30e9\u30fc\u3092\u30b9\u30ad\u30c3\u30d7\u3057\u305f\u3044<\/span> \u7d9a\u304d\u3092\u8aad\u3080 &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,4],"tags":[54,9],"class_list":["post-205","post","type-post","status-publish","format-standard","hentry","category-mysql-tech","category-tech","tag-mysql","tag-9"],"_links":{"self":[{"href":"http:\/\/lumieir.net\/blog\/wp-json\/wp\/v2\/posts\/205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/lumieir.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/lumieir.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/lumieir.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/lumieir.net\/blog\/wp-json\/wp\/v2\/comments?post=205"}],"version-history":[{"count":1,"href":"http:\/\/lumieir.net\/blog\/wp-json\/wp\/v2\/posts\/205\/revisions"}],"predecessor-version":[{"id":206,"href":"http:\/\/lumieir.net\/blog\/wp-json\/wp\/v2\/posts\/205\/revisions\/206"}],"wp:attachment":[{"href":"http:\/\/lumieir.net\/blog\/wp-json\/wp\/v2\/media?parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/lumieir.net\/blog\/wp-json\/wp\/v2\/categories?post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/lumieir.net\/blog\/wp-json\/wp\/v2\/tags?post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}