Planet MySQL

Displaying posts with tag: server-id (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.

Oct

2008

mysqlbinlog --server-id before MySQL 5.1? awk to the rescue!

Posted by Sheeri K. Cabral on Sun 12 Oct 2008 20:55 UTC
Tags:

Replication, binary, binary log, awk, mysqlbinlog, server-id, MySQL

Recently I had an interesting issue crop up. Due to an unfortunate migration incident in which involved master/master replication and not checking to see if replication was caught up, we ended up with an infinite replication loop of a number of SQL statements. awk helped immensely in the aftermath cleanup.

The basics of the replication infinite loop were (more…)

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links