This page provides the system requirements and installation instructions for the FlexDeploy database tier on MySQL.
Requirements
- 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.
- FlexDeploy uses three databases (FD, FF, and FD_ADMIN) and performs all work using the FD_ADMIN user.
Installation Instructions
- You should set the FD_ADMIN password before running the scripts.
- Open the file /database/mysql/install/scripts/CreateFD.sql
- Edit the line: CREATE USER 'FD_ADMIN'@'%' IDENTIFIED BY 'welcome1' so that it has a new password in it.
- Open a command prompt or putty window to the /database/mysql/install folder from extracted zip, launch mysql (use full path if not available on PATH environment)
- Run using a username with privileges to login from the host that you are running the commands from and to create users and objects.
- Change the bold text as needed in your environment.
- Run the appropriate command below.
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
Type the password when asked.
> mysqlDDL.txt records the output of the script so that you can refer back to it later.
The creation will take a few moments. Then you are ready to connect your datasource to the database.
You should record the FD_ADMIN password. Then you may wish to delete the CreateFD.sql file.