{"id":941,"date":"2010-06-29T13:49:39","date_gmt":"2010-06-29T12:49:39","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=941"},"modified":"2010-06-29T13:49:39","modified_gmt":"2010-06-29T12:49:39","slug":"mysql-admin-cookbook","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2010\/06\/29\/mysql-admin-cookbook\/","title":{"rendered":"MySQL Admin Cookbook"},"content":{"rendered":"<p><span style=\"color: #993300;\"><strong><a title=\"MySQL Admin Cookbook\" href=\"http:\/\/www.packtpub.com\/mysql-admin-cookbook\/book?utm_source=dasini.net&amp;utm_medium=bookrev&amp;utm_content=blog&amp;utm_campaign=mdb_002652 \" target=\"_blank\"><span style=\"color: #000000;\">MySQL Admin Cookbook<\/span><\/a> <\/strong><\/span>est un livre qui s&rsquo;adresse aussi bien \u00e0 l&rsquo;administrateur de base de donn\u00e9es d\u00e9butant qu&rsquo; \u00e0 celui qui cherche \u00e0 am\u00e9liorer ses comp\u00e9tences techniques.<\/p>\n<p>Avec son contenu riche en exemples pr\u00eats \u00e0 l&#8217;emploi, pr\u00e9sent\u00e9s sous la forme de \u00ab\u00a0recettes de cuisine\u00a0\u00bb (qui permet d&rsquo;associer une probl\u00e9matique donn\u00e9e \u00e0 sa solution), MySQL Admin Cookbook se veut r\u00e9solument orient\u00e9 pratique, d&rsquo;ailleurs \u00a0les exemples et les astuces y sont l\u00e9gions.<\/p>\n<p>Les principaux th\u00e8mes abord\u00e9s sont:<\/p>\n<ul>\n<li>La r\u00e9plication<\/li>\n<li>Les index<\/li>\n<li>Sauvegarde et restauration<\/li>\n<li>Gestion des donn\u00e9es et des utilisateurs<\/li>\n<li>La supervision<\/li>\n<li>Configuration de MySQL<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\">J&rsquo;ai bien aim\u00e9<\/span>: la vari\u00e9t\u00e9 des sujets et l&rsquo;angle pratique abord\u00e9.<\/p>\n<p><span style=\"text-decoration: underline;\">J&rsquo;ai moins aim\u00e9<\/span>: certaines parties un peu basique<\/p>\n<p>Le site de l&rsquo;\u00e9diteur:\u00a0<a title=\"Packt Publishing Limited\" href=\"http:\/\/www.packtpub.com\/mysql-admin-cookbook\/book?utm_source=dasini.net&amp;utm_medium=bookrev&amp;utm_content=blog&amp;utm_campaign=mdb_002652 \" target=\"_blank\">Packt Publishing Limited<\/a><\/p>\n<div style=\"width: 130px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.packtpub.com\/mysql-admin-cookbook\/book?utm_source=dasini.net&amp;utm_medium=bookrev&amp;utm_content=blog&amp;utm_campaign=mdb_002652\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\" \" title=\"MySQL Admin Cookbook\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-includes\/images\/blog\/MySQLAdminCookbook_120x148.png?resize=120%2C148\" alt=\"MySQL Admin Cookbook\" width=\"120\" height=\"148\" \/><\/a><p class=\"wp-caption-text\">MySQL Admin Cookbook<\/p><\/div>\n<ul>\n<li>Editeur : Packt Publishing Limited<\/li>\n<li>Langue : Anglais<\/li>\n<li>ISBN-13: 978-1-847197-96-2<\/li>\n<li>ISBN : 1847197965<\/li>\n<li>376 pages<\/li>\n<li>Auteurs: Daniel Schneller, Udo Schwedt<\/li>\n<li>Sortie: Mars 2010<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Admin Cookbook est un livre qui s&rsquo;adresse aussi bien \u00e0 l&rsquo;administrateur de base de donn\u00e9es d\u00e9butant qu&rsquo; \u00e0 celui qui cherche \u00e0 am\u00e9liorer ses comp\u00e9tences techniques.<\/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":[8],"tags":[],"class_list":["post-941","post","type-post","status-publish","format-standard","hentry","category-mysql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-fb","jetpack-related-posts":[{"id":2450,"url":"https:\/\/dasini.net\/blog\/2018\/07\/12\/nouveaux-livres-mysql\/","url_meta":{"origin":941,"position":0},"title":"Nouveaux livres MySQL","author":"Olivier DASINI","date":"12 juillet 2018","format":false,"excerpt":"Jadis, lorsque l'on voulait approfondir un sujet technique, il nous fallait \u00e0 tout prix LE livre (celui l\u00e0\u00a0\u00e0 litt\u00e9ralement chang\u00e9 ma vie, et ce n'est pas le seul: celui l\u00e0, celui l\u00e0,...). De nos jours, des milliards de ressources sont disponibles gratuitement sur internet, mais il faut bien l'avouer, la\u2026","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"MySQL and JSON: A Practical Programming Guide - Discover how to use JavaScript Object Notation (JSON) with MySQL","src":"https:\/\/i0.wp.com\/images-na.ssl-images-amazon.com\/images\/I\/416UKa-bH%2BL._SX332_BO1%2C204%2C203%2C200_.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":5741,"url":"https:\/\/dasini.net\/blog\/2022\/05\/02\/webinar-debuter-avec-mysql\/","url_meta":{"origin":941,"position":1},"title":"Webinar &#8211; D\u00e9buter avec MySQL","author":"Olivier DASINI","date":"2 mai 2022","format":false,"excerpt":"Comme tu le sais, MySQL est la base de donn\u00e9es la plus populaire au monde. MySQL est \u00e9galement un \u00e9l\u00e9ment majeur de la strat\u00e9gie base de donn\u00e9es des sites Web les plus fr\u00e9quent\u00e9s au monde, tels que Facebook, Twitter et YouTube. C\u2019est \u00e9galement l\u2019une des bases de donn\u00e9es les plus\u2026","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/05\/Debuter-avec-MySQL.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/05\/Debuter-avec-MySQL.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/05\/Debuter-avec-MySQL.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/05\/Debuter-avec-MySQL.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/05\/Debuter-avec-MySQL.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/05\/Debuter-avec-MySQL.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":887,"url":"https:\/\/dasini.net\/blog\/2010\/03\/24\/extraits-du-livre-audit-et-optimisation-%e2%80%93-mysql-5\/","url_meta":{"origin":941,"position":2},"title":"Extraits du livre Audit et optimisation \u2013 MySQL 5","author":"Olivier DASINI","date":"24 mars 2010","format":false,"excerpt":"A l'occasion de la sortie du livre \"Audit et optimisation MySQL 5\", Arnaud Gadal et Pascal Borghino blogueurs sur dbnewz et Olivier Dasini vous offrent 3 extraits du livre: L'avant propos: Avant-propos Le sommaire: Table des mati\u00e8res le chapitre 1 (int\u00e9gral): G\u00e9rer une situation d'urgence avec MySQL","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"Bonnes pratiques pour l'administrateur","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-includes\/images\/blog\/OptimiMySQL5_c1_130x158.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2959,"url":"https:\/\/dasini.net\/blog\/2019\/04\/08\/200\/","url_meta":{"origin":941,"position":3},"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":[]},{"id":41,"url":"https:\/\/dasini.net\/blog\/2008\/10\/30\/mysql-50-un-sgbdr-mature-part-44\/","url_meta":{"origin":941,"position":4},"title":"MySQL 5.0 : Un SGBDR mature ? &#8212; (part 4\/4)","author":"Olivier DASINI","date":"30 octobre 2008","format":false,"excerpt":"Les d\u00e9clencheurs (triggers) sont des ordres de d\u00e9clenchement d'op\u00e9rations quand un \u00e9v\u00e8nement survient sur une table.","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":817,"url":"https:\/\/dasini.net\/blog\/2009\/11\/09\/audit-et-optimisation-mysql-5\/","url_meta":{"origin":941,"position":5},"title":"Audit et optimisation MySQL 5","author":"Olivier DASINI","date":"9 novembre 2009","format":false,"excerpt":"Arnaud Gadal DBA MySQL \u00e0 Virgin Mobile, Pascal Borghino architecte base de donn\u00e9es \u00e0 Yahoo! (mes potos de dbnewz) et moi, venons juste de terminer l'\u00e9criture d'un livre consacr\u00e9 \u00e0 l'audit et \u00e0 l'optimisation d'un serveur MySQL. A travers cet ouvrage, nous avons essay\u00e9s de synth\u00e9tiser nos diff\u00e9rentes exp\u00e9riences pour\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":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/941","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=941"}],"version-history":[{"count":8,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/941\/revisions"}],"predecessor-version":[{"id":950,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/941\/revisions\/950"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}