Switching to MongoDB and auto increment
I originally prototyped our server monitoring service, Server Density, using MySQL, a database I’d been using for years on other projects. One standard feature is the auto_increment field property which [...]
MySQL server now includes embedded memcached for performance
The latest MySQL release (5.6.6) integrates the memcached daemon into the core server which allows you to use the memcached protocol to query InnoDB tables. This is interesting because it [...]
MySQL server monitoring – sd-agent 1.4.0
We have just released version 1.4.0 of sd-agent for our server monitoring product, Server Density. This includes support for MySQL monitoring, available immediately to all paid and trial users. This [...]
Choosing a non-relational database; why we migrated from MySQL to MongoDB
Update 23 Oct 2010: A discussion about the value of shortened field names has generated a lot of traffic to this post over the last 24 hours. A response has [...]
Database migration on 2009-07-15
Update 2009-07-16 19:48 GMT: All historical data has now been imported, completing the first phase of the migration. If you spot any problems, please let us know. Update 2009-07-16 18:15 [...]
Backing up large MySQL databases
The data backend for our server monitoring application, Server Density, uses MySQL. We are investigating using a non-RDBMS for the metrics data but plan to continue using MySQL for less [...]
Optimising multiple MySQL INSERTs
Starting last weekend with handling timezone conversion with PHP DateTime, we’re aiming to publish a technical blog post each weekend to give an insight into some of the things we’re [...]