Problem with my /var/lib/mysql space disk

Hi, 

Check the disk space required to run Centreon here: https://docs.centreon.com/docs/installation/prerequisites/#define-disk-space

/var/lib/mysql is holding all your centreon configuration and data, from what I see it’s far too small! 

Simon

How can I change It right now ? I have only 100 service to monitor

I have found a solution

Hi,

Even 3.5Gb is really too small. How many hosts do you want and how many checks per host ?

And look the BDD datas retention. Default is 6 months.

For example, I have :

800 hosts and 8200 services, with 3 months BDD retention.

With this, my BDD size is 47Gb, and it’s not so big.

You have to estimate the final number of hosts/services/retention you want to size your BDD volume.

As @sims24 said, use the prerequisites link to help you with the sizing.

Another tips ( if your BDD is on the central server ):

create a logical volume for /var/lib/centreon. 

It will be used for all metrics (rrd files ), and it consumes disk space ( 27Go for me ). 

Use different logical volume. Here is for example my volumes.

It’s the first thing to do when you install a central, estimate the sizing with documentation help

Hi,

Even 3.5Gb is really too small. How many hosts do you want and how many checks per host ?

And look the BDD datas retention. Default is 6 months.

 

For example, I have :

800 hosts and 8200 services, with 3 months BDD retention.

With this, my BDD size is 47Gb, and it’s not so big.

 

You have to estimate the final number of hosts/services/retention you want to size your BDD volume.

As @sims24 said, use the prerequisites link to help you with the sizing.

Another tips ( if your BDD is on the central server ):

create a logical volume for /var/lib/centreon. 

It will be used for all metrics (rrd files ), and it consumes disk space ( 27Go for me ). 

Use different logical volume. Here is for example my volumes.

It’s the first thing to do when you install a central, estimate the sizing with documentation help

Hi, thank for your answer ! In the futur I will be carefull with my disk volumes, but right now Im only monitoring 20 hosts and 100 services, later if I want to add more space to my /var/lib/mysql using the VGS memory is the only way to do that or there other better way to do it ?

Hi,

Yes, if you want to increase a LVM volume, use lvresize command, if tou have enough free space on your volume group ( vgdisplay to see the free space ).

If you don’t have enough free space to do the logical volume extend, add a new disk ( if your server is a VM ) and add the new disk to the volume group.

Hi,

Yes, if you want to increase a LVM volume, use lvresize command, if tou have enough free space on your volume group ( vgdisplay to see the free space ).

 

If you don’t have enough free space to do the logical volume extend, add a new disk ( if your server is a VM ) and add the new disk to the volume group.

How can I add a new disk on a VM ? because I have only 2,51GiB free right ?

Sorry for the delay, I was out of office.

1. Add a new disk to the VM in your Vcenter ( ex 50 or 100gb )
2. Make the kernel detect the new disk

echo "- - -" >/sys/class/scsi_host/host0/scan
echo "- - -" >/sys/class/scsi_host/host1/scan
echo "- - -" >/sys/class/scsi_host/host2/scan

3. Verify if you see the new disk

fdisk -l

4. create a new PV for LVM ( ex: if the new disk is /dev/sdc )

pvcreate /dev/sdc

5. Add the new PV to the VolumeGroup which contains the volume you want to extend ( ex: if the VG name is “rootVG” )

vgextend rootVG /dev/sdc

6. Vérify the new free space in your VolumeGroup ( Free PE / size  )

vgdisplay

7. Extend the LogicalVolume you want ( ex with varLV )

lvresize --resizefs --size +50G /dev/rootVG/varLV