Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

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.

  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.

You should record the FD_ADMIN password, which you modified in CreateSchemas.sql file.

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


  • No labels