How To Set Up SSH Encrypted MySQL Replication
Posted by
Michael J. DeMaria
April 30, 2010
log-bin=mysql-bin
server-id=1
Next, create the replication account. In MySQL, run the following queries:
CREATE USER 'replicationuser'@'master_ip' IDENTIFIED BY 'replicationpassword';
GRANT REPLICATION SLAVE ON *.* TO 'replicationuser'@'master_ip';
On the slave, add to the my.cnf file:
server-id = 2
master-host = 127.0.0.1
master-user = replicationuser
master-password = replicationpassword
master-port = 7777
Page: « Previous Page | 1 | 2 | 3 | Next Page »
