Option one (using VirtualBox)
This virtual machine image contains everything you need for the tutorial already installed – The operating system (Centos 7), MySQL 5.7, MySQL 5.6, MySQL 5.5 and MariaDB 10 (installed with MySQL Sandbox) and the database preloaded:
- Get the Virtual Machine for the tutorial (.ova, 3.2 GB): [Download from Dropbox] [Download from Google Drive]
- You will need the latest version of VirtualBox, available for Window, Mac or Linux.
You will need 10-20GB of free space due to the large example database installed in several MySQL/MariaDB versions at the same time.
Manual for the Virtual machine in short:
VirtualBox > File > Import Appliance... > Start > Login as User: dbahire / Password: dbahire > Run startxfce4
Option two – DIY (setting your own environment)
If you do not want to use a virtual machine or you prefer using your own cloud or bare metal server/laptop for testing, here you have all the pieces separately, but it may take you some time to put them together. You do not need these if you downloaded the Virtual Machine:
- Install an operating system, I recommend Linux. While MySQL is multiplatform, some specific features and 3rd party scripts explained are linux or unix-only. The virtual machine mentioned above has CentOS 7 preinstalled, which I will use on my presentation.
- Install the Optimizer/InnoDB/Replication lab release of MySQL 5.7.5. Some of the features presented will not be available in the regular 5.7.5 download. It is only available for linux x86_64, so you will have to use the source version or install the regular 5.7.5 version otherwise.
- Optionally, install other MySQL versions. I will be using MySQL 5.6.21, MySQL 5.5.40 and MariaDB 10.0.14. For handling several MySQL installations on the same machine, I recommend MySQL Sandbox.
- Download the Database SQL export (.sql.bz2, 127 MB): [Download from Dropbox] [Download from Google Drive]