Posts Tagged ‘mysql’

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/ so whenever you change the settings in my.cnf you need to remove it before you restart mysql.... Read More

Moving the MySQL database directory to different drive on Ubuntu

Thursday, May 24th, 2012

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

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

Migrating a Legacy Forum to vBulletin 4.0.3

Saturday, July 17th, 2010

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, a poker rakeback site, where the new forum is located at 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