{"id":929,"date":"2026-07-12T18:55:35","date_gmt":"2026-07-12T16:55:35","guid":{"rendered":"https:\/\/communaute-omr.fr\/?p=929"},"modified":"2026-07-12T19:00:16","modified_gmt":"2026-07-12T17:00:16","slug":"__trashed","status":"publish","type":"post","link":"https:\/\/communaute-omr.fr\/?p=929","title":{"rendered":"LVM"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><div class=\"ez-toc-title\" style=\"cursor:inherit\">Table des mati\u00e8res<\/div>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Presentation\" >Pr\u00e9sentation<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Perimetre_de_larticle\" >P\u00e9rim\u00e8tre de l&rsquo;article<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Creation_des_volumes_physiques\" >Cr\u00e9ation des volumes physiques<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Premier_controle_combien_jai_de_place_sur_mon_serveur\" >Premier contr\u00f4le : combien j&rsquo;ai de place sur mon serveur ?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Creation_du_volume_physique\" >Cr\u00e9ation du volume physique<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Creation_des_volumes_groups\" >Cr\u00e9ation des volumes groups<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Presentation_du_volume_groupe\" >Pr\u00e9sentation du volume groupe<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Creation_du_volume_groupe_VG_pour_Mysql\" >Cr\u00e9ation du volume groupe (VG) pour Mysql<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Creation_des_volumes_logiques\" >Cr\u00e9ation des volumes logiques<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Presentation_du_volume_logique_LV\" >Pr\u00e9sentation du volume logique (LV)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#_LV_pour_les_donnees_MySql\" >&nbsp;LV pour les donn\u00e9es MySql<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Creation_du_LV_pour_les_logs_MySql\" >Cr\u00e9ation du LV pour les logs MySql<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Creation_des_points_de_montage\" >Cr\u00e9ation des points de montage<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Data_Mysql\" >Data Mysql<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Logs_Mysql\" >Logs Mysql<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/communaute-omr.fr\/?p=929\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n\n<h1 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Presentation\"><\/span>Pr\u00e9sentation<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Linux permet de &nbsp;g\u00e9rer les disques via LVM qui est l\u2019acronyme de Logical Volume Manager.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cet outil fut d\u00e9velopp\u00e9 par IBM pour l\u2019AIX3 et fut port\u00e9 par la firme sous linux.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Il n\u2019y a pas de standard pour la structure des diff\u00e9rents \u00e9l\u00e9ments qu\u2019utilise LVM et donc chaque constructeur a d\u00e9velopp\u00e9 ses propres sp\u00e9cifications.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ce qui rend le portage et la compatibilit\u00e9 entre constructeurs difficile voir impossible.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Le sch\u00e9ma ci-dessous repr\u00e9sente un exemple simple, pour un seveur mysql, sur le mode de fonctionnement de LVM<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"http:\/\/communaute-omr.fr\/wp-content\/uploads\/2017\/06\/LVM.png\" alt=\"\" class=\"wp-image-231\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\">Dans le sch\u00e9ma ci dessus on voit que tous les PV (Volumes Physiques) sont rattach\u00e9s \u00e0 un \u00a0\u00bb Volume Group\u00a0\u00bb qui du point de vu serveur repr\u00e9sente un seul disque.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">L&rsquo;\u00e9tape suivante consistera \u00e0 cr\u00e9er les volumes logiques afin de les rattach\u00e9s aux points de montage pour chaque FS (File System);<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Perimetre_de_larticle\"><\/span>P\u00e9rim\u00e8tre de l&rsquo;article<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Cet article ne prend pas en compte :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>L&rsquo;utilisation d&rsquo;une baie de disque<\/li>\n\n\n\n<li>La configuration de MySql<\/li>\n\n\n\n<li>La gestion des partitions des disques sous linux<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_des_volumes_physiques\"><\/span>Cr\u00e9ation des volumes physiques<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Premier_controle_combien_jai_de_place_sur_mon_serveur\"><\/span>Premier contr\u00f4le : combien j&rsquo;ai de place sur mon serveur ?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Avant de pouvoir cr\u00e9er un Volume physique il faut d\u2019abord connaitre les disques physiques pr\u00e9sents sur le serveur.<\/li>\n\n\n\n<li>Pour cela la commande fdisk \u2013l nous donnera toutes les informations n\u00e9cessaires :<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># fdisk -l<br\/><br\/>Disque \/dev\/sda: 8589 Mo, 8589934592 octets<br\/>255 t\u00eates, 63 secteurs\/piste, 1044 cylindres<br\/>Unit\u00e9s = cylindres de 16065 * 512 = 8225280 octets<br\/>Sector size (logical\/physical): 512 bytes \/ 512 bytes<br\/>I\/O size (minimum\/optimal): 512 bytes \/ 512 bytes<br\/>Identifiant de disque : 0x00061088<br\/><br\/>P\u00e9riph\u00e9rique Amorce  D\u00e9but        Fin      Blocs     Id  Syst\u00e8me<br\/>\/dev\/sda1   *           1          64      512000   83  Linux<br\/>La partition 1 ne se termine pas sur une fronti\u00e8re de cylindre.<br\/>\/dev\/sda2              64        1045     7875584   8e  Linux LVM<br\/><br\/>Disque \/dev\/sdb: 8589 Mo, 8589934592 octets<br\/>255 t\u00eates, 63 secteurs\/piste, 1044 cylindres<br\/>Unit\u00e9s = cylindres de 16065 * 512 = 8225280 octets<br\/>Sector size (logical\/physical): 512 bytes \/ 512 bytes<br\/>I\/O size (minimum\/optimal): 512 bytes \/ 512 bytes<br\/>Identifiant de disque : 0x00000000<br\/><br\/><br\/>Disque \/dev\/mapper\/vg_cesdbmaster-lv_root: 7205 Mo, 7205814272 octets<br\/>255 t\u00eates, 63 secteurs\/piste, 876 cylindres<br\/>Unit\u00e9s = cylindres de 16065 * 512 = 8225280 octets<br\/>Sector size (logical\/physical): 512 bytes \/ 512 bytes<br\/>I\/O size (minimum\/optimal): 512 bytes \/ 512 bytes<br\/>Identifiant de disque : 0x00000000<br\/><br\/><br\/>Disque \/dev\/mapper\/vg_cesdbmaster-lv_swap: 855 Mo, 855638016 octets<br\/>255 t\u00eates, 63 secteurs\/piste, 104 cylindres<br\/>Unit\u00e9s = cylindres de 16065 * 512 = 8225280 octets<br\/>Sector size (logical\/physical): 512 bytes \/ 512 bytes<br\/>I\/O size (minimum\/optimal): 512 bytes \/ 512 bytes<br\/>Identifiant de disque : 0x00000000<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">La capture ci dessus nous montre que nous avons<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Un disque appel\u00e9&nbsp;<strong><em>sda&nbsp;<\/em><\/strong>contenant 2 partitions :\n<ul class=\"wp-block-list\">\n<li>\/dev\/sda1 qui contient notre syst\u00e8me d&rsquo;amor\u00e7age de notre OS<\/li>\n\n\n\n<li>\/dev\/sda2 qui contient une partition de type LVM qui est en fait notre volume physique.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Un disque appel\u00e9 <em><strong>sdb<\/strong>&nbsp;<\/em>qui pour l&rsquo;instant n&rsquo;est pas affect\u00e9.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Nous pouvons maintenant contr\u00f4ler o\u00f9 est affect\u00e9 notre volume physique :<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># pvdisplay \/dev\/sda2<br\/>  --- Physical volume ---<br\/>  PV Name               \/dev\/sda2<br\/>  VG Name               vg_cesdbmaster<br\/>  PV Size               7,51 GiB \/ not usable 3,00 MiB<br\/>  Allocatable           yes (but full)<br\/>  PE Size               4,00 MiB<br\/>  Total PE              1922<br\/>  Free PE               0<br\/>  Allocated PE          1922<br\/>  PV UUID               8xiikU-wmHK-hvFl-J1w7-sbc4-cvE1-vXPlev<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">La capture ci-dessus nous montre :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ligne 3 : Notre volume physique est bien rattach\u00e9 \u00e0&nbsp;\/dev\/sda2<\/li>\n\n\n\n<li>Ligne 4 : Le volume Physique est rattach\u00e9 au volume groupe&nbsp;vg_cesdbmaster<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_du_volume_physique\"><\/span>Cr\u00e9ation du volume physique<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">La cr\u00e9ation d&rsquo;un PV se fait via la commande pvcreate \u00ab\u00a0Nom du disque\u00a0\u00bb comme le montre la commande ci-dessous.<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># pvcreate \/dev\/sdb<br\/>  Physical volume &quot;\/dev\/sdb&quot; successfully created<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Le PV a \u00e9tait cr\u00e9\u00e9 nous pouvons contr\u00f4ler que tout va bien avec la commande pvdisplay<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># pvdisplay \/dev\/sdb<br\/>  &quot;\/dev\/sdb&quot; is a new physical volume of &quot;8,00 GiB&quot;<br\/>  --- NEW Physical volume ---<br\/>  PV Name               \/dev\/sdb<br\/>  VG Name<br\/>  PV Size               8,00 GiB<br\/>  Allocatable           NO<br\/>  PE Size               0<br\/>  Total PE              0<br\/>  Free PE               0<br\/>  Allocated PE          0<br\/>  PV UUID               5szPZx-S7pn-hAFQ-jotd-x83v-kfcD-2i5u5P<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Nous aurrons pu d\u00e9couper le disque en plusieurs partitions comme dans le disque \/dev\/sda.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_des_volumes_groups\"><\/span>Cr\u00e9ation des volumes groups<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Presentation_du_volume_groupe\"><\/span>Pr\u00e9sentation du volume groupe<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Du point de vu syst\u00e8me, un groupe de volumes correspond \u00e0 un disque.<\/li>\n\n\n\n<li>Un ou plusieurs volumes physiques peuvent lui \u00eatre attach\u00e9s<\/li>\n\n\n\n<li>Il appara\u00eet comme un disque dont la capacit\u00e9 est la somme des capacit\u00e9 de ces volumes physiques.<\/li>\n\n\n\n<li>Un groupe de volume peut \u00eatre consid\u00e9r\u00e9 comme un disque virtuel.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_du_volume_groupe_VG_pour_Mysql\"><\/span>Cr\u00e9ation du volume groupe (VG) pour Mysql<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># vgcreate vg_data_mysql \/dev\/sdb<br\/>  Volume group &quot;vg_data_mysql&quot; successfully created<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">La commande de cr\u00e9ation de volume groupe cr\u00e9\u00e9 le nom du VG et affecte \u00e0 la vol\u00e9e le PV<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Comme le montre la capture ci-dessous, le PV <em><strong>\/dev\/sdb<\/strong><\/em> est bien affect\u00e9 au VG &nbsp;<em><strong>vg_data_mysql<\/strong><\/em>.<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># vgdisplay vg_data_mysql<br\/>  --- Volume group ---<br\/>  VG Name               vg_data_mysql<br\/>  System ID<br\/>  Format                lvm2<br\/>  Metadata Areas        1<br\/>  Metadata Sequence No  1<br\/>  VG Access             read\/write<br\/>  VG Status             resizable<br\/>  MAX LV                0<br\/>  Cur LV                0<br\/>  Open LV               0<br\/>  Max PV                0<br\/>  Cur PV                1<br\/>  Act PV                1<br\/>  VG Size               8,00 GiB<br\/>  PE Size               4,00 MiB<br\/>  Total PE              2047<br\/>  Alloc PE \/ Size       0 \/ 0<br\/>  Free  PE \/ Size       2047 \/ 8,00 GiB<br\/>  VG UUID               e1Idtc-1zji-OXkI-5IaY-1DCD-OdCn-KVHfna<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_des_volumes_logiques\"><\/span>Cr\u00e9ation des volumes logiques<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Presentation_du_volume_logique_LV\"><\/span>Pr\u00e9sentation du volume logique (LV)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Un volume logique correspond \u00e0 une partition d\u2019un VG.<\/li>\n\n\n\n<li>Le LV est compos\u00e9 de blocs physiques qui ne sont pas forc\u00e9ment sur le m\u00eame disque ( Nous verrons pourquoi un peu plus loin ).<\/li>\n\n\n\n<li>Les LV peuvent aussi augment\u00e9s par des blocs de tailles fixes, les blocs logiques ( On y vient ).<\/li>\n\n\n\n<li>Un volume logique peut \u00eatre consid\u00e9r\u00e9 comme une partition virtuelle qui sera format\u00e9e avec un syst\u00e8me de fichier.<\/li>\n\n\n\n<li>Les blocs logiques sont les constituantes des LV.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"_LV_pour_les_donnees_MySql\"><\/span>&nbsp;LV pour les donn\u00e9es MySql<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">On cr\u00e9\u00e9 le LV Data MySql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># lvcreate -L 5G -n lv_data_mysql vg_data_mysql<br\/>  Logical volume &quot;lv_data_mysql&quot; created.<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">On contr\u00f4le de la taille du LV Data MySql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># lvdisplay \/dev\/vg_data_mysql\/lv_data_mysql<br\/>  --- Logical volume ---<br\/>  LV Path                \/dev\/vg_data_mysql\/lv_data_mysql<br\/>  LV Name                lv_data_mysql<br\/>  VG Name                vg_data_mysql<br\/>  LV UUID                iaO1u5-Dirc-1JDp-49W2-Tx5n-MtnX-CGF2Pe<br\/>  LV Write Access        read\/write<br\/>  LV Creation host, time CESDBMaster, 2017-06-20 03:58:27  0200<br\/>  LV Status              available<br\/>  # open                 0<br\/>  LV Size                5,00 GiB<br\/>  Current LE             1280<br\/>  Segments               1<br\/>  Allocation             inherit<br\/>  Read ahead sectors     auto<br\/>  - currently set to     256<br\/>  Block device           253:2<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_du_LV_pour_les_logs_MySql\"><\/span>Cr\u00e9ation du LV pour les logs MySql<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">On cr\u00e9\u00e9 le LV logs MySql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># lvcreate -L 2G -n lv_logs_mysql vg_data_mysql<br\/>  Logical volume &quot;lv_logs_mysql&quot; created.<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">On contr\u00f4le de la taille du LV logs MySql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># lvdisplay \/dev\/vg_data_mysql\/lv_logs_mysql<br\/>  --- Logical volume ---<br\/>  LV Path                \/dev\/vg_data_mysql\/lv_logs_mysql<br\/>  LV Name                lv_logs_mysql<br\/>  VG Name                vg_data_mysql<br\/>  LV UUID                LdKhCP-alck-cmuO-geQM-GZE9-0I5t-whI4W7<br\/>  LV Write Access        read\/write<br\/>  LV Creation host, time CESDBMaster, 2017-06-20 06:33:59  0200<br\/>  LV Status              available<br\/>  # open                 0<br\/>  LV Size                2,00 GiB<br\/>  Current LE             512<br\/>  Segments               1<br\/>  Allocation             inherit<br\/>  Read ahead sectors     auto<br\/>  - currently set to     256<br\/>  Block device           253:3<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_des_points_de_montage\"><\/span>Cr\u00e9ation des points de montage<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Data_Mysql\"><\/span>Data Mysql<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Stopper le service mysql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># service mysql stop<br\/>Shutting down MySQL. SUCCESS!<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Sauvegarde des donn\u00e9es MySql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># mv \/var\/lib\/mysql\/ \/var\/lib\/mysql.old<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Cr\u00e9ation du nouveau point de montage<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># mkdir \/var\/lib\/mysql\/<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Positionnement des droits<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\">chown mysql: \/var\/lib\/mysql\/<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pr\u00e9paration du FS pour les donn\u00e9es MySql<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">Formatage du FS<\/h5>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># mkfs.ext4 \/dev\/vg_data_mysql\/lv_data_mysql<br\/>mke2fs 1.41.12 (17-May-2010)<br\/>\u00c9tiquette de syst\u00e8me de fichiers=<br\/>Type de syst\u00e8me d&#039;exploitation\u00a0: Linux<br\/>Taille de bloc=4096 (log=2)<br\/>Taille de fragment=4096 (log=2)<br\/>\u00ab\u00a0Stride\u00a0\u00bb = 0 blocs, \u00ab\u00a0Stripe width\u00a0\u00bb = 0 blocs<br\/>327680 i-noeuds, 1310720 blocs<br\/>65536 blocs (5.00%) r\u00e9serv\u00e9s pour le super utilisateur<br\/>Premier bloc de donn\u00e9es=0<br\/>Nombre maximum de blocs du syst\u00e8me de fichiers=1342177280<br\/>40 groupes de blocs<br\/>32768 blocs par groupe, 32768 fragments par groupe<br\/>8192 i-noeuds par groupe<br\/>Superblocs de secours stock\u00e9s sur les blocs\u00a0:<br\/>        32768, 98304, 163840, 229376, 294912, 819200, 884736<br\/><br\/>\u00c9criture des tables d&#039;i-noeuds\u00a0: compl\u00e9t\u00e9<br\/>Cr\u00e9ation du journal (32768 blocs)\u00a0: compl\u00e9t\u00e9<br\/>\u00c9criture des superblocs et de l&#039;information de comptabilit\u00e9 du syst\u00e8me de<br\/>fichiers\u00a0: compl\u00e9t\u00e9<br\/><br\/>Le syst\u00e8me de fichiers sera automatiquement v\u00e9rifi\u00e9 tous les 29 montages ou<br\/>apr\u00e8s 180 jours, selon la premi\u00e8re \u00e9ventualit\u00e9. Utiliser tune2fs -c ou -i<br\/>pour \u00e9craser la valeur.<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Montage manuel du FS<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># mount  \/dev\/vg_data_mysql\/lv_data_mysql \/var\/lib\/mysql\/<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Contr\u00f4le du FS<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1,7,8\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># df -h<br\/>Filesystem            Size  Used Avail Use% Mounted on<br\/>\/dev\/mapper\/vg_cesdbmaster-lv_root<br\/>                      6,5G  1,3G  5,0G  21% \/<br\/>tmpfs                 499M     0  499M   0% \/dev\/shm<br\/>\/dev\/sda1             477M   60M  392M  14% \/boot<br\/>\/dev\/mapper\/vg_data_mysql-lv_data_mysql<br\/>                      4,8G   10M  4,6G   1% \/var\/lib\/mysql<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Restauration des donn\u00e9es Myql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\">cp -Rp \/var\/lib\/mysql.old\/* \/var\/lib\/mysql\/<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h5 class=\"wp-block-heading\">Application des droits MySql sur le r\u00e9pertoire de donn\u00e9es<\/h5>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># chown -R mysql: \/var\/lib\/mysql<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h5 class=\"wp-block-heading\">Contr\u00f4le des donn\u00e9es<\/h5>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># ls -rtl \/var\/lib\/mysql\/<br\/>total 28732<br\/>drwxr-xr-x 2 mysql mysql     4096 29 mai   16:56 test<br\/>drwx--x--x 2 mysql mysql     4096 29 mai   16:56 mysql<br\/>drwx------ 2 mysql mysql     4096 29 mai   16:56 performance_schema<br\/>-rw-rw---- 1 mysql mysql  5242880 29 mai   16:58 ib_logfile1<br\/>drwx------ 2 mysql mysql     4096 29 mai   17:46 wordpress<br\/>drwx------ 2 root  root     16384 20 juin  06:45 lost found<br\/>-rw-rw---- 1 mysql mysql       52 20 juin  06:46 aria_log_control<br\/>-rw-rw---- 1 mysql mysql    16384 20 juin  06:46 aria_log.00000001<br\/>-rw-rw---- 1 mysql mysql  5242880 20 juin  06:46 ib_logfile0<br\/>-rw-rw---- 1 mysql mysql 18874368 20 juin  06:46 ibdata1<br\/>-rw-r----- 1 mysql root      7021 20 juin  06:46 CESDBMaster.err<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">red\u00e9marrage du service mysql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># service mysql start<br\/>Starting MySQL.. SUCCESS!<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Test de connexion \u00e0 MySql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># mysql<br\/>Welcome to the MariaDB monitor.  Commands end with ; or \\g.<br\/>Your MariaDB connection id is 2<br\/>Server version: 5.5.47-MariaDB-log MariaDB Server<br\/><br\/>Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.<br\/><br\/>Type &#039;help;&#039; or &#039;\\h&#039; for help. Type &#039;\\c&#039; to clear the current input statement.<br\/><br\/>MariaDB [(none)]&gt;<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Montage automatique du FS des donn\u00e9es MySql<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Modifier le fichier \/etc\/fstab en ajoutant la ligne suivante<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\">\/dev\/mapper\/vg_data_mysql-lv_data_mysql \/var\/lib\/mysql ext4    defaults        1 1<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Red\u00e9marrage du serveur pour tester le montage automatique et le red\u00e9marrage automatique de MySql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># reboot<br\/>Broadcast message from root@CESDBMaster<br\/>        (\/dev\/pts\/0) at 13:43 ...<br\/><br\/>The system is going down for reboot NOW!<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Apr\u00e8s red\u00e9marrage on contr\u00f4le le bon fonctionnement de mysql<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># service mysql status<br\/> SUCCESS! MySQL running (2173)<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Logs_Mysql\"><\/span>Logs Mysql<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons mettre en place un FS d\u00e9di\u00e9 aux logs MySql afin de ne pas p\u00e9naliser le syst\u00e8me. Cette d\u00e9marche permet de d\u00e9marrer notre serveur dans tous les cas. Si le service MySql g\u00e9n\u00e8re trop de logs, le service ne d\u00e9marrera pas mais notre syst\u00e8me sera toujours accessible. Cette d\u00e9marche est valable pour tous les services dont le syst\u00e8me ne d\u00e9pend pas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pour ex\u00e9cuter cette partie de l&rsquo;article vous devais avoir configurer MySql pour ecrire ces logs dans un fichier d\u00e9di\u00e9 (L&rsquo;article par du principe que les logs MySql sont dans le r\u00e9pertoire <em><strong>\/var\/log\/mysqld<\/strong><\/em>) .<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Stopper le service mysql<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">cette commande n&rsquo;est pas n\u00e9cessaire mais cela permet de travail sereinement \ud83d\ude00<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># service mysql stop<br\/>Shutting down MySQL. SUCCESS!<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Cr\u00e9ation d&rsquo;un r\u00e9pertoire d\u00e9di\u00e9 aux logs MySql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># mkdir \/var\/log\/mysqld<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Positionnement des droits<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># chown mysql: \/var\/log\/mysqld<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Pr\u00e9paration du FS pour les donn\u00e9es MySql<\/h4>\n\n\n\n<h5 class=\"wp-block-heading\">Formatage du FS<\/h5>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># mkfs.ext4 \/dev\/vg_data_mysql\/lv_logs_mysql<br\/>mke2fs 1.41.12 (17-May-2010)<br\/>\u00c9tiquette de syst\u00e8me de fichiers=<br\/>Type de syst\u00e8me d&#039;exploitation\u00a0: Linux<br\/>Taille de bloc=4096 (log=2)<br\/>Taille de fragment=4096 (log=2)<br\/>\u00ab\u00a0Stride\u00a0\u00bb = 0 blocs, \u00ab\u00a0Stripe width\u00a0\u00bb = 0 blocs<br\/>131072 i-noeuds, 524288 blocs<br\/>26214 blocs (5.00%) r\u00e9serv\u00e9s pour le super utilisateur<br\/>Premier bloc de donn\u00e9es=0<br\/>Nombre maximum de blocs du syst\u00e8me de fichiers=536870912<br\/>16 groupes de blocs<br\/>32768 blocs par groupe, 32768 fragments par groupe<br\/>8192 i-noeuds par groupe<br\/>Superblocs de secours stock\u00e9s sur les blocs\u00a0:<br\/>        32768, 98304, 163840, 229376, 294912<br\/><br\/>\u00c9criture des tables d&#039;i-noeuds\u00a0: compl\u00e9t\u00e9<br\/>Cr\u00e9ation du journal (16384 blocs)\u00a0: compl\u00e9t\u00e9<br\/>\u00c9criture des superblocs et de l&#039;information de comptabilit\u00e9 du syst\u00e8me de<br\/>fichiers\u00a0: compl\u00e9t\u00e9<br\/><br\/>Le syst\u00e8me de fichiers sera automatiquement v\u00e9rifi\u00e9 tous les 35 montages ou<br\/>apr\u00e8s 180 jours, selon la premi\u00e8re \u00e9ventualit\u00e9. Utiliser tune2fs -c ou -i<br\/>pour \u00e9craser la valeur.<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Cr\u00e9ation du point de montage pour les logs mysql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># mkdir \/var\/log\/mysqld\/<br\/># chown mysql: \/var\/log\/mysqld\/<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Contr\u00f4le du point de montage<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># ls -ld \/var\/log\/mysqld\/<br\/>drwxr-xr-x 2 mysql mysql 4096 20 juin  14:08 \/var\/log\/mysqld\/<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Montage manuel du FS<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># mount  \/dev\/vg_data_mysql\/lv_logs_mysql \/var\/log\/mysqld\/<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Contr\u00f4le du FS<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1,9,10\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># df -h<br\/>Filesystem            Size  Used Avail Use% Mounted on<br\/>\/dev\/mapper\/vg_cesdbmaster-lv_root<br\/>                      6,5G  1,3G  4,9G  21% \/<br\/>tmpfs                 499M     0  499M   0% \/dev\/shm<br\/>\/dev\/sda1             477M   60M  392M  14% \/boot<br\/>\/dev\/mapper\/vg_data_mysql-lv_data_mysql<br\/>                      4,8G   40M  4,6G   1% \/var\/lib\/mysql<br\/>\/dev\/mapper\/vg_data_mysql-lv_logs_mysql<br\/>                      2,0G  3,0M  1,9G   1% \/var\/log\/mysqld<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h5 class=\"wp-block-heading\">Application des droits MySql sur le r\u00e9pertoire de donn\u00e9es<\/h5>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># chown -R mysql: \/var\/log\/mysqld<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">red\u00e9marrage du service mysql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># service mysql restart<br\/>Shutting down MySQL. SUCCESS!<br\/>Starting MySQL.. SUCCESS!<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Test de connexion \u00e0 MySql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># mysql<br\/>Welcome to the MariaDB monitor.  Commands end with ; or \\g.<br\/>Your MariaDB connection id is 2<br\/>Server version: 5.5.47-MariaDB-log MariaDB Server<br\/><br\/>Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.<br\/><br\/>Type &#039;help;&#039; or &#039;\\h&#039; for help. Type &#039;\\c&#039; to clear the current input statement.<br\/><br\/>MariaDB [(none)]&gt;<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Montage automatique du FS des donn\u00e9es MySql<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Modifier le fichier \/etc\/fstab en ajoutant la ligne suivante<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"1\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\">\/dev\/vg_data_mysql\/lv_logs_mysql \/var\/log\/mysqld ext4    defaults        1 1<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Red\u00e9marrage du serveur pour tester le montage automatique et le red\u00e9marrage automatique de MySql<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># reboot<br\/>Broadcast message from root@CESDBMaster<br\/>        (\/dev\/pts\/0) at 13:43 ...<br\/><br\/>The system is going down for reboot NOW!<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Apr\u00e8s red\u00e9marrage on contr\u00f4le le bon fonctionnement de mysql<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\"># service mysql status<br\/> SUCCESS! MySQL running (2173)<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Controle du bon montage du FS au red\u00e9marrage<\/h4>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre line-numbers\"  data-line=\"9,10\" data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\">]# df -h<br\/>Filesystem            Size  Used Avail Use% Mounted on<br\/>\/dev\/mapper\/vg_cesdbmaster-lv_root<br\/>                      6,5G  1,3G  4,9G  21% \/<br\/>tmpfs                 499M     0  499M   0% \/dev\/shm<br\/>\/dev\/sda1             477M   60M  392M  14% \/boot<br\/>\/dev\/mapper\/vg_data_mysql-lv_data_mysql<br\/>                      4,8G   40M  4,6G   1% \/var\/lib\/mysql<br\/>\/dev\/mapper\/vg_data_mysql-lv_logs_mysql<br\/>                      2,0G  3,0M  1,9G   1% \/var\/log\/mysqld<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A compl\u00e9ter \ud83d\ude00<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pr\u00e9sentation Linux permet de &nbsp;g\u00e9rer les disques via LVM qui est l\u2019acronyme de Logical Volume Manager. Cet outil fut d\u00e9velopp\u00e9 par IBM pour l\u2019AIX3 et fut port\u00e9 par la firme sous linux. Il n\u2019y a pas de standard pour la structure des diff\u00e9rents \u00e9l\u00e9ments qu\u2019utilise LVM et donc chaque constructeur a d\u00e9velopp\u00e9 ses propres sp\u00e9cifications. &#8230; <a title=\"LVM\" class=\"read-more\" href=\"https:\/\/communaute-omr.fr\/?p=929\" aria-label=\"En savoir plus sur LVM\">Lire la suite<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-929","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=929"}],"version-history":[{"count":3,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/929\/revisions"}],"predecessor-version":[{"id":935,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/929\/revisions\/935"}],"wp:attachment":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}