Create Databases and Users

Contents:

Expand all Collapse all

Contents:

Create DBs and Users

PostgreSQL

Run the following script, which builds the four databases and specifies the appropriate roles (users) for each database, based on the parameters you have specified in trifacta-conf.json and in the pg_hba.conf:

NOTE: This script must be run as the root user or via sudo superuser.

/opt/trifacta/bin/setup-utils/db/trifacta-create-postgres-roles-dbs.sh

MySQL

Run the following script, which builds the four databases and specifies the appropriate roles (users) for each database, based on the parameters you have specified in trifacta-conf.json:

NOTE: This script must be run as the root user or via sudo superuser.

/opt/trifacta/bin/setup-utils/db/trifacta-create-mysql-users-dbs.sh -u <MySql_admin_username> -w <MySql_admin_password>

where:

-u = MySQL admin username, which is usually root.
-w = MySQL admin password

Backup

For more information on backup recommendations and commands, see Backup and Recovery.

Configure Non-Default Database Connections

If you have used non-default values for the username, password, host, or port value for either database, you must update platform configuration. You can apply this change through the Admin Settings Page (recommended) or trifacta-conf.json. For more information, see Platform Configuration Methods.

NOTE: The default database server is PostgreSQL. If you have installed databases on a different server, updates are required below.

NOTE: Do not modify the other properties in these sections unless necessary.

Alteryx database

"webapp.db.username": "trifacta",
"webapp.db.logging": false,
"webapp.db.name": "trifacta",
"webapp.db.host": "localhost",
"webapp.db.password": "<pwd_trifactaDB>",
"webapp.db.type": "postgresql",
"webapp.db.port": 5432,
"webapp.db.pool.maxIdleTimeInMillis": 30000,
"webapp.db.pool.maxConnections": 10,

The following parameters apply to the Alteryx database only:

Parameter	Description
`logging`	Set this value to `true` to enable logging on the Alteryx database.
`pool.maxIdleTimeInMillis`	Specifies the maximum permitted idle time for a database connection before it is automatically closed.
`pool.maxConnections`	Defines the maximum permitted database connections for the Alteryx database.

Additional parameters are described below.

Jobs database

Modify the batch-job-runner.db settings:

"batch-job-runner.db.username": "trifactaactiviti", 
"batch-job-runner.db.name": "trifacta-activiti", 
"batch-job-runner.db.type": "postgresql", 
"batch-job-runner.db.driver": "org.postgresql.Driver", 
"batch-job-runner.db.host": "localhost", 
"batch-job-runner.db.password": "<pwd_trifactaactivitiDB>", 
"batch-job-runner.db.port": 5432,

Jobs database thread pool size

You can modify the following settings to specify minimum and maximum permitted thread pools for the Jobs database:

"batch-job-runner.db.minPoolSize": 3,
"batch-job-runner.db.initialPoolSize": 3,
"batch-job-runner.db.maxPoolSize": 50,

Parameter Name	Description
batch-job-runner.db.minPoolSize	Integer representing the minimum size of the database connection pool
batch-job-runner.db.initialPoolSize	Integer representing the initial size of the database connection pool
batch-job-runner.db.maxPoolSize	Integer representing the maximum size of the database connection pool

Scheduling service database

"scheduling-service.database.type": "POSTGRESQL",
"scheduling-service.database.host": "localhost",
"scheduling-service.database.port": "5432",
"scheduling-service.database.name": "trifactaschedulingservice",
"scheduling-service.database.user": "trifactaschedulingservice",
"scheduling-service.database.password": "<pwd_schedulingserviceDB>"

Time-based trigger service database

"time-based-trigger-service.database.type": "POSTGRESQL",
"time-based-trigger-service.database.host": "localhost",
"time-based-trigger-service.database.port": "5432",
"time-based-trigger-service.database.name": "trifactatimebasedtriggerservice",
"time-based-trigger-service.database.user": "trifactatimebasedtriggerservice",
"time-based-trigger-service.database.password": "<pwd_triggerserviceDB>"

Database Parameter Reference

The following generalized parameters apply to one or more of the databases.

Parameter	Description
`host`	Host of the database. Default value is `localhost`, meaning the database is hosted on the Alteryx node.
`port`	Port number for the database. Default value is `5432` for all databases, assuming that they are PostgreSQL. Modify this value accordingly if you have installed the databases onto a different type of database server. See System Ports.
`name`	Name of the database. This value should match what was used during installation.
`user` or `username`	The username to use to connect to the database.
`password`	Password to use to connect to the database.
`type`	The default database type is `POSTGRESQL`. Modify this value accordingly if you have installed the databases onto a different type of database server.
`driver`	Name of the database. Do not modify.

Save your changes and restart the platform.

Send Feedback

Page tree