need help on cPanel & mysql

yourpapa

I wanted to get your opinion on a cPanel website loading issue.

I am planning to use a Dell R630 server where:

Two 512GB NVMe drives (RAID) will be dedicated to MySQL. (NVMe drives are connected with a PCI-based slot)
SSDs will be used for the OS and website files.

If I move the MySQL data directory (source location) to the NVMe RAID, will cPanel have any problems with this setup?

Could this cause any issues with cPanel, updates, backups, or future maintenance that I should be aware of?

dbadude

sounds to me that you don't have a test environment. Yolo administration?

yourpapa

@dbadude said:
sounds to me that you don't have a test environment. Yolo administration?

I tested, but I need to learn from others who did this before me.

Andreix

@yourpapa said:
I wanted to get your opinion on a cPanel website loading issue.

I am planning to use a Dell R630 server where:

Two 512GB NVMe drives (RAID) will be dedicated to MySQL. (NVMe drives are connected with a PCI-based slot)
SSDs will be used for the OS and website files.

If I move the MySQL data directory (source location) to the NVMe RAID, will cPanel have any problems with this setup?

Could this cause any issues with cPanel, updates, backups, or future maintenance that I should be aware of?

No.

dbadude

@yourpapa said:

@dbadude said:
sounds to me that you don't have a test environment. Yolo administration?

I tested, but I need to learn from others who did this before me.

Moving database files often leads to problems. Try to create a new database using cpanel and look where the mysql data files are created.

yourpapa

@dbadude said:

@yourpapa said:

@dbadude said:
sounds to me that you don't have a test environment. Yolo administration?

I tested, but I need to learn from others who did this before me.

Moving database files often leads to problems. Try to create a new database using cpanel and look where the mysql data files are created.

As you know, cPanel stores databases in /var/lib/mysql/. I want to mount this directory on NVMe to store all databases for every cPanel account in this location.

ScreenReader

@yourpapa said:
...
As you know, cPanel stores databases in /var/lib/mysql/. I want to mount this directory on NVMe to store all databases for every cPanel account in this location.

that should work just fine. make sure you mount it by uuid BEFORE the whole cpanel start upon full reboot (you can create a drop-ins systemd config to tell the mysql start only after the disk mounting has finished) to prevent either cpanel or the mysql entering panic mode because it can't find previous database data.

a drop-ins like this should get you started (just for example, i have this inside /etc/systemd/system/docker.service.d/mount-overlay2.conf)

[Unit]
RequiresMountsFor=/var/lib/docker/overlay2
After=var-lib-docker-overlay2.mount

[Service]
ExecStartPre=/bin/sleep 60

the fstab has this entry

/dev/disk/by-uuid/looong-uuid-here-dasd-adadasda  /var/lib/docker/overlay2        ext4    defaults        0       1

as always, stop wondering and just actually test/simulate it in your dev/staging environment