Hey all, I'm doing some web development (specifically with scotch box) and I noticed if I try run my site by connecting to a mysql database that's running on the machine which is hosting the VM, it works - but the performance goes way down the toilet. If I use a DB via localhost (i.e. within the virtual machine), everything is just fine.
There's plenty of reasons why using a remote mysql DB would be slow especially for DB intensive stuff (Drupal, in this case) - but not only is this "remote" DB on the same private network, it's actually on the same machine - so it seems to me that it should perform comparably. Some googling led me to suggestions of configuring mysql with "skip_name_resolve" (https://groups.drupal.org/node/393578), but I'm connecting to a local private IP directly so I don't think there's anything for DNS to resolve. This is probably more of a mysql config question, but I thought others might have run into this using Vagrant/VMs. Are DB connections between the host and VM just going to be inherently slow? Is there some MySQL config that's a must-have for setups like this? Any other advice? Thanks in advance... -- You received this message because you are subscribed to the Google Groups "Vagrant" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
