Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 1 to 2 of 2 « Previous | Next »
Displaying posts with tag: server-id (reset)
Mar
12
2011
Setting up Master-Slave Replication with MySQL
Posted by Ovais Tariq on Sat 12 Mar 2011 10:48 UTC
Tags:

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
12
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:

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…)