Versionen im Vergleich

Schlüssel

  • Diese Zeile wurde hinzugefügt.
  • Diese Zeile wurde entfernt.
  • Formatierung wurde geändert.

Running a local dockerized database

Postgres

Codeblock
docker run \
    -e POSTGRES_PASSWORD=mysecretpassword \
    -p 5432:5432 \
    --name postgres \
    postgres:12.3
cmsbs.database.url      = "jdbc:postgresql://localhost:5432/"
cmsbs.database.user     = "postgres"
cmsbs.database.password = "secret"

JDBC Driver: https://jdbc.postgresql.org/download.html

MySQL

Codeblock
docker run \
    -e MYSQL_DATABASE=um -e MYSQL_ROOT_PASSWORD=secret \
    -p 3306:3306 \
    --name mysql \
    mysql:8.0
cmsbs.database.url      = "jdbc:mysql://localhost:3306/um?allowPublicKeyRetrieval=true"
cmsbs.database.user     = "root"
cmsbs.database.password = "secret"
cmsbs.database.mysql.Unicode = true

JDBC Driver: https://dev.mysql.com/downloads/connector/j/

MSSQL

Codeblock
docker run \
    -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=S3cre7pw' -e 'MSSQL_PID=Express' \
    -p 1433:1433 \
    --name mssql2017 \
    mcr.microsoft.com/mssql/server:2017-latest-ubuntu
cmsbs.database.url      = "jdbc:sqlserver://localhost:1433"
cmsbs.database.user     = "sa"
cmsbs.database.password = "S3cre7pw"
cmsbs.database.mssql.Unicode = true

JDBC Driver: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

Oracle

Codeblock
docker run \
    -p 1521:1521 \
    --name oracle-xe-11g \
    oracleinanutshell/oracle-xe-11g:latest
cmsbs.database.url      = "jdbc:oracle:thin:@localhost:1521:xe"
cmsbs.database.user     = "system"
cmsbs.database.password = "oracle"

JDBC Driver: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html (Oracle account required!)A Universal Messenger instance can either be deployed on-premise on your own (virtual) server or on a (virtual) server that is hosted somewhere else.

In addition Pinuts offers a Software as a Service solution that provides a fully customizable UM instance operated off of Amazon Web Services.

This solution utilizes several high level AWS services like

  • Relational Database Service

  • Application Load Balancer

  • Certificate Manager

  • Simple Email Service

  • Simple Notification Service

  • Elastic Container Registry

  • S3

  • Secrets Manager

  • CloudWatch

The SaaS solution usually consists of three separate UM stacks (test, staging and prod) that can be configured and updated independently.

Related topics

Providing a custom Plugin for a cloud-hosted UM