Configuring database serversEdit on GitHub
This article describes how you can change your database server.
Spryker supports MySQL, MariaDB, and PostgreSQL as database servers. By default, the virtual machine is configured to use the MariaDB database server, but you can easily switch to PostgreSQL.
To configure the database server you want to use, you have to keep in mind these constants and use them in the corresponding configuration file:
|MySQL or MariaDB||ZED_DB_ENGINE_MYSQL||3306|
The configuration files are placed under the
config/Shared/ folder. For example,
config/Shared/config_default-development.php is the configuration file for the development environment.
Using MySQL or MariaDB as a DB Server
<?php $config[PropelConstants::ZED_DB_ENGINE] = $config[PropelConstants::ZED_DB_ENGINE_MYSQL]; $config[PropelConstants::ZED_DB_PORT] = 3306;
Using PostgreSQL as a DB Server
<?php $config[PropelConstants::ZED_DB_ENGINE] = $config[PropelConstants::ZED_DB_ENGINE_PGSQL]; $config[PropelConstants::ZED_DB_PORT] = 5432;
Creating the database
To create or update the database configuration, run the installation tool using this command:
If the application is already installed on your virtual machine and you switch to a different database server, you can also run:
-h option to see the help page for this command.
For submitting the form