Caveats for running MySQL on block storage?
We've got a couple of servers that run MySQL perfectly fine right now in terms of Memory + CPU. However we're trying to plan out storage.
Is anyone running MySQL on Linode's Block Storage?
These would be read slaves/replicas… so read throughput is necessary but some downtime is OK.
A major caveat to keep in mind when moving to Block Storage is that this service utilizes HDDs whereas the storage native to your Linode benefits from SSDs. Given this, you can expect a bit more latency if you move your database to Block Storage; the latency is slightly more pronounced for read speeds vs. write speeds, too.
If possible, I recommend running some preliminary tests to see if our Block Storage will perform as needed for your purposes. For reference, here are a few relevant Community posts that you may find helpful: