{"id":2700,"date":"2018-10-29T15:16:10","date_gmt":"2018-10-29T14:16:10","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=2700"},"modified":"2018-10-30T16:20:19","modified_gmt":"2018-10-30T15:20:19","slug":"presentation-mysql-8-0-quoi-de-neuf-au-forum-php-2018","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2018\/10\/29\/presentation-mysql-8-0-quoi-de-neuf-au-forum-php-2018\/","title":{"rendered":"Pr\u00e9sentation  MySQL 8.0 : Quoi de neuf ? au Forum PHP 2018"},"content":{"rendered":"<p>Ce vendredi 26 octobre, j&rsquo;ai eu le plaisir de pr\u00e9senter devant une salle comble, malgr\u00e9 l&rsquo;horaire matinal (preuve s&rsquo;il en faut que les bases de donn\u00e9es sont un sujet qui int\u00e9resse les d\u00e9veloppeurs), les <strong>nouveaut\u00e9s de MySQL 8.0<\/strong>.<\/p>\n<p>Au programme, NoSQL + SQL = MySQL o\u00f9 MySQL peut aussi \u00eatre utilis\u00e9 comme un JSON Document Store, mais aussi les CTE (Common Table Expression), Window Functions, Instant Add Column, Invisible Indexes, Histograms, InnoDB Cluster,&#8230;\u00a0 que du bon en fait \ud83d\ude42 \u00e0 d\u00e9couvrir ci dessous :<\/p>\n<p>&nbsp;<\/p>\n<p>[slideshare id=121057225&amp;doc=mysql8-181029103808]<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Et encore un grand bravo \u00e0 l&rsquo;<a href=\"https:\/\/afup.org\/\" target=\"_blank\" rel=\"noopener\">AFUP<\/a> pour la qualit\u00e9 de ses \u00e9v\u00e9nements !<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignleft\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/olivier_dasini_mysql_speaker_2.jpg?resize=640%2C427\" alt=\"AFUP Forum PHP 2018 - MySQL 8.0\" width=\"640\" height=\"427\" \/><\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignleft\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/olivier_dasini_mysql_speaker_1.jpg?resize=640%2C427\" alt=\"AFUP Forum PHP 2018 - MySQL 8.0\" width=\"640\" height=\"427\" \/><\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignleft\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/olivier_dasini_mysql_speaker_forum_PHP_2018.jpg?resize=640%2C369\" alt=\"AFUP Forum PHP 2018 - MySQL 8.0\" width=\"640\" height=\"369\" \/><\/p>\n<p>Photos disponibles <a href=\"https:\/\/www.flickr.com\/groups\/3071907@N25\/pool\/\" target=\"_blank\" rel=\"noopener\">ici<\/a>. <em>powered by <strong><a href=\"https:\/\/twitter.com\/julienPauli\" target=\"_blank\" rel=\"noopener\">Julien Pauli<\/a><\/strong>\u00a0<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Thanks for using MySQL!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ce vendredi 26 octobre, j&rsquo;ai eu le plaisir de pr\u00e9senter devant une salle comble, malgr\u00e9 l&rsquo;horaire matinal (preuve s&rsquo;il en faut que les bases de donn\u00e9es sont un sujet qui int\u00e9resse les d\u00e9veloppeurs), les nouveaut\u00e9s de MySQL 8.0.<\/p>\n<p>Au programme, NoSQL + SQL = MySQL o\u00f9 MySQL peut aussi \u00eatre utilis\u00e9 comme un JSON Document Store, mais aussi les CTE (Common Table Expression), Window Functions, Instant Add Column, Invisible Indexes, Histograms, InnoDB Cluster,&#8230;\u00a0 que du bon en fait \ud83d\ude42 \u00e0 d\u00e9couvrir ci dessous :<br \/>\nhttps:\/\/www.slideshare.net\/freshdaz\/mysql-80-whats-new<\/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":[25,403,282,288,260,8,284,9,39,391],"tags":[],"class_list":["post-2700","post","type-post","status-publish","format-standard","hentry","category-conference","category-document-store","category-group-replication","category-innodb-cluster","category-json-fr","category-mysql","category-nosql","category-php","category-presentation","category-securite"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-Hy","jetpack-related-posts":[{"id":2684,"url":"https:\/\/dasini.net\/blog\/2018\/09\/27\/slides-de-lapero-php-mysql-8-0-avec-lafup-toulouse\/","url_meta":{"origin":2700,"position":0},"title":"Slides de l&rsquo;Ap\u00e9ro PHP MySQL 8.0 avec l&rsquo;AFUP Toulouse","author":"Olivier DASINI","date":"27 septembre 2018","format":false,"excerpt":"J'ai eu l'immense plaisir, ce mardi 25 septembre 2018, d'\u00eatre sous le doux soleil toulousain pour y rencontrer la communaut\u00e9 PHP, lors d'un ap\u00e9ro PHP. Je tiens \u00e0 remercier\u00a0toutes les personnes qui ont particip\u00e9 \u00e0 ce moment de partage et d'\u00e9change d'exception (et merci \u00e0 toi Olivier pour avoir initi\u00e9\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":2731,"url":"https:\/\/dasini.net\/blog\/2018\/11\/23\/slides-du-mysql-day-paris-2018-nosql-sql-mysql\/","url_meta":{"origin":2700,"position":1},"title":"Slides du MySQL Day Paris 2018 \u2013 NoSQL + SQL = MySQL","author":"Olivier DASINI","date":"23 novembre 2018","format":false,"excerpt":"Au nom de toute l'\u00e9quipe MySQL, je souhaite vous remercier pour votre pr\u00e9sence ! On a certes d\u00fb un peu pousser les murs (sorry for that), mais finalement cela n'a fait que contribuer \u00e0 rendre l'\u00e9v\u00e9nement encore plus convivial :) Et voici les slides:","rel":"","context":"Dans &quot;audit&quot;","block_context":{"text":"audit","link":"https:\/\/dasini.net\/blog\/category\/audit\/"},"img":{"alt_text":"MySQL 8 is Great","src":"https:\/\/i0.wp.com\/pbs.twimg.com\/media\/DsmMn7HXcAApacW.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/pbs.twimg.com\/media\/DsmMn7HXcAApacW.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/pbs.twimg.com\/media\/DsmMn7HXcAApacW.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":2656,"url":"https:\/\/dasini.net\/blog\/2018\/09\/19\/apero-php-mysql-8-0-avec-lafup-toulouse\/","url_meta":{"origin":2700,"position":2},"title":"Ap\u00e9ro PHP MySQL 8.0 avec l&rsquo;AFUP Toulouse","author":"Olivier DASINI","date":"19 septembre 2018","format":false,"excerpt":"Ce mardi 25 septembre 2018, rendez-vous dans la ville rose pour un Ap\u00e9ro PHP \u00e0 l\u2019initiative de l'AFUP Toulouse, avec pour th\u00e9matique MySQL 8.0. Au programme: Pr\u00e9sentation de MySQL 8.0 - la toute derni\u00e8re version. MySQL Document Store - le mode document qui permet d'utiliser MySQL en mode \"NoSQL\" avec\u2026","rel":"","context":"Dans &quot;Conf\u00e9rence&quot;","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"Meetup AperoPHP AFUP Toulouse","src":"http:\/\/dasini.net\/blog\/wp-content\/uploads\/meetup.svg","width":350,"height":200},"classes":[]},{"id":1736,"url":"https:\/\/dasini.net\/blog\/2016\/11\/24\/retour-sur-le-mysql-day-paris-2016\/","url_meta":{"origin":2700,"position":3},"title":"Retour sur le MySQL Day Paris 2016","author":"Olivier DASINI","date":"24 novembre 2016","format":false,"excerpt":"Venez d\u00e9couvrir le nouveau MySQL Cloud Service d'Oracle et toutes les nouveaut\u00e9s produits MySQL annonc\u00e9es \u00e0 Oracle Open World Vous utilisez ou envisagez d\u2019utiliser des services cloud pour votre projet ? Le nouveau MySQL Cloud Service d\u2019Oracle fournit un service cloud simple, automatis\u00e9, int\u00e9gr\u00e9, pr\u00eat \u00e0 l\u2019emploi, pour permettre aux\u2026","rel":"","context":"Dans &quot;Conf\u00e9rence&quot;","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"Oracle MySQL Day Paris","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/Oracle_MySQL_Day_Paris.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/Oracle_MySQL_Day_Paris.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/Oracle_MySQL_Day_Paris.png?resize=525%2C300 1.5x"},"classes":[]},{"id":2715,"url":"https:\/\/dasini.net\/blog\/2018\/11\/07\/mysql-day-paris-nosql-sql-mysql\/","url_meta":{"origin":2700,"position":4},"title":"MySQL Day Paris &#8211; NoSQL + SQL = MySQL","author":"Olivier DASINI","date":"7 novembre 2018","format":false,"excerpt":"\u00c9quation simple, quoique un tantinet intrigante, n'est ce pas ? En fait, MySQL 8.0 permet l'unification des donn\u00e9es non structur\u00e9es (schema-less) et des donn\u00e9es structur\u00e9es (schema-based) dans une seule et m\u00eame pile technologique !!! MySQL 8.0 c'est aussi pl\u00e9thore de nouvelles fonctionnalit\u00e9s li\u00e9es \u00e0 la s\u00e9curit\u00e9, \u00e0 la haute disponibilit\u00e9,\u2026","rel":"","context":"Dans &quot;Conf\u00e9rence&quot;","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"Oracle MySQL Day Paris","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/MySQL_Day_Paris6.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2959,"url":"https:\/\/dasini.net\/blog\/2019\/04\/08\/200\/","url_meta":{"origin":2700,"position":5},"title":"200 !!","author":"Olivier DASINI","date":"8 avril 2019","format":false,"excerpt":"Cet article est en fait mon 200 \u00e8me \\o\/ Pour marquer le coup, j'ai d\u00e9cid\u00e9 de faire une petite pause et de regarder dans le r\u00e9troviseur...","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"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\/2700","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=2700"}],"version-history":[{"count":10,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/2700\/revisions"}],"predecessor-version":[{"id":2713,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/2700\/revisions\/2713"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=2700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=2700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=2700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}