Posts Tagged ‘server-id’

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

By Sheeri Cabral October 12th, 2008 at 1:55 pm
Posted in MySQL
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…)