316 lines
9.4 KiB
YAML
316 lines
9.4 KiB
YAML
---
|
|
apiVersion: apps/v1
|
|
kind: StatefulSet
|
|
metadata:
|
|
labels:
|
|
app.kubernetes.io/component: primary
|
|
app.kubernetes.io/managed-by: octopus
|
|
app.kubernetes.io/name: mysql-db
|
|
app.kubernetes.io/release: bj-sh-uas-260511
|
|
cmii.app: mysql
|
|
cmii.type: middleware
|
|
octopus.control: mysql-db-wdd
|
|
name: helm-mysql
|
|
namespace: bj-sh-uas-260511
|
|
spec:
|
|
persistentVolumeClaimRetentionPolicy:
|
|
whenDeleted: Retain
|
|
whenScaled: Retain
|
|
podManagementPolicy: OrderedReady
|
|
replicas: 1
|
|
revisionHistoryLimit: 10
|
|
selector:
|
|
matchLabels:
|
|
app.kubernetes.io/component: primary
|
|
app.kubernetes.io/name: mysql-db
|
|
app.kubernetes.io/release: bj-sh-uas-260511
|
|
cmii.app: mysql
|
|
cmii.type: middleware
|
|
serviceName: helm-mysql
|
|
template:
|
|
metadata:
|
|
annotations:
|
|
checksum/configuration: 6b60fa0f3a846a6ada8effdc4f823cf8003d42a8c8f630fe8b1b66d3454082dd
|
|
creationTimestamp: null
|
|
labels:
|
|
app.kubernetes.io/component: primary
|
|
app.kubernetes.io/managed-by: octopus
|
|
app.kubernetes.io/name: mysql-db
|
|
app.kubernetes.io/release: bj-sh-uas-260511
|
|
cmii.app: mysql
|
|
cmii.type: middleware
|
|
octopus.control: mysql-db-wdd
|
|
spec:
|
|
affinity: {}
|
|
containers:
|
|
- env:
|
|
- name: BITNAMI_DEBUG
|
|
value: "true"
|
|
- name: MYSQL_ROOT_PASSWORD
|
|
valueFrom:
|
|
secretKeyRef:
|
|
key: mysql-root-password
|
|
name: helm-mysql
|
|
- name: MYSQL_DATABASE
|
|
value: cmii
|
|
image: 192.168.3.31:8088/cmii/mysql:8.1.0-debian-11-r42
|
|
imagePullPolicy: IfNotPresent
|
|
livenessProbe:
|
|
exec:
|
|
command:
|
|
- /bin/bash
|
|
- -ec
|
|
- |
|
|
password_aux="${MYSQL_ROOT_PASSWORD:-}"
|
|
if [[ -f "${MYSQL_ROOT_PASSWORD_FILE:-}" ]]; then
|
|
password_aux=$(cat "$MYSQL_ROOT_PASSWORD_FILE")
|
|
fi
|
|
mysqladmin status -uroot -p"${password_aux}"
|
|
failureThreshold: 5
|
|
initialDelaySeconds: 120
|
|
periodSeconds: 10
|
|
successThreshold: 1
|
|
timeoutSeconds: 3
|
|
name: mysql
|
|
ports:
|
|
- containerPort: 3306
|
|
name: mysql
|
|
protocol: TCP
|
|
readinessProbe:
|
|
exec:
|
|
command:
|
|
- /bin/bash
|
|
- -ec
|
|
- |
|
|
password_aux="${MYSQL_ROOT_PASSWORD:-}"
|
|
if [[ -f "${MYSQL_ROOT_PASSWORD_FILE:-}" ]]; then
|
|
password_aux=$(cat "$MYSQL_ROOT_PASSWORD_FILE")
|
|
fi
|
|
mysqladmin status -uroot -p"${password_aux}"
|
|
failureThreshold: 5
|
|
initialDelaySeconds: 30
|
|
periodSeconds: 10
|
|
successThreshold: 1
|
|
timeoutSeconds: 3
|
|
resources: {}
|
|
securityContext:
|
|
runAsUser: 1001
|
|
startupProbe:
|
|
exec:
|
|
command:
|
|
- /bin/bash
|
|
- -ec
|
|
- |
|
|
password_aux="${MYSQL_ROOT_PASSWORD:-}"
|
|
if [[ -f "${MYSQL_ROOT_PASSWORD_FILE:-}" ]]; then
|
|
password_aux=$(cat "$MYSQL_ROOT_PASSWORD_FILE")
|
|
fi
|
|
mysqladmin status -uroot -p"${password_aux}"
|
|
failureThreshold: 60
|
|
initialDelaySeconds: 120
|
|
periodSeconds: 10
|
|
successThreshold: 1
|
|
timeoutSeconds: 1
|
|
terminationMessagePath: /dev/termination-log
|
|
terminationMessagePolicy: File
|
|
volumeMounts:
|
|
- mountPath: /bitnami/mysql
|
|
name: mysql-data
|
|
- mountPath: /docker-entrypoint-initdb.d
|
|
name: custom-init-scripts
|
|
- mountPath: /opt/bitnami/mysql/conf/my.cnf
|
|
name: config
|
|
subPath: my.cnf
|
|
dnsPolicy: ClusterFirst
|
|
imagePullSecrets:
|
|
- name: harborsecret
|
|
initContainers:
|
|
- command:
|
|
- /bin/bash
|
|
- -ec
|
|
- |
|
|
chown -R 1001:1001 /bitnami/mysql
|
|
image: 192.168.3.31:8088/cmii/bitnami-shell:11-debian-11-r136
|
|
imagePullPolicy: Always
|
|
name: change-volume-permissions
|
|
resources: {}
|
|
securityContext:
|
|
runAsUser: 0
|
|
terminationMessagePath: /dev/termination-log
|
|
terminationMessagePolicy: File
|
|
volumeMounts:
|
|
- mountPath: /bitnami/mysql
|
|
name: mysql-data
|
|
nodeSelector:
|
|
mysql-deploy: "true"
|
|
restartPolicy: Always
|
|
schedulerName: default-scheduler
|
|
securityContext:
|
|
fsGroup: 1001
|
|
serviceAccount: helm-mysql
|
|
serviceAccountName: helm-mysql
|
|
terminationGracePeriodSeconds: 30
|
|
volumes:
|
|
- configMap:
|
|
defaultMode: 420
|
|
name: helm-mysql
|
|
name: config
|
|
- configMap:
|
|
defaultMode: 420
|
|
name: helm-mysql-init-scripts
|
|
name: custom-init-scripts
|
|
- hostPath:
|
|
path: /var/lib/docker/mysql-pv/bj-sh-uas-260511/
|
|
type: ""
|
|
name: mysql-data
|
|
updateStrategy:
|
|
type: RollingUpdate
|
|
---
|
|
apiVersion: v1
|
|
kind: Service
|
|
metadata:
|
|
labels:
|
|
app.kubernetes.io/component: primary
|
|
app.kubernetes.io/managed-by: octopus
|
|
app.kubernetes.io/name: mysql-db
|
|
app.kubernetes.io/release: bj-sh-uas-260511
|
|
cmii.app: mysql
|
|
cmii.type: middleware
|
|
octopus.control: mysql-db-wdd
|
|
name: helm-mysql
|
|
namespace: bj-sh-uas-260511
|
|
spec:
|
|
ports:
|
|
- name: mysql
|
|
nodePort: 33306
|
|
port: 3306
|
|
protocol: TCP
|
|
targetPort: mysql
|
|
selector:
|
|
app.kubernetes.io/component: primary
|
|
app.kubernetes.io/name: mysql-db
|
|
app.kubernetes.io/release: bj-sh-uas-260511
|
|
cmii.app: mysql
|
|
cmii.type: middleware
|
|
sessionAffinity: None
|
|
type: NodePort
|
|
---
|
|
apiVersion: v1
|
|
data:
|
|
my.cnf: |2-
|
|
[mysqld]
|
|
port=3306
|
|
basedir=/opt/bitnami/mysql
|
|
datadir=/bitnami/mysql/data
|
|
pid-file=/opt/bitnami/mysql/tmp/mysqld.pid
|
|
socket=/opt/bitnami/mysql/tmp/mysql.sock
|
|
log-error=/bitnami/mysql/data/error.log
|
|
general_log_file = /bitnami/mysql/data/general.log
|
|
slow_query_log_file = /bitnami/mysql/data/slow.log
|
|
innodb_data_file_path = ibdata1:512M:autoextend
|
|
innodb_buffer_pool_size = 512M
|
|
innodb_buffer_pool_instances = 2
|
|
innodb_log_file_size = 512M
|
|
innodb_log_files_in_group = 4
|
|
innodb_log_files_in_group = 4
|
|
log-bin = /bitnami/mysql/data/mysql-bin
|
|
max_binlog_size=1G
|
|
transaction_isolation = REPEATABLE-READ
|
|
default_storage_engine = innodb
|
|
character-set-server = utf8mb4
|
|
collation-server=utf8mb4_bin
|
|
binlog_format = ROW
|
|
binlog_rows_query_log_events=on
|
|
binlog_cache_size=4M
|
|
binlog_expire_logs_seconds = 1296000
|
|
max_binlog_cache_size=2G
|
|
gtid_mode = on
|
|
enforce_gtid_consistency = 1
|
|
sync_binlog = 1
|
|
innodb_flush_log_at_trx_commit = 1
|
|
innodb_flush_method = O_DIRECT
|
|
log_slave_updates=1
|
|
relay_log_recovery = 1
|
|
relay-log-purge = 1
|
|
default_time_zone = '+08:00'
|
|
lower_case_table_names=1
|
|
log_bin_trust_function_creators=1
|
|
group_concat_max_len=67108864
|
|
innodb_io_capacity = 4000
|
|
innodb_io_capacity_max = 8000
|
|
innodb_flush_sync = 0
|
|
innodb_flush_neighbors = 0
|
|
innodb_write_io_threads = 8
|
|
innodb_read_io_threads = 8
|
|
innodb_purge_threads = 4
|
|
innodb_page_cleaners = 4
|
|
innodb_open_files = 65535
|
|
innodb_max_dirty_pages_pct = 50
|
|
innodb_lru_scan_depth = 4000
|
|
innodb_checksum_algorithm = crc32
|
|
innodb_lock_wait_timeout = 10
|
|
innodb_rollback_on_timeout = 1
|
|
innodb_print_all_deadlocks = 1
|
|
innodb_file_per_table = 1
|
|
innodb_online_alter_log_max_size = 4G
|
|
innodb_stats_on_metadata = 0
|
|
innodb_thread_concurrency = 0
|
|
innodb_sync_spin_loops = 100
|
|
innodb_spin_wait_delay = 30
|
|
lock_wait_timeout = 3600
|
|
slow_query_log = 1
|
|
long_query_time = 10
|
|
log_queries_not_using_indexes =1
|
|
log_throttle_queries_not_using_indexes = 60
|
|
min_examined_row_limit = 100
|
|
log_slow_admin_statements = 1
|
|
log_slow_slave_statements = 1
|
|
default_authentication_plugin=mysql_native_password
|
|
skip-name-resolve=1
|
|
explicit_defaults_for_timestamp=1
|
|
plugin_dir=/opt/bitnami/mysql/plugin
|
|
max_allowed_packet=128M
|
|
max_connections = 2000
|
|
max_connect_errors = 1000000
|
|
table_definition_cache=2000
|
|
table_open_cache_instances=64
|
|
tablespace_definition_cache=1024
|
|
thread_cache_size=256
|
|
interactive_timeout = 600
|
|
wait_timeout = 600
|
|
tmpdir=/opt/bitnami/mysql/tmp
|
|
max_allowed_packet=32M
|
|
bind-address=0.0.0.0
|
|
performance_schema = 1
|
|
performance_schema_instrument = '%memory%=on'
|
|
performance_schema_instrument = '%lock%=on'
|
|
innodb_monitor_enable=ALL
|
|
|
|
[mysql]
|
|
no-auto-rehash
|
|
|
|
[mysqldump]
|
|
quick
|
|
max_allowed_packet = 32M
|
|
|
|
[client]
|
|
port=3306
|
|
socket=/opt/bitnami/mysql/tmp/mysql.sock
|
|
default-character-set=UTF8
|
|
plugin_dir=/opt/bitnami/mysql/plugin
|
|
|
|
[manager]
|
|
port=3306
|
|
socket=/opt/bitnami/mysql/tmp/mysql.sock
|
|
pid-file=/opt/bitnami/mysql/tmp/mysqld.pid
|
|
kind: ConfigMap
|
|
metadata:
|
|
labels:
|
|
app.kubernetes.io/component: primary
|
|
app.kubernetes.io/managed-by: octopus
|
|
app.kubernetes.io/name: mysql-db
|
|
app.kubernetes.io/release: bj-sh-uas-260511
|
|
octopus.control: mysql-db-wdd
|
|
name: helm-mysql
|
|
namespace: bj-sh-uas-260511
|