smittyoneeach's Journal: MySQL on Vagrant

Trying to point mysqld to some shared storage in lieu of /var/lib/mysql. I'd like to keep the data off of the virtual machine.
The precise reason the synched_folder isn't working is really unclear. Just an error 13 in the log. Wish I had all the time in the world to comb Google and find the proper magic spell.

You must follow the one true path

[fustakrakich]

Where is it?

Re:

[smittyoneeach]

It is where it is; this is more a question of how it's mounted, and how the filesystem stats. There is also the fact that Ubuntu implements AppArmor, because nothing jacks up a CompSci question quite like another layer of indirection being a helpy helper for you.

Re:

[fustakrakich]

Ubuntu?? God.. no wonder... You're supposed to be using Slackware :-) And are you just mounting the share to a local directory(bring the mountain to Mohammed, as opposed to reaching across the valley)?

Read this with a heavy Indian accent:

Mount the share to, say, /mydb

Edit your configuration file thingy to point to it. Of course check your permissions, etc.

Fire it up

When it doesn't work, call MH_42

Re:

[smittyoneeach]

Worth considering.

Re:

[fustakrakich]

You mean you don't do it that way? I'm sorry, but I thought I was being condescending for even mentioning something so apparently basic. Maybe I'm more accustomed to programs that don't communicate over a network very well. I never even tried with MySQL, just lazy, I guess.

And not to be a smartass or anything, but do make sure your VM is bridged to your real network, not NATed

Re:

[smittyoneeach]

Vagrant is really just a Ruby wrapper around VirtualBox; you can shake and bake the network to taste. I was worrying about the storage and configuration aspects first, before moving on to network nuances.

Re:

[fustakrakich]

Oops, so sorry, I never heard of Vagrant. I was just looking to eliminate what I thought was a 'communicating across the network' issue.

Re:

[smittyoneeach]

Fairly recent project; again, it just simplifies VirtualBox and lets you drive it at the command line, as well as making managing images somewhat easier.