Mysql loadGen for Dmaas schedule

[bhaskarhc]

Short Description :

• Generate Load on MySQL application to test Dmaas schedule .

[bhaskarhc]

Written python script to generate load on mysql by creating tables and appending rows in the table , Repo : https://github.com/mayadata-io/oep-e2e-aws/tree/test-mysql-load

[bhaskarhc]

Facing issue on connecting MySQL and loadgen-app in GitLab pipeline.

GitLab pipeline result

[bhaskarhc]

Succssfully Running loadGen-app in kubernetes cluster when running as pod .

loadGen-app Deployment yaml

---
apiVersion: apps/v1
kind: Deployment
metadata:
  labels:
    app: mysql-load-gen-app
  name: mysql-load-gen-app
  namespace: default
spec:
  replicas: 1
  selector:
    matchLabels:
      app: mysql-load-gen-app
  template:
    metadata:
      labels:
        app: mysql-load-gen-app
    spec:
      containers:
      - env:
        - name: MYSQLHOST
          value: "wordpress-mysql.mysql-dmaas-jiva"
        - name: MYSQLUSER
          value: "root"
        - name: DBPASS
          value: "mayadatae2e"
        - name: DBNAME
          value: "postgres"
        name: mysql-load-gen-app
        image: bhaskarjb/mysqlload:01
        imagePullPolicy: Always
        ports:
          - containerPort: 3000
            protocol: TCP
      restartPolicy: Always
---
apiVersion: v1
kind: Service
metadata:
  labels:
    app: mysql-load-gen-app
  name: mysql-load-gen-app
  namespace: default
spec:
  ports:
  - name: mysql-load-gen-app
    port: 3000
    protocol: TCP
    targetPort: 3000
    nodePort: 30002
  selector:
    app: mysql-load-gen-app
  type: NodePort

[bhaskarhc]

@harshshekhar15 @AmitKumarDas @atulabhi Need your help to run loadGen script on pipeline . 🙏