Как настроить MySQL Master-Slave репликацию?
change master to
GRANT REPLICATION SLAVE ON . TO ‘slave.user.on.master’@’%’;
CHANGE MASTER TO MASTER_HOST = ‘ip.to.master’,
MASTER_USER = ‘slave.user.on.master’,
MASTER_PASSWORD = ‘password’,
MASTER_LOG_FILE = ‘mysql-bin.000006’,
MASTER_LOG_POS = 249130214;
START SLAVE;
SHOW SLAVE STATUS;
Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’