{"id":565,"date":"2014-10-26T12:40:08","date_gmt":"2014-10-26T11:40:08","guid":{"rendered":"http:\/\/dbahire.com\/?page_id=565"},"modified":"2014-11-03T08:43:56","modified_gmt":"2014-11-03T07:43:56","slug":"pluk14","status":"publish","type":"page","link":"https:\/\/jynus.com\/dbahire\/pluk14\/","title":{"rendered":"&#8220;Query Optimization With MySQL 5.7 and MariaDB 10: Even Newer Tricks&#8221; workshop for Percona Live UK 2014"},"content":{"rendered":"<p><iframe loading=\"lazy\" src=\"\/\/www.slideshare.net\/slideshow\/embed_code\/41037462\" width=\"476\" height=\"400\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"float:right;\"><\/iframe><\/p>\n<h3>Option one (using VirtualBox)<\/h3>\n<p>This virtual machine image contains everything you need for the tutorial already installed &#8211; 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:<\/p>\n<ul>\n<li>Get the Virtual Machine for the tutorial (.ova, 3.2 GB): <a href=\"https:\/\/www.dropbox.com\/s\/si57ky5q6v88x4x\/query_optimization_vm.ova?dl=1\">[Download from Dropbox]<\/a> <a href=\"https:\/\/docs.google.com\/a\/jynus.com\/uc?id=0B-wHYNV-Xb6kSnhXSzhTVnJyX00&#038;export=download\">[Download from Google Drive]<\/a><\/li>\n<p> <code>MD5SUM: b8d04c1bcc082d6080d192457e767b1f<br \/>SHA1SUM: da9535f008707c69a7558a78c7029770de5df64e<\/code><\/p>\n<li>You will need <a href=\"https:\/\/www.virtualbox.org\/wiki\/Downloads\" title=\"VirtualBox Downloads for Windows, Mac and Linux\">the latest version of VirtualBox, available for Window, Mac or Linux<\/a>.<\/li>\n<\/ul>\n<p><strong>You will need 10-20GB of free space<\/strong> due to the large example database installed in several MySQL\/MariaDB versions at the same time.<br \/>\nManual for the Virtual machine in short: <code>VirtualBox > File > Import Appliance... > Start > Login as User: dbahire \/ Password: dbahire > Run startxfce4<\/code><\/p>\n<h3>Option two &#8211; DIY (setting your own environment)<\/h2>\n<p>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. <strong>You do not need these if you downloaded the Virtual Machine<\/strong>:<\/p>\n<ul>\n<li>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.<\/li>\n<li>Install the <a href=\"http:\/\/downloads.mysql.com\/snapshots\/pb\/mysql-5.7.5-labs-preview\/mysql-5.7.5-labs-preview-linux-el6-x86_64.tar.gz\" title=\"MySQL 5.7.5 lab release\">Optimizer\/InnoDB\/Replication lab release of MySQL 5.7.5<\/a>. 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 <a href=\"http:\/\/downloads.mysql.com\/snapshots\/pb\/mysql-5.7.5-labs-preview\/mysql-5.7.5-labs-preview.tar.gz\">the source version<\/a> or install the regular 5.7.5 version otherwise.<\/li>\n<li>Optionally, install other MySQL versions. I will be using <a href=\"http:\/\/dev.mysql.com\/downloads\/mysql\/5.6.html#downloads\">MySQL 5.6.21<\/a>, <a href=\"http:\/\/dev.mysql.com\/downloads\/mysql\/5.5.html#downloads\">MySQL 5.5.40<\/a> and <a href=\"https:\/\/downloads.mariadb.org\/mariadb\/10.0.14\/\">MariaDB 10.0.14<\/a>. For handling several MySQL installations on the same machine, I recommend <a href=\"https:\/\/launchpad.net\/mysql-sandbox\">MySQL Sandbox<\/a>.\n<li>Download the Database SQL export (.sql.bz2, 127 MB): <a href=\"https:\/\/dl.dropboxusercontent.com\/u\/27217745\/osm_backup.sql.bz2\">[Download from Dropbox]<\/a> <a href=\"https:\/\/docs.google.com\/a\/jynus.com\/uc?id=0B-wHYNV-Xb6kaGNHLVhMbk93MlE&#038;export=download\">[Download from Google Drive]<\/a><\/li>\n<ul>\n","protected":false},"excerpt":{"rendered":"<p>Option one (using VirtualBox) This virtual machine image contains everything you need for the tutorial already installed &#8211; 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:<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-565","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/pages\/565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/comments?post=565"}],"version-history":[{"count":12,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/pages\/565\/revisions"}],"predecessor-version":[{"id":598,"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/pages\/565\/revisions\/598"}],"wp:attachment":[{"href":"https:\/\/jynus.com\/dbahire\/wp-json\/wp\/v2\/media?parent=565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}