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

I’ve recently gotten some help and done some research into optimizing a MySQL database. The following applies if you have a powerful box at your disposal, I have 32GB RAM and 32 cores. If you are very limited hardware wise then not much of the following will apply.... 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

Update: This stuff has its own MySQL page now where we continue ... Read More

This piece is building on the prior tutorial, we now have Retrieve, Update and Delete in addition to the Create stuff. The prior tutorial has also been updated since the fromArrayExt method needed some adjustments to manage updating.... Read More

It was long overdue but finally I’ve taken a look at Doctrine. And I’m blown away, bye bye Zend DB.... Read More