You can follow the SolusVM tutorial here, ours is a modified article using their way but this is how we do it:
Update Centos and install the Epel repo:yum update -y
wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
rpm -ivh epel-release-6-8.noarch.rpm
Install and check the configurations:
yum install mysql mysql-server pdns pdns-backend-mysql -y
chkconfig --levels 235 mysqld on
chkconfig --levels 235 pdns on
service mysqld start
Sort the MySQL out:mysqladmin -u root password MYNEWPASSWORD
wget -N http://files.soluslabs.com/solusvm/pdns/pdns.sql
mysql --user=root --password=MYNEWPASSOWRD < pdns.sql
nano /etc/pdns/pdns.conf
Put the following under it:
launch=gmysql gmysql-host=127.0.0.1 gmysql-user=root gmysql-password=MYNEWPASSWORD gmysql-dbname=powerdns
Sort the MySQL permissions out:mysql -u root -p
GRANT ALL ON powerdns.* TO 'root'@'YOUR_SOLUSVM_MASTERS_IP' IDENTIFIED BY 'MYNEWPASSWORD';
exit
Start PowerDNS:/etc/init.d/pdns start
Disable iptables:service iptables stop
Ensure my.cnf is correctly set-up by following: https://documentation.solusvm.com/display/DOCS/MySQL+Replication+to+Slaves