MISSION CONTROL: Configuring or Seeding an External PostgreSQL for Mission Control 4.x

Since its version 4.x release, Mission ControlrequiresArtifactory version 7 to be installed as aprerequisite. Additionally, as third-party dependencies, Mission Control requiresPostgreSQLandElasticSearchdatabases, which may beexternalized. When using an external PostgreSQL, you’ll need to set up your database, users, and schemafirst, even before proceeding with the installation of Mission Control.

Follow these steps to set up or seed the tables and schemas needed by Mission Control in the external PostgreSQL DB:

1. Use thecreatePostgresUsers.shscript, which is bundled with your downloaded Mission Controlinstallation archives, as per ourinstallation steps.
2. Run thequeriesbelow to create the required Mission Control database, users, and schema.Note: In these queries, the user term,missioncontrol, and the DB term,mission_control, are used examples.

CREATE DATABASE mission_control WITH ENCODING='UTF8' TABLESPACE=pg_default;

#Exit from current login

q

#Login to $DB_NAME database using admin user(by default its postgres)

psql -U postgres mission_control

CREATE USER missioncontrol WITH PASSWORD 'password';

GRANT ALL ON DATABASE mission_control TO missioncontrol;

CREATE SCHEMA IF NOT EXISTS jfmc_server AUTHORIZATION missioncontrol;

CREATE SCHEMA IF NOT EXISTS insight_executor AUTHORIZATION missioncontrol;

CREATE SCHEMA IF NOT EXISTS insight_server AUTHORIZATION missioncontrol;

CREATE SCHEMA IF NOT EXISTS insight_scheduler AUTHORIZATION missioncontrol;

GRANT ALL ON SCHEMA jfmc_server TO missioncontrol;

GRANT ALL ON SCHEMA insight_scheduler TO missioncontrol;

GRANT ALL ON SCHEMA insight_server TO missioncontrol;

GRANT ALL ON SCHEMA insight_executor TO missioncontrol;

Once the required database tables, schemas, and users have been set up, you may proceed toinstall Mission Control. During the installation, select theoptionfor your external PostgreSQL database and provide the JDBC URL as follows:
postgresql://:5432/mission_control?sslmode=disable
Configure Mission Control’smicroservices database settingsto use the above-created user and schema in the Mission Controlsystem.yamlfile, such that the application will be using thesameuser and password to connect to the external database.

Published: Aug. 31, 2020
Last updated: Mar. 15, 2021

Keywords: external PostgreSQL, Mission Control