Prerequisites for SQL Server

  • Database User security role: Create a database login dbclient using SQL server authentication with server roles as sysadmin and public
  • Database and schema access: Installer will make use of the above login to create necessary databases and schemas required for the selected Quantum Fabric components.
  • Database Growth sizing: Refer to Quantum Fabric Deployment Guide > Database Growth Sizing
  • Database Transaction log size: Allocate sufficient space for the Transaction log file based on all the transactions activity of all the Quantum Fabric components installed and as per your database backup policy. Because transaction log sizing is linked to database backup. If additional application logging/events are enabled in multiple components of Quantum Fabric, then you may need to consider additional size for the transaction log.
  • Temp Database and temp log: This is based on usage of all the databases on the server instance, by all applications connecting to these databases. In case of Quantum Fabric, for sizing of the temp database, consider auto growth with increment size should be of 100MB and with maximum size to 10GB. But if application logging/events are enabled in multiple components of Quantum Fabric, then the maximum size should be increased upto 20GB. This size will get reclaimed as and when the DB is restarted.
  • Database versions: You can use SQL Server Standard Edition or SQL Server Enterprise Edition database for installing Quantum Fabric. Quantum Fabric is compatible with these editions. There are no prerequisites specific to these editions as Quantum Fabric uses features common to both editions.
  • Backup plan: You must use your organization's defined backup and retention policies for Backup strategies for your database.

Steps before installing (or) upgrading Fabric with an existing database

Perform the following activities before installing (or) upgrading Quantum Fabric with the existing database:

  • Take a backup of your database.
  • Make sure you have a previously installed directory.
  • Take a backup of the applications that are deployed at the server level. After the installation is complete, take a backup of the changes that were made to the binaries.
  • After the installation or upgrade process is complete, replace the old authService.key, workspaceService.key, and ACCOUNTS_ENCRYPTION_KEY keys.
    This is only applicable for the identity and workspace components.

Create /tmp Folder

Quantum Fabric Installer requires a /tmp folder in a Linux environment to unpack the installer. When the /tmp folder is not found, the Installer displays an I/O exception at the time of unpack exception.

This must be specified in the pre-req of installation. Installation requires temp folder to unpack MF installer (either default / custom temp folder).