Archive for the ‘Database’ Category

One Master, Two Slaves - Daisy Chaining MySQL

Sunday, October 6th, 2013

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

MySQL 5.5 Replication Bash Script

Saturday, July 13th, 2013

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

MySQL Slave Replication in 6 Quick Steps

Monday, March 11th, 2013

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

MySQL replication in PHP - on the same machine

Wednesday, September 14th, 2011

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

MySQL / InnoDB performance optimization

Wednesday, September 14th, 2011

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

Clojure and MySQL

Sunday, February 13th, 2011

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

Generating extended MySQL inserts in PHP

Thursday, November 4th, 2010

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

Remote MySQL database backup with local Linux shell

Wednesday, July 14th, 2010

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

Clojure and Cassandra with clj-cassandra

Sunday, May 9th, 2010

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

Memcached in PHP on Dapper

Monday, February 8th, 2010

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