2 added ubuntu and linux tags
| link
source | link

scaling options for mysql on linux vm (ubuntu) : how to scale when the RAID 0 is out of space

I was asked to give a scaling road map for our mysql database.

Currently, I have a single mysql instance v5.6.28 running on an ubuntu VM on azure. It has a (software) RAID 0 disk made with two 1TBs.

My question is, when this 2TB disk gets filled up, what am i supposed to do? I am thinking that my options would be

  1. add another RAID 0.
  2. add another mysql VM to existing infrastructure
  3. migrate to mysql cluster
  4. ???

I want to know what is the recommended method to scale when the tables grow to an extent that the existing RAID runs out of space.