{"id":166,"date":"2016-08-12T08:52:04","date_gmt":"2016-08-12T06:52:04","guid":{"rendered":"http:\/\/www.ritter.cc\/?page_id=166"},"modified":"2016-08-15T15:04:14","modified_gmt":"2016-08-15T13:04:14","slug":"mysql-master-master-replikation","status":"publish","type":"page","link":"https:\/\/www.ritter.cc\/?page_id=166","title":{"rendered":"MySQL &#8211; Master Master Replikation"},"content":{"rendered":"<p><strong>SETUP<\/strong><br \/>\nAls erstes sollte man pr\u00fcfen, ob die notwendigen Voraussetzungen in der my.cnf vorhanden sind.<br \/>\nBei Multi Master Setup\u00b4s muss zun\u00e4chst darauf geachtet werden, dass Auto Increment werte auf allen Servern nicht die gleichen Werte verursachen, da dies zu Replikationsproblemen (Error1032) f\u00fchrt.<br \/>\nUm dies zu erreichen m\u00fcssen die Werte<br \/>\nauto_increment_increment<br \/>\nauto_increment_offset<br \/>\nangepasst werden. Hierbei sollte f\u00fcr\u00a0auto_increment_increment auf jedem Master ein eindeutiger Wert verwendet werden (1 f\u00fcr den ersten, 2 f\u00fcr den zweiten, etc).<br \/>\nAls wert f\u00fcr\u00a0\u00a0auto_increment_offset eignet sich meistens die Anzahl aller Master (z.b. bei 2 Master Servern = 2).<\/p>\n<p><strong>Wiederherstellung einer Master Master Replikation nach Fehlern<\/strong><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SETUP Als erstes sollte man pr\u00fcfen, ob die notwendigen Voraussetzungen in der my.cnf vorhanden sind. Bei Multi Master Setup\u00b4s muss<\/p>\n<p><a href=\"https:\/\/www.ritter.cc\/?page_id=166\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\">MySQL &#8211; Master Master Replikation<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":52,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-166","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/pages\/166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ritter.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=166"}],"version-history":[{"count":4,"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/pages\/166\/revisions"}],"predecessor-version":[{"id":170,"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/pages\/166\/revisions\/170"}],"up":[{"embeddable":true,"href":"https:\/\/www.ritter.cc\/index.php?rest_route=\/wp\/v2\/pages\/52"}],"wp:attachment":[{"href":"https:\/\/www.ritter.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}