{"id":4433,"date":"2020-03-27T11:32:44","date_gmt":"2020-03-27T09:32:44","guid":{"rendered":"http:\/\/www.laurentmarot.fr\/wordpress\/?p=4433"},"modified":"2020-03-29T15:26:48","modified_gmt":"2020-03-29T13:26:48","slug":"improve-you-chinese","status":"publish","type":"post","link":"https:\/\/www.laurentmarot.fr\/wordpress\/?p=4433","title":{"rendered":"Improve you chinese &#8230;"},"content":{"rendered":"<p>Pour occuper cette p\u00e9riode un peu particuli\u00e8re de confinement COVID-19 et alimenter quelques menus TPs, je me lance dans la grande aventure de la<strong> tentative de compr\u00e9hension d&rsquo;InnoDB<\/strong>.<\/p>\n<p>Si j&rsquo;avais eu un peu de courage, je me serais remis \u00e0 Ruby et j&rsquo;aurais \u00e9tudi\u00e9 les excellents travaux de Jeremy Cole <a href=\"https:\/\/blog.jcole.us\/innodb\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/blog.jcole.us\/innodb\/<\/a> mais vu que des chinois sympathiques semblent avoir port\u00e9 son travail en java , let&rsquo;s go !!<\/p>\n<p>Jusqu&rsquo;\u00e0 la semaine derni\u00e8re, utilisateur-amateur de MariaDB, je ne m&rsquo;\u00e9tais m\u00eame jamais pos\u00e9 de questions sur les types de backend de mon SGBD. Je faisais juste le malin en allant lire vos tables \u00e0 partir des fichiers MYD avec un pauvre \u00e9diteur hexad\u00e9cimal.<\/p>\n<p>J&rsquo;ai donc t\u00e9l\u00e9charg\u00e9 le dernier build du client <a href=\"https:\/\/github.com\/alibaba\/innodb-java-reader\" target=\"_blank\" rel=\"noopener noreferrer\">innodb-java-reader<\/a> et &#8230;<\/p>\n<p>Bon, pour l&rsquo;instant, on ne va pas se cacher, \u00e7a ne se passe pas tr\u00e8s bien \ud83d\ude42<\/p>\n<div id=\"attachment_4434\" style=\"width: 310px\" class=\"wp-caption alignleft\"><a href=\"http:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-27-10-27-01.png\" rel=\"lightbox[4433]\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4434\" class=\"size-medium wp-image-4434\" src=\"http:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-27-10-27-01-300x220.png\" alt=\" alibaba \/ innodb-java-reader\" width=\"300\" height=\"220\" srcset=\"https:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-27-10-27-01-300x220.png 300w, https:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-27-10-27-01-1024x751.png 1024w, https:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-27-10-27-01-768x563.png 768w, https:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-27-10-27-01.png 1038w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-4434\" class=\"wp-caption-text\">alibaba \/<br \/>innodb-java-reader<\/p><\/div>\n<p>[2020-03-28] Puis apr\u00e8s quelques \u00e9changes par mail avec Xu, nous avons fini par d\u00e9couvrir un bug li\u00e9 \u00e0 ma config (bon c&rsquo;est s\u00fbr quand tu bosse sous windows pasr ce que ta Debian est brid\u00e9e sur Java 7 &#8230;) .<\/p>\n<div id=\"attachment_4465\" style=\"width: 310px\" class=\"wp-caption alignleft\"><a href=\"http:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-28-18-44-30.png\" rel=\"lightbox[4433]\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-4465\" class=\"size-medium wp-image-4465\" src=\"http:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-28-18-44-30-300x147.png\" alt=\"Read your data ...\" width=\"300\" height=\"147\" srcset=\"https:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-28-18-44-30-300x147.png 300w, https:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-28-18-44-30-1024x503.png 1024w, https:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-28-18-44-30-768x377.png 768w, https:\/\/www.laurentmarot.fr\/wordpress\/wp-content\/uploads\/2020\/03\/Capture-du-2020-03-28-18-44-30.png 1341w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-4465\" class=\"wp-caption-text\">Read your data &#8230;<\/p><\/div>\n<p>Je rappelle que l&rsquo;objectif reste de pouvoir aller lire les fichiers InnoDB sans passer par le moteur MariaDB afin de d\u00e9montrer la pertinence du chiffrement.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Pour occuper cette p\u00e9riode un peu particuli\u00e8re de confinement COVID-19 et alimenter quelques menus TPs, je me lance dans la grande aventure de la tentative de compr\u00e9hension d&rsquo;InnoDB. Si j&rsquo;avais eu un peu de courage, je me serais remis \u00e0 Ruby et j&rsquo;aurais \u00e9tudi\u00e9 les excellents travaux de Jeremy Cole https:\/\/blog.jcole.us\/innodb\/ mais vu que des [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"_links":{"self":[{"href":"https:\/\/www.laurentmarot.fr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4433"}],"collection":[{"href":"https:\/\/www.laurentmarot.fr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.laurentmarot.fr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.laurentmarot.fr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.laurentmarot.fr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4433"}],"version-history":[{"count":9,"href":"https:\/\/www.laurentmarot.fr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4433\/revisions"}],"predecessor-version":[{"id":4468,"href":"https:\/\/www.laurentmarot.fr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4433\/revisions\/4468"}],"wp:attachment":[{"href":"https:\/\/www.laurentmarot.fr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.laurentmarot.fr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.laurentmarot.fr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}