{"id":3957,"date":"2020-11-10T15:36:34","date_gmt":"2020-11-10T14:36:34","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=3957"},"modified":"2020-11-28T14:04:12","modified_gmt":"2020-11-28T13:04:12","slug":"mysql-8-0-22-new-features-summary","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/","title":{"rendered":"MySQL 8.0.22 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 class=\"wp-block-paragraph\">Presentation of some of the new features of&nbsp;MySQL&nbsp;8.0.<strong>22<\/strong>&nbsp;released on October 19th, 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><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/alter-database.html#alter-database-read-only\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Read Only Schema\">Read Only Schema<\/a><\/li><li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/performance-schema-error-log-table.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Error Log Table\">Error Log Table<\/a><\/li><li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/create-table-select.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Periodic Synchronization For SELECT INTO DUMPFILE|OUTFILE\">Periodic Synchronization For SELECT INTO DUMPFILE|OUTFILE<\/a><\/li><li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/connecting-using-dns-srv.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Libmysql Support For DNS SRV\">Libmysql Support For DNS SRV<\/a><\/li><li><a href=\"https:\/\/mysqlserverteam.com\/whats-new-in-mysql-shell-8-0-22\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Shell Enhancements\">MySQL Shell Enhancements<\/a><ul><li><a href=\"https:\/\/dev.mysql.com\/doc\/mysql-shell\/8.0\/en\/mysql-shell-utilities-dump-instance-schema.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Table dump utility\">Table dump utility<\/a><\/li><li><a href=\"https:\/\/dev.mysql.com\/doc\/mysql-shell\/8.0\/en\/mysql-shell-utilities-table-export.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Table export utility\">Table export utility<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/dev.mysql.com\/doc\/relnotes\/mysql-router\/en\/news-8-0-22.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Router Enhancements\">MySQL Router Enhancements<\/a><ul><li><a href=\"https:\/\/lefred.be\/content\/mysql-router-8-0-22-enables-rest-api-at-bootstrap\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Enable REST API at bootstrap\">Enable REST API at bootstrap<\/a><\/li><li><a href=\"https:\/\/dev.mysql.com\/worklog\/task\/?id=10703\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Scale routing core to 50k connections\">Scale routing core to 50k connections<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/mysqlhighavailability.com\/mysql-8-0-22-replication-enhancements\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Replication Enhancements\">MySQL Replication Enhancements<\/a><ul><li><a href=\"http:\/\/dasini.net\/blog\/2020\/11\/05\/automatic-connection-failover-for-asynchronous-replication\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Automatic Asynchronous Replication Connection Failover\">Automatic Asynchronous Replication Connection Failover<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/dev.mysql.com\/doc\/relnotes\/mysql-cluster\/8.0\/en\/news-8-0-22.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL NDB Cluster Enhancements\">MySQL NDB Cluster Enhancements<\/a><ul><li><a href=\"https:\/\/mysqlhighavailability.com\/new-mysql-ndb-cluster-8-0-22-out-now\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Support for IPv6 addresses\">Support for IPv6 addresses<\/a><\/li><li><a href=\"http:\/\/mikaelronstrom.blogspot.com\/2020\/10\/new-things-coming-in-mysql-cluster-8022.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Encrypted backup\">Encrypted backup<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/www.mysql.com\/products\/enterprise\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Enterprise New Features\">MySQL Enterprise New Features<\/a><ul><li><a href=\"https:\/\/dev.mysql.com\/doc\/relnotes\/mysql-enterprise-backup\/8.0\/en\/news-8-0-22.html\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Enterprise Backup\">MySQL Enterprise Backup<\/a><\/li><li><a href=\"https:\/\/blogs.oracle.com\/mysql\/mysql-announces-integration-with-oracle-cloud-infrastructure-vault\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Keyring plugin for Oracle Cloud Infrastructure Vault\">Keyring plugin for Oracle Cloud Infrastructure Vault<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/lefred.be\/content\/mysql-8-0-22-thank-you-for-the-contributions\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Thanks to the Contributors\">Thanks to the Contributors<\/a><\/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.22 - New Features Summary\" src=\"https:\/\/www.slideshare.net\/slideshow\/embed_code\/key\/vz4tkmsddOZtrO\" 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-8022-new-features-summary\/239179117\" title=\"MySQL 8.0.22 - New Features Summary\" target=\"_blank\">MySQL 8.0.22 &#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 class=\"wp-block-paragraph\">Download this presentation and others on my&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.slideshare.net\/freshdaz\/\" target=\"_blank\">SlideShare account<\/a>.<\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Video<\/h2>\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=\"MySQL 8.0.22 New Features Summary\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/CFFcaqhN-W8?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<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<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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<p class=\"wp-block-paragraph\">My <a href=\"https:\/\/www.slideshare.net\/freshdaz\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier DASINI on Slideshare\">Slideshare account<\/a> (<em>archive<\/em>).<\/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 wp-block-paragraph\"><strong>Thanks for using HeatWave &amp; MySQL!<\/strong><\/p>\n\n\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_post_was_ever_published":false},"categories":[203,1618],"tags":[1643,1624,1126],"class_list":["post-3957","post","type-post","status-publish","format-standard","hentry","category-mysql-en","category-new","tag-8-0-22","tag-presentation-2","tag-summary"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020. Highlight Read Only SchemaError Log TablePeriodic Synchronization For SELECT INTO DUMPFILE|OUTFILELibmysql Support For DNS SRVMySQL Shell EnhancementsTable dump utilityTable export utilityMySQL Router EnhancementsEnable REST API at bootstrapScale routing core to 50k connectionsMySQL Replication EnhancementsAutomatic Asynchronous Replication Connection FailoverMySQL NDB Cluster EnhancementsSupport for IPv6\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Olivier DASINI\"\/>\n\t<meta name=\"google-site-verification\" content=\"HN6x37mM2NBzUxcsZUKC8OY_DxAioI6oKazYPPNq02c\" \/>\n\t<meta name=\"keywords\" content=\"8.0.22,presentation,summary,mysql,new\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights | Exploring Beyond the Limits of Knowledge\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"MySQL 8.0.22 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\" \/>\n\t\t<meta property=\"og:description\" content=\"Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020. Highlight Read Only SchemaError Log TablePeriodic Synchronization For SELECT INTO DUMPFILE|OUTFILELibmysql Support For DNS SRVMySQL Shell EnhancementsTable dump utilityTable export utilityMySQL Router EnhancementsEnable REST API at bootstrapScale routing core to 50k connectionsMySQL Replication EnhancementsAutomatic Asynchronous Replication Connection FailoverMySQL NDB Cluster EnhancementsSupport for IPv6\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-11-10T14:36:34+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-11-28T13:04:12+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@freshdaz\" \/>\n\t\t<meta name=\"twitter:title\" content=\"MySQL 8.0.22 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020. Highlight Read Only SchemaError Log TablePeriodic Synchronization For SELECT INTO DUMPFILE|OUTFILELibmysql Support For DNS SRVMySQL Shell EnhancementsTable dump utilityTable export utilityMySQL Router EnhancementsEnable REST API at bootstrapScale routing core to 50k connectionsMySQL Replication EnhancementsAutomatic Asynchronous Replication Connection FailoverMySQL NDB Cluster EnhancementsSupport for IPv6\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@freshdaz\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#article\",\"name\":\"MySQL 8.0.22 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\",\"headline\":\"MySQL 8.0.22 New Features Summary\",\"author\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/dasini.net\\\/blog\\\/wp-content\\\/uploads\\\/Sakila_on_a_Rock_mozaik_600x333_by_olivier_dasini.JPG\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#articleImage\"},\"datePublished\":\"2020-11-10T15:36:34+01:00\",\"dateModified\":\"2020-11-28T14:04:12+01:00\",\"inLanguage\":\"fr-FR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#webpage\"},\"articleSection\":\"MySQL, New, 8.0.22, Presentation, Summary, English, pll_5faaa573d686d\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dasini.net\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"position\":2,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#listItem\",\"name\":\"MySQL 8.0.22 New Features Summary\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#listItem\",\"position\":3,\"name\":\"MySQL 8.0.22 New Features Summary\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"name\":\"MySQL\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\",\"name\":\"Olivier DASINI\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Olivier DASINI\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/\",\"name\":\"Olivier DASINI\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Olivier DASINI\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#webpage\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/\",\"name\":\"MySQL 8.0.22 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\",\"description\":\"Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020. Highlight Read Only SchemaError Log TablePeriodic Synchronization For SELECT INTO DUMPFILE|OUTFILELibmysql Support For DNS SRVMySQL Shell EnhancementsTable dump utilityTable export utilityMySQL Router EnhancementsEnable REST API at bootstrapScale routing core to 50k connectionsMySQL Replication EnhancementsAutomatic Asynchronous Replication Connection FailoverMySQL NDB Cluster EnhancementsSupport for IPv6\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2020\\\/11\\\/10\\\/mysql-8-0-22-new-features-summary\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"datePublished\":\"2020-11-10T15:36:34+01:00\",\"dateModified\":\"2020-11-28T14:04:12+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/\",\"name\":\"dasini.net - Diary of a MySQL expert\",\"description\":\"Exploring Beyond the Limits of Knowledge\",\"inLanguage\":\"fr-FR\",\"publisher\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MySQL 8.0.22 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","description":"Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020. Highlight Read Only SchemaError Log TablePeriodic Synchronization For SELECT INTO DUMPFILE|OUTFILELibmysql Support For DNS SRVMySQL Shell EnhancementsTable dump utilityTable export utilityMySQL Router EnhancementsEnable REST API at bootstrapScale routing core to 50k connectionsMySQL Replication EnhancementsAutomatic Asynchronous Replication Connection FailoverMySQL NDB Cluster EnhancementsSupport for IPv6","canonical_url":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/","robots":"max-image-preview:large","keywords":"8.0.22,presentation,summary,mysql,new","webmasterTools":{"google-site-verification":"HN6x37mM2NBzUxcsZUKC8OY_DxAioI6oKazYPPNq02c","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#article","name":"MySQL 8.0.22 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","headline":"MySQL 8.0.22 New Features Summary","author":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"publisher":{"@id":"https:\/\/dasini.net\/blog\/#person"},"image":{"@type":"ImageObject","url":"http:\/\/dasini.net\/blog\/wp-content\/uploads\/Sakila_on_a_Rock_mozaik_600x333_by_olivier_dasini.JPG","@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#articleImage"},"datePublished":"2020-11-10T15:36:34+01:00","dateModified":"2020-11-28T14:04:12+01:00","inLanguage":"fr-FR","mainEntityOfPage":{"@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#webpage"},"isPartOf":{"@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#webpage"},"articleSection":"MySQL, New, 8.0.22, Presentation, Summary, English, pll_5faaa573d686d"},{"@type":"BreadcrumbList","@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog#listItem","position":1,"name":"Home","item":"https:\/\/dasini.net\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","position":2,"name":"MySQL","item":"https:\/\/dasini.net\/blog\/category\/mysql-en\/","nextItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#listItem","name":"MySQL 8.0.22 New Features Summary"},"previousItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#listItem","position":3,"name":"MySQL 8.0.22 New Features Summary","previousItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","name":"MySQL"}}]},{"@type":"Person","@id":"https:\/\/dasini.net\/blog\/#person","name":"Olivier DASINI","image":{"@type":"ImageObject","@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g","width":96,"height":96,"caption":"Olivier DASINI"}},{"@type":"Person","@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author","url":"https:\/\/dasini.net\/blog\/author\/freshdaz\/","name":"Olivier DASINI","image":{"@type":"ImageObject","@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g","width":96,"height":96,"caption":"Olivier DASINI"}},{"@type":"WebPage","@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#webpage","url":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/","name":"MySQL 8.0.22 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","description":"Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020. Highlight Read Only SchemaError Log TablePeriodic Synchronization For SELECT INTO DUMPFILE|OUTFILELibmysql Support For DNS SRVMySQL Shell EnhancementsTable dump utilityTable export utilityMySQL Router EnhancementsEnable REST API at bootstrapScale routing core to 50k connectionsMySQL Replication EnhancementsAutomatic Asynchronous Replication Connection FailoverMySQL NDB Cluster EnhancementsSupport for IPv6","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/dasini.net\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/#breadcrumblist"},"author":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"creator":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"datePublished":"2020-11-10T15:36:34+01:00","dateModified":"2020-11-28T14:04:12+01:00"},{"@type":"WebSite","@id":"https:\/\/dasini.net\/blog\/#website","url":"https:\/\/dasini.net\/blog\/","name":"dasini.net - Diary of a MySQL expert","description":"Exploring Beyond the Limits of Knowledge","inLanguage":"fr-FR","publisher":{"@id":"https:\/\/dasini.net\/blog\/#person"}}]},"og:locale":"fr_FR","og:site_name":"Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights | Exploring Beyond the Limits of Knowledge","og:type":"article","og:title":"MySQL 8.0.22 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","og:description":"Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020. Highlight Read Only SchemaError Log TablePeriodic Synchronization For SELECT INTO DUMPFILE|OUTFILELibmysql Support For DNS SRVMySQL Shell EnhancementsTable dump utilityTable export utilityMySQL Router EnhancementsEnable REST API at bootstrapScale routing core to 50k connectionsMySQL Replication EnhancementsAutomatic Asynchronous Replication Connection FailoverMySQL NDB Cluster EnhancementsSupport for IPv6","og:url":"https:\/\/dasini.net\/blog\/2020\/11\/10\/mysql-8-0-22-new-features-summary\/","article:published_time":"2020-11-10T14:36:34+00:00","article:modified_time":"2020-11-28T13:04:12+00:00","twitter:card":"summary","twitter:site":"@freshdaz","twitter:title":"MySQL 8.0.22 New Features Summary | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","twitter:description":"Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020. Highlight Read Only SchemaError Log TablePeriodic Synchronization For SELECT INTO DUMPFILE|OUTFILELibmysql Support For DNS SRVMySQL Shell EnhancementsTable dump utilityTable export utilityMySQL Router EnhancementsEnable REST API at bootstrapScale routing core to 50k connectionsMySQL Replication EnhancementsAutomatic Asynchronous Replication Connection FailoverMySQL NDB Cluster EnhancementsSupport for IPv6","twitter:creator":"@freshdaz"},"aioseo_meta_data":{"post_id":"3957","title":null,"description":"","keywords":"","keyphrases":null,"primary_term":null,"canonical_url":"","og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 12:18:58","updated":"2025-06-24 10:02:23","seo_analyzer_scan_date":null},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-11P","jetpack-related-posts":[{"id":3481,"url":"https:\/\/dasini.net\/blog\/2019\/11\/26\/mysql-8-0-18-new-features-summary\/","url_meta":{"origin":3957,"position":0},"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":3747,"url":"https:\/\/dasini.net\/blog\/2020\/08\/27\/mysql-8-0-21-new-features-summary\/","url_meta":{"origin":3957,"position":1},"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":[]},{"id":3720,"url":"https:\/\/dasini.net\/blog\/2020\/05\/26\/mysql-8-0-20-new-features-summary\/","url_meta":{"origin":3957,"position":2},"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":3957,"position":3},"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":3157,"url":"https:\/\/dasini.net\/blog\/2019\/06\/05\/mysql-8-0-16-new-features-summary\/","url_meta":{"origin":3957,"position":4},"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":3463,"url":"https:\/\/dasini.net\/blog\/2019\/09\/19\/mysql-8-0-17-new-features-summary\/","url_meta":{"origin":3957,"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\/3957","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=3957"}],"version-history":[{"count":10,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3957\/revisions"}],"predecessor-version":[{"id":6520,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/3957\/revisions\/6520"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=3957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=3957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=3957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}