Here’s an interesting one, what if you have a MySQL replication setup and the slave stops replicating with a syntax error? The slave should be executing the exact same commands as the master, right? Well, as it turns out, yes and no. There is a bug in MySQL that has been fixed in 5.0.56 according [...]
Syntax error on MySQL replication slave (error 1064)
July 14th, 2009 · No Comments
Tags: MySQL · Replication
MySQL replication problems
October 9th, 2008 · 1 Comment
We are using a replication setup for our databases. The master database takes care of all the transactions and the slave database is used for hot standby, making backups and running reports. Running mysqldump for backups locks the main tables one by one (we’re using the MyISAM storage engine) and was causing user interruptions. Hence [...]
Tags: MySQL · Replication · monitoring
Changing the MySQL replication master host
July 24th, 2008 · 1 Comment
Here’s a little post on how to change the master database host that the replication slave in a MySQL replication setup uses. This can happen if there is a change in network addresses or when you want to switch over to using different internal network. The main thing to keep in mind is that when [...]
Tags: MySQL
MySQL error 1449 “There is no ‘username’@'host’ registered”
June 27th, 2008 · No Comments
The error message in the title occurs in a combination of circumstances. If you have 2 MySQL databases, one master and one slave in a replicating setup and you use triggers you may encounter this error. Although it is not necessary for the slave database to have the same users as the master for replication [...]
Tags: MySQL
