OFA directory structure

The easiest way to present the OFA structure is to lay it out in a table. Below is the table and several explanations are provided to clarify this structure.

In this document we consider the fact that OFA is a "Flexible" architecture. Therefore we don't provide instructions but only advices and best practices. Everyone is free to follow them or not. Also the level of details until which OFA should be implemented can be defined by the customer according to its requirements.

Mount point	Directory	Owner	Description
Unix – Windows directory structure:
/u01 Unix Drive: Win.		root	The /u01 mount point contains the MySQL administration files (software, configuration and log files, scripts)
	/app [ UNIX/Linux only ]	root	Application directory (i.e. Oracle, MySQL, Sybase)
	[/app]/mysql	mysql	MYSQL_BASE, basis for all MySQL components
	[/app]/mysql/etc	mysql	Directory containing the my.cnf file. Soft links exist from /etc to ${MYSQL_BASE}/etc/my.cnf. my.cnf contains the configuration of all MySQL servers.
MariaDB - Binary structure
Database
/u01	[/app]/mysql/product	mysql	Directory containing the MySQL software installations
	[/app]/mysql/ mariadb-10.4.8-linux-systemd-x86_64 and/or soft link mariadb-10.1.28-linux-systemd-x86_64 [/app]/mysql/product/mariadb-10.4.8	mysql	Product directory for MariaDB-10.4.8
DMK
	[/app]/oracle/local/dmk	mysql	Database Management Kit - DMK
	[/app]/oracle/local/dmk_dbcreate	mysql	Database Creation scripts
	[/app]/oracle/local/dmk_dbbackup	mysql	Database Backup scripts
	[/app]/oracle/local/dmk_sql	mysql	Database SQL scripts
Database
/u01 Drive: Win.	[/app]/oracle/admin	mysql	Base directory for database admin directories. See below in the document for details (“admin directory”)
	[/app]/oracle/admin/[MYSQL_SERVER]	mysql	Where MYSQL_SERVER=mysqld[99] For example: MYSQL_SERVER=mysqld1 admin directory for MySQL server mysqld1 Note : see below for details about admin directory contents
Database directories
Datafile
/uXX Drive: Win.	/u02/mysqldata	mysql	Basis directory for all database directories
	/mysqldata/mysqld1 /mysqldata/mysqld2	mysql	DB files directory for instance: mysqld1 DB files directory for instance: mysqld2
Backup, MySQL dump and binary log locations:
/u9X Drive: Win.		root	Different filesystem and disks for backup components
	[/app]/mysql	mysql
	[/app]/mysql/admin	mysql	Basis directory for database backup and archive directories
	[/app]/mysql/admin/mysqld1/backup	mysql	Physical location of the backup directory for mysqld1. This directory is soft linked from /u00 (see explanations below). Directory only used if no FRA or no media manager is in use (backup disk)
	[/app]/oracle/admin/mysqld1/binlog	mysql	Physical location of the archive directory for MariaDB servers. This directory is soft linked from /u01 (see explanations below)
	[/app]/oracle/admin/mysqld1/dump	mysql	Physical location of the MySQL dump exported files. This directory is soft linked from /u01 (see explanations below)