Difference between revisions of "Multi-Master Replication with HA-Proxy Load Balancing"
Jump to navigation
Jump to search
Michael.mast (talk | contribs) (Created page with "https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication <br> https://mariadb.com/kb/en/mariadb/setting-up-replication/ <br> http://forum...") |
Michael.mast (talk | contribs) |
||
Line 1: | Line 1: | ||
+ | ==NOTES== | ||
https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication <br> | https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication <br> | ||
https://mariadb.com/kb/en/mariadb/setting-up-replication/ <br> | https://mariadb.com/kb/en/mariadb/setting-up-replication/ <br> |
Latest revision as of 15:31, 24 July 2016
NOTES
https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication
https://mariadb.com/kb/en/mariadb/setting-up-replication/
http://forums.devshed.com/mysql-help-4/error-1113-table-1-column-163346.html
http://alvinalexander.com/blog/post/mysql/show-users-i-ve-created-in-mysql-database
http://dev.mysql.com/doc/refman/5.7/en/set-password.html
https://www.digitalocean.com/community/tutorials/how-to-use-haproxy-to-set-up-mysql-load-balancing--3
You can try this: Slave: stop slave; Master: flush logs Master: show master status; — take note of the master log file and master log position Slave: CHANGE MASTER TO MASTER_LOG_FILE=’log-bin.00000X′, MASTER_LOG_POS=106; Slave: start slave;