Knowledgebase

Portal Home > Knowledgebase > Articles Database > MySQL Replication on FreeBSD

MySQL Replication on FreeBSD

Posted by peep96, 09-12-2010, 10:08 AM

Hello, I would like to set up my failover FreeBSD server in a different location to replicate my whole MySQL database on the primary. I have found a tutorial online, but it looks like it describes how to do only 1 database, and i would like to sync everything. It is not a huge database, either. Any help is appreciated. Thanks

---

Posted by ZenMonk, 09-14-2010, 03:23 AM

All you need to do is assign server_id for master/slave and enable binary logging in /etc/my.cnf. Comment out binlog-do-db vairable, if any. Sync your databases from master to slave and then restart the mysql server on master, note down the master position using 'show master status' and set those postion in the slave.

---

Add to Favourites    Print this Article

Is dediwebhost down? (Views: 702)

ERROR! MySQL server PID file could not be found! (Views: 653)

tar: file changed as we read it (Views: 634)

Best FREE server montoring and statistics tool (Views: 677)

Cloud Hosting? (Views: 654)