Category Archives: Master Slave Replication

Repair MySQL Replication

Repair MySQL Replication: If you have set up MySQL replication, you probably know this problem: sometimes there are invalid MySQL queries which cause the replication to not work anymore. 1) Check log entry, #tail -n100 /var/log/mysql/error.log 131127 18:10:46 [ERROR] Slave … Continue reading

Posted in Master Slave Replication, Mysql | Tagged | Leave a comment

Setup MySQL Master Slave Replication

Setup MySQL Master Slave Replication : Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous – slaves need not be connected permanently to receive … Continue reading

Posted in Master Slave Replication, Mysql | Tagged | 1 Comment