{"id":3209,"date":"2016-04-13T21:16:07","date_gmt":"2016-04-13T13:16:07","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=3209"},"modified":"2016-04-14T15:46:36","modified_gmt":"2016-04-14T07:46:36","slug":"major-post-ga-features-in-the-5-7-release","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/13\/major-post-ga-features-in-the-5-7-release","title":{"rendered":"Major post-GA features in the 5.7 release!"},"content":{"rendered":"<p>Interesting developments in the MySQL world &#8211; it can now be used as a <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/document-store.html\">document store<\/a> and you can query the database using JavaScript instead of SQL (via the MySQL Shell). There is also a new <a href=\"http:\/\/dev.mysql.com\/doc\/x-devapi-userguide\/en\/\">X Plugin<\/a> (see: <code>mysql-5.7.12\/rapid\/<\/code>) (which now makes use of <a href=\"https:\/\/developers.google.com\/protocol-buffers\/\">protocol buffers<\/a> (see: <code>mysql-5.7.12\/extra\/protobuf\/<\/code>)). I will agree, this is <a href=\"http:\/\/mysqlserverteam.com\/mysql-5-7-12-part-1-more-than-a-maintenance-release\/\">more than just a maintenance release<\/a>.<\/p>\n<p>Do get started playing with <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/mysql-shell.html\">MySQL Shell<\/a>. If you&#8217;re using the yum repository, remember to ensure you have enabled the <code>mysql-tools-preview<\/code> in <code>\/etc\/yum.repos.d\/mysql-community.repo<\/code>. And don&#8217;t forget to load the X Plugin in the server! I can&#8217;t wait for the rest of the blog posts in the series, and today just took a cursory look at all of this &#8212; kudos Team MySQL @ Oracle.<\/p>\n<p>However, I&#8217;m concerned that the GA is getting what you would think of as more than just a maintenance release. We saw <a href=\"http:\/\/dev.mysql.com\/doc\/relnotes\/mysql\/5.7\/en\/news-5-7-11.html\">5.7.11<\/a> get at rest data encryption for InnoDB, and now <a href=\"http:\/\/dev.mysql.com\/doc\/relnotes\/mysql\/5.7\/en\/news-5-7-12.html\">5.7.12<\/a> getting even more changes. This is going to for example, ship in the next <a href=\"https:\/\/wiki.ubuntu.com\/XenialXerus\/ReleaseSchedule\">Ubuntu LTS, Xenial Xerus<\/a>. Today it has <a href=\"http:\/\/packages.ubuntu.com\/xenial\/database\/mysql-server-5.7\">5.7.11<\/a>, but presumably after release it will be upgrade to 5.7.12. I am not a huge fan of surprises in LTS releases (predictability over 5 years is a nice thing; this probably explains why I still have a 5.0.95 server running), but I guess this small band-aid is what we need to ensure this doesn&#8217;t happen going forward?<\/p>\n<p>As for the other question I&#8217;ve seen via email from several folk so far: will MariaDB Server support this? I don&#8217;t see why not in the future, so why not file a <a href=\"https:\/\/jira.mariadb.org\/secure\/Dashboard.jspa\">Jira<\/a>? <\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20Major%20post-GA%20features%20in%20the%205.7%20release%21&body=https%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2016%2F04%2F13%2Fmajor-post-ga-features-in-the-5-7-release&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"1237ae0a61\" data-email-share-track-url=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/13\/major-post-ga-features-in-the-5-7-release?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3209\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/13\/major-post-ga-features-in-the-5-7-release?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-3209\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/13\/major-post-ga-features-in-the-5-7-release?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-3209\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/13\/major-post-ga-features-in-the-5-7-release?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Interesting developments in the MySQL world &#8211; it can now be used as a document store and you can query the database using JavaScript instead of SQL (via the MySQL Shell). There is also a new X Plugin (see: mysql-5.7.12\/rapid\/) (which now makes use of protocol buffers (see: mysql-5.7.12\/extra\/protobuf\/)). I will agree, this is more [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20Major%20post-GA%20features%20in%20the%205.7%20release%21&body=https%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2016%2F04%2F13%2Fmajor-post-ga-features-in-the-5-7-release&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"1237ae0a61\" data-email-share-track-url=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/13\/major-post-ga-features-in-the-5-7-release?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3209\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/13\/major-post-ga-features-in-the-5-7-release?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-3209\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/13\/major-post-ga-features-in-the-5-7-release?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-3209\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/13\/major-post-ga-features-in-the-5-7-release?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[23],"tags":[967,1775,1552,1826,1824,1825],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-PL","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3199,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/08\/tweet-summary-of-percona-live-2015","url_meta":{"origin":3209,"position":0},"title":"(tweet) Summary of Percona Live 2015","date":"8\/4\/2016","format":false,"excerpt":"The problem with Twitter is that we talk about something and before you know it, people forget. (e.g. does WebScaleSQL have an async client library?) How many blog posts are there about Percona Live Santa Clara 2015? This time (2016), I'm going to endeavour to write more than to just\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3296,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server","url_meta":{"origin":3209,"position":1},"title":"Debian and MariaDB Server","date":"1\/12\/2016","format":false,"excerpt":"GNU\/Linux distributions matter, and Debian is one of the most popular ones out there in terms of user base. Its an interesting time as MariaDB Server becomes more divergent compared to upstream MySQL, and people go about choosing default providers of the database. The MariaDB Server original goals were to\u2026","rel":"","context":"In &quot;Distributions&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2701,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2013\/04\/24\/biggest-mysql-related-news-in-the-last-24-hours-day-2","url_meta":{"origin":3209,"position":2},"title":"Biggest MySQL related news in the last 24 hours, Day 2","date":"24\/4\/2013","format":false,"excerpt":"Continuing on from yesterday, the biggest news that I've noted in the past 24 hours: The commitment from Oracle's MySQL team to release a new GA about once every 24 months, with a Developer Milestone Release (DMR), with \"GA quality\" every 4-6 months. Tomas Ulin announced MySQL 5.7 DMR1 (milestone\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2863,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2014\/02\/01\/changes-in-mysql-5-7","url_meta":{"origin":3209,"position":3},"title":"Changes in MySQL 5.7","date":"1\/2\/2014","format":false,"excerpt":"I wish more discussion happened on the internals mailing list, but if you're interested in finding out what's upcoming\/changing in MySQL 5.7, so far the best resources I've found are: The video\u00a0(1h41m is worth a watch), and blog post from Todd Farmer A presentation from Morgan Tocker (I wonder if\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3131,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04","url_meta":{"origin":3209,"position":4},"title":"Ubuntu Online Summit: MySQL &#038; Variants in 16.04","date":"10\/11\/2015","format":false,"excerpt":"I personally have always enjoyed the Ubuntu Developer Summits (UDS), but nowadays they have been converted to the Ubuntu Online Summits (UOS). Attending them is not always convenient (timezone issues, might be travelling, etc.) so I watched the recorded video of a session I was interested in: MySQL & Variants\u2026","rel":"","context":"In &quot;Distributions&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":781,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/14\/my-favourite-bugfix-in-mysql-5124-rc","url_meta":{"origin":3209,"position":5},"title":"My favourite bugfix in MySQL 5.1.24-rc","date":"14\/4\/2008","format":false,"excerpt":"I've been using MySQL 5.1 a lot more of late. Also, as of about a month ago, I'm now a Mac OS X user, so tend to use MySQL on OS X Leopard 10.5 a lot more for testing. I've found a rather annoying bug (in 5.1.23-rc) that is fixed\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3209"}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=3209"}],"version-history":[{"count":1,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3209\/revisions"}],"predecessor-version":[{"id":3210,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3209\/revisions\/3210"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=3209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=3209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=3209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}