Wednesday, June 30, 2010

Mysql replication

Today I was working on a master-master replication setup and I couldn't get the slave threads to work. I could connect between the servers with the mysql client, but the slave threads couldn't connect. I finally found that although you can set a long password for a mysql user, the mysql replication will silently truncate long passwords before it uses them to log into the master server. So you set the password to one thing and something shorter is actually used. I ended up using a 10 character password and that worked fine.