Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- On PRIMARY (my.cnf): -- server_id = 1 -- log_bin = /var/log/mysql/bin.log -- binlog_format = ROW -- Create replication user CREATE USER "replicator"@"replica_ip" IDENTIFIED BY "strong_password"; GRANT REPLICATION SLAVE ON *.* TO "replicator"@"replica_ip"; FLUSH PRIVILEGES; SHOW MASTER STATUS; -- note File and Position -- On REPLICA: -- server_id = 2 CHANGE REPLICATION SOURCE TO SOURCE_HOST="primary_ip", SOURCE_USER="replicator", SOURCE_PASSWORD="strong_password", SOURCE_LOG_FILE="bin.000001", SOURCE_LOG_POS=154; START REPLICA; SHOW REPLICA STATUS\G
Result
Open