网站运营托管方案,湖南株洲建设局网站,招商网官网平台,社区网站建设工作职责目录 一、Helm安装
二、安装mysql
1、拉取镜像
2、修改配置文件
3、创建mysql-secret
4、安装 一、Helm安装
这里不再赘叙#xff0c;具体安装请参考官网
Helm | 快速入门指南
二、安装mysql
1、拉取镜像
#添加仓库
helm repo add bitnami https://charts.bitnami.c…目录 一、Helm安装
二、安装mysql
1、拉取镜像
2、修改配置文件
3、创建mysql-secret
4、安装 一、Helm安装
这里不再赘叙具体安装请参考官网
Helm | 快速入门指南
二、安装mysql
1、拉取镜像
#添加仓库
helm repo add bitnami https://charts.bitnami.com/bitnami#搜索镜像
helm search repo mysql#拉取镜像
helm pull bitnami/mysql --version 12.0.0#加压文件
tar -zxf mysql-12.0.0.tgz2、修改配置文件
# Copyright Broadcom, Inc. All Rights Reserved.
# SPDX-License-Identifier: APACHE-2.0## section Global parameters
## Global Docker image parameters
## Please, note that this will override the image parameters, including dependencies, configured to use the global value
## Current available global Docker image parameters: imageRegistry, imagePullSecrets and storageClass
#### param global.imageRegistry Global Docker image registry
## param global.imagePullSecrets Global Docker registry secret names as an array
## param global.defaultStorageClass Global default StorageClass for Persistent Volume(s)
## param global.storageClass DEPRECATED: use global.defaultStorageClass instead
##
global:imageRegistry: ## E.g.## imagePullSecrets:## - myRegistryKeySecretName##imagePullSecrets: []defaultStorageClass: manager-nfs-storage #修改这里为自己的scstorageClass: ## Compatibility adaptations for Kubernetes platforms##compatibility:## Compatibility adaptations for Openshift##openshift:## param global.compatibility.openshift.adaptSecurityContext Adapt the securityContext sections of the deployment to make them compatible with Openshift restricted-v2 SCC: remove runAsUser, runAsGroup and fsGroup and let the platform use their allowed default IDs. Possible values: auto (apply if the detected running cluster is Openshift), force (perform the adaptation always), disabled (do not perform adaptation)##adaptSecurityContext: auto
## section Common parameters
#### param kubeVersion Force target Kubernetes version (using Helm capabilities if not set)
##
kubeVersion:
## param nameOverride String to partially override common.names.fullname template (will maintain the release name)
##
nameOverride:
## param fullnameOverride String to fully override common.names.fullname template
##
fullnameOverride:
## param namespaceOverride String to fully override common.names.namespace
##
namespaceOverride:
## param clusterDomain Cluster domain
##
clusterDomain: cluster.local
## param commonAnnotations Common annotations to add to all MySQL resources (sub-charts are not considered). Evaluated as a template
##
commonAnnotations: {}
## param commonLabels Common labels to add to all MySQL resources (sub-charts are not considered). Evaluated as a template
##
commonLabels: {}
## param extraDeploy Array with extra yaml to deploy with the chart. Evaluated as a template
##
extraDeploy: []
## param serviceBindings.enabled Create secret for service binding (Experimental)
## Ref: https://servicebinding.io/service-provider/
##
serviceBindings:enabled: false
## Enable diagnostic mode in the deployment
##
diagnosticMode:## param diagnosticMode.enabled Enable diagnostic mode (all probes will be disabled and the command will be overridden)##enabled: false## param diagnosticMode.command Command to override all containers in the deployment##command:- sleep## param diagnosticMode.args Args to override all containers in the deployment##args:- infinity
## section MySQL common parameters
#### Bitnami MySQL image
## ref: https://hub.docker.com/r/bitnami/mysql/tags/
## param image.registry [default: REGISTRY_NAME] MySQL image registry
## param image.repository [default: REPOSITORY_NAME/mysql] MySQL image repository
## skip image.tag MySQL image tag (immutable tags are recommended)
## param image.digest MySQL image digest in the way sha256:aa.... Please note this parameter, if set, will override the tag
## param image.pullPolicy MySQL image pull policy
## param image.pullSecrets Specify docker-registry secret names as an array
## param image.debug Specify if debug logs should be enabled
##
image:registry: docker.iorepository: bitnami/mysqltag: 8.4.3-debian-12-r0digest: ## Specify a imagePullPolicy## ref: https://kubernetes.io/docs/concepts/containers/images/#pre-pulled-images##pullPolicy: IfNotPresent## Optionally specify an array of imagePullSecrets (secrets must be manually created in the namespace)## ref: https://kubernetes.io/docs/tasks/configure-pod-container/pull-image-private-registry/## Example:## pullSecrets:## - myRegistryKeySecretName##pullSecrets: []## Set to true if you would like to see extra information on logs## It turns BASH and/or NAMI debugging in the image##debug: false
## param architecture MySQL architecture (standalone or replication)
##
architecture: replication #这里指定replication
## MySQL Authentication parameters
##
auth:## param auth.rootPassword Password for the root user. Ignored if existing secret is provided## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#setting-the-root-password-on-first-run##rootPassword: ## param auth.createDatabase Whether to create the .Values.auth.database or not## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#creating-a-database-on-first-run##createDatabase: true## param auth.database Name for a custom database to create## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#creating-a-database-on-first-run##database: my_database## param auth.username Name for a custom user to create## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#creating-a-database-user-on-first-run##username: ## param auth.password Password for the new user. Ignored if existing secret is provided##password: ## param auth.replicationUser MySQL replication user## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#setting-up-a-replication-cluster##replicationUser: replicator## param auth.replicationPassword MySQL replication user password. Ignored if existing secret is provided##replicationPassword: ## param auth.existingSecret Use existing secret for password details. The secret has to contain the keys mysql-root-password, mysql-replication-password and mysql-password## NOTE: When its set the auth.rootPassword, auth.password, auth.replicationPassword are ignored.##existingSecret: mysql-secret #这里修改为自己创建的secret如果不修改这里就指定上面的rootPassword属性## param auth.usePasswordFiles Mount credentials as files instead of using an environment variable##usePasswordFiles: false## param auth.customPasswordFiles Use custom password files when auth.usePasswordFiles is set to true. Define path for keys root and user, also define replicator if architecture is set to replication## Example:## customPasswordFiles:## root: /vault/secrets/mysql-root## user: /vault/secrets/mysql-user## replicator: /vault/secrets/mysql-replicator##customPasswordFiles: {}## param auth.authenticationPolicy Sets the authentication policy, by default it will use * ,,## ref: https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html#sysvar_authentication_policy##authenticationPolicy:
## param initdbScripts Dictionary of initdb scripts
## Specify dictionary of scripts to be run at first boot
## Example:
## initdbScripts:
## my_init_script.sh: |
## #!/bin/bash
## echo Do something.
##
initdbScripts: {}
## param initdbScriptsConfigMap ConfigMap with the initdb scripts (Note: Overrides initdbScripts)
##
initdbScriptsConfigMap:
## param startdbScripts Dictionary of startdb scripts
## Specify dictionary of scripts to be run every time the container is started
## Example:
## startdbScripts:
## my_start_script.sh: |
## #!/bin/bash
## echo Do something.
##
startdbScripts: {}
## param startdbScriptsConfigMap ConfigMap with the startdb scripts (Note: Overrides startdbScripts)
##
startdbScriptsConfigMap:
## section MySQL Primary parameters
##
primary:## param primary.name Name of the primary database (eg primary, master, leader, ...)##name: master## param primary.command Override default container command on MySQL Primary container(s) (useful when using custom images)##command: []## param primary.args Override default container args on MySQL Primary container(s) (useful when using custom images)##args: []## param primary.lifecycleHooks for the MySQL Primary container(s) to automate configuration before or after startup##lifecycleHooks: {}## param primary.automountServiceAccountToken Mount Service Account token in pod##automountServiceAccountToken: false## param primary.hostAliases Deployment pod host aliases## https://kubernetes.io/docs/concepts/services-networking/add-entries-to-pod-etc-hosts-with-host-aliases/##hostAliases: []## param primary.enableMySQLX Enable mysqlx port## ref: https://dev.mysql.com/doc/dev/mysql-server/latest/mysqlx_protocol_xplugin.html##enableMySQLX: false## param primary.configuration [string] Configure MySQL Primary with a custom my.cnf file## ref: https://mysql.com/kb/en/mysql/configuring-mysql-with-mycnf/#example-of-configuration-file##configuration: |-[mysqld]authentication_policy{{- .Values.auth.authenticationPolicy | default * ,, }}skip-name-resolveexplicit_defaults_for_timestampbasedir/opt/bitnami/mysqlplugin_dir/opt/bitnami/mysql/lib/pluginport{{ .Values.primary.containerPorts.mysql }}mysqlx{{ ternary 1 0 .Values.primary.enableMySQLX }}mysqlx_port{{ .Values.primary.containerPorts.mysqlx }}socket/opt/bitnami/mysql/tmp/mysql.sockdatadir/bitnami/mysql/datatmpdir/opt/bitnami/mysql/tmpmax_allowed_packet16Mbind-address*pid-file/opt/bitnami/mysql/tmp/mysqld.pidlog-error/opt/bitnami/mysql/logs/mysqld.logcharacter-set-serverUTF8slow_query_log0long_query_time10.0[client]port{{ .Values.primary.containerPorts.mysql }}socket/opt/bitnami/mysql/tmp/mysql.sockdefault-character-setUTF8plugin_dir/opt/bitnami/mysql/lib/plugin[manager]port{{ .Values.primary.containerPorts.mysql }}socket/opt/bitnami/mysql/tmp/mysql.sockpid-file/opt/bitnami/mysql/tmp/mysqld.pid## param primary.existingConfigmap Name of existing ConfigMap with MySQL Primary configuration.## NOTE: When its set the configuration parameter is ignored##existingConfigmap: ## param primary.containerPorts.mysql Container port for mysql## param primary.containerPorts.mysqlx Container port for mysqlx##containerPorts:mysql: 3306mysqlx: 33060## param primary.updateStrategy.type Update strategy type for the MySQL primary statefulset## ref: https://kubernetes.io/docs/concepts/workloads/controllers/statefulset/#update-strategies##updateStrategy:type: RollingUpdate## param primary.podAnnotations Additional pod annotations for MySQL primary pods## ref: https://kubernetes.io/docs/concepts/overview/working-with-objects/annotations/##podAnnotations: {}## param primary.podAffinityPreset MySQL primary pod affinity preset. Ignored if primary.affinity is set. Allowed values: soft or hard## ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/#inter-pod-affinity-and-anti-affinity##podAffinityPreset: ## param primary.podAntiAffinityPreset MySQL primary pod anti-affinity preset. Ignored if primary.affinity is set. Allowed values: soft or hard## ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/#inter-pod-affinity-and-anti-affinity##podAntiAffinityPreset: soft## MySQL Primary node affinity preset## ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/#node-affinity##nodeAffinityPreset:## param primary.nodeAffinityPreset.type MySQL primary node affinity preset type. Ignored if primary.affinity is set. Allowed values: soft or hard##type: ## param primary.nodeAffinityPreset.key MySQL primary node label key to match Ignored if primary.affinity is set.## E.g.## key: kubernetes.io/e2e-az-name##key: ## param primary.nodeAffinityPreset.values MySQL primary node label values to match. Ignored if primary.affinity is set.## E.g.## values:## - e2e-az1## - e2e-az2##values: []## param primary.affinity Affinity for MySQL primary pods assignment## ref: https://kubernetes.io/docs/concepts/configuration/assign-pod-node/#affinity-and-anti-affinity## Note: podAffinityPreset, podAntiAffinityPreset, and nodeAffinityPreset will be ignored when its set##affinity: {}## param primary.nodeSelector Node labels for MySQL primary pods assignment## ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/##nodeSelector: {}## param primary.tolerations Tolerations for MySQL primary pods assignment## ref: https://kubernetes.io/docs/concepts/configuration/taint-and-toleration/##tolerations: []## param primary.priorityClassName MySQL primary pods priorityClassName##priorityClassName: ## param primary.runtimeClassName MySQL primary pods runtimeClassName##runtimeClassName: ## param primary.schedulerName Name of the k8s scheduler (other than default)## ref: https://kubernetes.io/docs/tasks/administer-cluster/configure-multiple-schedulers/##schedulerName: ## param primary.terminationGracePeriodSeconds In seconds, time the given to the MySQL primary pod needs to terminate gracefully## ref: https://kubernetes.io/docs/concepts/workloads/pods/pod/#termination-of-pods##terminationGracePeriodSeconds: ## param primary.topologySpreadConstraints Topology Spread Constraints for pod assignment## https://kubernetes.io/docs/concepts/workloads/pods/pod-topology-spread-constraints/## The value is evaluated as a template##topologySpreadConstraints: []## param primary.podManagementPolicy podManagementPolicy to manage scaling operation of MySQL primary pods## ref: https://kubernetes.io/docs/concepts/workloads/controllers/statefulset/#pod-management-policies##podManagementPolicy: ## MySQL primary Pod security context## ref: https://kubernetes.io/docs/tasks/configure-pod-container/security-context/#set-the-security-context-for-a-pod## param primary.podSecurityContext.enabled Enable security context for MySQL primary pods## param primary.podSecurityContext.fsGroupChangePolicy Set filesystem group change policy## param primary.podSecurityContext.sysctls Set kernel settings using the sysctl interface## param primary.podSecurityContext.supplementalGroups Set filesystem extra groups## param primary.podSecurityContext.fsGroup Group ID for the mounted volumes filesystem##podSecurityContext:enabled: truefsGroupChangePolicy: Alwayssysctls: []supplementalGroups: []fsGroup: 1001## MySQL primary container security context## ref: https://kubernetes.io/docs/tasks/configure-pod-container/security-context/#set-the-security-context-for-a-container## param primary.containerSecurityContext.enabled MySQL primary container securityContext## param primary.containerSecurityContext.seLinuxOptions [object,nullable] Set SELinux options in container## param primary.containerSecurityContext.runAsUser User ID for the MySQL primary container## param primary.containerSecurityContext.runAsGroup Group ID for the MySQL primary container## param primary.containerSecurityContext.runAsNonRoot Set MySQL primary containers Security Context runAsNonRoot## param primary.containerSecurityContext.allowPrivilegeEscalation Set containers privilege escalation## param primary.containerSecurityContext.capabilities.drop Set containers Security Context runAsNonRoot## param primary.containerSecurityContext.seccompProfile.type Set Client containers Security Context seccomp profile## param primary.containerSecurityContext.readOnlyRootFilesystem Set containers Security Context read-only root filesystem##containerSecurityContext:enabled: trueseLinuxOptions: {}runAsUser: 1001runAsGroup: 1001runAsNonRoot: trueallowPrivilegeEscalation: falsecapabilities:drop: [ALL]seccompProfile:type: RuntimeDefaultreadOnlyRootFilesystem: true## MySQL primary containers resource requests and limits## ref: https://kubernetes.io/docs/concepts/configuration/manage-compute-resources-container/## We usually recommend not to specify default resources and to leave this as a conscious## choice for the user. This also increases chances charts run on environments with little## resources, such as Minikube. If you do want to specify resources, uncomment the following## lines, adjust them as necessary, and remove the curly braces after resources:.## param primary.resourcesPreset Set container resources according to one common preset (allowed values: none, nano, micro, small, medium, large, xlarge, 2xlarge). This is ignored if primary.resources is set (primary.resources is recommended for production).## More information: https://github.com/bitnami/charts/blob/main/bitnami/common/templates/_resources.tpl#L15##resourcesPreset: small## param primary.resources Set container requests and limits for different resources like CPU or memory (essential for production workloads)## Example:## resources:## requests:## cpu: 2## memory: 512Mi## limits:## cpu: 3## memory: 1024Mi##resources: {}## Configure extra options for liveness probe## ref: https://kubernetes.io/docs/tasks/configure-pod-container/configure-liveness-readiness-probes/#configure-probes## param primary.livenessProbe.enabled Enable livenessProbe## param primary.livenessProbe.initialDelaySeconds Initial delay seconds for livenessProbe## param primary.livenessProbe.periodSeconds Period seconds for livenessProbe## param primary.livenessProbe.timeoutSeconds Timeout seconds for livenessProbe## param primary.livenessProbe.failureThreshold Failure threshold for livenessProbe## param primary.livenessProbe.successThreshold Success threshold for livenessProbe##livenessProbe:enabled: trueinitialDelaySeconds: 5periodSeconds: 10timeoutSeconds: 1failureThreshold: 3successThreshold: 1## Configure extra options for readiness probe## ref: https://kubernetes.io/docs/tasks/configure-pod-container/configure-liveness-readiness-probes/#configure-probes## param primary.readinessProbe.enabled Enable readinessProbe## param primary.readinessProbe.initialDelaySeconds Initial delay seconds for readinessProbe## param primary.readinessProbe.periodSeconds Period seconds for readinessProbe## param primary.readinessProbe.timeoutSeconds Timeout seconds for readinessProbe## param primary.readinessProbe.failureThreshold Failure threshold for readinessProbe## param primary.readinessProbe.successThreshold Success threshold for readinessProbe##readinessProbe:enabled: trueinitialDelaySeconds: 5periodSeconds: 10timeoutSeconds: 1failureThreshold: 3successThreshold: 1## Configure extra options for startupProbe probe## ref: https://kubernetes.io/docs/tasks/configure-pod-container/configure-liveness-readiness-probes/#configure-probes## param primary.startupProbe.enabled Enable startupProbe## param primary.startupProbe.initialDelaySeconds Initial delay seconds for startupProbe## param primary.startupProbe.periodSeconds Period seconds for startupProbe## param primary.startupProbe.timeoutSeconds Timeout seconds for startupProbe## param primary.startupProbe.failureThreshold Failure threshold for startupProbe## param primary.startupProbe.successThreshold Success threshold for startupProbe##startupProbe:enabled: trueinitialDelaySeconds: 15periodSeconds: 10timeoutSeconds: 1failureThreshold: 10successThreshold: 1## param primary.customLivenessProbe Override default liveness probe for MySQL primary containers##customLivenessProbe: {}## param primary.customReadinessProbe Override default readiness probe for MySQL primary containers##customReadinessProbe: {}## param primary.customStartupProbe Override default startup probe for MySQL primary containers##customStartupProbe: {}## param primary.extraFlags MySQL primary additional command line flags## Can be used to specify command line flags, for example:## E.g.## extraFlags: --max-connect-errors1000 --max_connections155##extraFlags: ## param primary.extraEnvVars Extra environment variables to be set on MySQL primary containers## E.g.## extraEnvVars:## - name: TZ## value: Europe/Paris##extraEnvVars: []## param primary.extraEnvVarsCM Name of existing ConfigMap containing extra env vars for MySQL primary containers##extraEnvVarsCM: ## param primary.extraEnvVarsSecret Name of existing Secret containing extra env vars for MySQL primary containers##extraEnvVarsSecret: ## param primary.extraPodSpec Optionally specify extra PodSpec for the MySQL Primary pod(s)##extraPodSpec: {}## param primary.extraPorts Extra ports to expose##extraPorts: []## Enable persistence using Persistent Volume Claims## ref: https://kubernetes.io/docs/concepts/storage/persistent-volumes/##persistence:## param primary.persistence.enabled Enable persistence on MySQL primary replicas using a PersistentVolumeClaim. If false, use emptyDir##enabled: true## param primary.persistence.existingClaim Name of an existing PersistentVolumeClaim for MySQL primary replicas## NOTE: When its set the rest of persistence parameters are ignored##existingClaim: ## param primary.persistence.subPath The name of a volumes sub path to mount for persistence##subPath: ## param primary.persistence.storageClass MySQL primary persistent volume storage Class## If defined, storageClassName: storageClass## If set to -, storageClassName: , which disables dynamic provisioning## If undefined (the default) or set to null, no storageClassName spec is## set, choosing the default provisioner. (gp2 on AWS, standard on## GKE, AWS OpenStack)##storageClass: manager-nfs-storage #这里修改自己的sc## param primary.persistence.annotations MySQL primary persistent volume claim annotations##annotations: {}## param primary.persistence.accessModes MySQL primary persistent volume access Modes##accessModes:- ReadWriteOnce## param primary.persistence.size MySQL primary persistent volume size##size: 1Gi #根据实际情况调整大小## param primary.persistence.selector Selector to match an existing Persistent Volume## selector:## matchLabels:## app: my-app##selector: {}## Primary Persistent Volume Claim Retention Policy## ref: https://kubernetes.io/docs/concepts/workloads/controllers/statefulset/#persistentvolumeclaim-retention##persistentVolumeClaimRetentionPolicy:## param primary.persistentVolumeClaimRetentionPolicy.enabled Enable Persistent volume retention policy for Primary StatefulSet##enabled: false## param primary.persistentVolumeClaimRetentionPolicy.whenScaled Volume retention behavior when the replica count of the StatefulSet is reduced##whenScaled: Retain## param primary.persistentVolumeClaimRetentionPolicy.whenDeleted Volume retention behavior that applies when the StatefulSet is deleted##whenDeleted: Retain## param primary.extraVolumes Optionally specify extra list of additional volumes to the MySQL Primary pod(s)##extraVolumes: []## param primary.extraVolumeMounts Optionally specify extra list of additional volumeMounts for the MySQL Primary container(s)##extraVolumeMounts: []## param primary.initContainers Add additional init containers for the MySQL Primary pod(s)##initContainers: []## param primary.sidecars Add additional sidecar containers for the MySQL Primary pod(s)##sidecars: []## MySQL Primary Service parameters##service:## param primary.service.type MySQL Primary K8s service type##type: NodePort #修改为nodeport,方便外部访问## param primary.service.ports.mysql MySQL Primary K8s service port## param primary.service.ports.mysqlx MySQL Primary K8s service mysqlx port##ports:mysql: 3306mysqlx: 33060## param primary.service.nodePorts.mysql MySQL Primary K8s service node port## param primary.service.nodePorts.mysqlx MySQL Primary K8s service node port mysqlx## ref: https://kubernetes.io/docs/concepts/services-networking/service/#type-nodeport##nodePorts:mysql: mysqlx: ## param primary.service.clusterIP MySQL Primary K8s service clusterIP IP## e.g:## clusterIP: None##clusterIP: ## param primary.service.loadBalancerIP MySQL Primary loadBalancerIP if service type is LoadBalancer## Set the LoadBalancer service type to internal only## ref: https://kubernetes.io/docs/concepts/services-networking/service/#internal-load-balancer##loadBalancerIP: ## param primary.service.externalTrafficPolicy Enable client source IP preservation## ref https://kubernetes.io/docs/tasks/access-application-cluster/create-external-load-balancer/#preserving-the-client-source-ip##externalTrafficPolicy: Cluster## param primary.service.loadBalancerSourceRanges Addresses that are allowed when MySQL Primary service is LoadBalancer## https://kubernetes.io/docs/tasks/access-application-cluster/configure-cloud-provider-firewall/#restrict-access-for-loadbalancer-service## E.g.## loadBalancerSourceRanges:## - 10.10.10.0/24##loadBalancerSourceRanges: []## param primary.service.extraPorts Extra ports to expose (normally used with the sidecar value)##extraPorts: []## param primary.service.annotations Additional custom annotations for MySQL primary service##annotations: {}## param primary.service.sessionAffinity Session Affinity for Kubernetes service, can be None or ClientIP## If ClientIP, consecutive client requests will be directed to the same Pod## ref: https://kubernetes.io/docs/concepts/services-networking/service/#virtual-ips-and-service-proxies##sessionAffinity: None## param primary.service.sessionAffinityConfig Additional settings for the sessionAffinity## sessionAffinityConfig:## clientIP:## timeoutSeconds: 300##sessionAffinityConfig: {}## Headless service properties##headless:## param primary.service.headless.annotations Additional custom annotations for headless MySQL primary service.##annotations: {}## MySQL primary Pod Disruption Budget configuration## ref: https://kubernetes.io/docs/tasks/run-application/configure-pdb/##pdb:## param primary.pdb.create Enable/disable a Pod Disruption Budget creation for MySQL primary pods##create: true## param primary.pdb.minAvailable Minimum number/percentage of MySQL primary pods that should remain scheduled##minAvailable: ## param primary.pdb.maxUnavailable Maximum number/percentage of MySQL primary pods that may be made unavailable. Defaults to 1 if both primary.pdb.minAvailable and primary.pdb.maxUnavailable are empty.##maxUnavailable: ## param primary.podLabels MySQL Primary pod label. If labels are same as commonLabels , this will take precedence##podLabels: {}
## section MySQL Secondary parameters
##
secondary:## param secondary.name Name of the secondary database (eg secondary, slave, ...)##name: slave #指定name## param secondary.replicaCount Number of MySQL secondary replicas##replicaCount: 1 #副本数量## param secondary.automountServiceAccountToken Mount Service Account token in pod##automountServiceAccountToken: false## param secondary.hostAliases Deployment pod host aliases## https://kubernetes.io/docs/concepts/services-networking/add-entries-to-pod-etc-hosts-with-host-aliases/##hostAliases: []## param secondary.command Override default container command on MySQL Secondary container(s) (useful when using custom images)##command: []## param secondary.args Override default container args on MySQL Secondary container(s) (useful when using custom images)##args: []## param secondary.lifecycleHooks for the MySQL Secondary container(s) to automate configuration before or after startup##lifecycleHooks: {}## param secondary.enableMySQLX Enable mysqlx port## ref: https://dev.mysql.com/doc/dev/mysql-server/latest/mysqlx_protocol_xplugin.html##enableMySQLX: false## param secondary.configuration [string] Configure MySQL Secondary with a custom my.cnf file## ref: https://mysql.com/kb/en/mysql/configuring-mysql-with-mycnf/#example-of-configuration-file##configuration: |-[mysqld]authentication_policy{{- .Values.auth.authenticationPolicy | default * ,, }}skip-name-resolveexplicit_defaults_for_timestampbasedir/opt/bitnami/mysqlplugin_dir/opt/bitnami/mysql/lib/pluginport{{ .Values.secondary.containerPorts.mysql }}mysqlx{{ ternary 1 0 .Values.secondary.enableMySQLX }}mysqlx_port{{ .Values.secondary.containerPorts.mysqlx }}socket/opt/bitnami/mysql/tmp/mysql.sockdatadir/bitnami/mysql/datatmpdir/opt/bitnami/mysql/tmpmax_allowed_packet16Mbind-address*pid-file/opt/bitnami/mysql/tmp/mysqld.pidlog-error/opt/bitnami/mysql/logs/mysqld.logcharacter-set-serverUTF8slow_query_log0long_query_time10.0[client]port{{ .Values.secondary.containerPorts.mysql }}socket/opt/bitnami/mysql/tmp/mysql.sockdefault-character-setUTF8plugin_dir/opt/bitnami/mysql/lib/plugin[manager]port{{ .Values.secondary.containerPorts.mysql }}socket/opt/bitnami/mysql/tmp/mysql.sockpid-file/opt/bitnami/mysql/tmp/mysqld.pid## param secondary.existingConfigmap Name of existing ConfigMap with MySQL Secondary configuration.## NOTE: When its set the configuration parameter is ignored##existingConfigmap: ## param secondary.containerPorts.mysql Container port for mysql## param secondary.containerPorts.mysqlx Container port for mysqlx##containerPorts:mysql: 3306mysqlx: 33060## param secondary.updateStrategy.type Update strategy type for the MySQL secondary statefulset## ref: https://kubernetes.io/docs/concepts/workloads/controllers/statefulset/#update-strategies##updateStrategy:type: RollingUpdate## param secondary.podAnnotations Additional pod annotations for MySQL secondary pods## ref: https://kubernetes.io/docs/concepts/overview/working-with-objects/annotations/##podAnnotations: {}## param secondary.podAffinityPreset MySQL secondary pod affinity preset. Ignored if secondary.affinity is set. Allowed values: soft or hard## ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/#inter-pod-affinity-and-anti-affinity##podAffinityPreset: ## param secondary.podAntiAffinityPreset MySQL secondary pod anti-affinity preset. Ignored if secondary.affinity is set. Allowed values: soft or hard## ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/#inter-pod-affinity-and-anti-affinity## Allowed values: soft, hard##podAntiAffinityPreset: soft## MySQL Secondary node affinity preset## ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/#node-affinity##nodeAffinityPreset:## param secondary.nodeAffinityPreset.type MySQL secondary node affinity preset type. Ignored if secondary.affinity is set. Allowed values: soft or hard##type: ## param secondary.nodeAffinityPreset.key MySQL secondary node label key to match Ignored if secondary.affinity is set.## E.g.## key: kubernetes.io/e2e-az-name##key: ## param secondary.nodeAffinityPreset.values MySQL secondary node label values to match. Ignored if secondary.affinity is set.## E.g.## values:## - e2e-az1## - e2e-az2##values: []## param secondary.affinity Affinity for MySQL secondary pods assignment## ref: https://kubernetes.io/docs/concepts/configuration/assign-pod-node/#affinity-and-anti-affinity## Note: podAffinityPreset, podAntiAffinityPreset, and nodeAffinityPreset will be ignored when its set##affinity: {}## param secondary.nodeSelector Node labels for MySQL secondary pods assignment## ref: https://kubernetes.io/docs/concepts/scheduling-eviction/assign-pod-node/##nodeSelector: {}## param secondary.tolerations Tolerations for MySQL secondary pods assignment## ref: https://kubernetes.io/docs/concepts/configuration/taint-and-toleration/##tolerations: []## param secondary.priorityClassName MySQL secondary pods priorityClassName##priorityClassName: ## param secondary.runtimeClassName MySQL secondary pods runtimeClassName##runtimeClassName: ## param secondary.schedulerName Name of the k8s scheduler (other than default)## ref: https://kubernetes.io/docs/tasks/administer-cluster/configure-multiple-schedulers/##schedulerName: ## param secondary.terminationGracePeriodSeconds In seconds, time the given to the MySQL secondary pod needs to terminate gracefully## ref: https://kubernetes.io/docs/concepts/workloads/pods/pod/#termination-of-pods##terminationGracePeriodSeconds: ## param secondary.topologySpreadConstraints Topology Spread Constraints for pod assignment## https://kubernetes.io/docs/concepts/workloads/pods/pod-topology-spread-constraints/## The value is evaluated as a template##topologySpreadConstraints: []## param secondary.podManagementPolicy podManagementPolicy to manage scaling operation of MySQL secondary pods## ref: https://kubernetes.io/docs/concepts/workloads/controllers/statefulset/#pod-management-policies##podManagementPolicy: ## MySQL secondary Pod security context## ref: https://kubernetes.io/docs/tasks/configure-pod-container/security-context/#set-the-security-context-for-a-pod## param secondary.podSecurityContext.enabled Enable security context for MySQL secondary pods## param secondary.podSecurityContext.fsGroupChangePolicy Set filesystem group change policy## param secondary.podSecurityContext.sysctls Set kernel settings using the sysctl interface## param secondary.podSecurityContext.supplementalGroups Set filesystem extra groups## param secondary.podSecurityContext.fsGroup Group ID for the mounted volumes filesystem##podSecurityContext:enabled: truefsGroupChangePolicy: Alwayssysctls: []supplementalGroups: []fsGroup: 1001## MySQL secondary container security context## ref: https://kubernetes.io/docs/tasks/configure-pod-container/security-context/#set-the-security-context-for-a-container## param secondary.containerSecurityContext.enabled MySQL secondary container securityContext## param secondary.containerSecurityContext.seLinuxOptions [object,nullable] Set SELinux options in container## param secondary.containerSecurityContext.runAsUser User ID for the MySQL secondary container## param secondary.containerSecurityContext.runAsGroup Group ID for the MySQL secondary container## param secondary.containerSecurityContext.runAsNonRoot Set MySQL secondary containers Security Context runAsNonRoot## param secondary.containerSecurityContext.allowPrivilegeEscalation Set containers privilege escalation## param secondary.containerSecurityContext.capabilities.drop Set containers Security Context runAsNonRoot## param secondary.containerSecurityContext.seccompProfile.type Set containers Security Context seccomp profile## param secondary.containerSecurityContext.readOnlyRootFilesystem Set containers Security Context read-only root filesystem##containerSecurityContext:enabled: trueseLinuxOptions: {}runAsUser: 1001runAsGroup: 1001runAsNonRoot: trueallowPrivilegeEscalation: falsecapabilities:drop: [ALL]seccompProfile:type: RuntimeDefaultreadOnlyRootFilesystem: true## MySQL secondary containers resource requests and limits## ref: https://kubernetes.io/docs/concepts/configuration/manage-compute-resources-container/## We usually recommend not to specify default resources and to leave this as a conscious## choice for the user. This also increases chances charts run on environments with little## resources, such as Minikube. If you do want to specify resources, uncomment the following## lines, adjust them as necessary, and remove the curly braces after resources:.## param secondary.resourcesPreset Set container resources according to one common preset (allowed values: none, nano, micro, small, medium, large, xlarge, 2xlarge). This is ignored if secondary.resources is set (secondary.resources is recommended for production).## More information: https://github.com/bitnami/charts/blob/main/bitnami/common/templates/_resources.tpl#L15##resourcesPreset: small## param secondary.resources Set container requests and limits for different resources like CPU or memory (essential for production workloads)## Example:## resources:## requests:## cpu: 2## memory: 512Mi## limits:## cpu: 3## memory: 1024Mi##resources: {}## Configure extra options for liveness probe## ref: https://kubernetes.io/docs/tasks/configure-pod-container/configure-liveness-readiness-probes/#configure-probes## param secondary.livenessProbe.enabled Enable livenessProbe## param secondary.livenessProbe.initialDelaySeconds Initial delay seconds for livenessProbe## param secondary.livenessProbe.periodSeconds Period seconds for livenessProbe## param secondary.livenessProbe.timeoutSeconds Timeout seconds for livenessProbe## param secondary.livenessProbe.failureThreshold Failure threshold for livenessProbe## param secondary.livenessProbe.successThreshold Success threshold for livenessProbe##livenessProbe:enabled: trueinitialDelaySeconds: 5periodSeconds: 10timeoutSeconds: 1failureThreshold: 3successThreshold: 1## Configure extra options for readiness probe## ref: https://kubernetes.io/docs/tasks/configure-pod-container/configure-liveness-readiness-probes/#configure-probes## param secondary.readinessProbe.enabled Enable readinessProbe## param secondary.readinessProbe.initialDelaySeconds Initial delay seconds for readinessProbe## param secondary.readinessProbe.periodSeconds Period seconds for readinessProbe## param secondary.readinessProbe.timeoutSeconds Timeout seconds for readinessProbe## param secondary.readinessProbe.failureThreshold Failure threshold for readinessProbe## param secondary.readinessProbe.successThreshold Success threshold for readinessProbe##readinessProbe:enabled: trueinitialDelaySeconds: 5periodSeconds: 10timeoutSeconds: 1failureThreshold: 3successThreshold: 1## Configure extra options for startupProbe probe## ref: https://kubernetes.io/docs/tasks/configure-pod-container/configure-liveness-readiness-probes/#configure-probes## param secondary.startupProbe.enabled Enable startupProbe## param secondary.startupProbe.initialDelaySeconds Initial delay seconds for startupProbe## param secondary.startupProbe.periodSeconds Period seconds for startupProbe## param secondary.startupProbe.timeoutSeconds Timeout seconds for startupProbe## param secondary.startupProbe.failureThreshold Failure threshold for startupProbe## param secondary.startupProbe.successThreshold Success threshold for startupProbe##startupProbe:enabled: trueinitialDelaySeconds: 15periodSeconds: 10timeoutSeconds: 1failureThreshold: 15successThreshold: 1## param secondary.customLivenessProbe Override default liveness probe for MySQL secondary containers##customLivenessProbe: {}## param secondary.customReadinessProbe Override default readiness probe for MySQL secondary containers##customReadinessProbe: {}## param secondary.customStartupProbe Override default startup probe for MySQL secondary containers##customStartupProbe: {}## param secondary.extraFlags MySQL secondary additional command line flags## Can be used to specify command line flags, for example:## E.g.## extraFlags: --max-connect-errors1000 --max_connections155##extraFlags: ## param secondary.extraEnvVars An array to add extra environment variables on MySQL secondary containers## E.g.## extraEnvVars:## - name: TZ## value: Europe/Paris##extraEnvVars: []## param secondary.extraEnvVarsCM Name of existing ConfigMap containing extra env vars for MySQL secondary containers##extraEnvVarsCM: ## param secondary.extraEnvVarsSecret Name of existing Secret containing extra env vars for MySQL secondary containers##extraEnvVarsSecret: ## param secondary.extraPodSpec Optionally specify extra PodSpec for the MySQL Secondary pod(s)##extraPodSpec: {}## param secondary.extraPorts Extra ports to expose##extraPorts: []## Enable persistence using Persistent Volume Claims## ref: https://kubernetes.io/docs/concepts/storage/persistent-volumes/##persistence:## param secondary.persistence.enabled Enable persistence on MySQL secondary replicas using a PersistentVolumeClaim##enabled: true## param secondary.persistence.existingClaim Name of an existing PersistentVolumeClaim for MySQL secondary replicas## NOTE: When its set the rest of persistence parameters are ignored##existingClaim: ## param secondary.persistence.subPath The name of a volumes sub path to mount for persistence##subPath: ## param secondary.persistence.storageClass MySQL secondary persistent volume storage Class## If defined, storageClassName: storageClass## If set to -, storageClassName: , which disables dynamic provisioning## If undefined (the default) or set to null, no storageClassName spec is## set, choosing the default provisioner. (gp2 on AWS, standard on## GKE, AWS OpenStack)##storageClass: manager-nfs-storage #修改为自己的sc## param secondary.persistence.annotations MySQL secondary persistent volume claim annotations##annotations: {}## param secondary.persistence.accessModes MySQL secondary persistent volume access Modes##accessModes:- ReadWriteOnce## param secondary.persistence.size MySQL secondary persistent volume size##size: 1Gi #根据实际情况修改我这里做测试写的比较小## param secondary.persistence.selector Selector to match an existing Persistent Volume## selector:## matchLabels:## app: my-app##selector: {}## Secondary Persistent Volume Claim Retention Policy## ref: https://kubernetes.io/docs/concepts/workloads/controllers/statefulset/#persistentvolumeclaim-retention##persistentVolumeClaimRetentionPolicy:## param secondary.persistentVolumeClaimRetentionPolicy.enabled Enable Persistent volume retention policy for read only StatefulSet##enabled: false## param secondary.persistentVolumeClaimRetentionPolicy.whenScaled Volume retention behavior when the replica count of the StatefulSet is reduced##whenScaled: Retain## param secondary.persistentVolumeClaimRetentionPolicy.whenDeleted Volume retention behavior that applies when the StatefulSet is deleted##whenDeleted: Retain## param secondary.extraVolumes Optionally specify extra list of additional volumes to the MySQL secondary pod(s)##extraVolumes: []## param secondary.extraVolumeMounts Optionally specify extra list of additional volumeMounts for the MySQL secondary container(s)##extraVolumeMounts: []## param secondary.initContainers Add additional init containers for the MySQL secondary pod(s)##initContainers: []## param secondary.sidecars Add additional sidecar containers for the MySQL secondary pod(s)##sidecars: []## MySQL Secondary Service parameters##service:## param secondary.service.type MySQL secondary Kubernetes service type##type: NodePort## param secondary.service.ports.mysql MySQL secondary Kubernetes service port## param secondary.service.ports.mysqlx MySQL secondary Kubernetes service port mysqlx##ports:mysql: 3306mysqlx: 33060## param secondary.service.nodePorts.mysql MySQL secondary Kubernetes service node port## param secondary.service.nodePorts.mysqlx MySQL secondary Kubernetes service node port mysqlx## ref: https://kubernetes.io/docs/concepts/services-networking/service/#type-nodeport##nodePorts:mysql: mysqlx: ## param secondary.service.clusterIP MySQL secondary Kubernetes service clusterIP IP## e.g:## clusterIP: None##clusterIP: ## param secondary.service.loadBalancerIP MySQL secondary loadBalancerIP if service type is LoadBalancer## Set the LoadBalancer service type to internal only## ref: https://kubernetes.io/docs/concepts/services-networking/service/#internal-load-balancer##loadBalancerIP: ## param secondary.service.externalTrafficPolicy Enable client source IP preservation## ref https://kubernetes.io/docs/tasks/access-application-cluster/create-external-load-balancer/#preserving-the-client-source-ip##externalTrafficPolicy: Cluster## param secondary.service.loadBalancerSourceRanges Addresses that are allowed when MySQL secondary service is LoadBalancer## https://kubernetes.io/docs/tasks/access-application-cluster/configure-cloud-provider-firewall/#restrict-access-for-loadbalancer-service## E.g.## loadBalancerSourceRanges:## - 10.10.10.0/24##loadBalancerSourceRanges: []## param secondary.service.extraPorts Extra ports to expose (normally used with the sidecar value)##extraPorts: []## param secondary.service.annotations Additional custom annotations for MySQL secondary service##annotations: {}## param secondary.service.sessionAffinity Session Affinity for Kubernetes service, can be None or ClientIP## If ClientIP, consecutive client requests will be directed to the same Pod## ref: https://kubernetes.io/docs/concepts/services-networking/service/#virtual-ips-and-service-proxies##sessionAffinity: None## param secondary.service.sessionAffinityConfig Additional settings for the sessionAffinity## sessionAffinityConfig:## clientIP:## timeoutSeconds: 300##sessionAffinityConfig: {}## Headless service properties##headless:## param secondary.service.headless.annotations Additional custom annotations for headless MySQL secondary service.##annotations: {}## MySQL secondary Pod Disruption Budget configuration## ref: https://kubernetes.io/docs/tasks/run-application/configure-pdb/##pdb:## param secondary.pdb.create Enable/disable a Pod Disruption Budget creation for MySQL secondary pods##create: true## param secondary.pdb.minAvailable Minimum number/percentage of MySQL secondary pods that should remain scheduled##minAvailable: ## param secondary.pdb.maxUnavailable Maximum number/percentage of MySQL secondary pods that may be made unavailable. Defaults to 1 if both secondary.pdb.minAvailable and secondary.pdb.maxUnavailable are empty.##maxUnavailable: ## param secondary.podLabels Additional pod labels for MySQL secondary pods##podLabels: {}
## section RBAC parameters
#### MySQL pods ServiceAccount
## ref: https://kubernetes.io/docs/tasks/configure-pod-container/configure-service-account/
##
serviceAccount:## param serviceAccount.create Enable the creation of a ServiceAccount for MySQL pods##create: true## param serviceAccount.name Name of the created ServiceAccount## If not set and create is true, a name is generated using the mysql.fullname template##name: ## param serviceAccount.annotations Annotations for MySQL Service Account##annotations: {}## param serviceAccount.automountServiceAccountToken Automount service account token for the server service account##automountServiceAccountToken: false
## Role Based Access
## ref: https://kubernetes.io/docs/admin/authorization/rbac/
##
rbac:## param rbac.create Whether to create use RBAC resources or not##create: false## param rbac.rules Custom RBAC rules to set## e.g:## rules:## - apiGroups:## - ## resources:## - pods## verbs:## - get## - list##rules: []
## section Network Policy
#### Network Policy configuration
## ref: https://kubernetes.io/docs/concepts/services-networking/network-policies/
##
networkPolicy:## param networkPolicy.enabled Enable creation of NetworkPolicy resources##enabled: true## param networkPolicy.allowExternal The Policy model to apply## When set to false, only pods with the correct client label will have network access to the ports MySQL is## listening on. When true, MySQL will accept connections from any source (with the correct destination port).##allowExternal: true## param networkPolicy.allowExternalEgress Allow the pod to access any range of port and all destinations.##allowExternalEgress: true## param networkPolicy.extraIngress [array] Add extra ingress rules to the NetworkPolicy## e.g:## extraIngress:## - ports:## - port: 1234## from:## - podSelector:## - matchLabels:## - role: frontend## - podSelector:## - matchExpressions:## - key: role## operator: In## values:## - frontend##extraIngress: []## param networkPolicy.extraEgress [array] Add extra ingress rules to the NetworkPolicy## e.g:## extraEgress:## - ports:## - port: 1234## to:## - podSelector:## - matchLabels:## - role: frontend## - podSelector:## - matchExpressions:## - key: role## operator: In## values:## - frontend##extraEgress: []## param networkPolicy.ingressNSMatchLabels [object] Labels to match to allow traffic from other namespaces## param networkPolicy.ingressNSPodMatchLabels [object] Pod labels to match to allow traffic from other namespaces##ingressNSMatchLabels: {}ingressNSPodMatchLabels: {}## section Password update job
##
passwordUpdateJob:## param passwordUpdateJob.enabled Enable password update job##enabled: false## param passwordUpdateJob.backoffLimit set backoff limit of the job##backoffLimit: 10## param passwordUpdateJob.command Override default container command on mysql Primary container(s) (useful when using custom images)##command: []## param passwordUpdateJob.args Override default container args on mysql Primary container(s) (useful when using custom images)##args: []## param passwordUpdateJob.extraCommands Extra commands to pass to the generation job##extraCommands: ## param passwordUpdateJob.previousPasswords.rootPassword Previous root password (set if the password secret was already changed)## param passwordUpdateJob.previousPasswords.password Previous password (set if the password secret was already changed)## param passwordUpdateJob.previousPasswords.replicationPassword Previous replication password (set if the password secret was already changed)## param passwordUpdateJob.previousPasswords.existingSecret Name of a secret containing the previous passwords (set if the password secret was already changed)previousPasswords:rootPassword: password: replicationPassword: existingSecret: ## Configure Container Security Context## ref: https://kubernetes.io/docs/tasks/configure-pod-container/security-context/#set-the-security-context-for-a-container## param passwordUpdateJob.containerSecurityContext.enabled Enabled containers Security Context## param passwordUpdateJob.containerSecurityContext.seLinuxOptions [object,nullable] Set SELinux options in container## param passwordUpdateJob.containerSecurityContext.runAsUser Set containers Security Context runAsUser## param passwordUpdateJob.containerSecurityContext.runAsGroup Set containers Security Context runAsGroup## param passwordUpdateJob.containerSecurityContext.runAsNonRoot Set containers Security Context runAsNonRoot## param passwordUpdateJob.containerSecurityContext.privileged Set containers Security Context privileged## param passwordUpdateJob.containerSecurityContext.readOnlyRootFilesystem Set containers Security Context readOnlyRootFilesystem## param passwordUpdateJob.containerSecurityContext.allowPrivilegeEscalation Set containers Security Context allowPrivilegeEscalation## param passwordUpdateJob.containerSecurityContext.capabilities.drop List of capabilities to be dropped## param passwordUpdateJob.containerSecurityContext.seccompProfile.type Set containers Security Context seccomp profile##containerSecurityContext:enabled: trueseLinuxOptions: {}runAsUser: 1001runAsGroup: 1001runAsNonRoot: trueprivileged: falsereadOnlyRootFilesystem: trueallowPrivilegeEscalation: falsecapabilities:drop: [ALL]seccompProfile:type: RuntimeDefault## Configure Pods Security Context## ref: https://kubernetes.io/docs/tasks/configure-pod-container/security-context/#set-the-security-context-for-a-pod## param passwordUpdateJob.podSecurityContext.enabled Enabled credential init job pods Security Context## param passwordUpdateJob.podSecurityContext.fsGroupChangePolicy Set filesystem group change policy## param passwordUpdateJob.podSecurityContext.sysctls Set kernel settings using the sysctl interface## param passwordUpdateJob.podSecurityContext.supplementalGroups Set filesystem extra groups## param passwordUpdateJob.podSecurityContext.fsGroup Set credential init job pods Security Context fsGroup##podSecurityContext:enabled: truefsGroupChangePolicy: Alwayssysctls: []supplementalGroups: []fsGroup: 1001## param passwordUpdateJob.extraEnvVars Array containing extra env vars to configure the credential init job## For example:## extraEnvVars:## - name: GF_DEFAULT_INSTANCE_NAME## value: my-instance##extraEnvVars: []## param passwordUpdateJob.extraEnvVarsCM ConfigMap containing extra env vars to configure the credential init job##extraEnvVarsCM: ## param passwordUpdateJob.extraEnvVarsSecret Secret containing extra env vars to configure the credential init job (in case of sensitive data)##extraEnvVarsSecret: ## param passwordUpdateJob.extraVolumes Optionally specify extra list of additional volumes for the credential init job##extraVolumes: []## param passwordUpdateJob.extraVolumeMounts Array of extra volume mounts to be added to the jwt Container (evaluated as template). Normally used with extraVolumes.##extraVolumeMounts: []## param passwordUpdateJob.initContainers Add additional init containers for the mysql Primary pod(s)##initContainers: []## Container resource requests and limits## ref: https://kubernetes.io/docs/concepts/configuration/manage-compute-resources-container/## param passwordUpdateJob.resourcesPreset Set container resources according to one common preset (allowed values: none, nano, micro, small, medium, large, xlarge, 2xlarge). This is ignored if passwordUpdateJob.resources is set (passwordUpdateJob.resources is recommended for production).## More information: https://github.com/bitnami/charts/blob/main/bitnami/common/templates/_resources.tpl#L15##resourcesPreset: micro## param passwordUpdateJob.resources Set container requests and limits for different resources like CPU or memory (essential for production workloads)## Example:## resources:## requests:## cpu: 2## memory: 512Mi## limits:## cpu: 3## memory: 1024Mi##resources: {}## param passwordUpdateJob.customLivenessProbe Custom livenessProbe that overrides the default one##customLivenessProbe: {}## param passwordUpdateJob.customReadinessProbe Custom readinessProbe that overrides the default one##customReadinessProbe: {}## param passwordUpdateJob.customStartupProbe Custom startupProbe that overrides the default one##customStartupProbe: {}## param passwordUpdateJob.automountServiceAccountToken Mount Service Account token in pod##automountServiceAccountToken: false## param passwordUpdateJob.hostAliases Add deployment host aliases## https://kubernetes.io/docs/concepts/services-networking/add-entries-to-pod-etc-hosts-with-host-aliases/##hostAliases: []## param passwordUpdateJob.annotations [object] Add annotations to the job##annotations: {}## param passwordUpdateJob.podLabels Additional pod labels## Ref: https://kubernetes.io/docs/concepts/overview/working-with-objects/labels/##podLabels: {}## param passwordUpdateJob.podAnnotations Additional pod annotations## ref: https://kubernetes.io/docs/concepts/overview/working-with-objects/annotations/##podAnnotations: {}## section Volume Permissions parameters
#### Init containers parameters:
## volumePermissions: Change the owner and group of the persistent volume mountpoint to runAsUser:fsGroup values from the securityContext section.
##
volumePermissions:## param volumePermissions.enabled Enable init container that changes the owner and group of the persistent volume(s) mountpoint to runAsUser:fsGroup##enabled: false## param volumePermissions.image.registry [default: REGISTRY_NAME] Init container volume-permissions image registry## param volumePermissions.image.repository [default: REPOSITORY_NAME/os-shell] Init container volume-permissions image repository## skip volumePermissions.image.tag Init container volume-permissions image tag (immutable tags are recommended)## param volumePermissions.image.digest Init container volume-permissions image digest in the way sha256:aa.... Please note this parameter, if set, will override the tag## param volumePermissions.image.pullPolicy Init container volume-permissions image pull policy## param volumePermissions.image.pullSecrets Specify docker-registry secret names as an array##image:registry: docker.iorepository: bitnami/os-shelltag: 12-debian-12-r31digest: pullPolicy: IfNotPresent## Optionally specify an array of imagePullSecrets.## Secrets must be manually created in the namespace.## ref: https://kubernetes.io/docs/tasks/configure-pod-container/pull-image-private-registry/## e.g:## pullSecrets:## - myRegistryKeySecretName##pullSecrets: []## param volumePermissions.resourcesPreset Set container resources according to one common preset (allowed values: none, nano, micro, small, medium, large, xlarge, 2xlarge). This is ignored if volumePermissions.resources is set (volumePermissions.resources is recommended for production).## More information: https://github.com/bitnami/charts/blob/main/bitnami/common/templates/_resources.tpl#L15##resourcesPreset: nano## param volumePermissions.resources Set container requests and limits for different resources like CPU or memory (essential for production workloads)## Example:## resources:## requests:## cpu: 2## memory: 512Mi## limits:## cpu: 3## memory: 1024Mi##resources: {}
## section Metrics parameters
#### Mysqld Prometheus exporter parameters
##
metrics:## param metrics.enabled Start a side-car prometheus exporter##enabled: false## param metrics.image.registry [default: REGISTRY_NAME] Exporter image registry## param metrics.image.repository [default: REPOSITORY_NAME/mysqld-exporter] Exporter image repository## skip metrics.image.tag Exporter image tag (immutable tags are recommended)## param metrics.image.digest Exporter image digest in the way sha256:aa.... Please note this parameter, if set, will override the tag## param metrics.image.pullPolicy Exporter image pull policy## param metrics.image.pullSecrets Specify docker-registry secret names as an array##image:registry: docker.iorepository: bitnami/mysqld-exportertag: 0.15.1-debian-12-r35digest: pullPolicy: IfNotPresent## Optionally specify an array of imagePullSecrets.## Secrets must be manually created in the namespace.## ref: https://kubernetes.io/docs/tasks/configure-pod-container/pull-image-private-registry/## e.g:## pullSecrets:## - myRegistryKeySecretName##pullSecrets: []## MySQL metrics container security context## ref: https://kubernetes.io/docs/tasks/configure-pod-container/security-context/#set-the-security-context-for-a-container## param metrics.containerSecurityContext.enabled MySQL metrics container securityContext## param metrics.containerSecurityContext.seLinuxOptions [object,nullable] Set SELinux options in container## param metrics.containerSecurityContext.runAsUser User ID for the MySQL metrics container## param metrics.containerSecurityContext.runAsGroup Group ID for the MySQL metrics container## param metrics.containerSecurityContext.runAsNonRoot Set MySQL metrics containers Security Context runAsNonRoot## param metrics.containerSecurityContext.allowPrivilegeEscalation Set containers privilege escalation## param metrics.containerSecurityContext.capabilities.drop Set containers Security Context runAsNonRoot## param metrics.containerSecurityContext.seccompProfile.type Set containers Security Context seccomp profile## param metrics.containerSecurityContext.readOnlyRootFilesystem Set containers Security Context read-only root filesystem##containerSecurityContext:enabled: trueseLinuxOptions: {}runAsUser: 1001runAsGroup: 1001runAsNonRoot: trueallowPrivilegeEscalation: falsecapabilities:drop: [ALL]seccompProfile:type: RuntimeDefaultreadOnlyRootFilesystem: true## param metrics.containerPorts.http Container port for http##containerPorts:http: 9104## MySQL Prometheus exporter service parameters## Mysqld Prometheus exporter liveness and readiness probes## ref: https://kubernetes.io/docs/concepts/workloads/pods/pod-lifecycle/#container-probes## param metrics.service.type Kubernetes service type for MySQL Prometheus Exporter## param metrics.service.clusterIP Kubernetes service clusterIP for MySQL Prometheus Exporter## param metrics.service.port MySQL Prometheus Exporter service port## param metrics.service.annotations [object] Prometheus exporter service annotations##service:type: ClusterIPport: 9104clusterIP: annotations:prometheus.io/scrape: trueprometheus.io/port: {{ .Values.metrics.service.port }}## param metrics.extraArgs.primary Extra args to be passed to mysqld_exporter on Primary pods## param metrics.extraArgs.secondary Extra args to be passed to mysqld_exporter on Secondary pods## ref: https://github.com/prometheus/mysqld_exporter/## E.g.## - --collect.auto_increment.columns## - --collect.binlog_size## - --collect.engine_innodb_status## - --collect.engine_tokudb_status## - --collect.global_status## - --collect.global_variables## - --collect.info_schema.clientstats## - --collect.info_schema.innodb_metrics## - --collect.info_schema.innodb_tablespaces## - --collect.info_schema.innodb_cmp## - --collect.info_schema.innodb_cmpmem## - --collect.info_schema.processlist## - --collect.info_schema.processlist.min_time## - --collect.info_schema.query_response_time## - --collect.info_schema.tables## - --collect.info_schema.tables.databases## - --collect.info_schema.tablestats## - --collect.info_schema.userstats## - --collect.perf_schema.eventsstatements## - --collect.perf_schema.eventsstatements.digest_text_limit## - --collect.perf_schema.eventsstatements.limit## - --collect.perf_schema.eventsstatements.timelimit## - --collect.perf_schema.eventswaits## - --collect.perf_schema.file_events## - --collect.perf_schema.file_instances## - --collect.perf_schema.indexiowaits## - --collect.perf_schema.tableiowaits## - --collect.perf_schema.tablelocks## - --collect.perf_schema.replication_group_member_stats## - --collect.slave_status## - --collect.slave_hosts## - --collect.heartbeat## - --collect.heartbeat.database## - --collect.heartbeat.table##extraArgs:primary: []secondary: []## Mysqld Prometheus exporter resource requests and limits## ref: https://kubernetes.io/docs/concepts/configuration/manage-compute-resources-container/## We usually recommend not to specify default resources and to leave this as a conscious## choice for the user. This also increases chances charts run on environments with little## resources, such as Minikube. If you do want to specify resources, uncomment the following## lines, adjust them as necessary, and remove the curly braces after resources:.## param metrics.resourcesPreset Set container resources according to one common preset (allowed values: none, nano, micro, small, medium, large, xlarge, 2xlarge). This is ignored if metrics.resources is set (metrics.resources is recommended for production).## More information: https://github.com/bitnami/charts/blob/main/bitnami/common/templates/_resources.tpl#L15##resourcesPreset: nano## param metrics.resources Set container requests and limits for different resources like CPU or memory (essential for production workloads)## Example:## resources:## requests:## cpu: 2## memory: 512Mi## limits:## cpu: 3## memory: 1024Mi##resources: {}## Mysqld Prometheus exporter liveness probe## ref: https://kubernetes.io/docs/concepts/workloads/pods/pod-lifecycle/#container-probes## param metrics.livenessProbe.enabled Enable livenessProbe## param metrics.livenessProbe.initialDelaySeconds Initial delay seconds for livenessProbe## param metrics.livenessProbe.periodSeconds Period seconds for livenessProbe## param metrics.livenessProbe.timeoutSeconds Timeout seconds for livenessProbe## param metrics.livenessProbe.failureThreshold Failure threshold for livenessProbe## param metrics.livenessProbe.successThreshold Success threshold for livenessProbe##livenessProbe:enabled: trueinitialDelaySeconds: 120periodSeconds: 10timeoutSeconds: 1successThreshold: 1failureThreshold: 3## Mysqld Prometheus exporter readiness probe## ref: https://kubernetes.io/docs/concepts/workloads/pods/pod-lifecycle/#container-probes## param metrics.readinessProbe.enabled Enable readinessProbe## param metrics.readinessProbe.initialDelaySeconds Initial delay seconds for readinessProbe## param metrics.readinessProbe.periodSeconds Period seconds for readinessProbe## param metrics.readinessProbe.timeoutSeconds Timeout seconds for readinessProbe## param metrics.readinessProbe.failureThreshold Failure threshold for readinessProbe## param metrics.readinessProbe.successThreshold Success threshold for readinessProbe##readinessProbe:enabled: trueinitialDelaySeconds: 30periodSeconds: 10timeoutSeconds: 1successThreshold: 1failureThreshold: 3## Prometheus Service Monitor## ref: https://github.com/coreos/prometheus-operator##serviceMonitor:## param metrics.serviceMonitor.enabled Create ServiceMonitor Resource for scraping metrics using PrometheusOperator##enabled: false## param metrics.serviceMonitor.namespace Specify the namespace in which the serviceMonitor resource will be created##namespace: ## param metrics.serviceMonitor.jobLabel The name of the label on the target service to use as the job name in prometheus.##jobLabel: ## param metrics.serviceMonitor.interval Specify the interval at which metrics should be scraped##interval: 30s## param metrics.serviceMonitor.scrapeTimeout Specify the timeout after which the scrape is ended## e.g:## scrapeTimeout: 30s##scrapeTimeout: ## param metrics.serviceMonitor.relabelings RelabelConfigs to apply to samples before scraping## ref: https://github.com/coreos/prometheus-operator/blob/master/Documentation/api.md#relabelconfig##relabelings: []## param metrics.serviceMonitor.metricRelabelings MetricRelabelConfigs to apply to samples before ingestion## ref: https://github.com/coreos/prometheus-operator/blob/master/Documentation/api.md#relabelconfig##metricRelabelings: []## param metrics.serviceMonitor.selector ServiceMonitor selector labels## ref: https://github.com/bitnami/charts/tree/main/bitnami/prometheus-operator#prometheus-configuration#### selector:## prometheus: my-prometheus##selector: {}## param metrics.serviceMonitor.honorLabels Specify honorLabels parameter to add the scrape endpoint##honorLabels: false## param metrics.serviceMonitor.labels Used to pass Labels that are used by the Prometheus installed in your cluster to select Service Monitors to work with## ref: https://github.com/coreos/prometheus-operator/blob/master/Documentation/api.md#prometheusspec##labels: {}## param metrics.serviceMonitor.annotations ServiceMonitor annotations##annotations: {}## Prometheus Operator prometheusRule configuration##prometheusRule:## param metrics.prometheusRule.enabled Creates a Prometheus Operator prometheusRule (also requires metrics.enabled to be true and metrics.prometheusRule.rules)##enabled: false #这里普罗修斯监控我没开启## param metrics.prometheusRule.namespace Namespace for the prometheusRule Resource (defaults to the Release Namespace)##namespace: ## param metrics.prometheusRule.additionalLabels Additional labels that can be used so prometheusRule will be discovered by Prometheus##additionalLabels: {}## param metrics.prometheusRule.rules Prometheus Rule definitions## - alert: Mysql-Down## expr: absent(up{jobmysql} 1)## for: 5m## labels:## severity: warning## service: mysql## annotations:## message: mysql instance {{{{}} $labels.instance {{}}}} is down## summary: mysql instance is down##rules: []3、创建mysql-secret
apiVersion: v1
kind: Secret
metadata:name: mysql-secretnamespace: mysql8labels:app: mysql
type: Opaque
data:password: MTIzNDU2 # echo -n 123456mysql-root-password: MTIzNDU2mysql-replication-password: MTIzNDU24、安装
#创建ns
kubectl create ns mysql8
#创建secretkubectl create -f mysql-secret.yaml#安装mysql8helm install mysql ./mysql -n mysql8 #查看资源kubectl get all -n mysql8