{"id":3131,"date":"2015-11-10T01:04:46","date_gmt":"2015-11-10T06:04:46","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=3131"},"modified":"2015-11-10T01:06:27","modified_gmt":"2015-11-10T06:06:27","slug":"ubuntu-online-summit-mysql-variants-in-16-04","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04","title":{"rendered":"Ubuntu Online Summit: MySQL &#038; Variants in 16.04"},"content":{"rendered":"<p>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: <a href=\"http:\/\/summit.ubuntu.com\/uos-1511\/meeting\/22627\/mysql-variants-in-1604\/\">MySQL &amp; Variants in 16.04<\/a>. <\/p>\n<h1>My key takeaways<\/h1>\n<ol>\n<li>Ubuntu 16.04 Xenial Xerus is an LTS release.<\/li>\n<li>The term &#8220;cross-grade&#8221; is used a lot (it is not about downgrading\/upgrading, but being able to use MySQL or MariaDB or Percona Server interchangeably) <\/li>\n<li>It would be nice to see MySQL 5.7 in this release (for Xenial as well as Debian Stretch). From Oracle there is a new packager taking over the task (Lars)<\/li>\n<li>MySQL 5.5 is still the default in Debian, and there needs to be upgrades tested between 5.5 to 5.7 (it looks like the ideal jump is that Ubuntu will not be seeing MySQL 5.6)<\/li>\n<li>Percona Server 5.7 is 60-90 days out; xtrabackup has had some new modifications and deserves an upgrade<\/li>\n<li>Boost is a new requirement for MySQL 5.7 &amp; Percona Server 5.7; some old TokuDB problems in the builds are likely already fixed in MariaDB Server so this can be inherited<\/li>\n<li>MariaDB is waiting to iron out the bugs in 10.0, and may stick to that<\/li>\n<\/ol>\n<h1>My &#8220;raw&#8221; transcribed notes<\/h1>\n<ul>\n<li>\n<p>Attendees:<\/p>\n<blockquote>\n<ul>\n<li>Jon Grimm (Engineering Director for Ubuntu)<\/li>\n<li>Robie Basak (Ubuntu)<\/li>\n<li>Otto Kek\u00c3\u00a4l\u00c3\u00a4inen (MariaDB Foundation)<\/li>\n<li>Lars Tangvald, Norvald H. Ryeng (Oracle)<\/li>\n<li>George Ormond Lorch III (Percona)<\/li>\n<\/ul>\n<\/blockquote>\n<\/li>\n<li>\n<p>Robie: Waiting in Debian for a transition slot from MySQL 5.5 to MySQL 5.6. There&#8217;s some discussion with bugs, re: Akonadi, need to also resolve ABI issues with MySQL 5.6. Not really discussed MySQL 5.7 yet.<\/p>\n<\/li>\n<li>Norvald: 5.7, changes to installation. Client library ABI cleaned up. There may be some clients breaking because of that. No more exported symbols. See: <a href=\"http:\/\/mysqlserverteam.com\/the-client-library-part-1-the-api-the-whole-api-and-nothing-but-the-api\/\">The Client Library, Part 1: The API, the Whole API and Nothing but the API<\/a> &amp; <a href=\"http:\/\/mysqlserverteam.com\/the-client-library-part-2-the-version-number\/\">The Client Library, Part 2: The Version Number<\/a><\/li>\n<li><code>mysql_install_db<\/code> is now replaced by <code>--initialize<\/code> in the server, so have to rewrite the post-install scripts. Might also have some AppArmour changes. Spoke to people @ DebConf (so best place is to put AppArmour profiles upstream (i.e. in mysql) and Debian and other distros will get it from there). AppArmour profile is in the MySQL source package now. Probably can get away with doing everything as cmake variables.<\/li>\n<li>MySQL 5.7 has disabled the old password hashing algorithm, so if people haven&#8217;t upgraded they might have problems; so a manual intervention to fix their accounts. <\/li>\n<li>Going from MySQL 5.7 to MySQL 5.6? It is done by dump and restore. There is no testing automated downgrades. Are there disk format changes? Norvald is not aware of any. If you use virtual columns in 5.7, you can&#8217;t downgrade easily to 5.6. <\/li>\n<li>Robie would prefer to not release 5.6 and 5.7 concurrently. During Trusty, there was some level of user confusion. Debian &#8211; release team would prefer to see one transfer than two, so is it better to just do a single transition to 5.7?<\/li>\n<li>Norvald says there hasn&#8217;t been testing from 5.5 -> 5.7. They only support upgrades from 5.5 -> 5.6 -> 5.7. For Ubuntu the choice can be to have 5.6 and then later do 5.7, but Jessie only just released with 5.5, so Stretch with 5.6 might not be a great idea (so users migrating from Jessie to Stretch will go from 5.5 to 5.7). Could also have 5.7 depend on a stripped 5.6 binary (like the embedded server; this is for localhost and the security team shouldn&#8217;t be too annoyed) for people to do an upgrade. Norvald says this has not been tried and there needs to be a migration path tested from 5.5 -> 5.7. <\/li>\n<li>Conclusion: 5.7 in Stretch. Xenial is an LTS release, and 5.7 should be targeted for that.<\/li>\n<li>If the maintainer script fails (postinstall script fails &#8211; don&#8217;t leave apt in a weird state). If it fails then upgrades, leave a debconf critical notice to say that the service is disabled and then fix it manually. Otto says that leaving \/etc in a broken state is terrible, so we should avoid it.<\/li>\n<li>Do we (Oracle) have the resources for 5.7 packaging and how soon can it be done in time for Xenial? There were patches from Lars in the git tree, but there haven&#8217;t been more recently. Lars will take over the 5.7 transition so if there is a list of work items, this will be settled (Lars will take over from Norvald).<\/li>\n<li>There will be a separate session with Norvald\/Lars\/Robie outside of UOS about 5.7. Defer the Boost conversation after the session as well.<\/li>\n<li>George: Percona is mainly looking out towards the 5.7 work and what kind of resources that will be put to that. There are new folk @ Percona to help with this. Percona inherits so much from the upstream codebase, it just works for Percona Server. There is Percona XtraDB Cluster and Percona xtrabackup, and xtrabackup has moved on quite a bit since the last upload (since last November 2014). So might be good idea to look at a refresh. There has also been a lot of work done on Percona XtraDB Cluster and there are some developments with Codership, so they are unsure if they will have their own Percona XtraDB Cluster 5.7 by the time Ubuntu is supposed to ship. When Percona is ready for something, just give Robie a shout to ensure that things happen. 60-90 days before a Percona Server 5.7 release. Just be aware of feature freeze for Xenial.<\/li>\n<li>Norvald mentions that Percona Server 5.7 will also depend on Boost and there needs to be a decision on this. George mentions that TokuDB is now part of Percona Server, and it has some of its own requirements as well. Do we include TokuDB? It has requirements like it will only run on 64-bit platforms. Things to figure out going forward? MariaDB has been carrying TokuDB last November, but Robie remembers disabling it in Ubuntu. George says there were some licensing issues back then but they seem to be taken care of.<\/li>\n<li>Otto says the builds for TokuDB was failing. It has a dependency on jemalloc, and that might have been the reason there were failures (says George). There may be something else where it doesn&#8217;t build on Ubuntu builders. But Otto says that there was a commit where this got fixed about last month. George will follow on, just to absorb it, since the legwork is already complete.<\/li>\n<li>Otto: Trusty has 5.5, and Jessie and all other Ubuntu releases have 10.0, and 10.1 was released last month and I&#8217;m not quite pushing it to Debian quite yet. Fix 10.0 build fixes, upstream them, then only focus on 10.1. Blocking? (last summer) 5.6 is not in testing, so could not depend on it\/changes done in 5.6 mysql-common. Here&#8217;s hoping that mysql-common going forward will be generated separately. <\/li>\n<li>Robie will take an action to resolve the delta (probably just drop it). To sync MariaDB 10.0 to Xenial.<\/li>\n<li>Discussion on <code>\/var\/lib\/mysql\/*.flag<\/code> thing on the list &#8212; conclusion at: <a href=\"http:\/\/lists.alioth.debian.org\/pipermail\/pkg-mysql-maint\/2015-November\/008360.html\">mailing list<\/a> &#8212; goal: within a single Ubuntu release, people can &#8220;cross-grade&#8221; between MySQL variants. The goal is to support all 3, and users want to try them, and thats when the bug reports come. Robie&#8217;s goal: move to a per-variant data directory. Otto says that once directory names change, 3rd party tools might have breakage. So a working prototype. Migration path is difficult. Maybe the best is to turn <code>\/var\/lib\/mysql<\/code> into a symlink and store the data elsewhere. PostgreSQL does per version directories today; so studying that is going to happen.<\/li>\n<\/ul>\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%20Ubuntu%20Online%20Summit%3A%20MySQL%20%26%20Variants%20in%2016.04&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2015%2F11%2F10%2Fubuntu-online-summit-mysql-variants-in-16-04&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=\"a0b440d461\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3131\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04?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-3131\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04?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-3131\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04?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>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 &amp; Variants in 16.04. My key takeaways [&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%20Ubuntu%20Online%20Summit%3A%20MySQL%20%26%20Variants%20in%2016.04&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2015%2F11%2F10%2Fubuntu-online-summit-mysql-variants-in-16-04&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=\"a0b440d461\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3131\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04?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-3131\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04?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-3131\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04?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":[1671,1064,23],"tags":[741,1052,1775,1376,15],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-Ov","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2906,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/04\/18\/congratulations-ubuntu-for-the-wide-choice","url_meta":{"origin":3131,"position":0},"title":"Congratulations Ubuntu, for the wide choice!","date":"18\/4\/2014","format":false,"excerpt":"Inspired by Yngve Svendsen\u2019s post, I too think it makes absolute sense to congratulate Ubuntu on the 14.04 LTS release\u00a0(some server notes\u00a0- MySQL has a section dedicated to it). Ubuntu users have a lot of server choice today (that\u2019s from all major MySQL ecosystem vendors): MySQL 5.5.35 ships in\u00a0main. It\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3214,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2016\/05\/02\/april-2016-mariadb-server-related-worklog","url_meta":{"origin":3131,"position":1},"title":"April 2016 MariaDB Server related worklog","date":"2\/5\/2016","format":false,"excerpt":"Planning for May MariaDB Corporation roadshows in London and Paris. The Paris edition is also one where Kentoku Shiba from Spiral Arms will make an appearance; we're also likely to plan several meetings around there too. Planning the MariaDB Berlin Meetup. Getting the speakers from our side. Ensuring that other\u2026","rel":"","context":"In &quot;Work&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2914,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/04\/22\/ubuntu-14-04-some-mysql-ecosystem-notes","url_meta":{"origin":3131,"position":2},"title":"Ubuntu 14.04 &#8211; some MySQL ecosystem notes","date":"22\/4\/2014","format":false,"excerpt":"Following my previous post on the launch, I just rolled Ubuntu 14.04 LTS on an Amazon EC2 t1.micro instance (not something you expect to run a database server on, for sure - 1 vCPU, 0.613GiB RAM). If you do an apt-cache search mysql you get 435 return result sets with\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2840,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/12\/27\/mariadb-distributions-update-dec-2013","url_meta":{"origin":3131,"position":3},"title":"MariaDB &#038; distributions update, Dec 2013","date":"27\/12\/2013","format":false,"excerpt":"A few things to note recently, amongst MariaDB in distributions.\u00a0 Ubuntu keeps MySQL 5.5 despite MariaDB's success. There's a lot of reasons for this, but remember the key takeaway here is MySQL 5.5 & the fact that MariaDB wasn't even in Debian yet when the decision was made. MariaDB is\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2922,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-related-irc-discussion-channels","url_meta":{"origin":3131,"position":4},"title":"MySQL related IRC discussion channels","date":"2\/5\/2014","format":false,"excerpt":"There are many MySQL related IRC discussion channels as the ecosystem itself grows. I join the following. Are there any that I\u2019m missing? Freenode (irc.freenode.net): #mysql - main channel for all kinds of end user MySQL related discussions (the noisiest of the lot, naturally) #maria - main channel for all\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2295,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/replication-features-of-2011-by-sergey-petrunia","url_meta":{"origin":3131,"position":5},"title":"Replication features of 2011 by Sergey Petrunia","date":"5\/2\/2012","format":false,"excerpt":"Sergey Petrunia of the\u00a0MariaDB project & Monty Program. MySQL 5.5 GA at the end of 2010. MariaDB 5.3 RC towards the end of 2011 (beta in June 2011). MySQL 5.5 is merged to Percona Server 5.5 which included semi-sync replication, slave fsync options, atuomatic relay log recovery, RBR slave type\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3131"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=3131"}],"version-history":[{"count":2,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3131\/revisions"}],"predecessor-version":[{"id":3133,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3131\/revisions\/3133"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=3131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=3131"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=3131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}