{"title":"mysql\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3","provider_url":"https://hatena.blog","image_url":null,"description":"MySQL\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u8a2d\u5b9a \u57fa\u672c\u7684\u306a\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u3064\u3044\u3066\u3001master-slave1\u53f0\u3065\u3064\u306e\u69cb\u6210\u3092\u30b5\u30f3\u30d7\u30eb\u306b\u3057\u3066\u307e\u3059\u3002 master(192.168.1.11) slave(192.168.1.12) master\u306e\u8a2d\u5b9a \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u7528\u30e6\u30fc\u30b6\u30fc\u306e\u4f5c\u6210 slave(192.168.1.0/24)\u304b\u3089server2\u3068\u3044\u3046\u30e6\u30fc\u30b6\u30fc\u3067relay_log\u3092\u53d6\u5f97\u3057\u306b\u304f\u308b\u8a31\u53ef\u3092\u3059\u308b > GRANT REPLICATION SLAVE ON *.* TO 'server2'@'192.168.1.0/255.255.255.0'; my.cnf [mysqld] log-bin=mysql-bi\u2026","url":"https://swfz.hatenablog.com/entry/2014/08/31/233321","author_name":"swfz","published":"2014-08-31 23:33:21","version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fswfz.hatenablog.com%2Fentry%2F2014%2F08%2F31%2F233321\" title=\"mysql\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3 - notebook\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","provider_name":"Hatena Blog","height":"190","width":"100%","blog_url":"https://swfz.hatenablog.com/","categories":["MySQL"],"blog_title":"notebook","author_url":"https://blog.hatena.ne.jp/swfz/"}