{"height":"190","blog_url":"https://kagasu.hatenablog.com/","provider_name":"Hatena Blog","title":"MariaDB\u3067\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3059\u308b\u65b9\u6cd5","published":"2021-05-07 21:11:38","version":"1.0","blog_title":"\u5099\u5fd8\u9332","categories":["MariaDB"],"author_name":"kagasu","url":"https://kagasu.hatenablog.com/entry/2021/05/07/211138","description":"\u2160. \u306f\u3058\u3081\u306b \u30bf\u30a4\u30c8\u30eb\u306e\u901a\u308a\u300cMariaDB\u3067\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3059\u308b\u65b9\u6cd5\u300d\u3067\u3059\u3002 \u2161. \u3084\u308a\u65b9 1. Master\u5074\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3059\u308b server.cnf [mysqld] server-id = 1 log-bin expire_logs_days = 3 max_binlog_size = 500M 2. Master\u5074\u306eDB\u3092\u30c0\u30f3\u30d7\u3059\u308b mysqldump -u root -p --all-databases --flush-logs --single-transaction --master-data=2 > dump.sql 3. Slave\u5074\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3059\u308b server.cnf \u2026","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/k/kagasu/20210507/20210507211100.gif","width":"100%","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkagasu.hatenablog.com%2Fentry%2F2021%2F05%2F07%2F211138\" title=\"MariaDB\u3067\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3059\u308b\u65b9\u6cd5 - \u5099\u5fd8\u9332\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/kagasu/"}