Skip to content

Create and Configure a Database for Workspace Services

Create and Configure a Database for Workspace Services

To create a database for Workspace Services, follow these steps:

  1. Create a database for  mfconsoledb with a custom name along with prefix and suffix. Prefix and suffix are optional. For example, database name is <prefix>mfconsoledb<suffix>.

    Note:  For Oracle databases, a schema name should be in capital letters.

    Note: For Oracle, create necessary tablespaces and Users before proceeding. Refer to Prerequisites for Volt MX Foundry with Oracle.

    • The following is a sample query for creating a database in SQL Server:
CREATE DATABASE mfconsoledb;
  • The following is a sample query for creating a database in MySQL:
CREATE DATABASE \`<DBNAME>\` DEFAULT CHARACTER SET utf8 COLLATE utf8\_unicode\_ci;

For Foundry version V9.2.2.0 or greater:

To create mfconsoledb:

The following is a sample query for creating a database in MySQL: CREATE DATABASE `<DBNAME>` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Important:  For workspace, you can create database with a custom name instead the default databases such as  mfconsoledb.
For example, if you have created a workspace database with a custom name ( <prefix>mfconsoledb<suffix>), replace the custom database name in all SQL scripts in the \VoltMXFoundry_Plugins\scripts\waasdbmigrations\commondbscripts  folder.

  1. Execute all SQL scripts for the component by using the steps provided at Configuring Flyway Command-line Tool.

    The following details pre-requisites for Flyway configuration:

    • Schema name for workspace: mfconsoledb
    • Placeholders for Workspace Services:

      # Volt MX Workspace Services Database, replace the following placeholders 
        # in SQL migrations for your database
        flyway.placeholders.VOLTMX_WAAS_LOG_LOCATION=C:VoltMXFoundry/logs
        flyway.placeholders.VOLTMX_WAAS_LOG_LEVEL=INFO
        flyway.placeholders.VOLTMX_WAAS_LOG_OPTION=logfile
        flyway.placeholders.VOLTMX_WORKSPACES_GLOBAL_DB
        flyway.placeholders.VOLTMX_WAAS_GLOBAL_DB
  • Tablespace Placeholders for Oracle:

    Product Name Tablespace Placeholders for Oracle
    Workspace WAAS_DATA_TABLESPACE , WAAS_INDEX_TABLESPACE , WAAS_LOB_TABLESPACE
  • SQL files paths for Workspace Services in VoltMXFoundry_Plugins folders.

    Path for SQL files in the VoltMXFoundry_Plugins folder Database Component
    \VoltMXFoundry_Plugins\scripts\waasdbmigrations\commondbscripts MySQL Workspace  
    \VoltMXFoundry_Plugins\scripts\mmigrations-waas-oracle\commondbscripts Oracle
    \VoltMXFoundry_Plugins\scripts\migrations-waas-sqlserver\commondbscripts SQL Server
  • Execute all SQL scripts by using the steps provided at Configuring Flyway Command-line Tool.

    In flyway conf, set flyway.baselineOnMigrate=true

    set flyway.validateOnMigrate=false

    Click here to view the Workspace schema diagram