上Mysql HA課程 Day1 12/9 DIY
[Master] Boot MySQL Server 1.server-id 2.datadir * 3.log-bin [Slave] Boot MySQL Server 1.server-id 2.datadir * 3.Port * 4.socket * (if in Unix like OS) [Master] Create user for replication slave, with password Grant “REPLICATION SLAVE” privilege to this user [Slave via client] Issue ‘CHANGE MASTER TO’ with option: 1.MASTER HOST 2.MASTER USER 3.MASTER PASSWORD Issue ‘Start SLAVE’ ============ command [Master] PS:start可有可無 mysqld –server-id=1 –datadir=..\data1 –log-bin start mysqld –server-id=1 –datadir=..\data1 –log-bin [Slave] start mysqld –server-id=2 –datadir=..\data2 –port=3307 –log-bin ...