{"published":"2011-01-28 01:09:22","author_name":"rockstar2007","blog_title":"\u4e09\u5341\u8def\u30a8\u30f3\u30b8\u30cb\u30a2\u306e\u5099\u5fd8\u9332+\u03b1","blog_url":"https://rockstar2007.hatenadiary.org/","url":"https://rockstar2007.hatenadiary.org/entry/20110128/1296230962","provider_name":"Hatena Blog","image_url":null,"categories":["MySQL"],"provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Frockstar2007.hatenadiary.org%2Fentry%2F20110128%2F1296230962\" title=\"MySQL\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u52d5\u4f5c\u78ba\u8a8d\u3068\u4e0d\u5177\u5408\u6642\u306e\u5fa9\u65e7\u65b9\u6cd5 - \u4e09\u5341\u8def\u30a8\u30f3\u30b8\u30cb\u30a2\u306e\u5099\u5fd8\u9332+\u03b1\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/rockstar2007/","title":"MySQL\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u52d5\u4f5c\u78ba\u8a8d\u3068\u4e0d\u5177\u5408\u6642\u306e\u5fa9\u65e7\u65b9\u6cd5","type":"rich","height":"190","description":"\u3010\u52d5\u4f5c\u4e0d\u5177\u5408\u6642\u306e\u78ba\u8a8d\u65b9\u6cd5\u3011\u30b9\u30ec\u30fc\u30d6\u30b5\u30fc\u30d0\u3067\u3001 mysql> show slave status\\G; \u30fb \u30fb Read_Master_Log_Pos: 424597747 \u30fb Slave_IO_Running: Yes Slave_SQL_Running: Yes \u301cRunning\u304cNo\u306b\u306a\u3063\u3066\u3044\u305f\u3089\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u6b62\u307e\u3063\u3066\u3044\u307e\u3059\u3002\u30de\u30b9\u30bf\u30fc\u30b5\u30fc\u30d0\u3067\u3001 mysql> show master status\\G; File: mysql-bin.000108 Position: 424597871 Position\u306e\u5024\u3068\u30b9\u30ec\u30fc\u30d6\u30b5\u30fc\u30d0\u306eRead_Master_Log_Pos\u306e\u5024\u304c\u7570\u306a\u3063\u3066\u3044\u308b\u3068\u00d7\u3067\u2026","width":"100%","version":"1.0"}