The crucial detail is log_slave_updates = 1 on the first slave to be able to pass on the replication updates to the next machine in the chain.... Read More

So the old way (worked in 5.1) of automating the replication setup doesn’t work anymore, luckily the below works just as well.... Read More

Update: Apparently the master connection info gets cached in /var/lib/mysql/master.info so whenever you change the settings in my.cnf you need to remove it before you restart mysql.... Read More

I just realized I needed to replicate some data from one database to another, but only certain tables.... Read More

Update: Do not forget to erase the two ib_log* files in /var/lib/mysql before restarting with the new configuration!... Read More

It’s time to start saving the data we downloaded in the prior part in a MySQL database.... Read More

Today I just realized I didn’t have any PHP code to generate extended MySQL inserts at my disposal. For heavy inserts I’ve been using BEGIN and COMMIT with lines terminated with ;. ... Read More

There is a lot of talk about a lot of automation tools these days. Truth is though that you can cover a lot by simply using a normal shell script and some common Linux tools.... Read More

I’ve just finished playing with Robert Luo’s clj-cassandra for today and it’s time to recap what’s happened so far.... Read More

What is Memcached and what is it good for?... Read More