I am attempting to create an Ubuntu instance on an OpenStack Cloud. However, the basic images don't allow for a large root (/) partition nor would that be common when deployed to public clouds.
I have come to the idea that I should create a volume for persistent storage and tell MySQL to use this for its data storage.
However, I am not sure if that is conventional nor smart. Also, would it be better to simply replace /var with the volume (since it will save logs in addition to the database) or should I create a custom directory with the volume dedicated only to MySQL?
Overall, what is an acceptable or conventional way to create an OpenStack Ubuntu instance configured to host a MySQL daemon with a good amount of persistent storage for the data?
Note: This question has answers which will show me how to configure MySQL so feel free to abstract those particular details out of any answer.