apiVersion: apps/v1
kind: Deployment
metadata:
name: devops-mysql # deployment控制器名称
spec:
replicas: 1
revisionHistoryLimit: 5
strategy:
    type: RollingUpdate
selector:
    matchLabels:
      app: devops-mysql
template:
    metadata:
      labels:
        app: devops-mysql
    spec:
      containers:
        - name: devops-mysql
          image: mysql:8.0
          env:
            - name: MYSQL_ROOT_PASSWORD
              value: XXXXXXXX # root密码
          imagePullPolicy: Always
          ports:
            - containerPort: 3306
---
apiVersion: v1
kind: Service
metadata:
name: devops-mysql # 数据库服务的名称
spec:
ports:
    - port: 3306
      protocol: TCP
      targetPort: 3306
selector:
    app: devops-mysql
sessionAffinity: ClientIP

apiVersion: apps/v1
kind: Deployment
metadata:
  name: nginx-deployment
spec:
  replicas: 1
  selector:
    matchLabels:
      app: nginx
  template:
    metadata:
      labels:
        app: nginx
    spec:
      containers:
      - name: nginx
        image: nginx:latest
        volumeMounts:
          - mountPath: etc/nginx/nginx.conf
            name: nginxconf
            readOnly: true
            subPath: nginx.conf
          - mountPath: etc/nginx/tcp.d/tcp.conf
            name: tcpconf
            readOnly: true
            subPath: tcp.conf
      volumes:
        - configMap:
            defaultMode: 420
            name: nginxconf
          name: nginxconf
        - configMap:
            defaultMode: 420
            name: tcpconf
          name: tcpconf
---
apiVersion: v1
kind: ConfigMap
data:
  tcp.conf: |-
    stream {
        server {
            listen 9999;
            proxy_pass devops-mysql:3306;
        }
    }
metadata:
  name: tcpconf
---
apiVersion: v1
kind: ConfigMap
data:
  nginx.conf: |-
    user nginx;
    worker_processes auto;
    
    error_log var/log/nginx/error.log notice;
    pid var/run/nginx.pid;
    
    
    events {
        worker_connections 1024;
    }
    
    
    http {
        include       /etc/nginx/mime.types;
        default_type application/octet-stream;
    
        log_format main '$remote_addr - $remote_user [$time_local] "$request" '
                          '$status $body_bytes_sent "$http_referer" '
                          '"$http_user_agent" "$http_x_forwarded_for"';
    
        access_log var/log/nginx/access.log main;
    
        sendfile on;
        #tcp_nopush on;
    
        keepalive_timeout 65;
    
    
        #gzip on;
    
        include /etc/nginx/conf.d/*.conf;
    }
    include etc/nginx/tcp.d/*.conf; # 加载stream tcp转发
metadata:
  name: nginxconf
---
apiVersion: v1
kind: Service
metadata:
  name: service-nginx
spec:
  selector:
    app: nginx
  ports:
  - protocol: TCP
    port: 9999
    targetPort: 9999
  type: NodePort

kubectl create -f XXX.yaml

nginx -X

nginx: [emerg] "stream" directive is not allowed here in /usr/local/nginx/conf/nginx.conf:86