need help on cPanel & mysql

Comments

• dbadude Member

  8:11AM

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

  8:16AM

  @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 Member, Host Rep

  8:17AM edited 8:17AM

  @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.

  Thanked by 1yourpapa
• dbadude Member

  8:18AM

  @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 Member

  9:08AM

  @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 Member

  9:33AM

  @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

  Thanked by 1yourpapa