Create the Database¶
Install one of the supported Database Management System Servers or allocate the existing one for Oro application data storage.
Create a dedicated database admin user that will be later on used in the installation configuration.
Create an empty database for Oro application. You will need the database name, server host and port information, and user information when you get to the Installation Parameters Configuration step of the installation below.
If you use Oro application with MySQL 5.X and store data on the HDD, you may face performance issues. If you choose to keep using this configuration, please follow the recommendations provided in the optimizing InnoDB Disk I/O article, and hence use the following configuration:
innodb_file_per_table = 0 wait_timeout = 28800
If you use an Oro application with the PostgreSQL database, load the uuid-ossp extension. Log into the database management system and run the following SQL query:
CREATE EXTENSION "uuid-ossp";
This step ensures that PostgreSQL properly handles the doctrine guid type.