This page provides the system requirements and installation instructions for the FlexDeploy database tier on MySQL.

Requirements

• MySQL 8
• 4GB of RAM
• 1 or 2 CPU
• At least 10GB of available space, may need additional space. Purge settings within FlexDeploy will determine future needs.
• Normal database backup procedures should be followed outside of the FlexDeploy Application. Backing up of this database is not included in FlexDeploy.

Installation Instructions

FlexDeploy uses three databases (FD, FF, and FD_ADMIN) and performs all work using the FD_ADMIN user. Run database scripts from where you extracted downloaded FlexDeploy zip file. Navigate to the /database/mysql/install directory.

1. You should set the FD_ADMIN password before running the scripts.
   1. Open the file <Unzip Folder>/database/mysql/install/scripts/CreateFD.sql
   2. Edit the line: CREATE USER 'FD_ADMIN'@'%' IDENTIFIED BY 'welcome1' so that it has a new password in it.
2. Open a command prompt or putty window to the <Unzip Folder>/database/mysql/install folder, launch mysql (use full path if not available on PATH environment)
3. Run using a username with privileges to login from the host that you are running the commands from and to create users and objects.
4. Change the bold text as needed in your environment.
5. Run the appropriate command below.

Type the password when asked. MySQLDDL.txt records the output of the script so that you can refer back to it later.

Linux

• /path/to/mysql -u username -h hostname --port=3306 -p < CreateFlexDeploySchemas.sql > MySQLDDL.txt

Windows

• "C:\path to\mysql" -u username -h hostname --port=3306 -p < CreateFlexDeploySchemas.sql > MySQLDDL.txt