Skip to content

databases.md

Latest commit

 

History

History
120 lines (81 loc) · 1.79 KB

databases.md

File metadata and controls

120 lines (81 loc) · 1.79 KB

Databases

SQL

SqlServer

  • Hostname: sqlserver
  • Port: 1433
  • SA Password: L0c@lh0st

Kubernetes

Using WSL run the following commands to create a folder and grant permissions

sudo mkdir -p /mnt/c/rancher-data/sqlserver/{data,log,secrets}
sudo chown -R 10001:0 /mnt/c/rancher-data/sqlserver
sudo chmod -R 777 /mnt/c/rancher-data/sqlserver

Apply the YAML

kubectl apply -f .\sqlserver-k8.yaml

Docker

docker-compose -f .\sqlserver-docker.yaml -p sqlserver up -d

This is the command to copy the backup files from the container:

docker cp sqlserver:/var/opt/mssql/data/. .

Postgres

  • Hostname: postgres
  • Port: 5432
  • Default User: postgres
  • Default Pass: postgres
  • PgAdmin port: 8081

Kubernetes

kubectl apply -f .\databases\postgres-k8.yaml

Docker

docker-compose -f .\postgres-docker.yaml -p postgres up -d

MySQL

  • Hostname: mysql
  • Port: 3306
  • Root Password: localhost
  • PhpMyAdmin port: 8088

Kubernetes

kubectl apply -f .\mysql-k8.yaml

Docker

docker-compose -f .\mysql-docker.yaml -p mysql up -d

NoSQL

MongoDB

  • Hostname: mongodb
  • Port: 27017
  • User: mongodb
  • Password: mongodb

Kubernetes

kubectl apply -f .\mongodb-k8.yaml

Docker

docker-compose -f .\mongodb-docker.yaml -p mongodb up -d

Clients:

Redis

  • Hostname: redis
  • Port: 6379
  • Commander Port: 8081
  • Manager Port: 16379

Kubernetes

kubectl apply -f .\redis-k8.yaml

Docker

docker-compose -f .\redis-docker.yaml -p redis up -d