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 [...]
Entries Tagged as 'Replication'
Syntax error on MySQL replication slave (error 1064)
July 14th, 2009 · No Comments
Tags: MySQL · Replication
Cloud computing scenario’s for database servers
February 17th, 2009 · No Comments
We’ve been investigating the possibilities of using cloud computing for our clients. Especially Amazon EC2 has the potential to be be really effective in offering flexible, pay-as-you-go computing. From my own perspective I have been looking at how to use cloud computing in combination with MySQL and I must say that I’m a bit sceptical [...]
Tags: Down Time · MySQL · Performance · Replication · hosting
MySQL replication problems
October 9th, 2008 · 2 Comments
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
