mysql database replication using phpmyadmin on xampp

1
votes

My query is to setup database replication (master/slave) process to balance database load using phpmyadmin in xampp. I tried. There is one link in phpmyadmin called replication.

I followed this below link : http://ahmedzubayr.wordpress.com/2012/04/24/configure-master-slave-replication-mysql-xampp/

While configuring MySQL Slave Configuration, I got an error like slave not configured on master. I cannot find these issue. Can anyone make a suggestion? Thanks in advance.

1
mysqlphpmyadminxamppdatabase-replication
@SVarun, just in case you missed the point about your edit block: please stop putting everything in code blocks. Please use code for code only. Thanks. - Arjan
First of all you need to create a user on the Master server that the Slave will connect as. - RafaSashi

1 Answers

0
votes

MySQL must be accessible via network. If you ran the command /opt/lamp/lamp security when you installed XAMPP, probably MySQL wasn’t accessible via network. You must comment the skip-networking line in /opt/lampp/etc/my.cnf and restart XAMPP.