> For the complete documentation index, see [llms.txt](https://dbi-services.gitbook.io/dmk-mariadb-manual/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dbi-services.gitbook.io/dmk-mariadb-manual/ofa/ofa-directory-structure.md).

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

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

##