Separating frappe/erpnext sites and mariadb data

#1

Hi,

Does anyone have guidance how to separate bench and mariadb to different volumes?

  • disk1 : OS (AlmaLinux 8)
  • disk2: bench (apps, sites, config, etc)
  • disk3: mariadb

Thank you

#2

hi

You can provide the path to the –installroot option in the Yum or DNF install command to the drive or directory you want for mariadb and other apps

#3

So to confirm:

sudo dnf --installroot=/desk2/appdir --releasever=/ install <all other dependencies>

How about bench init?

sudo dnf --installroot=/desk3/dbdir --releasever=/ install mariadb mariadb-server

Then how to point the frappe/erpnext to the mariadb?
Is this considered remote db (need to set host in common_site_config.json) or not?

#4

MariaDB data is located at /var/lib/mysql, Mount a disk at that location before installing mariadb. Google search resulted in linux - Remounting MySQL under a new mount point - Server Fault

edit: Setup MariaDB Server · frappe/frappe Wiki · GitHub

#5

This link might be useful

Also you could look at the links on the above post by @revant_one, which is another way to do as well

#6

So to summarize my setup:

A server with 3 disks/partition:

  • Partition 1: OS
  • Partition 2: Bench (moving /home to this partition)
  • Partition 3: Mariadb (moving /var/lib/mysql to this partition)
1 Like