{"id":3831,"date":"2020-10-21T11:11:25","date_gmt":"2020-10-21T10:11:25","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=3831"},"modified":"2020-10-21T09:36:26","modified_gmt":"2020-10-21T08:36:26","slug":"plan-your-mysql-upgrade","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2020\/10\/21\/plan-your-mysql-upgrade\/","title":{"rendered":"Plan your MySQL upgrade"},"content":{"rendered":"\n<figure class=\"wp-block-image\" id=\"block-15302b8a-e017-4855-ad57-2f5ff8c233d3\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/Martinique_jardin_Balata_by_Olivier_DASINI_940x600.jpg\" alt=\"Jardin Balata Martinique by Olivier DASINI\"\/><\/figure>\n\n\n\n\n\n<p>I&rsquo;ve made a short video that will give you tips and tricks to successfully upgrade to MySQL 8<\/p>\n\n\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Plan your MySQL upgrade\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/x0bxBsXk8mw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n\n\n<p>These information are from my presentation : <strong><a href=\"https:\/\/www.slideshare.net\/freshdaz\/upgrade-from-mysql-57-to-mysql-80\" target=\"_blank\" rel=\"noreferrer noopener\">Upgrade from MySQL 5.7 to MySQL 8.0<\/a><\/strong><\/p>\n\n\n\n\n\n\n\n<p id=\"block-0ed217ab-9555-4fce-b2eb-a8e159fea886\">Thanks for using MySQL!<\/p>\n\n\n\n<p id=\"block-868b7105-d7e9-407c-90f8-86bb4bc000c8\"><a href=\"https:\/\/twitter.com\/freshdaz\" target=\"_blank\" rel=\"noreferrer noopener\">Follow me on twitter<\/a><\/p>\n\n\n\n<p id=\"block-bfa5aa6b-9ea8-40f9-bcaf-40051829c5f1\">Watch my videos on my <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\" target=\"_blank\" rel=\"noreferrer noopener\">YouTube channel<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&rsquo;ve made a short video that will give you tips and tricks to successfully upgrade to MySQL 8<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[1634,203,327,1105],"tags":[1620,1635,1106],"class_list":["post-3831","post","type-post","status-publish","format-standard","hentry","category-migration","category-mysql-en","category-trick","category-video","tag-migration","tag-upgrade","tag-video"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-ZN","jetpack-related-posts":[{"id":5556,"url":"https:\/\/dasini.net\/blog\/2022\/03\/09\/data-migration-from-mariadb-to-mysql\/","url_meta":{"origin":3831,"position":0},"title":"Data Migration from MariaDB to MySQL","author":"Olivier DASINI","date":"9 mars 2022","format":false,"excerpt":"Yet another customer wanted to migrate from MariaDB to MySQL. So I decided to write down the overall data migration process. Indeed each migration are a unique story so I won\u2019t provide you a \u201cHow to migrate\u201d\u2026 The idea is to highlight the general path and help you to avoid\u2026","rel":"","context":"Dans &quot;Cloud&quot;","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/03\/MySQL_Shell_Overview.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/03\/MySQL_Shell_Overview.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/03\/MySQL_Shell_Overview.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/03\/MySQL_Shell_Overview.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":3157,"url":"https:\/\/dasini.net\/blog\/2019\/06\/05\/mysql-8-0-16-new-features-summary\/","url_meta":{"origin":3831,"position":1},"title":"MySQL 8.0.16 New Features Summary","author":"Olivier DASINI","date":"5 juin 2019","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.16 released on April 25, 2019","rel":"","context":"Dans &quot;Group Replication&quot;","block_context":{"text":"Group Replication","link":"https:\/\/dasini.net\/blog\/category\/group-replication-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/3_esLnhHHck\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":5762,"url":"https:\/\/dasini.net\/blog\/2022\/06\/09\/explore-visualize-your-mysql-heatwave-data-with-superset\/","url_meta":{"origin":3831,"position":2},"title":"Explore &#038; visualize your MySQL HeatWave data with Superset","author":"Olivier DASINI","date":"9 juin 2022","format":false,"excerpt":"In this article I will show you how to properly configure Apache Superset in order to take advantage of a high performance, in-memory query accelerator: MySQL HeatWave.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=1050%2C600 3x"},"classes":[]},{"id":3166,"url":"https:\/\/dasini.net\/blog\/2019\/06\/11\/check-the-mysql-server-startup-configuration\/","url_meta":{"origin":3831,"position":3},"title":"Check the MySQL server startup configuration","author":"Olivier DASINI","date":"11 juin 2019","format":false,"excerpt":"Since 8.0.16, MySQL Server supports a --validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode. --validate-config can be used any time, but is particularly useful after an upgrade, to check whether any options previously used with the older server\u2026","rel":"","context":"Dans &quot;Astuce&quot;","block_context":{"text":"Astuce","link":"https:\/\/dasini.net\/blog\/category\/astuce\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1455,"url":"https:\/\/dasini.net\/blog\/2013\/09\/10\/mysql-tech-day-paris-on-oct-10-2013\/","url_meta":{"origin":3831,"position":4},"title":"MySQL Tech Day @Paris on Oct 10, 2013","author":"Olivier DASINI","date":"10 septembre 2013","format":false,"excerpt":"MySQL Tech Day @Paris We're happy to announce you that MySQL Tech Day will take place in Paris on Oct 10, 2013 in Oracle main office. It'll be a full day event giving you an occasion to listen directly from Oracle developers about most of the improvements made recently within\u2026","rel":"","context":"Dans &quot;Conf\u00e9rence&quot;","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference-en\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3720,"url":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/","url_meta":{"origin":3831,"position":5},"title":"MySQL 8.0.20 New Features Summary","author":"Olivier DASINI","date":"26 mai 2020","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/iJp9npOJWFw\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3831","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=3831"}],"version-history":[{"count":4,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3831\/revisions"}],"predecessor-version":[{"id":3838,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3831\/revisions\/3838"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=3831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=3831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=3831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}