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 have a server where there are two RAID1 disks where the second disk is mounted on /mnt/data, having the MySQL database there would be great as it then would have a whole disk all by itself without having to share with other processes that read and write to the same disk. I/O is often the bottleneck and now we make sure it gets as good as it can be with the hardware we have.... 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

Recently I’ve just finished migrating a custom forum to vBulletin, in doing this your mileage may vary, much of it depends on if the original forum was part of a bigger offering that should still exist, or if it was standalone. In my case the site is cardlovers.com, a poker rakeback site, where the new forum is located at cardlovers.com/forum... 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