{"id":348,"date":"2012-07-31T22:35:12","date_gmt":"2012-07-31T22:35:12","guid":{"rendered":"http:\/\/blog.trungson.com\/?p=348"},"modified":"2012-07-31T22:35:12","modified_gmt":"2012-07-31T22:35:12","slug":"nice-replication-setup","status":"publish","type":"post","link":"http:\/\/blog.trungson.com\/?p=348","title":{"rendered":"Nice replication setup"},"content":{"rendered":"<p>If you have a chain replication: A=&gt;B=&gt;C. If B is out of sync for some reason, C will be out of sync and you need to rebuild. The nice thing is that when B is rebuilt, it automatically rebuilds all its slaves (C1, C2, C3, etc.) because B&amp;C are still in replication, the DROP IF EXISTS and those INSERTs will run as normal, which is very nice because you can have a few secondary head slaves (B1, B2, B3) and then hundreds\/thousands of real slave (C1,C2,C3,C4,C5). They will cascade data down the chain when you only have to rebuild the secondary masters.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have a chain replication: A=&gt;B=&gt;C. If B is out of sync for some reason, C will be out of sync and you need to rebuild. The nice thing is that when B is rebuilt, it automatically rebuilds all its slaves (C1, C2, C3, etc.) because B&amp;C are still in replication, the DROP IF [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts\/348"}],"collection":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=348"}],"version-history":[{"count":1,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts\/348\/revisions"}],"predecessor-version":[{"id":349,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts\/348\/revisions\/349"}],"wp:attachment":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=348"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}