$ tree .
.
|-- mysql-deployment.yaml
|-- mysql-volume.yaml
|-- was-deployment.yaml
|-- was-secret.yaml
`-- was-volume.yaml

from fastapi import FastAPI
from dataclasses import dataclass
import pymysql
import os

def get_env() -> tuple[str | int]:
    return (
        os.getenv('MYSQL_HOST'),
        os.getenv('MYSQL_PORT'),
        os.getenv('MYSQL_USER'),
        os.getenv('MYSQL_PASSWORD'),
        os.getenv('MYSQL_DATABASE'),
    )

@dataclass
class Data():
    host: str
    port: int
    user: str
    password: str
    database: str

data : Data = Data(*get_env())

def connect_db() -> pymysql.Connection:
    con = pymysql.connect(
        host=data.host,
        port=int(data.port),
        user=data.user,
        password=data.password,
        database=data.database,
        charset='utf8'
    )
    return con

app = FastAPI()

@app.get('/')
def say_hello() -> dict[str,str]:
    return {"Message": "안녕하세요"}

@app.get('/db')
def connect() -> None | dict[str,str]:
    try:
        con : pymysql.Connection = connect_db()
        cursor = con.cursor()

        query = "SELECT * FROM testTBL;"
        cursor.execute(query)
        result = cursor.fetchone()
        print(result)
        return {"Message": "DB connection complete!}
    except Exception as e:
        print(e)
        return {"Message": "DB connection failed!"}

FROM python:3.10-slim-buster

WORKDIR /usr/src/app

COPY ./requirements/*.txt ./requirements.txt

RUN pip install --upgrade pip && pip install -r ./requirements.txt

COPY ./ ./

EXPOSE 8080

CMD ["uvicorn", "main:app", "--host", "0.0.0.0", "--port", "8080"]

$ docker buildx build --platform linux/amd64 --push --tag yshrim12/was .

$ mkdir /mnt/shared/fastapi-app
$ mkdir /mnt/shared/fastapi-db

# 아래 내용 추가
/mnt/shared 192.168.56.30/24(rw,sync,no_root_squash,no_subtree_check)

$ exportfs -a

$ systemctl restart nfs-server

apiVersion: v1
kind: PersistentVolume
metadata:
  name: db-storage
  labels:
    type: db-nfs
spec:
  capacity:
    storage: 10Gi
  accessModes: ["ReadWriteMany"]
  nfs:
    server: "192.168.56.30"
    path: "/mnt/shared/fastapi-db"

apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: db-claim
spec:
  accessModes:
    - ReadWriteMany
  resources:
    requests:
      storage: 4Gi
  storageClassName: ""
  selector:
    matchLabels:
      type: db-nfs

#================
# MySQL Service
#================
apiVersion: v1
kind: Service
metadata:
  name: mysql-service
spec:
  ports:
    - name: db-port
      port: 3306
      targetPort: 3306
  selector:
    app: mysql
  type: ClusterIP
---
#================
# MySQL Deployment
#================
apiVersion: apps/v1
kind: Deployment
metadata:
  name: mysql-pod
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mysql
  template:
    metadata:
      labels:
        app: mysql
    spec:
      containers:
        - name: mysql
          image: docker.io/mysql:latest
          ports:
            - containerPort: 3306
              protocol: TCP
          volumeMounts:
            - name: db-volume
              mountPath: /var/lib/mysql
          env:
            - name: MYSQL_ROOT_PASSWORD
              value: secret
            - name: MYSQL_DATABASE
              value: testDB
      volumes:
        - name: db-volume
          persistentVolumeClaim:
            claimName: db-claim

apiVersion: v1
kind: PersistentVolume
metadata:
  name: was-storage
  labels:
    type: was-nfs
spec:
  capacity:
    storage: 10Gi
  accessModes: ["ReadWriteMany"]
  nfs:
    server: "192.168.56.30"
    path: "/mnt/shared/fastapi-app"

apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: was-claim
spec:
  accessModes:
    - ReadWriteMany
  resources:
    requests:
      storage: 4Gi
  storageClassName: ""
  selector:
    matchLabels:
      type: was-nfs

#================
# WAS Service
#================
apiVersion: v1
kind: Service
metadata:
  name: was-service
spec:
  ports:
    - port: 8080
      targetPort: 8080
      nodePort: 30002
  selector:
    app: fastapi
  type: NodePort
---
#================
# WAS Deployment
#================
apiVersion: apps/v1
kind: Deployment
metadata:
  name: was-fastapi
spec:
  replicas: 1
  selector:
    matchLabels:
      app: fastapi
  template:
    metadata:
      labels:
        app: fastapi
    spec:
      containers:
        - name: fastapi
          image: docker.io/yshrim12/was:latest
          resources:
            limits:
              cpu: "0.5"
              memory: 1Gi
          ports:
            - containerPort: 8080
          volumeMounts:
            - name: was-volume
              mountPath: /apps
          env:
            - name: MYSQL_HOST
              valueFrom:
                secretKeyRef:
                  name: was-secret
                  key: MYSQL_HOST
            - name: MYSQL_PORT
              valueFrom:
                secretKeyRef:
                  name: was-secret
                  key: MYSQL_PORT
            - name: MYSQL_USER
              valueFrom:
                secretKeyRef:
                  name: was-secret
                  key: MYSQL_USER
            - name: MYSQL_PASSWORD
              valueFrom:
                secretKeyRef:
                  name: was-secret
                  key: MYSQL_PASSWORD
            - name: MYSQL_DATABASE
              valueFrom:
                secretKeyRef:
                  name: was-secret
                  key: MYSQL_DATABASE
      volumes:
        - name: was-volume
          persistentVolumeClaim:
            claimName: was-claim

$ kubectl apply -f .
service/mysql-service created
deployment.apps/mysql-pod created
persistentvolume/db-storage created
persistentvolumeclaim/db-claim created
service/was-service created
deployment.apps/was-fastapi created
secret/was-secret created
persistentvolume/was-storage created
persistentvolumeclaim/was-claim created