Planet MySQL

Displaying posts with tag: replication slave (reset)

Mar

2011

Setting up Master-Slave Replication with MySQL

Posted by Ovais Tariq on Sat 12 Mar 2011 10:48 UTC
Tags:

Replication, master, slave, scale-out, mysqldump, slave status, server-id, relay log, binary logs, master-slave, master status, read-load, write-load, log-slave-updates, read-only, replication client, replication privileges, replication slave, MySQL

Replication enables data from one MySQL server to be replicated on one or more other MySQL servers. Replication is mostly used as scale-out solution. In such a solution, all writes and updates take place on the master server, while reads take place on one or more slaves. This model is actually known as master-slave replication and this is the kind of replication that I will be setting up in this post.

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links