Skip to content

Instantly share code, notes, and snippets.

@dbafromthecold
Created December 6, 2020 11:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dbafromthecold/92ddea343d525f6c680d9e3fff4906c9 to your computer and use it in GitHub Desktop.
Save dbafromthecold/92ddea343d525f6c680d9e3fff4906c9 to your computer and use it in GitHub Desktop.
Azure SQL Edge with persistent volume claims
apiVersion: apps/v1
kind: Deployment
metadata:
name: sqledge-deployment
spec:
replicas: 1
selector:
matchLabels:
app: sqledge
template:
metadata:
labels:
app: sqledge
spec:
volumes:
- name: sqlsystem
persistentVolumeClaim:
claimName: sqlsystem-pvc
- name: sqldata
persistentVolumeClaim:
claimName: sqldata-pvc
- name: sqllog
persistentVolumeClaim:
claimName: sqllog-pvc
containers:
- name: azuresqledge
image: mcr.microsoft.com/azure-sql-edge:latest
ports:
- containerPort: 1433
volumeMounts:
- name: sqlsystem
mountPath: /var/opt/mssql
- name: sqldata
mountPath: /var/opt/sqlserver/data
- name: sqllog
mountPath: /var/opt/sqlserver/log
env:
- name: MSSQL_PID
value: "Developer"
- name: ACCEPT_EULA
value: "Y"
- name: SA_PASSWORD
value: "Testing1122"
- name: MSSQL_AGENT_ENABLED
value: "TRUE"
- name: MSSQL_COLLATION
value: "SQL_Latin1_General_CP1_CI_AS"
- name: MSSQL_LCID
value: "1033"
- name: MSSQL_DATA_DIR
value: "/var/opt/sqlserver/data"
- name: MSSQL_LOG_DIR
value: "/var/opt/sqlserver/log"
terminationGracePeriodSeconds: 30
securityContext:
fsGroup: 10001
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment