{"id":3747,"date":"2020-08-27T10:05:24","date_gmt":"2020-08-27T09:05:24","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=3747"},"modified":"2020-11-28T14:04:39","modified_gmt":"2020-11-28T13:04:39","slug":"mysql-8-0-21-new-features-summary","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2020\/08\/27\/mysql-8-0-21-new-features-summary\/","title":{"rendered":"MySQL 8.0.21 New Features Summary"},"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>Presentation of some of the new features of&nbsp;MySQL&nbsp;8.0.<strong>21<\/strong>&nbsp;released on July 13th, 2020.<\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Highlight<\/h2>\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<h2 class=\"wp-block-heading\">Slides<\/h2>\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<p>Download this presentation and others on my&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.slideshare.net\/freshdaz\/\" target=\"_blank\" class=\"aioseop-link\">SlideShare account<\/a>.<\/p>\n\n\n\n\n\n\n\n<p>Watch my videos on my <a aria-label=\"YouTube channel (opens in a new tab)\" class=\"aioseop-link\" href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\" target=\"_blank\" rel=\"noreferrer noopener\">YouTube channel<\/a>.<\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">That might interest you<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"http:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/\" title=\"MySQL 8.0.22 New Features Summary\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 8.0.22 New Features Summary<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2020\/08\/27\/mysql-8-0-21-new-features-summary\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL 8.0.21 New Features Summary\">MySQL 8.0.21 New Features Summary<\/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\/\" title=\"MySQL 8.0.18 New Features Summary\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 8.0.18 New Features Summary<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2019\/09\/19\/mysql-8-0-17-new-features-summary\/\" title=\"MySQL 8.0.17 \u2013 New Features Summary\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 8.0.17 \u2013 New Features Summary<\/a><\/li><li><a href=\"http:\/\/dasini.net\/blog\/2019\/06\/05\/mysql-8-0-16-new-features-summary\/\" title=\"MySQL 8.0.16 New Features Summary\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL 8.0.16 New Features Summary<\/a><\/li><\/ul>\n\n\n\n\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>Presentation of some of the new features of MySQL 8.0.21 released on July 13th, 2020.<\/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":[203,1618],"tags":[1632,1624,1126],"class_list":["post-3747","post","type-post","status-publish","format-standard","hentry","category-mysql-en","category-new","tag-8-0-21","tag-presentation-2","tag-summary"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-Yr","jetpack-related-posts":[{"id":3720,"url":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/","url_meta":{"origin":3747,"position":0},"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":[]},{"id":3503,"url":"https:\/\/dasini.net\/blog\/2020\/02\/17\/mysql-8-0-19-new-features-summary\/","url_meta":{"origin":3747,"position":1},"title":"MySQL 8.0.19 New Features Summary","author":"Olivier DASINI","date":"17 f\u00e9vrier 2020","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.19 released on January 13, 2020.","rel":"","context":"Dans &quot;High Availability&quot;","block_context":{"text":"High Availability","link":"https:\/\/dasini.net\/blog\/category\/high-availability\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3481,"url":"https:\/\/dasini.net\/blog\/2019\/11\/26\/mysql-8-0-18-new-features-summary\/","url_meta":{"origin":3747,"position":2},"title":"MySQL 8.0.18 New Features Summary","author":"Olivier DASINI","date":"26 novembre 2019","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.18 released on October 14, 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":"","width":0,"height":0},"classes":[]},{"id":3157,"url":"https:\/\/dasini.net\/blog\/2019\/06\/05\/mysql-8-0-16-new-features-summary\/","url_meta":{"origin":3747,"position":3},"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":3957,"url":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/","url_meta":{"origin":3747,"position":4},"title":"MySQL 8.0.22 New Features Summary","author":"Olivier DASINI","date":"10 novembre 2020","format":false,"excerpt":"Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 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\/CFFcaqhN-W8\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3463,"url":"https:\/\/dasini.net\/blog\/2019\/09\/19\/mysql-8-0-17-new-features-summary\/","url_meta":{"origin":3747,"position":5},"title":"MySQL 8.0.17 &#8211; New Features Summary","author":"Olivier DASINI","date":"19 septembre 2019","format":false,"excerpt":"This presentation is a summary of the MySQL 8.0.17 new features.","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":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3747","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=3747"}],"version-history":[{"count":6,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3747\/revisions"}],"predecessor-version":[{"id":4033,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3747\/revisions\/4033"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=3747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=3747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=3747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}