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
- add another RAID 0.
- add another mysql VM to existing infrastructure
- migrate to mysql cluster
- ???
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.