Where is physical MySQL database location for Zabbix server?

[robert_gorajski]

Hello.

I am going to install Zabbix on PROXMOX in the following configuration:




My Home Lab PROXMOX drives:




(1) - Three SSD disks for VM storage.
(2) - Two HDD disks for Databases storage & data backups VM for example:
- InfluxDB for Grafana.
- Data from SAMBA server.

(3) - One SSD disk for PROXMOX server.
(4) - One SSD disk additional storage for some, whole VM backups, for example:
- Unbound server.
- AdGard Home server, etc.

I want to place MySQL database on a specific Zabbix drive, it means:

- raidz1-0 - Location for Debian + Zabbix server

- mirror-0 - Location for MySQL database only.


I looked through the Zabbix documentation and searched for information on the Internet. Unfortunately, I cannot find information where the Zabbix SQL database is physically located in the Linux directory hierarchy


Can I ask for help on this topic?

Thank you in advance for any help.

Regards Robert.

[cyber]

By default it is where installation package (mysql, not zabbix) will put it... But I think it is all defineable in mysql config... And has nothing to do with Zabbix config..
You need to mount a correct disk to some mountpoint and point your mysql there.. Zabbix does not see it through mysql, it will talk to mysql and mysql does the rest of it...
EDIT: I'm not a virtual infra specialist, but I guess you need to make that mirror-0 visible to the VM, where you run your debian and mount it there to specific mountpoint and then tell mysql to use that mountpoint to store DB ...

[robert_gorajski]

Of course - thank you for opening my eyes to this matter. I was too brief on the installation process. After all, the package: zabbix-server-mysql is not a database. For example, MariaDB stores databases in the /var directory.
In summary, maybe someone else will find this information useful:

In my case, I need to create a VM with two virtual disks. The first virtual disk on raidz1-0 (this is where the system will be installed), the second virtual disk on mirror-0 (this is where the database will be located).

When installing Debian GNU Linux, create partitions as follows:
(1) - first virtual disk on raidz1-0 = sda for Debian (contains: EFI, SWAP and root "/" partitions)
(2) - second virtual disk on mirror-0 = sdb for Debian (contains only the partition mounted in "/var" directory).



I already have this arrangement of disks on one of the virtual servers that supports InfluxDB + Grafana.

Sorry for my stupid question. I'm so ashamed

Regards.
Robert