{"id":2959,"date":"2019-04-08T14:31:09","date_gmt":"2019-04-08T13:31:09","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=2959"},"modified":"2019-09-03T07:23:19","modified_gmt":"2019-09-03T06:23:19","slug":"200","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2019\/04\/08\/200\/","title":{"rendered":"200 !!"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/11001000-4.png\" alt=\"200 (binary)\"><figcaption><br><\/figcaption><\/figure><\/div>\n\n\n\n<p>Tu es entrain de lire le <strong>200<\/strong> \u00e8me article publi\u00e9 sur ce blog \\o\/<br>Pour marquer le coup, j&rsquo;ai d\u00e9cid\u00e9 de faire une petite pause et de regarder dans le r\u00e9troviseur&#8230;<\/p>\n\n\n\n<p>Mon <strong>1<\/strong>er article a \u00e9t\u00e9 publi\u00e9 le 26\/10\/2008  :-0<br>Il s&rsquo;intitule en toute sobri\u00e9t\u00e9 <a rel=\"noreferrer noopener\" aria-label=\"Open Source (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2008\/10\/26\/bonjour-tout-le-monde\/\" target=\"_blank\">Open Source<\/a>, et nous donne la d\u00e9finition originelle, v 1.0.<br>Par les temps qui courent, ce n&rsquo;est pas superflu de rappeler l&rsquo;esprit du logiciel libre.<\/p>\n\n\n\n<p>La licence d\u2019un programme \u00ab open-source\u00bb doit correspondre aux crit\u00e8res suivants :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Libre redistribution du logiciel.<\/strong><\/li><li><strong>Code source doit accessible.<\/strong><\/li><li><strong>Autoriser les modifications<\/strong><strong>.<\/strong><\/li><li><strong>Int\u00e9grit\u00e9 du code source de l\u2019auteur.<\/strong><\/li><li><strong>Pas de discrimination entre les personnes ou les groupes.<\/strong><\/li><li><strong>Pas de discrimination entre les domaines d\u2019application.<\/strong><\/li><li><strong>Distribution de la licence.<\/strong><\/li><li><strong>La licence ne doit pas \u00eatre sp\u00e9cifique \u00e0&nbsp; un produit.<\/strong><\/li><li><strong>La licence ne doit pas contaminer d\u2019autres logiciels.<\/strong><\/li><\/ul>\n\n\n\n<p><a href=\"http:\/\/www.linux-france.org\/article\/these\/osd\/fr-osd.html\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">http:\/\/www.linux-france.org\/article\/these\/osd\/fr-osd.html<\/a><\/p>\n\n\n\n<p>En clair: <\/p>\n\n\n\n<p style=\"text-align:center\" class=\"has-text-color has-medium-font-size has-vivid-red-color\"><strong>Free as in \u201cFreedom\u201d, not as in \u201cFree Beer\u201d<\/strong><\/p>\n\n\n\n\n\n<p>Mon <strong>1<\/strong>er article en anglais (enfin plut\u00f4t du franglais) a \u00e9t\u00e9 publi\u00e9 le 14\/08\/2012, il s&rsquo;agit d&rsquo;une question d&rsquo;un coll\u00e8gue sur comment optimiser son <a rel=\"noreferrer noopener\" aria-label=\"ALTER TABLE (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2012\/08\/14\/alter-optimization\/\" target=\"_blank\">ALTER TABLE<\/a>, (mes excuses pour les soucis d&rsquo;affichage, probl\u00e8me de compatibilit\u00e9  WordPress) .<\/p>\n\n\n\n<p>D\u00e8s lors, je me retrouve de fait, \u00e0 l&rsquo;insu de mon plein gr\u00e8s,  avec 2 blogs:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"http:\/\/dasini.net\/blog\/fr\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">http:\/\/dasini.net\/blog\/fr<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"http:\/\/dasini.net\/blog\/en (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/en\" target=\"_blank\">http:\/\/dasini.net\/blog\/en<\/a><\/li><\/ul>\n\n\n\n<p>Etant attach\u00e9 \u00e0 la langue fran\u00e7aise, (malgr\u00e9 le fait d&rsquo;\u00eatre nul en orthographe), le but \u00e0 l&rsquo;origine \u00e9tait d&rsquo;avoir une version fran\u00e7aise de tous les articles&#8230; LOL (malheureusement trop consommateur en temps).<\/p>\n\n\n\n<p><br><u>R\u00e9sultat<\/u>; <br>La version anglaise est plus souvent mise \u00e0 jour et les articles ne sont pas les m\u00eames version FR et version EN.<br>2 blogs pour le prix d&rsquo;un en somme \ud83d\ude42<\/p>\n\n\n\n\n\n<p>J&rsquo;ai \u00e9galement eu l&rsquo;opportunit\u00e9 de co-\u00e9crire 3 livres sur MySQL:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"Audit et optimisation MySQL 5 : Bonnes pratiques pour l'administrateur (opens in a new tab)\" href=\"https:\/\/www.amazon.fr\/Audit-optimisation-MySQL-ladministrateur-2010-03-25\/dp\/B00IVOTVZ2\/ref=sr_1_9?qid=1554725555&amp;refinements=p_27%3AOlivier+Dasini&amp;s=books&amp;sr=1-9\" target=\"_blank\">Audit et optimisation MySQL 5 : Bonnes pratiques pour l&rsquo;administrateur<\/a> (2010)<\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL 5 - Administration et optimisation (opens in a new tab)\" href=\"https:\/\/www.amazon.fr\/MySQL-Administration-optimisation-Olivier-Dasini\/dp\/2746055163\/ref=sr_1_1?qid=1554725555&amp;refinements=p_27%3AOlivier+Dasini&amp;s=books&amp;sr=1-1\" target=\"_blank\">MySQL 5 &#8211; Administration et optimisation<\/a> (2010)<\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL 5.6 - Administration et optimisation (opens in a new tab)\" href=\"https:\/\/www.amazon.fr\/MySQL-5-6-Administration-optimisation-COMBAUDON\/dp\/B0160JDGQ4\/ref=sr_1_8?qid=1554725555&amp;refinements=p_27%3AOlivier+Dasini&amp;s=books&amp;sr=1-8\" target=\"_blank\">MySQL 5.6 &#8211; Administration et optimisation<\/a> (2013)<\/li><\/ul>\n\n\n\n\n\n<p>Riche de toutes ces ann\u00e9es, \u00e0 crapahuter \u00e0 l&rsquo;int\u00e9rieur des \u00e9cosyst\u00e8mes base de donn\u00e9es et plus particuli\u00e8rement MySQL, voici les tendances fortes que j&rsquo;ai remarqu\u00e9 aupr\u00e8s de nos utilisateurs:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">S\u00e9curit\u00e9<\/h3>\n\n\n\n<p>La donn\u00e9e est bien souvent au c\u0153ur de la strat\u00e9gie de l&rsquo;entreprise. Et m\u00eame lorsque ce n&rsquo;est pas le cas, nos donn\u00e9es doivent, dor\u00e9navant (et c&rsquo;est pas trop t\u00f4t), \u00eatre prot\u00e9g\u00e9es.<br>MySQL propose nativement ou sous forme de plugins, diff\u00e9rents outils, plugins et strat\u00e9gies pour minimiser les risques:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Security \u2013 Password Validation Plugin (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2018\/03\/01\/mysql-security-password-validation-plugin\/\" target=\"_blank\">MySQL Security \u2013 Password Validation Plugin<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Security \u2013 Password Management (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2018\/03\/07\/mysql-security-password-management\/\" target=\"_blank\">MySQL Security \u2013 Password Management<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Security \u2013 User Account Locking (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2018\/03\/14\/mysql-security-user-account-locking\/\" target=\"_blank\">MySQL Security \u2013 User Account Locking<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Security \u2013 The Connection-Control Plugins (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2018\/03\/29\/mysql-security-the-connection-control-plugins\/\" target=\"_blank\">MySQL Security \u2013 The Connection-Control Plugins<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Security \u2013 MySQL Enterprise Audit (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2018\/04\/04\/mysql-security-mysql-enterprise-audit\/\" target=\"_blank\">MySQL Security \u2013 MySQL Enterprise Audit<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Security \u2013 MySQL Enterprise Transparent Data Encryption (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2018\/04\/10\/mysql-security-mysql-enterprise-transparent-data-encryption\/\" target=\"_blank\">MySQL Security \u2013 MySQL Enterprise Transparent Data Encryption<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Security \u2013 MySQL Enterprise Firewall (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2018\/04\/16\/mysql-security-mysql-enterprise-firewall\/\" target=\"_blank\">MySQL Security \u2013 MySQL Enterprise Firewall<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Security \u2013 MySQL Enterprise Data Masking and De-Identification (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2019\/03\/19\/mysql-security-mysql-enterprise-data-masking-and-de-identification\/\" target=\"_blank\">MySQL Security \u2013 MySQL Enterprise Data Masking and De-Identification<\/a> <\/li><\/ul>\n\n\n\n<p>La s\u00e9curit\u00e9 est \u00e9galement un th\u00e8me d\u00e9velopp\u00e9 par d&rsquo;autres, notamment l&rsquo;excellente <a href=\"https:\/\/twitter.com\/elisetta1984\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Elisa (opens in a new tab)\">Elisa<\/a>:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL 8.0 \u2013 Roles are finally there (opens in a new tab)\" href=\"https:\/\/blog.dbi-services.com\/mysql-8-0-roles-are-finally-there\/\" target=\"_blank\">MySQL 8.0 \u2013 Roles are finally there<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"Password Verification Policy in MySQL 8.0.13 (opens in a new tab)\" href=\"https:\/\/blog.dbi-services.com\/password-verification-policy-in-mysql-8-0-13\/\" target=\"_blank\">Password Verification Policy in MySQL 8.0.13<\/a> <\/li><li><a href=\"https:\/\/blog.dbi-services.com\/mysql-8-and-security-encryption-of-binary-logs\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MySQL 8 and Security \u2013 Encryption of binary logs (opens in a new tab)\">MySQL 8 and Security \u2013 Encryption of binary logs<\/a> <\/li><\/ul>\n\n\n\n<p><br> <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Haute Disponibilit\u00e9<\/h3>\n\n\n\n<p>La tendance est au toujours <em><strong>UP<\/strong><\/em>. <br>La haute dispo, base de donn\u00e9es et pas cher!!! est devenue la norme.<br> En plus de la r\u00e9plication historique, <a rel=\"noreferrer noopener\" aria-label=\"MySQL Replication (opens in a new tab)\" href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/replication.html\" target=\"_blank\">MySQL Replication<\/a>, et de l&rsquo;ultra performante technologie qu&rsquo;est <a rel=\"noreferrer noopener\" aria-label=\"MySQL NDB Cluster (opens in a new tab)\" href=\"https:\/\/mysql.wisborg.dk\/2018\/02\/14\/what-is-mysql-ndb-cluster\/\" target=\"_blank\">MySQL NDB Cluster<\/a>. MySQL propose depuis la version 5.7, <strong>MySQL InnoDB Cluster<\/strong>. C&rsquo;est en passant, la fonctionnalit\u00e9 pour laquelle je re\u00e7ois le plus de demandes:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\" (s\u2019ouvre dans un nouvel onglet)\" href=\"http:\/\/dasini.net\/blog\/2019\/09\/03\/tutoriel-deployer-mysql-8-0-innodb-cluster-09-2019\/\" target=\"_blank\">Tutoriel \u2013 D\u00e9ployer MySQL 8.0 InnoDB Cluster<\/a> <\/li><li><a href=\"http:\/\/dasini.net\/blog\/2018\/08\/21\/tutoriel-deployer-mysql-5-7-innodb-cluster\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (s\u2019ouvre dans un nouvel onglet)\">Tutoriel \u2013 D\u00e9ployer MySQL 5.7 InnoDB Cluster<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL InnoDB Cluster \u2013 howto install it from scratch (opens in a new tab)\" href=\"https:\/\/lefred.be\/content\/mysql-innodb-cluster-howto-install-it-from-scratch\/\" target=\"_blank\">MySQL InnoDB Cluster \u2013 howto install it from scratch<\/a> <em>(by lefred)<\/em><\/li><\/ul>\n\n\n\n\n\n<h3 class=\"wp-block-heading\">JSON &amp; Document Store<\/h3>\n\n\n\n<p>Le JSON est devenu un standard. <br>MySQL offre une tr\u00e8s grande flexibilit\u00e9 pour manipuler les documents JSON, avec du SQL, mais aussi en mode NoSQL avec du CRUD.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL JSON Document Store (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2019\/04\/02\/mysql-json-document-store\/\" target=\"_blank\">MySQL JSON Document Store<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"30 mins avec les fonctions JSON de MySQL (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2018\/07\/23\/30-mins-avec-les-fonctions-json-de-mysql\/\" target=\"_blank\">30 mins avec les fonctions JSON de MySQL<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"30 mins with MySQL JSON functions (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2018\/07\/23\/30-mins-with-mysql-json-functions\/\" target=\"_blank\">30 mins with MySQL JSON functions<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"JSON et colonnes g\u00e9n\u00e9r\u00e9es avec MySQL (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2015\/11\/30\/json-et-colonnes-generees-avec-mysql\/\" target=\"_blank\">JSON et colonnes g\u00e9n\u00e9r\u00e9es avec MySQL<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"30 mins avec JSON en MySQL (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2015\/11\/17\/30-mins-avec-json-en-mysql\/\" target=\"_blank\">30 mins avec JSON en MySQL<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"30 mins with JSON in MySQL (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2015\/11\/17\/30-mins-with-json-in-mysql\/\" target=\"_blank\">30 mins with JSON in MySQL<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Functional Indexes (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2019\/03\/14\/mysql-functional-indexes\/\" target=\"_blank\">MySQL Functional Indexes<\/a> <\/li><\/ul>\n\n\n\n\n\n<h3 class=\"wp-block-heading\">T\u00e9l\u00e9charger MySQL<\/h3>\n\n\n\n<p>C&rsquo;est LA base \ud83d\ude42<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"O\u00f9 t\u00e9l\u00e9charger MySQL ? (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2017\/07\/24\/ou-telecharger-mysql\/\" target=\"_blank\">O\u00f9 t\u00e9l\u00e9charger MySQL ?<\/a> <\/li><li><a href=\"http:\/\/dasini.net\/blog\/2017\/07\/24\/how-to-get-mysql\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"How to Get MySQL? (opens in a new tab)\">How to Get MySQL?<\/a> <\/li><\/ul>\n\n\n\n\n\n<h3 class=\"wp-block-heading\">Historique des versions de MySQL<\/h3>\n\n\n\n<p>Back in the day\u2026<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"Topo sur les premi\u00e8res versions publique de MySQL (opens in a new tab)\" href=\"http:\/\/dasini.net\/blog\/2017\/07\/19\/topo-sur-les-premieres-versions-publique-de-mysql\/\" target=\"_blank\">Topo sur les premi\u00e8res versions publique de MySQL<\/a> <\/li><li><a href=\"http:\/\/dasini.net\/blog\/2017\/07\/19\/mysql-first-public-releases\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MySQL first Public Releases (opens in a new tab)\">MySQL first Public Releases<\/a> <\/li><\/ul>\n\n\n\n\n\n<h3 class=\"wp-block-heading\">Migration<\/h3>\n\n\n\n<p>C&rsquo;est un sujet que je n&rsquo;ai pas encore abord\u00e9, mais c&rsquo;est pr\u00e9vu \ud83d\ude42<\/p>\n\n\n\n<p>Un sujet connexe. <br>Contrairement \u00e0 ce que certains veulent bien faire croire, MariaDB ce n&rsquo;est <strong>PAS<\/strong> du MySQL et n&rsquo;est <strong>PAS<\/strong> compatible.<br>On a donc 2 produits diff\u00e9rents. <br>Mon coll\u00e8gue et ami <a rel=\"noreferrer noopener\" aria-label=\"Fred (opens in a new tab)\" href=\"https:\/\/lefred.be\/\" target=\"_blank\">Fred<\/a>, explique comment s&rsquo;en d\u00e9barrasser \ud83d\ude42<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"Replace MariaDB 10.3 by MySQL 8.0 (opens in a new tab)\" href=\"https:\/\/lefred.be\/content\/replace-mariadb-10-3-by-mysql-8-0\/\" target=\"_blank\">Replace MariaDB 10.3 by MySQL 8.0<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"Migrate from MariaDB to MySQL on CentOS (opens in a new tab)\" href=\"https:\/\/lefred.be\/content\/migrate-from-mariadb-to-the-mysql-on-centos\/\" target=\"_blank\">Migrate from MariaDB to MySQL on CentOS<\/a> <\/li><\/ul>\n\n\n\n\n\n<h3 class=\"wp-block-heading\">Performance<\/h3>\n\n\n\n<p>Oui c&rsquo;est vrai, MySQL est r\u00e9put\u00e9 pour \u00eatre une base de donn\u00e9es tr\u00e8s performante. La performance est effectivement un sujet multiforme et important:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"http:\/\/dasini.net\/blog\/2019\/03\/14\/mysql-functional-indexes\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MySQL Functional Indexes (opens in a new tab)\">MySQL Functional Indexes<\/a> <\/li><\/ul>\n\n\n\n<p>Ceci dit, la r\u00e9f\u00e9rence mondiale en mati\u00e8re de performance est mon coll\u00e8gue et ami <a href=\"http:\/\/dimitrik.free.fr\/blog\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Dimitri (opens in a new tab)\">Dimitri<\/a>:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" href=\"http:\/\/dimitrik.free.fr\/blog\/posts\/mysql-performance-testing-80-with-less-blood.html\" target=\"_blank\">MySQL Performance : Testing 8.0 with less blood&#8230;<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Performance : 1M IO-bound QPS with 8.0 GA on Intel Optane SSD ! (opens in a new tab)\" href=\"http:\/\/dimitrik.free.fr\/blog\/posts\/mysql-performance-1m-iobound-qps-with-80-ga-on-intel-optane-ssd.html\" target=\"_blank\">MySQL Performance : 1M <\/a><em><a rel=\"noreferrer noopener\" aria-label=\"MySQL Performance : 1M IO-bound QPS with 8.0 GA on Intel Optane SSD ! (opens in a new tab)\" href=\"http:\/\/dimitrik.free.fr\/blog\/posts\/mysql-performance-1m-iobound-qps-with-80-ga-on-intel-optane-ssd.html\" target=\"_blank\">IO-bound<\/a><\/em><a rel=\"noreferrer noopener\" aria-label=\"MySQL Performance : 1M IO-bound QPS with 8.0 GA on Intel Optane SSD ! (opens in a new tab)\" href=\"http:\/\/dimitrik.free.fr\/blog\/posts\/mysql-performance-1m-iobound-qps-with-80-ga-on-intel-optane-ssd.html\" target=\"_blank\"> QPS with 8.0 GA on Intel Optane SSD !<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Performance : 8.0 and Sysbench OLTP_RW \/ Update-NoKEY (opens in a new tab)\" href=\"http:\/\/dimitrik.free.fr\/blog\/posts\/mysql-performance-80-and-sysbench-oltp_rw-updatenokey.html\" target=\"_blank\">MySQL Performance : 8.0 and Sysbench OLTP_RW \/ Update-NoKEY<\/a> <\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL Performance : over 1.8M QPS with 8.0 GA on 2S Skylake ! (opens in a new tab)\" href=\"http:\/\/dimitrik.free.fr\/blog\/posts\/mysql-performance-over-18m-qps-with-80-ga-on-2s-skylake.html\" target=\"_blank\">MySQL Performance : over 1.8M QPS with 8.0 GA on 2S Skylake !<\/a> <\/li><\/ul>\n\n\n\n\n\n<p>Je pourrais \u00e9galement \u00e9crire un chapitre sur toutes ces personnes passionnantes et passionn\u00e9es que j&rsquo;ai rencontr\u00e9, d&rsquo;ailleurs certains sont devenus des amis \ud83d\ude42<br>Mais \u00e7a y est, c&rsquo;est l&rsquo;heure de remettre le contact, il reste encore tant a explorer dans la galaxie MySQL.<\/p>\n\n\n\n<p>A bient\u00f4t !<\/p>\n\n\n\n\n\n<div style=\"height:75px\" 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 MySQL!<\/strong><\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\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>Cet article est en fait mon 200 \u00e8me \\o\/<br \/>\nPour marquer le coup, j&rsquo;ai d\u00e9cid\u00e9 de faire une petite pause et de regarder dans le r\u00e9troviseur&#8230;<\/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":[3,403,282,316,288,260,418,167,8,284,34,391,337],"tags":[],"class_list":["post-2959","post","type-post","status-publish","format-standard","hentry","category-divers","category-document-store","category-group-replication","category-haute-disponibilite","category-innodb-cluster","category-json-fr","category-livre","category-mariadb","category-mysql","category-nosql","category-optimisation","category-securite","category-tuto"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s9LfWW-200","jetpack-related-posts":[{"id":687,"url":"https:\/\/dasini.net\/blog\/2009\/07\/27\/sql-server-et-mysql-stars-des-utilisateurs-europeens\/","url_meta":{"origin":2959,"position":0},"title":"SQL Server et MySQL : stars des utilisateurs europ\u00e9ens","author":"Olivier DASINI","date":"27 juillet 2009","format":false,"excerpt":"Selon la derni\u00e8re \u00e9tude d'Evans Data, les d\u00e9veloppeurs europ\u00e9ens auraient abondemment utilis\u00e9 SQL Server et MySQL. Les deux bases se retrouvent plac\u00e9es dans un mouchoir de poche, alrs qu'Oracle se classe troisi\u00e8me. Plus surprenant, DB2 est devanc\u00e9 par PostGreSQL. Les d\u00e9veloppeurs de la zone EMEA ont presque autant utilis\u00e9 SQL\u2026","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"evansjpg","src":"https:\/\/i0.wp.com\/www.lemagit.fr\/files\/caafani6behdhxrka4knac3go4zb7dju87c5rp08w208h12c.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":127,"url":"https:\/\/dasini.net\/blog\/2008\/11\/14\/presentation-mysql-50-un-sgbdr-mature\/","url_meta":{"origin":2959,"position":1},"title":"Pr\u00e9sentation : MySQL 5.0, un SGBDR mature ?","author":"Olivier DASINI","date":"14 novembre 2008","format":false,"excerpt":"MySQL est le SGBDR Open Source le plus populaire au monde. Sa cinqui\u00e8me version, sortie en octobre 2005, permet de mieux r\u00e9pondre aux probl\u00e9matiques d\u2019entreprise. Au menu des nouveaut\u00e9s fonctionnelles : les vues, les proc\u00e9dures stock\u00e9es, les d\u00e9clencheurs, de nouveaux moteurs de stockage, la base de donn\u00e9es INFORMATION_SCHEMA et diverses\u2026","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":1,"url":"https:\/\/dasini.net\/blog\/2008\/10\/26\/bonjour-tout-le-monde\/","url_meta":{"origin":2959,"position":2},"title":"Open source","author":"Olivier DASINI","date":"26 octobre 2008","format":false,"excerpt":"La licence d'un programme \u00ab open-source\u00bb doit correspondre aux crit\u00e8res suivants : Libre redistribution du logiciel. Code source doit accessible. Autoriser les modifications. Int\u00e9grit\u00e9 du code source de l'auteur. Pas de discrimination entre les personnes ou les groupes. Pas de discrimination entre les domaines d'application. Distribution de la licence. La\u2026","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":[]},{"id":683,"url":"https:\/\/dasini.net\/blog\/2009\/07\/21\/open-source-le-marche-francais-depasse-les-15-milliard-deuros\/","url_meta":{"origin":2959,"position":3},"title":"Open Source : le march\u00e9 fran\u00e7ais d\u00e9passe les 1,5 milliard d&rsquo;euros","author":"Olivier DASINI","date":"21 juillet 2009","format":false,"excerpt":"Pr\u00e9sent\u00e9e lors des Rencontres mondiales du logiciel libre, qui se tenait du 7 au 11 juillet \u00e0 Nantes, une \u00e9tude de Pierre Audoin Consultants d\u00e9crit un march\u00e9 fran\u00e7ais du logiciel libre en forte croissance, m\u00eame si celle-ci tend \u00e0 ralentir. Selon le cabinet, ce segment pourrait d\u00e9passer les 3 milliards\u2026","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"pac oss1","src":"https:\/\/i0.wp.com\/www.lemagit.fr\/files\/qj63wt2lqvvg66o6vhakqozoqmxapn64bfcarp08w205h050.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":397,"url":"https:\/\/dasini.net\/blog\/2009\/01\/09\/debats-des-dernieres-tendances-de-lopen-source-le-140109\/","url_meta":{"origin":2959,"position":4},"title":"D\u00e9bats des derni\u00e8res tendances de l&rsquo;open source le 14\/01\/09","author":"Olivier DASINI","date":"9 janvier 2009","format":false,"excerpt":"Le MySQL User Group (LeMUG.fr) vous invite \u00e0 une rencontre de d\u00e9bats et d'\u00e9changes autour des derni\u00e8res tendances de l'open source, avec la participation des Club Utilisateurs GUSES (Solaris), JUG (Java) et OSS Get-Together Paris et la pr\u00e9sence exceptionnelle de Simon Phipps, Sun\u2019s Chief Open Source Officer","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":491,"url":"https:\/\/dasini.net\/blog\/2009\/03\/03\/soiree-open-source-gestion-des-donnees-performance-zfs-open-storage-et-mysql\/","url_meta":{"origin":2959,"position":5},"title":"Soir\u00e9e Open Source &#8211; Gestion des donn\u00e9es, Performance, ZFS, Open Storage et MySQL","author":"Olivier DASINI","date":"3 mars 2009","format":false,"excerpt":"Pour la venue \u00e0 Paris de Roch Bourbonnais, Senior Performance Analyst ZFS\/OpenStorage, nous vous proposons de participer \u00e0 une soir\u00e9e de d\u00e9bats et d'\u00e9changes autour des derni\u00e8res tendances du stockage de donn\u00e9es et des meilleurs pratiques sur les performances de ZFS et de l'Open Storage.","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":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/2959","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=2959"}],"version-history":[{"count":33,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/2959\/revisions"}],"predecessor-version":[{"id":3404,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/2959\/revisions\/3404"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=2959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=2959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=2959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}