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.