Changing hats Note: I have updated this article as of April 24, 2008 to indicate that you do not have to set auto_increment_increment or auto_increment_offset for the slaves. If you see this in the diagrams, please ignore. The master sets the auto_increment value in it's binary log which the slave reads via replication. I may write an update to this article at some point soon. I have put on the ha