Getting Started on Windows - domflannery/mysql-sandbox GitHub Wiki

After you've installed the software from the Required Software page and cloned or downloaded the mysql-sandbox repo, it's pretty easy to use.

The first thing you need to do is open up the cmd prompt and cd to the directory of the mysql-sandbox. You should be in the directory where the Vagrantfile exists.

Starting db1, db2 and ansible

Then you would run "vagrant up" to start all the vm's. As a default, this command will start up db1, db2 and ansible vms. There is a db3 that isn't configured to be autostart, so it won't start unless explicitly specified.

Starting a single vm

Destroying all vms:

The above command will destroy all running vms. This means that any work or history you've saved on the machines will be gone forever.

Destroying only one vm:

Stopping all vm's:

Checking status of VM's:

Accessing the VM's

In windows you'll need some sort of tool that allows you to ssh into a linux host. The most common tool for this is putty and that's what I'll be using in the below screenshots.

In putty, you can save the connections and once you do, then you just double click on which connection you'd like to open.

To create the connection for the ansible host, you'd put 127.0.0.1 in the Host Name (or IP address) box. This will actually be the same IP for all the hosts. Then you need to put the port, normally when creating an ssh connection, the IP will change but the port will stay the same (22). For this setup however, we'll be changing the port for each. So the port for ansible is 2205 and this can be seen looking at the Vagrantfile, which is where these are defined. Then under Saved Sessions there is a text box where you can enter a name, then click save.

Do the same as above for the other connections. db1 port is 2203, db2 is 2204 and db3 is 2206.

After you have your connections saved and the vm's are running, you can ssh into them. When you double click on a connection, it'll present you with a log in screen. The username/password is vagrant/vagrant.

The ansible vm is used for the setup of MySQL. You're now ready to learn about how to use the special ansible vm to do the MySQL setup.