Configuring MySql Replication

This article will take you through configuring mysql cluster on CentOS, Since configuration is same this should work with other distros like ubuntu. Replication Master Configuration Add following in my.cnf [mysqld] log-bin=mysql-bin server-id=1 ubuntu service mysql start centos service mysqld start Creating a User for Replication ON MASTER mysql>GRANT REPLICATION SLAVE ON *.* TO ‘repl’@'SLAVE-SERVER-IP/HOSTNAME’ [...]

Full Story »

Trending Posts