{"id":2924,"date":"2014-05-02T05:48:22","date_gmt":"2014-05-02T10:48:22","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2924"},"modified":"2014-05-02T05:48:22","modified_gmt":"2014-05-02T10:48:22","slug":"mysql-5-6-gtid-mariadb-10-replication","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-5-6-gtid-mariadb-10-replication","title":{"rendered":"MySQL 5.6 + GTID &#038; MariaDB 10 replication"},"content":{"rendered":"<p>While at the keynote of\u00a0<a href=\"http:\/\/insidemysql.com\/\">Tomas Ulin<\/a>\u00a0at <a href=\"https:\/\/www.percona.com\/live\/mysql-conference-2014\/\">Percona Live MySQL Conference &amp; Expo Santa Clara 2014<\/a>, he asked the audience what they were running, and most of the audience was on MySQL 5.5 while about 15% of the audience was on MySQL 5.6. This number is steadily increasing I\u2019m sure, so one thing that becomes important is that people will probably start turning on <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/replication-gtids.html\">Global Transaction Identifiers<\/a> (GTIDs).\u00a0<\/p>\n<p>As you may already know, MariaDB 10 has a different implementation of <a href=\"https:\/\/mariadb.com\/kb\/en\/global-transaction-id\/\">Global Transaction ID<\/a>. To me, this poses a problem in a mixed use environment (or even a migration scenario). Which is why <a href=\"https:\/\/mariadb.atlassian.net\/browse\/MDEV-4487\"><strong>MDEV-4487<\/strong><\/a> is so important: it is a <a href=\"https:\/\/mariadb.atlassian.net\/browse\/MDEV-4487\"><strong>feature request to allow replication from MySQL 5.6+ when GTID is enabled on the master<\/strong><\/a>.\u00a0<\/p>\n<p>If you think the issue is important, you can <strong>vote<\/strong>\u00a0and <strong>watch<\/strong>\u00a0the issue on JIRA. I for one think this should be fixed for 10.0.11 or 10.0.12 and not wait for the 10.1 timeframe. Best not to comment here, focus on the JIRA request, <a href=\"https:\/\/mariadb.atlassian.net\/browse\/MDEV-4487\"><strong>MDEV-4487<\/strong><\/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%20MySQL%205.6%20%2B%20GTID%20%26%20MariaDB%2010%20replication&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2014%2F05%2F02%2Fmysql-5-6-gtid-mariadb-10-replication&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=\"b1ceffb032\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-5-6-gtid-mariadb-10-replication?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2924\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-5-6-gtid-mariadb-10-replication?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-2924\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-5-6-gtid-mariadb-10-replication?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-2924\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-5-6-gtid-mariadb-10-replication?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>While at the keynote of\u00a0Tomas Ulin\u00a0at Percona Live MySQL Conference &amp; Expo Santa Clara 2014, he asked the audience what they were running, and most of the audience was on MySQL 5.5 while about 15% of the audience was on MySQL 5.6. This number is steadily increasing I\u2019m sure, so one thing that becomes important [&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%20MySQL%205.6%20%2B%20GTID%20%26%20MariaDB%2010%20replication&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2014%2F05%2F02%2Fmysql-5-6-gtid-mariadb-10-replication&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=\"b1ceffb032\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-5-6-gtid-mariadb-10-replication?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2924\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-5-6-gtid-mariadb-10-replication?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-2924\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-5-6-gtid-mariadb-10-replication?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-2924\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-5-6-gtid-mariadb-10-replication?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":[1064,23],"tags":[1666,1052,1610,1775,1333,1046],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-La","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2295,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/replication-features-of-2011-by-sergey-petrunia","url_meta":{"origin":2924,"position":0},"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":[]},{"id":2820,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server","url_meta":{"origin":2924,"position":1},"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":2914,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/04\/22\/ubuntu-14-04-some-mysql-ecosystem-notes","url_meta":{"origin":2924,"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":2354,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/03\/30\/paybox-services-and-seeing-mariadb-in-use","url_meta":{"origin":2924,"position":3},"title":"Paybox Services and seeing MariaDB in use","date":"30\/3\/2012","format":false,"excerpt":"When I was at MySQL, I took for granted that pretty much every website I used had software at the back of it that was basically MySQL. It was a nice feeling. MariaDB is a lot younger, so when I was in Paris and had to make a payment for\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":2924,"position":4},"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":2743,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/06\/11\/homebrew-mac-os-x-and-mariadb-10-0-series","url_meta":{"origin":2924,"position":5},"title":"Homebrew (Mac OS X) and MariaDB 10.0 series","date":"11\/6\/2013","format":false,"excerpt":"Today I performed a brew update. I noticed that MariaDB now exists as stable (5.5.30) and devel (10.0.2). Brew formulas also exist for MySQL (5.6.10) and Percona Server (5.5.30-30.2) now. 10.0.3 is around the corner but I wanted to run 10.0.2 now. This is how I did it: brew unlink\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\/2924"}],"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=2924"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2924\/revisions"}],"predecessor-version":[{"id":2925,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2924\/revisions\/2925"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2924"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2924"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}