k8s安装powerjob

k8s安装powerjob

k8s安装powerjob

1、mysql

mkdir -p ~/powerjob-ymlkubectl create ns powerjob

cat > ~/powerjob-yml/powerjob-mysql.yml << 'EOF'
apiVersion: v1
kind: ConfigMap
metadata:name: powerjob-mysql-confignamespace: powerjob
data:my.cnf: |[mysqld]pid-file        = /var/run/mysqld/mysqld.pidsocket          = /var/run/mysqld/mysqld.sockdatadir         = /var/lib/mysqlsecure-file-priv= NULL# Custom config should go here!includedir /etc/mysql/conf.d/# 优化配置# 设置最大连接数为 2500max_connections = 2500# 允许最多 100,000 个预处理语句同时存在（取值范围：0 - 1048576，默认16382）max_prepared_stmt_count = 100000# 设置字符集为 UTF-8character-set-server=utf8mb4collation-server=utf8mb4_general_ci# 设置 InnoDB 引擎的缓冲区大小(InnoDB 缓冲池设置为内存的50%-75%)innodb_buffer_pool_size=4G---
apiVersion: apps/v1
kind: StatefulSet
metadata:name: powerjob-mysqlnamespace: powerjob
spec:serviceName: "powerjob-mysql-headless"replicas: 1selector:matchLabels:app: powerjob-mysqltemplate:metadata:labels:app: powerjob-mysqlspec:containers:- name: powerjob-mysql#image: mysql:8.0.28image: ccr.ccs.tencentyun.com/huanghuanhui/mysql:8.0.28imagePullPolicy: IfNotPresentports:- name: powerjob-mysqlcontainerPort: 3306env:- name: MYSQL_ROOT_PASSWORDvalue: "Powerjob@2024"
#       resources:
#         limits:
#           cpu: 2
#           memory: 4Gi
#         requests:
#           cpu: 2
#           memory: 4GilivenessProbe:exec:command: ["mysqladmin", "ping", "-uroot", "-p${MYSQL_ROOT_PASSWORD}"]initialDelaySeconds: 30periodSeconds: 10timeoutSeconds: 5readinessProbe:exec:command: ["mysqladmin", "ping", "-uroot", "-p${MYSQL_ROOT_PASSWORD}"]initialDelaySeconds: 5periodSeconds: 2timeoutSeconds: 1volumeMounts:- name: powerjob-mysql-data-pvcmountPath: /var/lib/mysql- name: powerjob-mysql-configmountPath: /etc/mysql/my.cnfsubPath: my.cnf- mountPath: /etc/localtimename: localtimevolumes:- name: powerjob-mysql-configconfigMap:name: powerjob-mysql-config- name: localtimehostPath:path: /etc/localtimevolumeClaimTemplates:- metadata:name: powerjob-mysql-data-pvcspec:accessModes: ["ReadWriteOnce"]storageClassName: cfsresources:requests:storage: 100Gi---
apiVersion: v1
kind: Service
metadata:name: powerjob-mysql-headlessnamespace: powerjoblabels:app: powerjob-mysql
spec:clusterIP: Noneports:- port: 3306name: powerjob-mysqltargetPort: 3306selector:app: powerjob-mysql---
apiVersion: v1
kind: Service
metadata:name: powerjob-mysqlnamespace: powerjoblabels:app: powerjob-mysql
spec:type: NodePortports:- port: 3306targetPort: 3306nodePort: 30336selector:app: powerjob-mysql
EOF

kubectl apply -f ~/powerjob-yml/powerjob-mysql.yml

kubectl exec -it powerjob-mysql-0 -n powerjob -- mysql -pPowerjob@2024 -e "show databases;"kubectl exec -it powerjob-mysql-0 -n powerjob -- mysql -pPowerjob@2024 -e "select host,user from mysql.user;"kubectl exec -it powerjob-mysql-0 -n powerjob -- mysql -pPowerjob@2024 -e "alter user 'root'@'%' identified with mysql_native_password by 'Powerjob@2024';"kubectl exec -it powerjob-mysql-0 -n powerjob -- mysql -pPowerjob@2024 -e "flush privileges;"CREATE DATABASE IF NOT EXISTS `powerjob-product` DEFAULT CHARSET utf8mb4;

2、mongodb

cat > ~/powerjob-yml/powerjob-mongodb.yml << 'EOF'
apiVersion: apps/v1
kind: StatefulSet
metadata:name: powerjob-mongodbnamespace: powerjob
spec:serviceName: "powerjob-mongodb-headless"replicas: 1selector:matchLabels:app: powerjob-mongodbtemplate:metadata:labels:app: powerjob-mongodbspec:containers:- name: powerjob-mongodbimage: ccr.ccs.tencentyun.com/huanghuanhui/mongo:7.0.8ports:- containerPort: 27017name: mongodbvolumeMounts:- name: powerjob-mongodb-data-pvcmountPath: /data/db- name: localtimemountPath: /etc/localtimevolumes:- name: localtimehostPath:path: /etc/localtimevolumeClaimTemplates:- metadata:name: powerjob-mongodb-data-pvcspec:accessModes: ["ReadWriteOnce"]storageClassName: cfsresources:requests:storage: 100Gi---
apiVersion: v1
kind: Service
metadata:name: powerjob-mongodb-headlessnamespace: powerjoblabels:app: powerjob-mongodb
spec:clusterIP: Noneports:- port: 27017name: powerjob-mongodbtargetPort: 27017selector:app: powerjob-mongodb---
apiVersion: v1
kind: Service
metadata:name: powerjob-mongodbnamespace: powerjoblabels:app: powerjob-mongodb
spec:type: NodePortports:- port: 27017targetPort: 27017nodePort: 30277selector:app: powerjob-mongodb
EOF

kubectl apply -f ~/powerjob-yml/powerjob-mongodb.yml

3、powerjob

cat > ~/powerjob-yml/powerjob.yml << 'EOF' 
apiVersion: apps/v1
kind: StatefulSet
metadata:name: powerjob-servernamespace: powerjob
spec:serviceName: "powerjob-server-headless"replicas: 1selector:matchLabels:app: powerjob-servertemplate:metadata:labels:app: powerjob-serverspec:containers:- name: powerjob-serverimage: ccr.ccs.tencentyun.com/huanghuanhui/powerjob-server:4.3.9ports:- containerPort: 7700name: http- containerPort: 10086name: agent- containerPort: 10010name: adminenv:- name: TZvalue: "Asia/Shanghai"- name: JVMOPTIONSvalue: ""- name: PARAMSvalue: "--spring.profiles.active=product --spring.datasource.core.jdbc-url=jdbc:mysql://powerjob-mysql-headless:3306/powerjob-product?useUnicode=true&characterEncoding=UTF-8 --spring.datasource.core.username=root --spring.datasource.core.password=Powerjob@2024 --spring.data.mongodb.uri=mongodb://powerjob-mongodb-headless:27017/powerjob-product"volumeMounts:- name: powerjob-data-pvcmountPath: /root/powerjob/server- name: m2-repomountPath: /root/.m2volumes:- name: m2-repoemptyDir: {}volumeClaimTemplates:- metadata:name: powerjob-data-pvcspec:accessModes: ["ReadWriteOnce"]storageClassName: cfsresources:requests:storage: 100Gi---
apiVersion: v1
kind: Service
metadata:name: powerjob-servernamespace: powerjoblabels:app: powerjob-server
spec:type: NodePortports:- name: httpport: 7700targetPort: httpnodePort: 30077- name: agentport: 10086targetPort: agentnodePort: 30086- name: adminport: 10010targetPort: adminnodePort: 30110selector:app: powerjob-server
EOF

kubectl apply -f ~/powerjob-yml/powerjob.yml