https://wiki.1701technology.com/index.php?action=history&feed=atom&title=Multi-Master_Replication_with_HA-Proxy_Load_Balancing 2026-05-06T14:11:49Z Revision history for this page on the wiki MediaWiki 1.34.1 https://wiki.1701technology.com/index.php?title=Multi-Master_Replication_with_HA-Proxy_Load_Balancing&diff=131&oldid=prev 2016-07-24T20:31:56Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 20:31, 24 July 2016</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">==NOTES==</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication &lt;br&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication &lt;br&gt;</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>https://mariadb.com/kb/en/mariadb/setting-up-replication/ &lt;br&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>https://mariadb.com/kb/en/mariadb/setting-up-replication/ &lt;br&gt;</div></td></tr> </table>

Michael.mast https://wiki.1701technology.com/index.php?title=Multi-Master_Replication_with_HA-Proxy_Load_Balancing&diff=130&oldid=prev 2016-07-24T20:31:29Z

<p>Created page with &quot;https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication &lt;br&gt; https://mariadb.com/kb/en/mariadb/setting-up-replication/ &lt;br&gt; http://forum...&quot;</p> <p><b>New page</b></p><div>https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication &lt;br&gt;<br /> https://mariadb.com/kb/en/mariadb/setting-up-replication/ &lt;br&gt;<br /> http://forums.devshed.com/mysql-help-4/error-1113-table-1-column-163346.html &lt;br&gt;<br /> http://alvinalexander.com/blog/post/mysql/show-users-i-ve-created-in-mysql-database &lt;br&gt;<br /> http://dev.mysql.com/doc/refman/5.7/en/set-password.html &lt;br&gt;<br /> &lt;br&gt;<br /> https://www.digitalocean.com/community/tutorials/how-to-use-haproxy-to-set-up-mysql-load-balancing--3<br /> &lt;pre&gt;<br /> <br /> <br /> You can try this:<br /> <br /> Slave: stop slave;<br /> Master: flush logs<br /> <br /> Master: show master status; — take note of the master log file and master log position<br /> <br /> Slave: CHANGE MASTER TO MASTER_LOG_FILE=’log-bin.00000X′, MASTER_LOG_POS=106;<br /> Slave: start slave;<br /> <br /> &lt;/pre&gt;</div>

Michael.mast