Installation Instructions - Database Tier - MySQL

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

Backup Considerations

Customers should follow their standard practices for Database and File System(Artifact Repository) backup. During upgrade procedure, we have defined steps to take complete backup of database and file system as well.

You must be in /database/mysql/install folder from extracted zip when executing scripts.

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.

Step 1. You should set the FD_ADMIN password before running the scripts.

  • Open the file <Unzip Folder>/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.

You should record the FD_ADMIN password, as that will be used in configuration of data source on application server.

Step 2. Install MySQL database, if you have done that already. Follow guidelines for your platform as documented in MySQL documentation.

Step 3. Create FlexDeploy schema objects.

  • 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)
  • 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

  • Type the password when asked. MySQLDDL.txt records the output of the script so that you can refer back to it later.
    • cd <Unzip Folder>/database/mysql/install
    • /path/to/mysql -u username -h hostname --port=3306 -p < CreateFlexDeploySchemas.sql > MySQLDDL.txt

Windows

  • Type the password when asked. MySQLDDL.txt records the output of the script so that you can refer back to it later.
    • cd <Unzip Folder>/database/mysql/install
    • "C:\path to\mysql" -u username -h hostname --port=3306 -p < CreateFlexDeploySchemas.sql > MySQLDDL.txt