{"id":2126,"date":"2011-04-20T01:26:41","date_gmt":"2011-04-20T06:26:41","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2126"},"modified":"2011-04-20T01:26:49","modified_gmt":"2011-04-20T06:26:49","slug":"where-is-mariadb-today","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2011\/04\/20\/where-is-mariadb-today","title":{"rendered":"Where is MariaDB today?"},"content":{"rendered":"<p>These were my notes from the &#8220;Where is MariaDB today?&#8221; session at the Lisbon MariaDB Developers Meeting that happened in March 2011. I just realised I hadn&#8217;t posted it; also note that it is really raw.<\/p>\n<p>Where is MariaDB today?<\/p>\n<p>5.3 &#8211; look at the KB article titled &#8220;<a href=\"http:\/\/kb.askmonty.org\/v\/mariadb-53-todo\">MariaDB 5.3 TODO<\/a>&#8220;. A lot of things are in the review state at the moment.<\/p>\n<p>Sergei has all the phone home code for the server working; what is missing is a host to collect the data, and also have a website to display things (Holyfoot will work on this).<\/p>\n<p>Mark Callaghan says there are at least two different implementations of group commit work now, and Percona might have a third. This is in relation to Kristian Nielsen&#8217;s work. World&#8217;s largest workload on group commit is probably at Facebook &#8212; Mark&#8217;s implementation is in the Facebook patch. Mark wants to make sure that Percona ends up using the MariaDB group commit, because having three versions would be silly. Monty believes that we need to have something that works for everyone, not just for Facebook. Its late in the game, and Percona needs to agree with either the Facebook or MariaDB version of group commit. Mark is also concerned that the group commit patch is very large and intrusive. Mark wants a public design review for group commit. Kristian agrees &#8211; we need to have a better way to do design reviews with the MariaDB community (i.e. people outside of Monty Program).<\/p>\n<p>Mark is worried that there are too many optimiser changes in MariaDB which make it difficult to roll out (due to bugs). The ultimate goal is to ensure that Mark doesn&#8217;t have to maintain the Facebook patch, and its all in mainline MariaDB.<\/p>\n<p>&#8220;We don&#8217;t encounter bugs in the optimiser. We see bad paths but we force it.&#8221; &#8211; Mark<\/p>\n<p>The Google patch removed subqueries from the parser &#8212; they didn&#8217;t allow subqueries to be run. Subqueries aren&#8217;t largely used in large data centres. MariaDB is going to have very optimised subqueries now (in 5.3). Percona does not really hack on the optimiser and the pick up rate of Percona server is great (they just published 1,000 customers). Mark wants to ensure we can show the deployments are coming.<\/p>\n<p>Mark is also concerned we only focus on the optimiser too much. The optimiser optimisations will be complete soon. He wants us to focus on InnoDB and replication. Igor said we won&#8217;t be able to do it because we don&#8217;t have specialists. Timour says we should finish the optimiser stuff that has taken several years, and the future is that we should definitely focus on InnoDB and replication.<\/p>\n<p>Percona (Peter) wants to ensure that when an optimiser change is made, there is always a flag. And there is in MariaDB.<\/p>\n<p>Mark will sponsor a design review for Percona on group commit. He wants one solution that both Percona &amp; Monty Program agree on for MariaDB. Kristian is open to this as well. Monty hasn&#8217;t reviewed the patch yet, its on his TODO.<\/p>\n<p>Krisitan brings up two different mindsets:<\/p>\n<ol>\n<li>The MariaDB way &#8211; you do something amazing, good engineering and then deal with the merges later<\/li>\n<li>The MySQL from Oracle is upstream, you make technical compromises, and you make a less intrusive patch<\/li>\n<\/ol>\n<p>Kristian focused on the MariaDB way for the group commit patch.<\/p>\n<p>Sergei Golubchik takes the stage to talk about the status of MariaDB based on MySQL 5.5<\/p>\n<p>He&#8217;s doing a bzr merge then goes through all the conflicts. Then one does the tests to make sure things pass. Then do a complete diff, and understand the changes and see if things need to get fixed. Monty admits the merges are getting more complex.<\/p>\n<p>At the end of the meeting, the plans for <a href=\"http:\/\/kb.askmonty.org\/v\/plans-for-56\">MariaDB 5.6<\/a> were formulated. There&#8217;s a lot of work coming up ahead.<\/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%20Where%20is%20MariaDB%20today%3F&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2011%2F04%2F20%2Fwhere-is-mariadb-today&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=\"a8bb5938bb\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/04\/20\/where-is-mariadb-today?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2126\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/04\/20\/where-is-mariadb-today?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-2126\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/04\/20\/where-is-mariadb-today?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-2126\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/04\/20\/where-is-mariadb-today?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>These were my notes from the &#8220;Where is MariaDB today?&#8221; session at the Lisbon MariaDB Developers Meeting that happened in March 2011. I just realised I hadn&#8217;t posted it; also note that it is really raw. Where is MariaDB today? 5.3 &#8211; look at the KB article titled &#8220;MariaDB 5.3 TODO&#8220;. A lot of things [&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%20Where%20is%20MariaDB%20today%3F&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2011%2F04%2F20%2Fwhere-is-mariadb-today&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=\"a8bb5938bb\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/04\/20\/where-is-mariadb-today?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2126\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/04\/20\/where-is-mariadb-today?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-2126\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/04\/20\/where-is-mariadb-today?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-2126\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2011\/04\/20\/where-is-mariadb-today?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":[1243,1052,1244],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-yi","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":2126,"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":2735,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/06\/01\/percona-has-more-mariadb-features-now","url_meta":{"origin":2126,"position":1},"title":"Percona has more MariaDB features now","date":"1\/6\/2013","format":false,"excerpt":"Lately more people ask me for comparisons between Percona Server & MariaDB. There isn't a definitive blow-by-blow feature comparison yet, but it'll come soon. All that said, its great to see new features from MariaDB make it into Percona Server. The features that I've managed to track: group commit for\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2173,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2011\/08\/07\/book-mariadb-crash-course","url_meta":{"origin":2126,"position":2},"title":"Book: MariaDB Crash Course","date":"7\/8\/2011","format":false,"excerpt":"Exciting news - MariaDB gets its first book! Many years ago I read Ben Forta's MySQL Crash Course . It is a book targeted at beginners of MySQL. Ben has now written another book, titled: MariaDB Crash Course. Its still targeted at beginners, and covers many of the new features\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2335,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/03\/22\/mariadb-at-percona-live-santa-clara","url_meta":{"origin":2126,"position":3},"title":"MariaDB at Percona Live Santa Clara","date":"22\/3\/2012","format":false,"excerpt":"I for one can say that I'm truly excited that MariaDB will be part of Percona Live Santa Clara. The MariaDB session list includes: A tutorial: Improving MySQL\/MariaDB query performance through optimizer tuning by\u00a0Timour Katchaounov and\u00a0Sergey Petrunia. You can benefit from this even as a stock MySQL user naturally. MySQL\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2380,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/05\/25\/mariadb-5-5-has-deprecated-pbxt","url_meta":{"origin":2126,"position":4},"title":"MariaDB 5.5 has deprecated PBXT","date":"25\/5\/2012","format":false,"excerpt":"One of the things we (Team MariaDB) talked quite a bit about since we released was PBXT. It was a feature differentiation to MySQL as we shipped another storage engine. It was included in MariaDB 5.1, 5.2, and 5.3; however with our release of MariaDB 5.5, PBXT (docs in the\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2106,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2011\/03\/03\/going-to-lisbon-portugal","url_meta":{"origin":2126,"position":5},"title":"Going to Lisbon, Portugal","date":"3\/3\/2011","format":false,"excerpt":"I'm headed to Lisbon, Portugal for the week of March 7-15. Were have a MariaDB Developer Meeting there, hosted by Monty Program. We're still getting people stating that they are coming (which is good), so if you're local to the area, and dig MySQL\/MariaDB\/databases\/opensource, drop by and say hi (March\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\/2126"}],"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=2126"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2126\/revisions"}],"predecessor-version":[{"id":2127,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2126\/revisions\/2127"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2126"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}