Our senior sysadmin, Nathan March, has been compiling some notes on MySQL and InnoDB for internal use, but we thought they might be of some use and interest to a broader audience. We’ve split Nathan’s insights up into three posts which we’ll be posting daily. First up, Nathan talks about the distinctions between MyISAM and InnoDB, two of MySQL’s storage engines:

I initially started writing this for sysadmins but thought it might be of use to programmers on the whole to help give some insight into MySQL’s storage engine, how they work and why they do certain things. Hopefully this will help demystify things a little on how InnoDB and replication work internally.

Read the rest of this entry »

Part of our managed hosting service includes the active monitoring of your servers. If ever there is a bottleneck or a slow down in your website, we can tell you exactly where it is occurring and how to remedy the issue. Our consultation also allows for you to anticipate growth, plan for the future, and handle the mass amounts of traffic that you might expect.

We’ve now added MySQL performance monitoring to give you more information at your fingertips, so you can know exactly what is going on with your site.

Read the rest of this entry »