Submitted by Ron on Mon, 2013/03/18 - 20:28
Got a CentOS box running as a slave of my Ubuntu server.
Here are the steps I took, starting on the slave:
# yum install mysql-server*
Then we ought to secure our installation:
# /usr/bin/mysql_secure_installation
On the master, we need to create a user for the slave to connect as (adjust user name & IP address to suit your needs):
mysql> GRANT REPLICATION SLAVE ON *.* TO 'slave'@'192.168.1.%' IDENTIFIED BY PASSWORD [your-choice-of-password]
Submitted by Ron on Fri, 2013/02/01 - 06:53
Been replicating MySQL databases from master to slave computers and encountered a frustrating, and potentially major problem:
