Multi-Master Replication with HA-Proxy Load Balancing
Jump to navigation
Jump to search
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;