Skip to content

OTRS DB Import

Archived (pre-2022)

Preserved for reference only -- likely outdated. View original | Last updated: March 2020

Based on the ticket DEVOPSBLN-1301

Description

We have an external DB managed by the 3rd party OTRS service which is being used by our Customer Support.

There is a need for our customer support to run queries against this data, but they don't have direct access to the OTRS Database. And it would the best solution to ask OTRS 3rd party company to create the read replica of this DB and provide us read-only credentials so we can query this read replica instead of what we are doing now.

But so far we don't have it, so we developed the following solution:

  • RDS MariaDB instance in AWS Fyber Core Ireland called aws-production-otrs-datastore-2.
  • Jenkins's job is creating a docker container with MySQL tools with purpose to dump the data from the OTRS DB, and recover it to our RDS.
  • Provided our customer support with access to our RDS

RDS was created manually (no terraform)

Jenkins Job: Jenkins - otrs-import

Jenkins Job Code: Jenkinsfile (Github)

Credentials

The root user credentials are saved in the last pass under OTRS DB Root Access site.