{"provider_name":"Hatena Blog","author_name":"takashikono","blog_url":"https://takashikono.hatenadiary.jp/","height":"190","type":"rich","provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/takashikono/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftakashikono.hatenadiary.jp%2Fentry%2F2021%2F08%2F17%2F141824\" title=\"CentOS 8 + MariaDB 10.5 \u306e \u53cc\u65b9\u5411\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3 + 1 read only replica \u3067 1 \u53f0 Main \u304c\u843d\u3061\u305f\u6642\u306e\u30b7\u30e5\u30df\u30ec\u30fc\u30b7\u30e7\u30f3 \u305d\u306e2 - takashi kono&#39;s blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","width":"100%","categories":[],"url":"https://takashikono.hatenadiary.jp/entry/2021/08/17/141824","title":"CentOS 8 + MariaDB 10.5 \u306e \u53cc\u65b9\u5411\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3 + 1 read only replica \u3067 1 \u53f0 Main \u304c\u843d\u3061\u305f\u6642\u306e\u30b7\u30e5\u30df\u30ec\u30fc\u30b7\u30e7\u30f3 \u305d\u306e2","published":"2021-08-17 14:18:24","image_url":null,"description":"\u76ee\u6b21 \u76ee\u6b21 Con1 \u306e MAIN \u306e mariadb \u30d7\u30ed\u30bb\u30b9\u304c\u843d\u3061\u305f\u6642\u306e\u5bfe\u5fdc\u3092\u3084\u3063\u3066\u307f\u308b \u524d\u56de\u306e\u8a18\u4e8b \u3084\u3063\u3066\u307f\u308b \u624b\u9806 radius0 \u3067 mariadb \u306e main pid \u3092\u8abf\u3079\u308b radius0 \u3067 mariadb \u3092 kill -9 \u3059\u308b Connection Con1 \u306e REPLICA \u3092 STOP \u3059\u308b radius1 \u3067 INSERT \u3057\u3066\u3001\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\u3059\u308b radius0 \u3067 mariadb \u306e\u4f59\u8a08\u306a\u5b50\u30d7\u30ed\u30bb\u30b9\u304c\u3042\u308c\u3070 kill \u3059\u308b \u5ff5\u306e\u70ba radius1 \u3067\u30c7\u30fc\u30bf\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u884c\u3046 radius0 \u3067 mariadb \u3092\u8d77\u52d5\u3059\u308b radius0 \u3067 Connect\u2026","blog_title":"takashi kono's blog"}