Page tree

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

Compare with Current View Page History

Version 1 Next »

   

Contents:


As needed, the Trifacta® databases can be installed as PostgreSQL DBs on Amazon RDS. Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. 

Limitations

  • In Amazon RDS, databases must be installed in a supported version of PostgreSQL.
  • SSL connectivity is not supported.

Pre-requisites

NOTE: You can use the suggested defaults below for sizing your RDS instance. If you have questions or concerns about sizing recommendations, please contact Trifacta Support.

  • Admin access to an Amazon RDS account

Initialize RDS instance

Steps:

  1. In your RDS dashboard, click Launch a DB instance. 

    NOTE: The RDS instance must be launched in the same Amazon region as the Trifacta node.

  2. For Select Engine: Select PostgresSQL.
  3. For Production?:  Choose Yes if you are deploying the database for a production instance of the Trifacta platform.  Otherwise, select No
  4. DB Engine: postgres
  5. For the DB details, see below:

    NOTE: Except as noted below, properties should be specified according to your enterprise requirements.

    1. Instance Specifications:

      1. License Model: postresql-license
      2. DB Engine Version: For more information on the supported versions of PostgreSQL, see System Requirements.
      3. Allocated Storage: at least 10 GB

  6. For Advanced Settings, please apply the following settings:

    1. Network and Security:

      1. VPC security group must allow for access from the Trifacta platform

    2. Database Options:

      1. Database Name: trifacta

      2. Database Port: 5432

        1. The port number can be changed as needed. See System Ports.

  7. Populate other properties according to your enterprise requirements.

  8. To complete the set up click Launch DB Instance.

  9. When the RDS DB instance is up and running, please collect the following information, which is used later:
    1. Public DNS
    2. Port Number
    3. Admin username
    4. Admin password

Configure the Trifacta platform for RDS

Please complete the following steps to integrate the Trifacta platform with the DB instance you just created.

Steps:

  1. In the RDS console, you must find the Public DNS endpoint for the RDS instance you created: 

    1. Under Instances, expand the name of the instance you created.

    2. The DNS endpoint should be listed under the name in the Endpoint section.

  2. Set the host for each database to the Public DNS endpoint for the RDS instance:

    DatabaseParameter
    Main databasewebapp.database.host
    Jobs database batch-job-runner.database.host
    Scheduling database scheduling-service.database.host
    Time-based Trigger database time-based-trigger-service.database.host
    Configuration Service databaseconfiguration-service.database.host

    Artifact Storage Service database

    artifact-storage-service.database.host
    Job Metadata Service databasejob-metadata-service.database.host

    For more information, see Database Parameter Reference.

  3. To set custom database names, usernames, and passwords:

    1. Edit 

      /opt/trifacta/conf/trifacta-conf.json

    2. For each database, you can review the database name, username, and password

      DatabaseParameter area
      Main databasewebapp.database.*
      Jobs databasebatch-job-runner.database.*
      Scheduling databasescheduling-service.database.*
      Time-Based Trigger databasetime-based-trigger-service.database.*
      Configuration Service databaseconfiguration-service.database.*

      Artifact Storage Service database

      artifact-storage-service.database.*
      Job Metadata Service databasejob-metadata-service.database.*
    3. Make changes in the file as needed and save.

Initialize the databases

NOTE: For the host, port, username, and password values in the following configuration, use the public DNS value for the RDS instance.

To initialize the databases, complete the instructions for manual install of each PostgreSQL database. For more information, see Manual Database Install.

Configure non-default connections

If you have used non-default values for the username, password, host, or port value for either database, you must update platform configuration. For more information, see Database Parameter Reference.

Logging

  1. To review database logs in RDS, locate the Instance details page in the RDS console.
  2. Click Recent Events and Logs.
  3. If your account has the appropriate permissions, all Trifacta database logs are available here. 

  • No labels

This page has no comments.