{"id":3483,"date":"2019-10-02T14:51:05","date_gmt":"2019-10-02T06:51:05","guid":{"rendered":"https:\/\/www.bytebot.net\/blog\/?p=3483"},"modified":"2019-10-02T14:51:05","modified_gmt":"2019-10-02T06:51:05","slug":"percona-live-europe-amsterdam-day-1-notes","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2019\/10\/02\/percona-live-europe-amsterdam-day-1-notes","title":{"rendered":"Percona Live Europe Amsterdam Day 1 notes"},"content":{"rendered":"<p>Percona Live Europe Amsterdam Day 1 was a bunch of fun, especially since I didn&#8217;t have to give a talk or anything since my tutorial was over on Day 0.<\/p>\n<p>At lunch, I realised that there are a lot more fringe events happening around Percona Live&#8230; and if you&#8217;ve seen how people do &#8220;tech weeks&#8221;, maybe this is what the event ends up being &#8211; a show, plus plenty of focused satellite events. <a href=\"https:\/\/fosdem.org\/2020\/\">FOSDEM<\/a> in the open source world totally gets this, and best of all, also lists fringe events (see example from <a href=\"https:\/\/archive.fosdem.org\/2019\/fringe\/\">2019<\/a>). <\/p>\n<p>So, Thursday evening gets a few fringe events, a relatively short train ride away:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.altinity.com\/events\/2019\/10\/3\/clickhouse-meetup-in-paris-2019\">ClickHouse Paris Meetup 2019<\/a><\/li>\n<li><a href=\"https:\/\/proxysql.com\/blog\/proxysql-technology-day-ghent-oct3rd2019\">ProxySQL Technology Day Ghent<\/a><\/li>\n<\/ul>\n<p>Anyway, what was Day 1 like? Keynotes started the morning, and I did make a <a href=\"https:\/\/twitter.com\/bytebot\/status\/1178929966194597888?s=20\">Twitter thread<\/a>. It is clear that there is a lot of talk amongst companies that make open source software, and companies in the ecosystem that somehow also derive great value from it. Some look at this as the great cloud vendors vs open source software vendors debate, but this isn&#8217;t necessarily always the case &#8211; we&#8217;ve seen this as Percona&#8217;s model too. And we&#8217;ve seen cloud companies contribute back (again, just like Percona). Guess this is a topic for a different post, because there are always two sides to this situation&#8230; <\/p>\n<p>It is also clear that people want permissive open source licenses over anything source available. If you&#8217;re a CxO looking for software, it would be almost irresponsible to be using critical software that is just source available with a proprietary license. After all, what happens when the company decides to ask for more money? (Companies change ownership too, you know).<\/p>\n<p>It is probably clear the best strategies are the &#8220;multi&#8221; (or hybrid) strategies. Multiple databases, multiple clouds, and going all in on open source to avoid vendor lock-in. Of course, don&#8217;t forget that open source software also can have &#8220;vendor lock-in&#8221; &#8211; always look at the health metrics of a project, vs. a product. We&#8217;re lucky in the MySQL ecosystem that we have not just the excellent work of Oracle, but also MariaDB Corporation \/ MariaDB Foundation and also Percona.<\/p>\n<p>MySQL 8.0 <a href=\"https:\/\/twitter.com\/bytebot\/status\/1178937120255365121\">adoption<\/a> is taking off, with about 26% of the users on it. Those on MySQL 5.6 still seem to be on it, and there has been a decrease in 5.7 use to grow that 8.0 pie. It isn&#8217;t clear how these stats are generated (since there is no &#8220;phone home&#8221; functionality in MySQL; also the <a href=\"https:\/\/mariadb.org\/about\/statistics\/\">MariaDB Server variant<\/a> doesn&#8217;t get as much usage as one would like), but maybe it is via download numbers? <\/p>\n<p>Anyone paying any attention to MySQL 8 will know that they have switched to a &#8220;continuous delivery model&#8221;, also known as, you get new features in every point release. So the latest 8.0.18 gets EXPLAIN ANALYZE, and while we can&#8217;t try it yet (not released, and the documentation isn&#8217;t updated), I expect it will be fairly soon. I am eager to try this, because MariaDB Server has had <a href=\"https:\/\/mariadb.com\/kb\/en\/library\/documentation\/sql-statements-structure\/sql-statements\/administrative-sql-statements\/analyze-and-explain-statements\/analyze-statement\/\">ANALYZE<\/a> since 10.1 (GA &#8211; Oct 2015). And it wasn&#8217;t long ago that MySQL received <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/create-table-check-constraints.html\">CHECK constraints<\/a> support (8.0.16). Also the CLONE plugin in 8.0.17 warrants some checking\/usage!<\/p>\n<p>Besides all the hallway chats and meetings I did manage to get into a few sessions&#8230; Rakuten Intelligence <a href=\"https:\/\/twitter.com\/bytebot\/status\/1178965556298485760\">talked about<\/a> their usage of ProxySQL, and one thing was interesting with regard to their future plans slide &#8211; they do consider group replication but they wonder what would replace their custom HA software? But most importantly they wonder if it is stable and which companies have successfully deployed it, because they don&#8217;t want to be the first. Question from the floor about Galera Cluster came up, and they said they had one app that required XA support &#8211; looks like something to consider once Galera 4 is fully baked!<\/p>\n<p>The PXC&#8211;8 talk was also chock full of information, delivered excellently, and something to try soon (it wasn&#8217;t quite available yesterday, but today I see a release announcement: <a href=\"https:\/\/www.percona.com\/blog\/2019\/10\/01\/experimental-binary-of-percona-xtradb-cluster-8-0\/\">Experimental Binary of Percona XtraDB Cluster 8.0<\/a>).<\/p>\n<p>I enjoyed the OpenCorporates use case at the end too. From the fact that for them, being on-premise would be cheaper than the cloud, how they use ProxySQL, Galera Cluster branch Percona XtraDB Cluster (PXC), and ZFS. ZFS is not the most common filesystem for MySQL deployments, so it was interesting to see what could be achieved. <\/p>\n<p>Then there was the Booking.com party and boy, did they outdo themselves. We had <a href=\"https:\/\/twitter.com\/ask_dba\/status\/1179101110088409090\">a menu<\/a>, multi-course meal with wine pairings, and a lot of <a href=\"https:\/\/twitter.com\/bytebot\/status\/1179113691083689984\">good conversation<\/a>. A night wouldn&#8217;t be complete without some Salmiakkikossu, and Monty <a href=\"https:\/\/twitter.com\/bytebot\/status\/1179151308638605312\">sent some<\/a> over for us to enjoy. <\/p>\n<p>Food at the Hilton has been great too (something I would never really want to say, considering I&#8217;m not a fan of the hotel chain) &#8211; even the coffee breaks are well catered for. I think maybe this has been the best Percona Live in terms of catering, and I&#8217;ve been to a lot of them (maybe all&#8230;). I have to give much kudos to Bronwyn and Lorraine at Percona for the impeccable organisation. The WiFi works a charm as well. On towards Day 2!<\/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%20Percona%20Live%20Europe%20Amsterdam%20Day%201%20notes&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2019%2F10%2F02%2Fpercona-live-europe-amsterdam-day-1-notes&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=\"26d8878a11\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/10\/02\/percona-live-europe-amsterdam-day-1-notes?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3483\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/10\/02\/percona-live-europe-amsterdam-day-1-notes?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-3483\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/10\/02\/percona-live-europe-amsterdam-day-1-notes?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-3483\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/10\/02\/percona-live-europe-amsterdam-day-1-notes?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>Percona Live Europe Amsterdam Day 1 was a bunch of fun, especially since I didn&#8217;t have to give a talk or anything since my tutorial was over on Day 0. At lunch, I realised that there are a lot more fringe events happening around Percona Live&#8230; and if you&#8217;ve seen how people do &#8220;tech weeks&#8221;, [&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%20Percona%20Live%20Europe%20Amsterdam%20Day%201%20notes&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2019%2F10%2F02%2Fpercona-live-europe-amsterdam-day-1-notes&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=\"26d8878a11\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/10\/02\/percona-live-europe-amsterdam-day-1-notes?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3483\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/10\/02\/percona-live-europe-amsterdam-day-1-notes?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-3483\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/10\/02\/percona-live-europe-amsterdam-day-1-notes?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-3483\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/10\/02\/percona-live-europe-amsterdam-day-1-notes?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":[1761,1955,1052,1775,1300,1864,1877],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-Ub","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3280,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2016\/09\/08\/speaking-at-percona-live-europe-amsterdam","url_meta":{"origin":3483,"position":0},"title":"Speaking at Percona Live Europe Amsterdam","date":"8\/9\/2016","format":false,"excerpt":"I'm happy to speak at Percona Live Europe Amsterdam 2016 again this year (just look at the awesome schedule). On my agenda: Monday Oct 3 Tutorial: Best Practices of MySQL High Availability Monday Oct 3 Tutorial: The Complete MariaDB Tutorial Wednesday Oct 5 Talk: Securing your MySQL\/MariaDB data with my\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3285,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2016\/09\/27\/percona-live-europe-amsterdam-postgresql-day","url_meta":{"origin":3483,"position":1},"title":"Percona Live Europe Amsterdam PostgreSQL Day","date":"27\/9\/2016","format":false,"excerpt":"This is my very first post on Planet PostgreSQL, so thank you for having me here! I'm not sure if you're aware, but the PostgreSQL Events page lists the conference as something that should be of interest to PostgreSQL users and developers. There is a PostgreSQL Day on October 4\u2026","rel":"","context":"In &quot;Databases&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3367,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2017\/07\/13\/cfp-for-percona-live-europe-dublin-2017-closes-july-17-2017","url_meta":{"origin":3483,"position":2},"title":"CFP for Percona Live Europe Dublin 2017 closes July 17 2017!","date":"13\/7\/2017","format":false,"excerpt":"I've always enjoyed the Percona Live Europe events, because I consider them to be a lot more intimate than the event in Santa Clara. It started in London, had a smashing success last year in Amsterdam (conference sold out), and by design the travelling conference is now in Dublin from\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3084,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2015\/07\/08\/perconalive-amsterdam-schedule-now-out","url_meta":{"origin":3483,"position":3},"title":"#PerconaLive Amsterdam &#8211; schedule now out","date":"8\/7\/2015","format":false,"excerpt":"The schedule is out for Percona Live Europe: Amsterdam\u00a0(September 21-23 2015), and you can see it at: https:\/\/www.percona.com\/live\/europe-amsterdam-2015\/program. From MariaDB Corporation\/Foundation, we have 1 tutorial: Best Practices for MySQL High Availability - Colin Charles (MariaDB) And 5 talks: Using Docker for Fast and Easy Testing of MariaDB and MaxScale -\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3292,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2016\/11\/11\/cfp-for-percona-live-santa-clara-closes-november-13","url_meta":{"origin":3483,"position":4},"title":"CfP for Percona Live Santa Clara closes November 13!","date":"11\/11\/2016","format":false,"excerpt":"At Percona Live Amsterdam recently, the conference expanded beyond just its focus areas of MySQL & its ecosystem and MongoDB to also include PostgreSQL and other open source databases (just look at the recent poll). The event was a sold out success. This will continue for Percona Live Santa Clara\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3287,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2016\/10\/02\/speaking-in-october-2016","url_meta":{"origin":3483,"position":5},"title":"Speaking in October 2016","date":"2\/10\/2016","format":false,"excerpt":"I'm thrilled to naturally be at Percona Live Europe Amsterdam from Oct 3-5 2016. I have previously talked about some of my sessions but I think there's another one on the schedule already. LinuxCon Europe - Oct 4-6 2016. I won't be there for the whole conference, but hope to\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\/3483"}],"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=3483"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3483\/revisions"}],"predecessor-version":[{"id":3484,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3483\/revisions\/3484"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=3483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=3483"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=3483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}