MySQL Database in my space!
For BuildAPI, I needed to install MySQL and import snapshots of two databases that I would be using. So it was installed on my Fedora virtual machine (with a 25GB raw disk (yes, it should have been LVM))... and that eventually ran out of space. The database snapshots 'statusdb' and 'schedulerdb' were almost 10GB of space combined - something I did not expect, and did not account for.
I was close to cloning my virtual machine into another with a larger disk but after consulting with Chris Tyler, there were much simpler options - such as simply adding another raw disk, and this is what I did.
Moreover, I edited my MySQL configuration file (/etc/my.cnf) and pointed the data directory to be on the new virtual raw disk and worked on it from there. Although my VM was terribly slow at importing the (very large) sql dumpfile, and even failed once, it worked out worked out fine in the end.
Lesson: use LVM, or better yet, do this all on an actual host and not a virtual machine
No comments:
Post a Comment