{"id":3296,"date":"2016-12-01T16:13:44","date_gmt":"2016-12-01T08:13:44","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=3296"},"modified":"2016-12-06T22:14:49","modified_gmt":"2016-12-06T14:14:49","slug":"debian-and-mariadb-server","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server","title":{"rendered":"Debian and MariaDB Server"},"content":{"rendered":"<p>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.<\/p>\n<p>The MariaDB Server original goals were to be a drop-in replacement. In fact this is how its <a href=\"http:\/\/mariadb.org\/about\/\">described<\/a> (&#8220;It is an enhanced, drop-in replacement for MySQL&#8221;). We all know that its becoming <a href=\"http:\/\/www.slideshare.net\/bytebot\/mariadb-server-compatibility-with-mysql\">increasingly hard<\/a> for that line to be used these days.<\/p>\n<p>Anyhow in March 2016, Debian&#8217;s release team has made the <a href=\"http:\/\/lists.alioth.debian.org\/pipermail\/pkg-mysql-maint\/2016-March\/008895.html\">decision<\/a> that going forward, MariaDB Server is what people using <a href=\"https:\/\/wiki.debian.org\/DebianStretch\">Debian Stretch<\/a> get, when they ask for MySQL (i.e. MariaDB Server is the default provider of an application that requires the use of port 3306, and provides a MySQL-like protocol).<\/p>\n<p>All this has brought some interesting bug reports and discussions, so here&#8217;s a collection of links that interest me (with decisions that will affect Debian users going forward).<\/p>\n<h2>Connectors<\/h2>\n<ul>\n<li><a href=\"http:\/\/lists.alioth.debian.org\/pipermail\/pkg-mysql-maint\/2016-October\/009673.html\">MySQL ODBC in Stretch<\/a> &#8211; do follow the thread<\/li>\n<li><a href=\"http:\/\/lists.alioth.debian.org\/pipermail\/pkg-mysql-maint\/2016-October\/009605.html\"><code>[debian-mysql] final decision about MySQL r-deps needed \/ cleaning up the MySQL mess<\/code><\/a> &#8211; yes, the MySQL C++ connector is not the same as the MariaDB Connector\/C. And let&#8217;s not forget the things that depend on the C++ connector, i.e. <a href=\"http:\/\/lists.alioth.debian.org\/pipermail\/pkg-mysql-maint\/2016-October\/009597.html\">libreoffice-mysql-connector<\/a>. Rene Engelhard started this excellent <a href=\"http:\/\/lists.alioth.debian.org\/pipermail\/pkg-mysql-maint\/2016-October\/009596.html\">thread<\/a> with questions that could do with answers. <\/li>\n<\/ul>\n<h2>MariaDB Server<\/h2>\n<ul>\n<li><a href=\"https:\/\/bugs.debian.org\/cgi-bin\/bugreport.cgi?bug=837615\">Don&#8217;t include in stretch &#8211; bug#837615<\/a> &#8211; this is about how MariaDB Server 10.0 (note the version &#8211; this matters) should be included, but MySQL 5.6 shouldn&#8217;t be. <\/li>\n<li><a href=\"https:\/\/bugs.debian.org\/cgi-bin\/bugreport.cgi?bug=840857\">MariaDB 10.1?<\/a> &#8211; note that Otto Kek\u00c3\u00a4l\u00c3\u00a4inen, CEO of the MariaDB Foundation, says the plan is to skip MariaDB Server 10.1 and go straight to MariaDB Server 10.2. As of this writing, MariaDB Server 10.2 is in its <a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb\/what-is-mariadb-102\/\">first beta<\/a> released 27 Sep 2016, so are we expecting a few more betas before the release candidate? History shows there were <a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb\/what-is-mariadb-101\/#list-of-all-mariadb-101-releases\">four betas for 10.1<\/a> and one release candidate, while there were <a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb\/what-is-mariadb-100\/#list-of-all-mariadb-100-releases\">three betas and two release candidates of 10.0<\/a>. There is no response here as to what is gained from skipping MariaDB Server 10.1, but one can guess that this has to do with support cycles.<\/li>\n<li><a href=\"https:\/\/bugs.debian.org\/cgi-bin\/bugreport.cgi?bug=842011\">default-mysql-client forces removal of mysql-server* and mysql-client* &#8211; bug#842011<\/a> &#8211; bug reporter is a bit hostile towards the package team, but the gist is that &#8220;mariadb is NOT a drop-in replacement for mysql.&#8221; Users are bound to realise this once Debian Stretch gets more mainstream use.<\/li>\n<li><a href=\"http:\/\/lists.alioth.debian.org\/pipermail\/pkg-mysql-maint\/2016-October\/009583.html\"><code>[debian-mysql] Bug#840855: Bug#840855: mysql-server: MySQL 5.7?<\/code><\/a> &#8211; questioning what happens to MySQL 5.7, and this is really a call to action &#8211; if you disagree, email the security and release teams <strong>now<\/strong> not after Stretch is released! Quoting Clint Byrum, &#8220;The release and security teams have decided that MySQL will live only in unstable for stretch due to the perceived complications with tracking security patches in MySQL.&#8221;<\/li>\n<li><a href=\"http:\/\/lists.alioth.debian.org\/pipermail\/pkg-mysql-maint\/2016-July\/009168.html\"><code>[debian-mysql] About packages that depend on mysql-* \/ mariadb  \/ virtual-mysql-*<\/code><\/a> &#8211; in where we find the API-incompatible <code>libmysqlclient<\/code>, naming conventions, and more.<\/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%20Debian%20and%20MariaDB%20Server&body=https%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2016%2F12%2F01%2Fdebian-and-mariadb-server&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=\"90eadae5b7\" data-email-share-track-url=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3296\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server?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-3296\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server?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-3296\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server?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>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 be a drop-in replacement. In [&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%20Debian%20and%20MariaDB%20Server&body=https%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2016%2F12%2F01%2Fdebian-and-mariadb-server&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=\"90eadae5b7\" data-email-share-track-url=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3296\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server?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-3296\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server?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-3296\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server?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,1781,1775],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-Ra","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2840,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2013\/12\/27\/mariadb-distributions-update-dec-2013","url_meta":{"origin":3296,"position":0},"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":2938,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2014\/06\/11\/rhel7-now-with-mariadb","url_meta":{"origin":3296,"position":1},"title":"RHEL7 now with MariaDB","date":"11\/6\/2014","format":false,"excerpt":"Congratulations to the entire team at Red Hat, for the release of Red Hat Enterprise Linux 7 (RHEL7). The release notes have something important, under Web Servers & Services: MariaDB 5.5 MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of\u2026","rel":"","context":"In &quot;Distributions&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1689,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2010\/02\/23\/recently-in-mariadb-1","url_meta":{"origin":3296,"position":2},"title":"Recently in MariaDB #1","date":"23\/2\/2010","format":false,"excerpt":"The aims of this kind of blog post is simple - I want to help keep the masses informed as to what's happening with MariaDB, as a whole. There is a community growing, and MariaDB is a community project, not necessarily a Monty Program Ab baby (and we're clear on\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2820,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server","url_meta":{"origin":3296,"position":3},"title":"MySQL 5.6 system variables in the MariaDB 10 server","date":"20\/11\/2013","format":false,"excerpt":"Since MariaDB aims to be a compatible\/drop-in replacement to MySQL, its crucial that in 10.0 we support all the 5.6 options\/system variables, else we have to clearly document them in the Knowledgebase article MariaDB versus MySQL - Compatibility. To this extent,\u00a0Sergey Vojtovich (svoj) has created MDEV-5277 as a tracker. There\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3158,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2016\/01\/12\/fosdem-2016-see-you-in-brussels","url_meta":{"origin":3296,"position":4},"title":"FOSDEM 2016 &#8211; See you in Brussels","date":"12\/1\/2016","format":false,"excerpt":"Over the weekend I read in the FT (paywall): Is Brussels safe? Ring a local resident to find out. I\u2019m sure it will be fine, and you will want to be there for FOSDEM, happening 30-31 January 2016.\u00a0 There is the excellent one day track, that is the MySQL &\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2810,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2013\/10\/05\/mariadb-in-debian-unstable","url_meta":{"origin":3296,"position":5},"title":"MariaDB in Debian unstable","date":"5\/10\/2013","format":false,"excerpt":"There is a Debian\u00a0MariaDB plan\u00a0from the MySQL package team. There is good news as on September 30 2013, the upload to Debian unstable is complete with MariaDB 5.5 (5.5.32). It's now only a matter of time before this becomes available in Debian.\u00a0 Its great to see the work of\u00a0Otto Kek\u00c3\u00a4l\u00c3\u00a4inen\u2026","rel":"","context":"In &quot;MariaDB&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\/3296"}],"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=3296"}],"version-history":[{"count":2,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3296\/revisions"}],"predecessor-version":[{"id":3304,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3296\/revisions\/3304"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=3296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=3296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=3296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}