{"id":3751,"date":"2020-08-27T10:05:24","date_gmt":"2020-08-27T09:05:24","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=3751"},"modified":"2020-11-28T14:07:14","modified_gmt":"2020-11-28T13:07:14","slug":"resume-des-nouveautes-de-mysql-8-0-21","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2020\/08\/27\/resume-des-nouveautes-de-mysql-8-0-21\/","title":{"rendered":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.21"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/Sakila_on_a_Rock_mozaik_600x333_by_olivier_dasini.JPG\" alt=\"Sakila mozaik by Olivier DASINI\"\/><\/figure>\n\n\n\n<p>J&rsquo;ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de <a rel=\"noreferrer noopener\" href=\"https:\/\/dev.mysql.com\/downloads\/\" target=\"_blank\">MySQL<\/a>, sortie le 13 juillet 2020, la 8.0.<strong>21<\/strong>.<\/p>\n\n\n\n\n\n<p><u>Au programme<\/u>:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Runtime disabling Innodb Redo Log<\/li><li>JSON_VALUE fonction<\/li><li>CREATE TABLE&#8230; SELECT is atomic<\/li><li>Per-user Comments &amp; Attributes<\/li><li>MySQL Document Store Enhancements<\/li><li>MySQL Shell Enhancements<\/li><li>MySQL Router Enhancements<\/li><li>MySQL InnoDB Cluster Enhancements<\/li><li>MySQL Group Replication Enhancements<\/li><li>Thanks to the Contributors<\/li><\/ul>\n\n\n\n\n\n<p><span style=\"text-decoration: underline;\">Notes de l&rsquo;expert<\/span> \ud83d\ude42<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Runtime disabling Innodb Redo Log<\/p><\/blockquote>\n\n\n\n<p>Le fait de d\u00e9sactiver les <strong><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/glossary.html#glos_redo_log\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Redo log\">Redo Logs<\/a><\/strong>  permet de charger des donn\u00e9es dans une instance MySQL \u00e0 la vitesse de la lumi\u00e8re !!!<br>Bon j&rsquo;exag\u00e8re un petit peu \ud83d\ude42 Mais cela reste vraiment impressionnant.<br>Attention tout de fois \u00e0 ne pas utiliser cette technique sur une instance d\u00e9j\u00e0 en production. Le risque est de corrompre l&rsquo;instance.<br>En clair, cela sert \u00e0 charger un instance tr\u00e8s rapidement avant la mise en prod.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>CREATE TABLE&#8230; SELECT is atomic<\/p><\/blockquote>\n\n\n\n<p>Certains utilisateurs n&rsquo;avaient pas la possibilit\u00e9 d&rsquo;utiliser cette formidable techno qu&rsquo;est <a href=\"http:\/\/dasini.net\/blog\/2019\/09\/03\/tutoriel-deployer-mysql-8-0-innodb-cluster-09-2019\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Tuto - MySQL InnoDB Cluster\"><strong>MySQL InnoDB Cluster<\/strong><\/a> parce que <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/group-replication.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Group Replication\"><strong>MySQL Group Replication<\/strong><\/a> ne permettait pas l&rsquo;utilisation de ce type de requ\u00eate&#8230;<br>Cette limitation est lev\u00e9e maintenant \\o\/<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Per-user Comments &amp; Attributes<\/p><\/blockquote>\n\n\n\n<p>Permet d&#8217;embarquer de la documentation dans ta base MySQL.<br>J&rsquo;adore !<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>MySQL Shell Enhancements<\/p><\/blockquote>\n\n\n\n<p>3 nouveaux utilitaires pour <strong><a href=\"https:\/\/dev.mysql.com\/doc\/mysql-shell\/8.0\/en\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Shell\">MySQL Shell<\/a><\/strong> : <strong>dumpInstance<\/strong>() , <strong>dumpSchemas<\/strong>() , <strong>loadDump<\/strong>()<br>Les noms sont explicites. <br>Ce qu&rsquo;il faut retenir c&rsquo;est que charger et restaurer des donn\u00e9es en mode logique n&rsquo;a jamais \u00e9t\u00e9 aussi <strong>rapide<\/strong> (au revoir mysqldump &amp; Co :D).<br>A essayer de toute urgence, surtout si vous avez une quantit\u00e9 de donn\u00e9es importante.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Autres&#8230;<\/p><\/blockquote>\n\n\n\n<p>Il y a \u00e9galement pas mal d&rsquo;autres bonnes choses, comme les am\u00e9liorations pour <strong><a href=\"https:\/\/www.mysql.com\/products\/enterprise\/router.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Router\">MySQL Router<\/a><\/strong>, <strong><a href=\"http:\/\/dasini.net\/blog\/2019\/09\/03\/tutoriel-deployer-mysql-8-0-innodb-cluster-09-2019\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Tuto - MySQL InnoDB Cluster\"><strong>MySQL InnoDB Cluster<\/strong><\/a><\/strong> et <strong><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/group-replication.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Group Replication\"><strong>MySQL Group Replication<\/strong><\/a><\/strong>.<br>je te laisse le soin de d\u00e9couvrir tout \u00e7a, tout seul \ud83d\ude42 <\/p>\n\n\n\n\n\n<p>Les slides sont disponibles et t\u00e9l\u00e9chargeables sur mon compte <a rel=\"noreferrer noopener\" href=\"https:\/\/www.slideshare.net\/freshdaz\/\" target=\"_blank\">SlideShare<\/a>:<\/p>\n\n\n\n<figure class=\"wp-block-embed-slideshare wp-block-embed is-type-rich is-provider-slideshare wp-embed-aspect-1-1 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"MySQL 8.0.21 - New Features Summary\" src=\"https:\/\/www.slideshare.net\/slideshow\/embed_code\/key\/n9s3LRX8LMGIMB\" width=\"427\" height=\"356\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" style=\"border:1px solid #CCC; border-width:1px; margin-bottom:5px; max-width: 100%;\" allowfullscreen> <\/iframe> <div style=\"margin-bottom:5px\"> <strong> <a href=\"https:\/\/www.slideshare.net\/slideshow\/mysql-8021-new-features-summary-238109628\/238109628\" title=\"MySQL 8.0.21 - New Features Summary\" target=\"_blank\">MySQL 8.0.21 &#8211; New Features Summary<\/a> <\/strong> from <strong><a href=\"https:\/\/www.slideshare.net\/freshdaz\" target=\"_blank\">Olivier DASINI<\/a><\/strong> <\/div>\n<\/div><\/figure>\n\n\n\n\n\n\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<p><strong><span style=\"text-decoration: underline;\">Ces articles devraient t&rsquo;int\u00e9resser<\/span><\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"http:\/\/dasini.net\/blog\/2020\/11\/10\/resume-des-nouveautes-de-mysql-8-0-22\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.22\">R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.22<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2020\/08\/27\/resume-des-nouveautes-de-mysql-8-0-21\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.21\">R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.21<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL 8.0.20 New Features Summary\">MySQL 8.0.20 New Features Summary<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2020\/02\/17\/mysql-8-0-19-new-features-summary\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL 8.0.19 New Features Summary\">MySQL 8.0.19 New Features Summary<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2019\/11\/26\/mysql-8-0-18-new-features-summary\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.18\">R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.18<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2019\/09\/19\/resume-des-nouveautes-de-mysql-8-0-17\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.17\">R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.17<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2019\/06\/05\/resume-des-nouveautes-de-mysql-8-0-16\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.16\">R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.16<\/a><\/li><\/ul>\n\n\n<\/div><\/div>\n\n\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/www.linkedin.com\/groups\/12524512\/\" target=\"_blank\" rel=\"noopener\" title=\"Olivier DASINI on Linkedin\">Follow me on Linkedin<\/a><\/p>\n\n\n\n<p>Watch my videos on my <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier's MySQL Channel\">YouTube channel<\/a> and <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\/?sub_confirmation=1\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Subscribe\">subscribe<\/a>.<\/p>\n\n\n\n<p>My <a href=\"https:\/\/www.slideshare.net\/freshdaz\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier DASINI on Slideshare\">Slideshare account<\/a>.<\/p>\n\n\n\n<p>My <a href=\"https:\/\/speakerdeck.com\/freshdaz\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier DASINI on Speaker Deck\">Speaker Deck account<\/a>.<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-vivid-red-color has-text-color\"><strong>Thanks for using HeatWave &amp; MySQL!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>J&rsquo;ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL, sortie le 13 juillet 2020, la 8.0.21.<\/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":[8,1618,39],"tags":[1632,1619,1624],"class_list":["post-3751","post","type-post","status-publish","format-standard","hentry","category-mysql","category-new","category-presentation","tag-8-0-21","tag-new","tag-presentation-2"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-Yv","jetpack-related-posts":[{"id":3492,"url":"https:\/\/dasini.net\/blog\/2019\/11\/26\/resume-des-nouveautes-de-mysql-8-0-18\/","url_meta":{"origin":3751,"position":0},"title":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.18","author":"Olivier DASINI","date":"26 novembre 2019","format":false,"excerpt":"J'ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL en date, la 8.0.18.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3969,"url":"https:\/\/dasini.net\/blog\/2020\/11\/10\/resume-des-nouveautes-de-mysql-8-0-22\/","url_meta":{"origin":3751,"position":1},"title":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.22","author":"Olivier DASINI","date":"10 novembre 2020","format":false,"excerpt":"J'ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL, sortie le 19 octobre 2020, la 8.0.22.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/CFFcaqhN-W8\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3140,"url":"https:\/\/dasini.net\/blog\/2019\/06\/05\/resume-des-nouveautes-de-mysql-8-0-16\/","url_meta":{"origin":3751,"position":2},"title":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.16","author":"Olivier DASINI","date":"5 juin 2019","format":false,"excerpt":"J'ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL en date, la 8.0.16.","rel":"","context":"Dans &quot;Group Replication&quot;","block_context":{"text":"Group Replication","link":"https:\/\/dasini.net\/blog\/category\/group-replication\/"},"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":3469,"url":"https:\/\/dasini.net\/blog\/2019\/09\/19\/resume-des-nouveautes-de-mysql-8-0-17\/","url_meta":{"origin":3751,"position":3},"title":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.17","author":"Olivier DASINI","date":"19 septembre 2019","format":false,"excerpt":"J'ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL en date, la 8.0.17. Je te propose une vid\u00e9o, en fran\u00e7ais, de moins de 5 minutes ainsi que les slides (en anglais) \u00e0 t\u00e9l\u00e9charger.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/BxenbgcKdPQ\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3762,"url":"https:\/\/dasini.net\/blog\/2020\/09\/10\/webinar-migrer-vers-mysql-8-0\/","url_meta":{"origin":3751,"position":4},"title":"Webinar &#8211; Migrer vers MySQL 8.0","author":"Olivier DASINI","date":"10 septembre 2020","format":false,"excerpt":"MySQL 8.0 est la derni\u00e8re GA - version conseill\u00e9e pour la production - de la base de donn\u00e9es la plus populaire au monde, disponible depuis 2018. Cette pr\u00e9sentation vous donnera les bonnes pratiques et les astuces pour vous aider \u00e0 migrer votre base de donn\u00e9es de mani\u00e8re fluide. Pourquoi migrer\u2026","rel":"","context":"Dans &quot;Conf\u00e9rence&quot;","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3747,"url":"https:\/\/dasini.net\/blog\/2020\/08\/27\/mysql-8-0-21-new-features-summary\/","url_meta":{"origin":3751,"position":5},"title":"MySQL 8.0.21 New Features Summary","author":"Olivier DASINI","date":"27 ao\u00fbt 2020","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.21 released on July 13th, 2020.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql-en\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3751","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=3751"}],"version-history":[{"count":8,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3751\/revisions"}],"predecessor-version":[{"id":4040,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3751\/revisions\/4040"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=3751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=3751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=3751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}