I’m starting to think that I won’t be able to host my application on Linode at all. Here’s the results of my latest testing:
| Database | Home | Gradwell | Linode |
|---|---|---|---|
| PostgreSQL | 7:46 | 21:01 | |
| MySQL | 0:32 | 1:01 | 42:40 |
The abysmal performance on the last run, MySQL on Linode, appears to be because I’ve hit some sort of I/O limiting that they do when people do too much disk I/O (i.e. swap).
I’m going to try the tests again on Linode but with the database hosted somewhere else – either at home or on my Gradwell server. Even if that works, I’m not sure what that will mean about my options.