source commons files source engines files source kubeblocks files source kubedb files CLUSTER_NAME: `kubectl get namespace | grep ns-wutxk ` `kubectl create namespace ns-wutxk` namespace/ns-wutxk created create namespace ns-wutxk done download kbcli `gh release list --repo apecloud/kbcli --limit 100 | (grep "1.0" || true)` `curl -fsSL https://kubeblocks.io/installer/install_cli.sh | bash -s v1.0.1` Your system is linux_amd64 Installing kbcli ... Downloading ... % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 33.6M 100 33.6M 0 0 62.9M 0 --:--:-- --:--:-- --:--:-- 124M kbcli installed successfully. Kubernetes: v1.32.6 KubeBlocks: 1.0.1 kbcli: 1.0.1 Make sure your docker service is running and begin your journey with kbcli: kbcli playground init For more information on how to get started, please visit: https://kubeblocks.io download kbcli v1.0.1 done Kubernetes: v1.32.6 KubeBlocks: 1.0.1 kbcli: 1.0.1 Kubernetes Env: v1.32.6 check snapshot controller check snapshot controller done POD_RESOURCES: aks kb-default-sc found aks default-vsc found found default storage class: default KubeBlocks version is:1.0.1 skip upgrade KubeBlocks current KubeBlocks version: 1.0.1 Error: no repositories to show helm repo add chaos-mesh https://charts.chaos-mesh.org "chaos-mesh" has been added to your repositories add helm chart repo chaos-mesh success chaos mesh already installed create orchestrator cluster orcm-ysadrs check component definition set component name:orchestrator set orchestrator component definition set orchestrator component definition orchestrator-raft-1.0.1 LIMIT_CPU:0.5 LIMIT_MEMORY:0.5 storage size: 1 CLUSTER_NAME:orcm-ysadrs No resources found in ns-wutxk namespace. pod_info: create 3 replica WipeOut orchestrator cluster check component definition set component definition by component version no component definitions found apiVersion: apps.kubeblocks.io/v1 kind: Cluster metadata: name: orcm-ysadrs namespace: ns-wutxk spec: clusterDef: orchestrator topology: raft terminationPolicy: WipeOut services: - name: orchestrator componentSelector: orchestrator spec: ports: - name: orc-http port: 80 componentSpecs: - name: orchestrator serviceVersion: 3.2.6 replicas: 3 resources: requests: cpu: 500m memory: 0.5Gi limits: cpu: 500m memory: 0.5Gi volumeClaimTemplates: - name: data spec: storageClassName: accessModes: - ReadWriteOnce resources: requests: storage: 1Gi `kubectl apply -f test_create_orcm-ysadrs.yaml` cluster.apps.kubeblocks.io/orcm-ysadrs created apply test_create_orcm-ysadrs.yaml Success `rm -rf test_create_orcm-ysadrs.yaml` check cluster status `kbcli cluster list orcm-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS orcm-ysadrs ns-wutxk orchestrator WipeOut Creating Sep 12,2025 13:05 UTC+0800 clusterdefinition.kubeblocks.io/name=orchestrator cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances orcm-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME orcm-ysadrs-orchestrator-0 ns-wutxk orcm-ysadrs orchestrator Running primary 0 500m / 500m 512Mi / 512Mi data:1Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:05 UTC+0800 orcm-ysadrs-orchestrator-1 ns-wutxk orcm-ysadrs orchestrator Running secondary 0 500m / 500m 512Mi / 512Mi data:1Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:06 UTC+0800 orcm-ysadrs-orchestrator-2 ns-wutxk orcm-ysadrs orchestrator Running secondary 0 500m / 500m 512Mi / 512Mi data:1Gi aks-cicdamdpool-13759654-vmss000000/10.224.0.5 Sep 12,2025 13:07 UTC+0800 check pod status done check cluster connect ` echo 'curl -s http://orcm-ysadrs-orchestrator:80/api/health ' | kubectl exec -it orcm-ysadrs-orchestrator-0 --namespace ns-wutxk -- bash` check cluster connect done `kubectl get secrets -l app.kubernetes.io/instance=orcm-ysadrs` set secret: orcm-ysadrs-orchestrator-account-orchestrator `kubectl get secrets orcm-ysadrs-orchestrator-account-orchestrator -o jsonpath="***.data.username***"` `kubectl get secrets orcm-ysadrs-orchestrator-account-orchestrator -o jsonpath="***.data.password***"` `kubectl get secrets orcm-ysadrs-orchestrator-account-orchestrator -o jsonpath="***.data.port***"` DB_USERNAME:orchestrator;DB_PASSWORD:f8sY9M905x6x64tc;DB_PORT:;DB_DATABASE: check pod orcm-ysadrs-orchestrator-0 container_name orchestrator exist password f8sY9M905x6x64tc check pod orcm-ysadrs-orchestrator-0 container_name kbagent exist password f8sY9M905x6x64tc No container logs contain secret password. check component definition set component name:mysql set component version set component version:mysql set service versions:8.4.2,8.4.1,8.4.0,8.0.39,8.0.38,8.0.37,8.0.36,8.0.35,8.0.34,8.0.33,8.0.32,8.0.31,8.0.30,5.7.44 set service versions sorted:5.7.44,8.0.30,8.0.31,8.0.32,8.0.33,8.0.34,8.0.35,8.0.36,8.0.37,8.0.38,8.0.39,8.4.0,8.4.1,8.4.2 set mysql component definition set mysql component definition REPORT_COUNT 0:0 set replicas first:2,5.7.44|2,8.0.30|2,8.0.31|2,8.0.32|2,8.0.33|2,8.0.34|2,8.0.35|2,8.0.36|2,8.0.37|2,8.0.38|2,8.0.39 set replicas third:2,8.0.38 set replicas fourth:2,8.0.30 set minimum cmpv service version set minimum cmpv service version replicas:2,8.0.30 REPORT_COUNT:1 CLUSTER_TOPOLOGY:orc topology orc found in cluster definition mysql set mysql component definition set mysql component definition LIMIT_CPU:0.5 LIMIT_MEMORY:0.5 storage size: 10 CLUSTER_NAME:mysql-ysadrs No resources found in ns-wutxk namespace. pod_info: termination_policy:DoNotTerminate create 2 replica DoNotTerminate mysql cluster check component definition set component definition by component version check cmpd by labels set component definition1: mysql-8.0-1.0.1 by component version:mysql apiVersion: apps.kubeblocks.io/v1 kind: Cluster metadata: name: mysql-ysadrs namespace: ns-wutxk spec: clusterDef: mysql topology: orc terminationPolicy: DoNotTerminate componentSpecs: - name: mysql serviceVersion: 8.0.30 disableExporter: true replicas: 2 resources: limits: cpu: 500m memory: 0.5Gi requests: cpu: 500m memory: 0.5Gi volumeClaimTemplates: - name: data spec: storageClassName: accessModes: - ReadWriteOnce resources: requests: storage: 10Gi serviceRefs: - name: orchestrator namespace: ns-wutxk clusterServiceSelector: cluster: orcm-ysadrs service: component: orchestrator service: orchestrator port: orc-http credential: component: orchestrator name: orchestrator `kubectl apply -f test_create_mysql-ysadrs.yaml` cluster.apps.kubeblocks.io/mysql-ysadrs created apply test_create_mysql-ysadrs.yaml Success `rm -rf test_create_mysql-ysadrs.yaml` check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Creating Sep 12,2025 13:08 UTC+0800 clusterdefinition.kubeblocks.io/name=mysql cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:08 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:10 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check pod mysql-ysadrs-mysql-0 container_name mysql exist password Efu1819pJ1 check pod mysql-ysadrs-mysql-0 container_name kbagent exist password Efu1819pJ1 check pod mysql-ysadrs-mysql-0 container_name config-manager exist password Efu1819pJ1 No container logs contain secret password. describe cluster `kbcli cluster describe mysql-ysadrs --namespace ns-wutxk ` Name: mysql-ysadrs Created Time: Sep 12,2025 13:08 UTC+0800 NAMESPACE CLUSTER-DEFINITION TOPOLOGY STATUS TERMINATION-POLICY ns-wutxk mysql orc Running DoNotTerminate Endpoints: COMPONENT INTERNAL EXTERNAL mysql mysql-ysadrs-mysql-0.ns-wutxk.svc.cluster.local:3306 mysql-ysadrs-mysql-1.ns-wutxk.svc.cluster.local:3306 mysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local:3306 Topology: COMPONENT SERVICE-VERSION INSTANCE ROLE STATUS AZ NODE CREATED-TIME mysql 8.0.30 mysql-ysadrs-mysql-0 primary Running 0 aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:08 UTC+0800 mysql 8.0.30 mysql-ysadrs-mysql-1 secondary Running 0 aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:10 UTC+0800 Resources Allocation: COMPONENT INSTANCE-TEMPLATE CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE-SIZE STORAGE-CLASS mysql 500m / 500m 512Mi / 512Mi data:10Gi default Images: COMPONENT COMPONENT-DEFINITION IMAGE mysql mysql-orc-8.0-1.0.1 docker.io/apecloud/mysql:8.0.30 docker.io/apecloud/kubeblocks-tools:1.0.1 Data Protection: BACKUP-REPO AUTO-BACKUP BACKUP-SCHEDULE BACKUP-METHOD BACKUP-RETENTION RECOVERABLE-TIME Show cluster events: kbcli cluster list-events -n ns-wutxk mysql-ysadrs `kbcli cluster label mysql-ysadrs app.kubernetes.io/instance- --namespace ns-wutxk ` label "app.kubernetes.io/instance" not found. `kbcli cluster label mysql-ysadrs app.kubernetes.io/instance=mysql-ysadrs --namespace ns-wutxk ` `kbcli cluster label mysql-ysadrs --list --namespace ns-wutxk ` NAME NAMESPACE LABELS mysql-ysadrs ns-wutxk app.kubernetes.io/instance=mysql-ysadrs clusterdefinition.kubeblocks.io/name=mysql label cluster app.kubernetes.io/instance=mysql-ysadrs Success `kbcli cluster label case.name=kbcli.test1 -l app.kubernetes.io/instance=mysql-ysadrs --namespace ns-wutxk ` `kbcli cluster label mysql-ysadrs --list --namespace ns-wutxk ` NAME NAMESPACE LABELS mysql-ysadrs ns-wutxk app.kubernetes.io/instance=mysql-ysadrs case.name=kbcli.test1 clusterdefinition.kubeblocks.io/name=mysql label cluster case.name=kbcli.test1 Success `kbcli cluster label mysql-ysadrs case.name=kbcli.test2 --overwrite --namespace ns-wutxk ` `kbcli cluster label mysql-ysadrs --list --namespace ns-wutxk ` NAME NAMESPACE LABELS mysql-ysadrs ns-wutxk app.kubernetes.io/instance=mysql-ysadrs case.name=kbcli.test2 clusterdefinition.kubeblocks.io/name=mysql label cluster case.name=kbcli.test2 Success `kbcli cluster label mysql-ysadrs case.name- --namespace ns-wutxk ` `kbcli cluster label mysql-ysadrs --list --namespace ns-wutxk ` NAME NAMESPACE LABELS mysql-ysadrs ns-wutxk app.kubernetes.io/instance=mysql-ysadrs clusterdefinition.kubeblocks.io/name=mysql delete cluster label case.name Success cluster connect `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql Defaulted container "mysql" out of: mysql, kbagent, config-manager, init-data (init), init-jq (init), init-kbagent (init), kbagent-worker (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. *************************** 1. row *************************** Slave_IO_State: Waiting for source to send event Master_Host: mysql-ysadrs-mysql-0.mysql-ysadrs-mysql-headless Master_User: root Master_Port: 3306 Connect_Retry: 1 Master_Log_File: mysql-ysadrs-mysql-0-bin.000003 Read_Master_Log_Pos: 3514 Relay_Log_File: relay-bin.000002 Relay_Log_Pos: 3760 Relay_Master_Log_File: mysql-ysadrs-mysql-0-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 3514 Relay_Log_Space: 3964 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_UUID: a304d8b4-8f96-11f0-9954-b6896f7fd594 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: a304d8b4-8f96-11f0-9954-b6896f7fd594:1-10 Executed_Gtid_Set: a304d8b4-8f96-11f0-9954-b6896f7fd594:1-10 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: Master_public_key_path: Get_master_public_key: 1 Network_Namespace: `echo " echo \"show variables like 'max_connections';\" | mysql -h127.0.0.1 -uroot -pEfu1819pJ1 -P3306 " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` Defaulted container "mysql" out of: mysql, kbagent, config-manager, init-data (init), init-jq (init), init-kbagent (init), kbagent-worker (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. Variable_name Value max_connections 83 connect cluster Success set max_connections to 83 insert batch data by db client Error from server (NotFound): pods "test-db-client-executionloop-mysql-ysadrs" not found `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge pods test-db-client-executionloop-mysql-ysadrs --namespace ns-wutxk ` Error from server (NotFound): pods "test-db-client-executionloop-mysql-ysadrs" not found Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): pods "test-db-client-executionloop-mysql-ysadrs" not found `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql apiVersion: v1 kind: Pod metadata: name: test-db-client-executionloop-mysql-ysadrs namespace: ns-wutxk spec: containers: - name: test-dbclient imagePullPolicy: IfNotPresent image: docker.io/apecloud/dbclient:test args: - "--host" - "mysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local" - "--user" - "root" - "--password" - "Efu1819pJ1" - "--port" - "3306" - "--dbtype" - "mysql" - "--test" - "executionloop" - "--duration" - "60" - "--interval" - "1" restartPolicy: Never `kubectl apply -f test-db-client-executionloop-mysql-ysadrs.yaml` pod/test-db-client-executionloop-mysql-ysadrs created apply test-db-client-executionloop-mysql-ysadrs.yaml Success `rm -rf test-db-client-executionloop-mysql-ysadrs.yaml` check pod status pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 6s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 10s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 15s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 20s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 26s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 31s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 36s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 41s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 47s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 52s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 57s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 1/1 Running 0 62s check pod test-db-client-executionloop-mysql-ysadrs status done pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-mysql-ysadrs 0/1 Completed 0 68s check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:08 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:10 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done --host mysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local --user root --password Efu1819pJ1 --port 3306 --dbtype mysql --test executionloop --duration 60 --interval 1 SLF4J(I): Connected with provider of type [ch.qos.logback.classic.spi.LogbackServiceProvider] Execution loop start: create databases executions_loop CREATE DATABASE IF NOT EXISTS executions_loop; drop table executions_loop_table DROP TABLE IF EXISTS executions_loop.executions_loop_table; create table executions_loop_table CREATE TABLE IF NOT EXISTS executions_loop.executions_loop_table (id INT PRIMARY KEY AUTO_INCREMENT, value VARCHAR(255), tinyint_col TINYINT, smallint_col SMALLINT, mediumint_col MEDIUMINT, int_col INT, bigint_col BIGINT, float_col FLOAT, double_col DOUBLE, decimal_col DECIMAL(10, 2), date_col DATE, time_col TIME, datetime_col DATETIME, timestamp_col TIMESTAMP, year_col YEAR, char_col CHAR(10), text_col TEXT, blob_col BLOB, binary_col BINARY(10), varbinary_col VARBINARY(255), enum_col ENUM('Option1', 'Option2', 'Option3'), set_col SET('Value1', 'Value2', 'Value3') ); Execution loop start:INSERT INTO executions_loop.executions_loop_table (value, tinyint_col, smallint_col, mediumint_col, int_col, bigint_col, float_col, double_col, decimal_col, date_col, time_col, datetime_col, timestamp_col, year_col, char_col, text_col, blob_col, binary_col, varbinary_col, enum_col, set_col) VALUES ('executions_loop_test_1', 27, 21054, 8320114, 1401119705, 8749230776303056010, 0.45714402, 0.7752514804414501, 50.08667294663608, '2025-09-12', '05:11:38', '2025-09-12 05:11:38.8', CURRENT_TIMESTAMP, 2034, 'H6WNs41d1p', 'mXzRqa9CMDIWYb3rXoDfkT0eBGpgF9HiCAM2omrEyIhLiCbDYWp7Hc8qexhcosUaPKP8JPG4I8Erdgi7s8JN6WOV07QnafSsdWCsBuZq0tahDaGzJPxyCRhAGmAzDddAL5MJ7N4nYVLGH9KBeJfwNcxrPoQZGuZeFfSjsXXv2BF8w1QofbOfAaMa7tGtAnxQBABM0mE6N9Q3cW1SE5Mcb4Q5wFXEo03GlAURO3prEWeBzQSwcd2en9VXcXbSgk7', UNHEX(REPLACE('2ac479dfb6c3dc665f80', ' ', '')), UNHEX(REPLACE('32db12e8ebaa2065e73b', ' ', '')), UNHEX(REPLACE('16ea8dc120b29a0b0eec528bb9e6ae68c62878679c2e3ffb7efe5918df63ac8440c19c903b4f8056dd02aebfb86c664d2ce84610b9541f9a98a1c171d45a0da93e6049f21a161212353665c7b6121a19a887dcb511f31469eedbe06edb562286cf484bd9a5087f7f832fca0afbc670b441e2b158128c12b74cda932d8e0f87e5e5b9ccaeed6fbde88d3a2286910d156873af041c8ab7dc510dbd91fa89ea571f26a2c908a11cd722e9bb103cc7748078b01d23cc2feb090fa5f6774aee37f0786e626ab199374d8883f769b5b21911efdd3ca0f717d302cd18fa720ce27e83c14b6004954fa2f5e01b272895a73c9b89d138bba1403a85158039dece0ddae3', ' ', '')), 'Option2', 'Value1' ); [ 1s ] executions total: 52 successful: 52 failed: 0 disconnect: 0 [ 2s ] executions total: 109 successful: 109 failed: 0 disconnect: 0 [ 3s ] executions total: 188 successful: 188 failed: 0 disconnect: 0 [ 4s ] executions total: 264 successful: 264 failed: 0 disconnect: 0 [ 5s ] executions total: 338 successful: 338 failed: 0 disconnect: 0 [ 6s ] executions total: 417 successful: 417 failed: 0 disconnect: 0 [ 7s ] executions total: 493 successful: 493 failed: 0 disconnect: 0 [ 8s ] executions total: 570 successful: 570 failed: 0 disconnect: 0 [ 9s ] executions total: 647 successful: 647 failed: 0 disconnect: 0 [ 10s ] executions total: 725 successful: 725 failed: 0 disconnect: 0 [ 11s ] executions total: 772 successful: 772 failed: 0 disconnect: 0 [ 12s ] executions total: 850 successful: 850 failed: 0 disconnect: 0 [ 13s ] executions total: 925 successful: 925 failed: 0 disconnect: 0 [ 14s ] executions total: 1005 successful: 1005 failed: 0 disconnect: 0 [ 15s ] executions total: 1081 successful: 1081 failed: 0 disconnect: 0 [ 16s ] executions total: 1161 successful: 1161 failed: 0 disconnect: 0 [ 17s ] executions total: 1238 successful: 1238 failed: 0 disconnect: 0 [ 18s ] executions total: 1315 successful: 1315 failed: 0 disconnect: 0 [ 19s ] executions total: 1394 successful: 1394 failed: 0 disconnect: 0 [ 20s ] executions total: 1472 successful: 1472 failed: 0 disconnect: 0 [ 21s ] executions total: 1552 successful: 1552 failed: 0 disconnect: 0 [ 22s ] executions total: 1631 successful: 1631 failed: 0 disconnect: 0 [ 23s ] executions total: 1710 successful: 1710 failed: 0 disconnect: 0 [ 24s ] executions total: 1787 successful: 1787 failed: 0 disconnect: 0 [ 25s ] executions total: 1866 successful: 1866 failed: 0 disconnect: 0 [ 26s ] executions total: 1943 successful: 1943 failed: 0 disconnect: 0 [ 27s ] executions total: 2015 successful: 2015 failed: 0 disconnect: 0 [ 28s ] executions total: 2088 successful: 2088 failed: 0 disconnect: 0 [ 29s ] executions total: 2161 successful: 2161 failed: 0 disconnect: 0 [ 30s ] executions total: 2231 successful: 2231 failed: 0 disconnect: 0 [ 31s ] executions total: 2305 successful: 2305 failed: 0 disconnect: 0 [ 32s ] executions total: 2377 successful: 2377 failed: 0 disconnect: 0 [ 33s ] executions total: 2447 successful: 2447 failed: 0 disconnect: 0 [ 34s ] executions total: 2521 successful: 2521 failed: 0 disconnect: 0 [ 35s ] executions total: 2597 successful: 2597 failed: 0 disconnect: 0 [ 36s ] executions total: 2673 successful: 2673 failed: 0 disconnect: 0 [ 37s ] executions total: 2750 successful: 2750 failed: 0 disconnect: 0 [ 38s ] executions total: 2826 successful: 2826 failed: 0 disconnect: 0 [ 39s ] executions total: 2904 successful: 2904 failed: 0 disconnect: 0 [ 40s ] executions total: 2980 successful: 2980 failed: 0 disconnect: 0 [ 41s ] executions total: 3032 successful: 3032 failed: 0 disconnect: 0 [ 42s ] executions total: 3107 successful: 3107 failed: 0 disconnect: 0 [ 43s ] executions total: 3174 successful: 3174 failed: 0 disconnect: 0 [ 44s ] executions total: 3253 successful: 3253 failed: 0 disconnect: 0 [ 45s ] executions total: 3331 successful: 3331 failed: 0 disconnect: 0 [ 46s ] executions total: 3411 successful: 3411 failed: 0 disconnect: 0 [ 47s ] executions total: 3489 successful: 3489 failed: 0 disconnect: 0 [ 48s ] executions total: 3570 successful: 3570 failed: 0 disconnect: 0 [ 49s ] executions total: 3646 successful: 3646 failed: 0 disconnect: 0 [ 50s ] executions total: 3721 successful: 3721 failed: 0 disconnect: 0 [ 51s ] executions total: 3801 successful: 3801 failed: 0 disconnect: 0 [ 52s ] executions total: 3877 successful: 3877 failed: 0 disconnect: 0 [ 53s ] executions total: 3958 successful: 3958 failed: 0 disconnect: 0 [ 54s ] executions total: 4031 successful: 4031 failed: 0 disconnect: 0 [ 55s ] executions total: 4111 successful: 4111 failed: 0 disconnect: 0 [ 56s ] executions total: 4190 successful: 4190 failed: 0 disconnect: 0 [ 57s ] executions total: 4265 successful: 4265 failed: 0 disconnect: 0 [ 58s ] executions total: 4345 successful: 4345 failed: 0 disconnect: 0 [ 59s ] executions total: 4423 successful: 4423 failed: 0 disconnect: 0 [ 60s ] executions total: 4452 successful: 4452 failed: 0 disconnect: 0 Test Result: Total Executions: 4452 Successful Executions: 4452 Failed Executions: 0 Disconnection Counts: 0 Connection Information: Database Type: mysql Host: mysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local Port: 3306 Database: Table: User: root Org: Access Mode: mysql Test Type: executionloop Query: Duration: 60 seconds Interval: 1 seconds DB_CLIENT_BATCH_DATA_COUNT: 4452 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge pods test-db-client-executionloop-mysql-ysadrs --namespace ns-wutxk ` pod/test-db-client-executionloop-mysql-ysadrs patched (no change) Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. pod "test-db-client-executionloop-mysql-ysadrs" force deleted `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql set db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` set db_client batch data Success LB_TYPE is set to: internet cluster expose check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster expose mysql-ysadrs --auto-approve --force=true --type internet --enable true --components mysql --role-selector primary --namespace ns-wutxk ` OpsRequest mysql-ysadrs-expose-d5m4c created successfully, you can view the progress: kbcli cluster describe-ops mysql-ysadrs-expose-d5m4c -n ns-wutxk check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-expose-d5m4c ns-wutxk Expose mysql-ysadrs mysql Running 0/1 Sep 12,2025 13:12 UTC+0800 check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:08 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:10 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-expose-d5m4c ns-wutxk Expose mysql-ysadrs mysql Succeed 1/1 Sep 12,2025 13:12 UTC+0800 check ops status done ops_status:mysql-ysadrs-expose-d5m4c ns-wutxk Expose mysql-ysadrs mysql Succeed 1/1 Sep 12,2025 13:12 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations mysql-ysadrs-expose-d5m4c --namespace ns-wutxk ` opsrequest.operations.kubeblocks.io/mysql-ysadrs-expose-d5m4c patched `kbcli cluster delete-ops --name mysql-ysadrs-expose-d5m4c --force --auto-approve --namespace ns-wutxk ` OpsRequest mysql-ysadrs-expose-d5m4c deleted `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success cluster does not need to check monitor currently check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:08 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:10 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done test failover connectionstress check cluster status before cluster-failover-connectionstress check cluster status done cluster_status:Running Error from server (NotFound): pods "test-db-client-connectionstress-mysql-ysadrs" not found `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge pods test-db-client-connectionstress-mysql-ysadrs --namespace ns-wutxk ` Error from server (NotFound): pods "test-db-client-connectionstress-mysql-ysadrs" not found Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): pods "test-db-client-connectionstress-mysql-ysadrs" not found `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql apiVersion: v1 kind: Pod metadata: name: test-db-client-connectionstress-mysql-ysadrs namespace: ns-wutxk spec: containers: - name: test-dbclient imagePullPolicy: IfNotPresent image: docker.io/apecloud/dbclient:test args: - "--host" - "mysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local" - "--user" - "root" - "--password" - "Efu1819pJ1" - "--port" - "3306" - "--database" - "mysql" - "--dbtype" - "mysql" - "--test" - "connectionstress" - "--connections" - "83" - "--duration" - "60" restartPolicy: Never `kubectl apply -f test-db-client-connectionstress-mysql-ysadrs.yaml` pod/test-db-client-connectionstress-mysql-ysadrs created apply test-db-client-connectionstress-mysql-ysadrs.yaml Success `rm -rf test-db-client-connectionstress-mysql-ysadrs.yaml` check pod status check pod test-db-client-connectionstress-mysql-ysadrs status done pod_status:NAME READY STATUS RESTARTS AGE test-db-client-connectionstress-mysql-ysadrs 0/1 Completed 0 5s check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:08 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:10 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done --host mysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local --user root --password Efu1819pJ1 --port 3306 --database mysql --dbtype mysql --test connectionstress --connections 83 --duration 60 SLF4J(I): Connected with provider of type [ch.qos.logback.classic.spi.LogbackServiceProvider] Test Result: null Connection Information: Database Type: mysql Host: mysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local Port: 3306 Database: mysql Table: User: root Org: Access Mode: mysql Test Type: connectionstress Connection Count: 83 Duration: 60 seconds `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge pods test-db-client-connectionstress-mysql-ysadrs --namespace ns-wutxk ` pod/test-db-client-connectionstress-mysql-ysadrs patched (no change) Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. pod "test-db-client-connectionstress-mysql-ysadrs" force deleted `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql set db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` set db_client batch data Success check failover pod name failover pod name:mysql-ysadrs-mysql-0 failover connectionstress Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success skip cluster HorizontalScaling In cluster configure component_tmp: mysql apiVersion: operations.kubeblocks.io/v1alpha1 kind: OpsRequest metadata: generateName: mysql-ysadrs-reconfiguring- namespace: ns-wutxk spec: type: Reconfiguring clusterName: mysql-ysadrs force: true reconfigures: - componentName: mysql parameters: - key: binlog_expire_logs_seconds value: '691200' check cluster status before ops check cluster status done cluster_status:Running `kubectl create -f test_ops_cluster_mysql-ysadrs.yaml` opsrequest.operations.kubeblocks.io/mysql-ysadrs-reconfiguring-th745 created create test_ops_cluster_mysql-ysadrs.yaml Success `rm -rf test_ops_cluster_mysql-ysadrs.yaml` check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-reconfiguring-th745 ns-wutxk Reconfiguring mysql-ysadrs mysql,mysql Running -/- Sep 12,2025 13:13 UTC+0800 check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:08 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:10 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-reconfiguring-th745 ns-wutxk Reconfiguring mysql-ysadrs mysql,mysql Succeed -/- Sep 12,2025 13:13 UTC+0800 check ops status done ops_status:mysql-ysadrs-reconfiguring-th745 ns-wutxk Reconfiguring mysql-ysadrs mysql,mysql Succeed -/- Sep 12,2025 13:13 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations mysql-ysadrs-reconfiguring-th745 --namespace ns-wutxk ` opsrequest.operations.kubeblocks.io/mysql-ysadrs-reconfiguring-th745 patched `kbcli cluster delete-ops --name mysql-ysadrs-reconfiguring-th745 --force --auto-approve --namespace ns-wutxk ` OpsRequest mysql-ysadrs-reconfiguring-th745 deleted component_config:mysql check config variables `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql Defaulted container "mysql" out of: mysql, kbagent, config-manager, init-data (init), init-jq (init), init-kbagent (init), kbagent-worker (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. current value_actual: 691200 configure:[binlog_expire_logs_seconds] result actual:[691200] equal expected:[691200] `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success test failover dnserror check cluster status before cluster-failover-dnserror check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge DNSChaos test-chaos-mesh-dnserror-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): dnschaos.chaos-mesh.org "test-chaos-mesh-dnserror-mysql-ysadrs" not found Error from server (NotFound): dnschaos.chaos-mesh.org "test-chaos-mesh-dnserror-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: DNSChaos metadata: name: test-chaos-mesh-dnserror-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-0 mode: all action: error duration: 2m `kubectl apply -f test-chaos-mesh-dnserror-mysql-ysadrs.yaml` dnschaos.chaos-mesh.org/test-chaos-mesh-dnserror-mysql-ysadrs created apply test-chaos-mesh-dnserror-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-dnserror-mysql-ysadrs.yaml` dnserror chaos test waiting 120 seconds check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:08 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:10 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge DNSChaos test-chaos-mesh-dnserror-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. dnschaos.chaos-mesh.org "test-chaos-mesh-dnserror-mysql-ysadrs" force deleted Error from server (NotFound): dnschaos.chaos-mesh.org "test-chaos-mesh-dnserror-mysql-ysadrs" not found check failover pod name failover pod name:mysql-ysadrs-mysql-0 failover dnserror Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success cluster stop check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster stop mysql-ysadrs --auto-approve --force=true --namespace ns-wutxk ` OpsRequest mysql-ysadrs-stop-m4h87 created successfully, you can view the progress: kbcli cluster describe-ops mysql-ysadrs-stop-m4h87 -n ns-wutxk check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-stop-m4h87 ns-wutxk Stop mysql-ysadrs mysql Running 0/2 Sep 12,2025 13:16 UTC+0800 check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Stopping Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping check cluster status done cluster_status:Stopped check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME check pod status done check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-stop-m4h87 ns-wutxk Stop mysql-ysadrs mysql Succeed 2/2 Sep 12,2025 13:16 UTC+0800 check ops status done ops_status:mysql-ysadrs-stop-m4h87 ns-wutxk Stop mysql-ysadrs mysql Succeed 2/2 Sep 12,2025 13:16 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations mysql-ysadrs-stop-m4h87 --namespace ns-wutxk ` opsrequest.operations.kubeblocks.io/mysql-ysadrs-stop-m4h87 patched `kbcli cluster delete-ops --name mysql-ysadrs-stop-m4h87 --force --auto-approve --namespace ns-wutxk ` OpsRequest mysql-ysadrs-stop-m4h87 deleted cluster start check cluster status before ops check cluster status done cluster_status:Stopped `kbcli cluster start mysql-ysadrs --force=true --namespace ns-wutxk ` OpsRequest mysql-ysadrs-start-7wq9m created successfully, you can view the progress: kbcli cluster describe-ops mysql-ysadrs-start-7wq9m -n ns-wutxk check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-start-7wq9m ns-wutxk Start mysql-ysadrs mysql Running 0/2 Sep 12,2025 13:17 UTC+0800 check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Updating Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:17 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:19 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-start-7wq9m ns-wutxk Start mysql-ysadrs mysql Succeed 2/2 Sep 12,2025 13:17 UTC+0800 check ops status done ops_status:mysql-ysadrs-start-7wq9m ns-wutxk Start mysql-ysadrs mysql Succeed 2/2 Sep 12,2025 13:17 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations mysql-ysadrs-start-7wq9m --namespace ns-wutxk ` opsrequest.operations.kubeblocks.io/mysql-ysadrs-start-7wq9m patched `kbcli cluster delete-ops --name mysql-ysadrs-start-7wq9m --force --auto-approve --namespace ns-wutxk ` OpsRequest mysql-ysadrs-start-7wq9m deleted `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success cluster restart check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster restart mysql-ysadrs --auto-approve --force=true --namespace ns-wutxk ` OpsRequest mysql-ysadrs-restart-w5fd2 created successfully, you can view the progress: kbcli cluster describe-ops mysql-ysadrs-restart-w5fd2 -n ns-wutxk check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-restart-w5fd2 ns-wutxk Restart mysql-ysadrs mysql Running 0/2 Sep 12,2025 13:20 UTC+0800 check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Updating Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:21 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:21 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-1;secondary: mysql-ysadrs-mysql-0 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check cluster connect done check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-restart-w5fd2 ns-wutxk Restart mysql-ysadrs mysql Succeed 2/2 Sep 12,2025 13:20 UTC+0800 check ops status done ops_status:mysql-ysadrs-restart-w5fd2 ns-wutxk Restart mysql-ysadrs mysql Succeed 2/2 Sep 12,2025 13:20 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations mysql-ysadrs-restart-w5fd2 --namespace ns-wutxk ` opsrequest.operations.kubeblocks.io/mysql-ysadrs-restart-w5fd2 patched `kbcli cluster delete-ops --name mysql-ysadrs-restart-w5fd2 --force --auto-approve --namespace ns-wutxk ` OpsRequest mysql-ysadrs-restart-w5fd2 deleted `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success test failover networkpartition check cluster status before cluster-failover-networkpartition check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkpartition-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkpartition-mysql-ysadrs" not found Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkpartition-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: NetworkChaos metadata: name: test-chaos-mesh-networkpartition-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-1 action: partition mode: all target: mode: all selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-0 direction: to duration: 2m `kubectl apply -f test-chaos-mesh-networkpartition-mysql-ysadrs.yaml` networkchaos.chaos-mesh.org/test-chaos-mesh-networkpartition-mysql-ysadrs created apply test-chaos-mesh-networkpartition-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-networkpartition-mysql-ysadrs.yaml` networkpartition chaos test waiting 120 seconds check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:21 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:21 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-1;secondary: mysql-ysadrs-mysql-0 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkpartition-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. networkchaos.chaos-mesh.org "test-chaos-mesh-networkpartition-mysql-ysadrs" force deleted Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkpartition-mysql-ysadrs" not found check failover pod name failover pod name:mysql-ysadrs-mysql-1 failover networkpartition Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success test failover networkdelay check cluster status before cluster-failover-networkdelay check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkdelay-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkdelay-mysql-ysadrs" not found Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkdelay-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: NetworkChaos metadata: name: test-chaos-mesh-networkdelay-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-1 mode: all action: delay delay: latency: 2000ms correlation: '100' jitter: 0ms direction: to duration: 2m `kubectl apply -f test-chaos-mesh-networkdelay-mysql-ysadrs.yaml` networkchaos.chaos-mesh.org/test-chaos-mesh-networkdelay-mysql-ysadrs created apply test-chaos-mesh-networkdelay-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-networkdelay-mysql-ysadrs.yaml` networkdelay chaos test waiting 120 seconds check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:21 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:21 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-1;secondary: mysql-ysadrs-mysql-0 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkdelay-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. networkchaos.chaos-mesh.org "test-chaos-mesh-networkdelay-mysql-ysadrs" force deleted Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkdelay-mysql-ysadrs" not found check failover pod name failover pod name:mysql-ysadrs-mysql-1 failover networkdelay Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success test failover networkcorruptover check cluster status before cluster-failover-networkcorruptover check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkcorruptover-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkcorruptover-mysql-ysadrs" not found Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkcorruptover-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: NetworkChaos metadata: name: test-chaos-mesh-networkcorruptover-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-1 mode: all action: corrupt corrupt: corrupt: '100' correlation: '100' direction: to duration: 2m `kubectl apply -f test-chaos-mesh-networkcorruptover-mysql-ysadrs.yaml` networkchaos.chaos-mesh.org/test-chaos-mesh-networkcorruptover-mysql-ysadrs created apply test-chaos-mesh-networkcorruptover-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-networkcorruptover-mysql-ysadrs.yaml` networkcorruptover chaos test waiting 120 seconds check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:21 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:21 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkcorruptover-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. networkchaos.chaos-mesh.org "test-chaos-mesh-networkcorruptover-mysql-ysadrs" force deleted Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkcorruptover-mysql-ysadrs" not found check failover pod name failover pod name:mysql-ysadrs-mysql-0 failover networkcorruptover Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success test failover dnsrandom check cluster status before cluster-failover-dnsrandom check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge DNSChaos test-chaos-mesh-dnsrandom-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): dnschaos.chaos-mesh.org "test-chaos-mesh-dnsrandom-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: DNSChaos metadata: name: test-chaos-mesh-dnsrandom-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-0 mode: all action: random duration: 2m `kubectl apply -f test-chaos-mesh-dnsrandom-mysql-ysadrs.yaml` Error from server (NotFound): dnschaos.chaos-mesh.org "test-chaos-mesh-dnsrandom-mysql-ysadrs" not found dnschaos.chaos-mesh.org/test-chaos-mesh-dnsrandom-mysql-ysadrs created apply test-chaos-mesh-dnsrandom-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-dnsrandom-mysql-ysadrs.yaml` dnsrandom chaos test waiting 120 seconds check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:21 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:10Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:21 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge DNSChaos test-chaos-mesh-dnsrandom-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. dnschaos.chaos-mesh.org "test-chaos-mesh-dnsrandom-mysql-ysadrs" force deleted Error from server (NotFound): dnschaos.chaos-mesh.org "test-chaos-mesh-dnsrandom-mysql-ysadrs" not found check failover pod name failover pod name:mysql-ysadrs-mysql-0 failover dnsrandom Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success `kubectl get pvc -l app.kubernetes.io/instance=mysql-ysadrs,apps.kubeblocks.io/component-name=mysql,apps.kubeblocks.io/vct-name=data --namespace ns-wutxk ` cluster volume-expand check cluster status before ops check cluster status done cluster_status:Running No resources found in mysql-ysadrs namespace. `kbcli cluster volume-expand mysql-ysadrs --auto-approve --force=true --components mysql --volume-claim-templates data --storage 11Gi --namespace ns-wutxk ` OpsRequest mysql-ysadrs-volumeexpansion-pwr48 created successfully, you can view the progress: kbcli cluster describe-ops mysql-ysadrs-volumeexpansion-pwr48 -n ns-wutxk check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-volumeexpansion-pwr48 ns-wutxk VolumeExpansion mysql-ysadrs mysql Running -/- Sep 12,2025 13:31 UTC+0800 check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Updating Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:21 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:21 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done No resources found in mysql-ysadrs namespace. check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-volumeexpansion-pwr48 ns-wutxk VolumeExpansion mysql-ysadrs mysql Succeed 2/2 Sep 12,2025 13:31 UTC+0800 check ops status done ops_status:mysql-ysadrs-volumeexpansion-pwr48 ns-wutxk VolumeExpansion mysql-ysadrs mysql Succeed 2/2 Sep 12,2025 13:31 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations mysql-ysadrs-volumeexpansion-pwr48 --namespace ns-wutxk ` opsrequest.operations.kubeblocks.io/mysql-ysadrs-volumeexpansion-pwr48 patched `kbcli cluster delete-ops --name mysql-ysadrs-volumeexpansion-pwr48 --force --auto-approve --namespace ns-wutxk ` OpsRequest mysql-ysadrs-volumeexpansion-pwr48 deleted `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success test failover fullcpu check cluster status before cluster-failover-fullcpu check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge StressChaos test-chaos-mesh-fullcpu-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): stresschaos.chaos-mesh.org "test-chaos-mesh-fullcpu-mysql-ysadrs" not found Error from server (NotFound): stresschaos.chaos-mesh.org "test-chaos-mesh-fullcpu-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: StressChaos metadata: name: test-chaos-mesh-fullcpu-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-0 mode: all stressors: cpu: workers: 100 load: 100 duration: 2m `kubectl apply -f test-chaos-mesh-fullcpu-mysql-ysadrs.yaml` stresschaos.chaos-mesh.org/test-chaos-mesh-fullcpu-mysql-ysadrs created apply test-chaos-mesh-fullcpu-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-fullcpu-mysql-ysadrs.yaml` fullcpu chaos test waiting 120 seconds check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 500m / 500m 512Mi / 512Mi data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:21 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 500m / 500m 512Mi / 512Mi data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:21 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge StressChaos test-chaos-mesh-fullcpu-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. stresschaos.chaos-mesh.org "test-chaos-mesh-fullcpu-mysql-ysadrs" force deleted Error from server (NotFound): stresschaos.chaos-mesh.org "test-chaos-mesh-fullcpu-mysql-ysadrs" not found check failover pod name failover pod name:mysql-ysadrs-mysql-0 failover fullcpu Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster vscale mysql-ysadrs --auto-approve --force=true --components mysql --cpu 600m --memory 0.6Gi --namespace ns-wutxk ` OpsRequest mysql-ysadrs-verticalscaling-rnxmd created successfully, you can view the progress: kbcli cluster describe-ops mysql-ysadrs-verticalscaling-rnxmd -n ns-wutxk check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-verticalscaling-rnxmd ns-wutxk VerticalScaling mysql-ysadrs mysql Running 0/2 Sep 12,2025 13:39 UTC+0800 check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Updating Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:40 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:39 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-1;secondary: mysql-ysadrs-mysql-0 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check cluster connect done check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-verticalscaling-rnxmd ns-wutxk VerticalScaling mysql-ysadrs mysql Succeed 2/2 Sep 12,2025 13:39 UTC+0800 check ops status done ops_status:mysql-ysadrs-verticalscaling-rnxmd ns-wutxk VerticalScaling mysql-ysadrs mysql Succeed 2/2 Sep 12,2025 13:39 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations mysql-ysadrs-verticalscaling-rnxmd --namespace ns-wutxk ` opsrequest.operations.kubeblocks.io/mysql-ysadrs-verticalscaling-rnxmd patched `kbcli cluster delete-ops --name mysql-ysadrs-verticalscaling-rnxmd --force --auto-approve --namespace ns-wutxk ` OpsRequest mysql-ysadrs-verticalscaling-rnxmd deleted `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success test failover networkloss check cluster status before cluster-failover-networkloss check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkloss-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkloss-mysql-ysadrs" not found Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkloss-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: NetworkChaos metadata: name: test-chaos-mesh-networkloss-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-1 mode: all action: loss loss: loss: '100' correlation: '100' direction: to duration: 2m `kubectl apply -f test-chaos-mesh-networkloss-mysql-ysadrs.yaml` networkchaos.chaos-mesh.org/test-chaos-mesh-networkloss-mysql-ysadrs created apply test-chaos-mesh-networkloss-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-networkloss-mysql-ysadrs.yaml` networkloss chaos test waiting 120 seconds check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Updating Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:40 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:39 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-1;secondary: mysql-ysadrs-mysql-0 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkloss-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. networkchaos.chaos-mesh.org "test-chaos-mesh-networkloss-mysql-ysadrs" force deleted Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkloss-mysql-ysadrs" not found check failover pod name failover pod name:mysql-ysadrs-mysql-1 failover networkloss Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success test failover oom check cluster status before cluster-failover-oom check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge StressChaos test-chaos-mesh-oom-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): stresschaos.chaos-mesh.org "test-chaos-mesh-oom-mysql-ysadrs" not found Error from server (NotFound): stresschaos.chaos-mesh.org "test-chaos-mesh-oom-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: StressChaos metadata: name: test-chaos-mesh-oom-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-1 mode: all stressors: memory: workers: 1 size: "100GB" oomScoreAdj: -1000 duration: 2m `kubectl apply -f test-chaos-mesh-oom-mysql-ysadrs.yaml` stresschaos.chaos-mesh.org/test-chaos-mesh-oom-mysql-ysadrs created apply test-chaos-mesh-oom-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-oom-mysql-ysadrs.yaml` check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Updating Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Failed check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:40 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:39 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-1;secondary: mysql-ysadrs-mysql-0 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge StressChaos test-chaos-mesh-oom-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. stresschaos.chaos-mesh.org "test-chaos-mesh-oom-mysql-ysadrs" force deleted stresschaos.chaos-mesh.org/test-chaos-mesh-oom-mysql-ysadrs patched check failover pod name failover pod name:mysql-ysadrs-mysql-1 checking failover... `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge StressChaos test-chaos-mesh-oom-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): stresschaos.chaos-mesh.org "test-chaos-mesh-oom-mysql-ysadrs" not found Error from server (NotFound): stresschaos.chaos-mesh.org "test-chaos-mesh-oom-mysql-ysadrs" not found `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge StressChaos test-chaos-mesh-oom-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): stresschaos.chaos-mesh.org "test-chaos-mesh-oom-mysql-ysadrs" not found Error from server (NotFound): stresschaos.chaos-mesh.org "test-chaos-mesh-oom-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: StressChaos metadata: name: test-chaos-mesh-oom-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-1 mode: all stressors: memory: workers: 1 size: "100GB" oomScoreAdj: -1000 duration: 2m `kubectl apply -f test-chaos-mesh-oom-mysql-ysadrs.yaml` stresschaos.chaos-mesh.org/test-chaos-mesh-oom-mysql-ysadrs created apply test-chaos-mesh-oom-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-oom-mysql-ysadrs.yaml` check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Updating Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql cluster_status:Updating cluster_status:Failed check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:40 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:39 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge StressChaos test-chaos-mesh-oom-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. stresschaos.chaos-mesh.org "test-chaos-mesh-oom-mysql-ysadrs" force deleted stresschaos.chaos-mesh.org/test-chaos-mesh-oom-mysql-ysadrs patched check failover pod name:mysql-ysadrs-mysql-0 failover oom Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success test failover timeoffset check cluster status before cluster-failover-timeoffset check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge TimeChaos test-chaos-mesh-timeoffset-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): timechaos.chaos-mesh.org "test-chaos-mesh-timeoffset-mysql-ysadrs" not found Error from server (NotFound): timechaos.chaos-mesh.org "test-chaos-mesh-timeoffset-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: TimeChaos metadata: name: test-chaos-mesh-timeoffset-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-0 mode: all timeOffset: '-10m' clockIds: - CLOCK_REALTIME duration: 2m `kubectl apply -f test-chaos-mesh-timeoffset-mysql-ysadrs.yaml` timechaos.chaos-mesh.org/test-chaos-mesh-timeoffset-mysql-ysadrs created apply test-chaos-mesh-timeoffset-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-timeoffset-mysql-ysadrs.yaml` timeoffset chaos test waiting 120 seconds check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:40 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:39 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge TimeChaos test-chaos-mesh-timeoffset-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. timechaos.chaos-mesh.org "test-chaos-mesh-timeoffset-mysql-ysadrs" force deleted Error from server (NotFound): timechaos.chaos-mesh.org "test-chaos-mesh-timeoffset-mysql-ysadrs" not found check failover pod name failover pod name:mysql-ysadrs-mysql-0 failover timeoffset Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success LB_TYPE is set to: internet No resources found in ns-wutxk namespace. `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql apiVersion: v1 kind: Pod metadata: name: benchtest-mysql-ysadrs namespace: ns-wutxk spec: containers: - name: test-sysbench imagePullPolicy: IfNotPresent image: docker.io/apecloud/customsuites:latest env: - name: TYPE value: "2" - name: FLAG value: "0" - name: CONFIGS value: "mode:all,driver:mysql,host:135.234.155.111,user:root,password:Efu1819pJ1,port:3306,db:benchtest,tables:5,threads:4,times:10,size:1000,type:oltp_read_write" restartPolicy: Never `kubectl apply -f benchtest-mysql-ysadrs.yaml` pod/benchtest-mysql-ysadrs created apply benchtest-mysql-ysadrs.yaml Success check pod status pod_status:NAME READY STATUS RESTARTS AGE benchtest-mysql-ysadrs 0/1 ContainerCreating 0 0s pod_status:NAME READY STATUS RESTARTS AGE benchtest-mysql-ysadrs 0/1 ContainerCreating 0 4s pod_status:NAME READY STATUS RESTARTS AGE benchtest-mysql-ysadrs 0/1 ContainerCreating 0 10s pod_status:NAME READY STATUS RESTARTS AGE benchtest-mysql-ysadrs 0/1 ContainerCreating 0 15s pod_status:NAME READY STATUS RESTARTS AGE benchtest-mysql-ysadrs 1/1 Running 0 20s pod_status:NAME READY STATUS RESTARTS AGE benchtest-mysql-ysadrs 1/1 Running 0 25s pod_status:NAME READY STATUS RESTARTS AGE benchtest-mysql-ysadrs 1/1 Running 0 31s pod_status:NAME READY STATUS RESTARTS AGE benchtest-mysql-ysadrs 1/1 Running 0 36s check pod benchtest-mysql-ysadrs status done pod_status:NAME READY STATUS RESTARTS AGE benchtest-mysql-ysadrs 0/1 Completed 0 41s `rm -rf benchtest-mysql-ysadrs.yaml` `kubectl logs benchtest-mysql-ysadrs --tail 30 --namespace ns-wutxk ` [ 7s ] thds: 4 tps: 127.94 qps: 2586.71 (r/w/o: 1812.10/517.74/256.87) lat (ms,99%): 70.55 err/s: 1.00 reconn/s: 0.00 [ 8s ] thds: 4 tps: 123.05 qps: 2450.06 (r/w/o: 1717.74/486.21/246.11) lat (ms,99%): 62.19 err/s: 0.00 reconn/s: 0.00 [ 9s ] thds: 4 tps: 124.98 qps: 2507.54 (r/w/o: 1754.68/502.91/249.95) lat (ms,99%): 71.83 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 4 tps: 120.98 qps: 2422.65 (r/w/o: 1693.76/486.93/241.97) lat (ms,99%): 87.56 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 18242 write: 5210 other: 2605 total: 26057 transactions: 1302 (129.72 per sec.) queries: 26057 (2596.02 per sec.) ignored errors: 1 (0.10 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0358s total number of events: 1302 Latency (ms): min: 11.50 avg: 30.80 max: 88.51 99th percentile: 71.83 sum: 40102.43 Threads fairness: events (avg/stddev): 325.5000/4.15 execution time (avg/stddev): 10.0256/0.01 `kubectl delete pod benchtest-mysql-ysadrs --force --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. pod "benchtest-mysql-ysadrs" force deleted test failover networkduplicate check cluster status before cluster-failover-networkduplicate check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkduplicate-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkduplicate-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: NetworkChaos metadata: name: test-chaos-mesh-networkduplicate-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-0 mode: all action: duplicate duplicate: duplicate: '100' correlation: '100' direction: to duration: 2m `kubectl apply -f test-chaos-mesh-networkduplicate-mysql-ysadrs.yaml` Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkduplicate-mysql-ysadrs" not found networkchaos.chaos-mesh.org/test-chaos-mesh-networkduplicate-mysql-ysadrs created apply test-chaos-mesh-networkduplicate-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-networkduplicate-mysql-ysadrs.yaml` networkduplicate chaos test waiting 120 seconds check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:40 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:39 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-0;secondary: mysql-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkduplicate-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. networkchaos.chaos-mesh.org "test-chaos-mesh-networkduplicate-mysql-ysadrs" force deleted networkchaos.chaos-mesh.org/test-chaos-mesh-networkduplicate-mysql-ysadrs patched check failover pod name failover pod name:mysql-ysadrs-mysql-0 failover networkduplicate Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success test failover networkbandwidthover check cluster status before cluster-failover-networkbandwidthover check cluster status done cluster_status:Running `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkbandwidthover-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkbandwidthover-mysql-ysadrs" not found Error from server (NotFound): networkchaos.chaos-mesh.org "test-chaos-mesh-networkbandwidthover-mysql-ysadrs" not found apiVersion: chaos-mesh.org/v1alpha1 kind: NetworkChaos metadata: name: test-chaos-mesh-networkbandwidthover-mysql-ysadrs namespace: ns-wutxk spec: selector: namespaces: - ns-wutxk labelSelectors: apps.kubeblocks.io/pod-name: mysql-ysadrs-mysql-0 action: bandwidth mode: all bandwidth: rate: '1bps' limit: 20971520 buffer: 10000 duration: 2m `kubectl apply -f test-chaos-mesh-networkbandwidthover-mysql-ysadrs.yaml` networkchaos.chaos-mesh.org/test-chaos-mesh-networkbandwidthover-mysql-ysadrs created apply test-chaos-mesh-networkbandwidthover-mysql-ysadrs.yaml Success `rm -rf test-chaos-mesh-networkbandwidthover-mysql-ysadrs.yaml` networkbandwidthover chaos test waiting 120 seconds check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql DoNotTerminate Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:40 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:39 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-1;secondary: mysql-ysadrs-mysql-0 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check cluster connect done `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge NetworkChaos test-chaos-mesh-networkbandwidthover-mysql-ysadrs --namespace ns-wutxk ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. networkchaos.chaos-mesh.org "test-chaos-mesh-networkbandwidthover-mysql-ysadrs" force deleted networkchaos.chaos-mesh.org/test-chaos-mesh-networkbandwidthover-mysql-ysadrs patched check failover pod name failover pod name:mysql-ysadrs-mysql-1 failover networkbandwidthover Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success cluster update terminationPolicy WipeOut `kbcli cluster update mysql-ysadrs --termination-policy=WipeOut --namespace ns-wutxk ` cluster.apps.kubeblocks.io/mysql-ysadrs updated check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql WipeOut Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:40 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:39 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-1;secondary: mysql-ysadrs-mysql-0 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check cluster connect done cluster xtrabackup backup `kubectl get backuprepo backuprepo-kbcli-test -o jsonpath="***.spec.credential.name***"` `kubectl get backuprepo backuprepo-kbcli-test -o jsonpath="***.spec.credential.namespace***"` `kubectl get secrets kb-backuprepo-85gdv -n kb-osxch -o jsonpath="***.data.accessKeyId***"` `kubectl get secrets kb-backuprepo-85gdv -n kb-osxch -o jsonpath="***.data.secretAccessKey***"` KUBEBLOCKS NAMESPACE:kb-osxch get kubeblocks namespace done `kubectl get secrets -l app.kubernetes.io/instance=kbcli-test-minio --namespace kb-osxch -o jsonpath="***.items[0].data.root-user***"` `kubectl get secrets -l app.kubernetes.io/instance=kbcli-test-minio --namespace kb-osxch -o jsonpath="***.items[0].data.root-password***"` minio_user:kbclitest,minio_password:kbclitest,minio_endpoint:kbcli-test-minio.kb-osxch.svc.cluster.local:9000 list minio bucket kbcli-test `echo 'mc config host add minioserver http://kbcli-test-minio.kb-osxch.svc.cluster.local:9000 kbclitest kbclitest;mc ls minioserver' | kubectl exec -it kbcli-test-minio-7664db4c4f-zj7xt --namespace kb-osxch -- bash` Unable to use a TTY - input is not a terminal or the right kind of file list minio bucket done default backuprepo:backuprepo-kbcli-test exists `kbcli cluster backup mysql-ysadrs --method xtrabackup --namespace ns-wutxk ` Backup backup-ns-wutxk-mysql-ysadrs-20250912135418 created successfully, you can view the progress: kbcli cluster list-backups --names=backup-ns-wutxk-mysql-ysadrs-20250912135418 -n ns-wutxk check backup status `kbcli cluster list-backups mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE SOURCE-CLUSTER METHOD STATUS TOTAL-SIZE DURATION DELETION-POLICY CREATE-TIME COMPLETION-TIME EXPIRATION backup-ns-wutxk-mysql-ysadrs-20250912135418 ns-wutxk mysql-ysadrs xtrabackup Running Delete Sep 12,2025 13:54 UTC+0800 backup_status:mysql-ysadrs-xtrabackup-Running backup_status:mysql-ysadrs-xtrabackup-Running backup_status:mysql-ysadrs-xtrabackup-Running backup_status:mysql-ysadrs-xtrabackup-Running backup_status:mysql-ysadrs-xtrabackup-Running check backup status done backup_status:backup-ns-wutxk-mysql-ysadrs-20250912135418 ns-wutxk mysql-ysadrs xtrabackup Completed 5169734 24s Delete Sep 12,2025 13:54 UTC+0800 Sep 12,2025 13:54 UTC+0800 cluster restore backup Error from server (NotFound): opsrequests.operations.kubeblocks.io "abk-ysadrs" not found `kbcli cluster describe-backup --names backup-ns-wutxk-mysql-ysadrs-20250912135418 --namespace ns-wutxk ` Name: backup-ns-wutxk-mysql-ysadrs-20250912135418 Cluster: mysql-ysadrs Namespace: ns-wutxk Spec: Method: xtrabackup Policy Name: mysql-ysadrs-mysql-backup-policy Actions: dp-backup-0: ActionType: Job WorkloadName: dp-backup-0-backup-ns-wutxk-mysql-ysadrs-20250912135418-5de1ea4 TargetPodName: mysql-ysadrs-mysql-0 Phase: Completed Start Time: Sep 12,2025 13:54 UTC+0800 Completion Time: Sep 12,2025 13:54 UTC+0800 Status: Phase: Completed Total Size: 5169734 ActionSet Name: mysql-xtrabackup-br Repository: backuprepo-kbcli-test Duration: 24s Start Time: Sep 12,2025 13:54 UTC+0800 Completion Time: Sep 12,2025 13:54 UTC+0800 Path: /ns-wutxk/mysql-ysadrs-ddf05490-8f05-434d-906b-df50702a1c27/mysql/backup-ns-wutxk-mysql-ysadrs-20250912135418 Warning Events: `kbcli cluster restore abk-ysadrs --backup backup-ns-wutxk-mysql-ysadrs-20250912135418 --namespace ns-wutxk ` Cluster abk-ysadrs created check cluster status `kbcli cluster list abk-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS abk-ysadrs ns-wutxk mysql WipeOut Creating Sep 12,2025 13:54 UTC+0800 clusterdefinition.kubeblocks.io/name=mysql cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances abk-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME abk-ysadrs-mysql-0 ns-wutxk abk-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:55 UTC+0800 abk-ysadrs-mysql-1 ns-wutxk abk-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000000/10.224.0.5 Sep 12,2025 13:55 UTC+0800 check pod status done check cluster role check cluster role done primary: abk-ysadrs-mysql-0;secondary: abk-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=abk-ysadrs` set secret: abk-ysadrs-mysql-account-root `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it abk-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done `kbcli cluster describe-backup --names backup-ns-wutxk-mysql-ysadrs-20250912135418 --namespace ns-wutxk ` Name: backup-ns-wutxk-mysql-ysadrs-20250912135418 Cluster: mysql-ysadrs Namespace: ns-wutxk Spec: Method: xtrabackup Policy Name: mysql-ysadrs-mysql-backup-policy Actions: dp-backup-0: ActionType: Job WorkloadName: dp-backup-0-backup-ns-wutxk-mysql-ysadrs-20250912135418-5de1ea4 TargetPodName: mysql-ysadrs-mysql-0 Phase: Completed Start Time: Sep 12,2025 13:54 UTC+0800 Completion Time: Sep 12,2025 13:54 UTC+0800 Status: Phase: Completed Total Size: 5169734 ActionSet Name: mysql-xtrabackup-br Repository: backuprepo-kbcli-test Duration: 24s Start Time: Sep 12,2025 13:54 UTC+0800 Completion Time: Sep 12,2025 13:54 UTC+0800 Path: /ns-wutxk/mysql-ysadrs-ddf05490-8f05-434d-906b-df50702a1c27/mysql/backup-ns-wutxk-mysql-ysadrs-20250912135418 Warning Events: cluster connect `kubectl get secrets -l app.kubernetes.io/instance=abk-ysadrs` set secret: abk-ysadrs-mysql-account-root `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql Defaulted container "mysql" out of: mysql, kbagent, config-manager, init-data (init), init-jq (init), init-kbagent (init), kbagent-worker (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. *************************** 1. row *************************** Slave_IO_State: Waiting for source to send event Master_Host: abk-ysadrs-mysql-0.abk-ysadrs-mysql-headless Master_User: root Master_Port: 3306 Connect_Retry: 1 Master_Log_File: abk-ysadrs-mysql-0-bin.000001 Read_Master_Log_Pos: 2957 Relay_Log_File: relay-bin.000002 Relay_Log_Pos: 3199 Relay_Master_Log_File: abk-ysadrs-mysql-0-bin.000001 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 2957 Relay_Log_Space: 3403 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_UUID: 19584a1f-8f9d-11f0-8497-0a68fcb7173c Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 19584a1f-8f9d-11f0-8497-0a68fcb7173c:1-8 Executed_Gtid_Set: 19584a1f-8f9d-11f0-8497-0a68fcb7173c:1-8, a304d8b4-8f96-11f0-9954-b6896f7fd594:1-5796 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: Master_public_key_path: Get_master_public_key: 1 Network_Namespace: `echo " echo \"show variables like 'max_connections';\" | mysql -h127.0.0.1 -uroot -pEfu1819pJ1 -P3306 " | kubectl exec -it abk-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` Defaulted container "mysql" out of: mysql, kbagent, config-manager, init-data (init), init-jq (init), init-kbagent (init), kbagent-worker (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. Variable_name Value max_connections 100 connect cluster Success set max_connections to 100 delete cluster abk-ysadrs `kbcli cluster delete abk-ysadrs --auto-approve --namespace ns-wutxk ` Cluster abk-ysadrs deleted pod_info:abk-ysadrs-mysql-0 3/3 Running 0 71s abk-ysadrs-mysql-1 3/3 Running 0 47s pod_info:abk-ysadrs-mysql-0 3/3 Terminating 0 91s abk-ysadrs-mysql-1 3/3 Terminating 0 67s No resources found in ns-wutxk namespace. delete cluster pod done No resources found in ns-wutxk namespace. check cluster resource non-exist OK: pvc No resources found in ns-wutxk namespace. delete cluster done No resources found in ns-wutxk namespace. No resources found in ns-wutxk namespace. No resources found in ns-wutxk namespace. cluster delete backup `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge backups backup-ns-wutxk-mysql-ysadrs-20250912135418 --namespace ns-wutxk ` backup.dataprotection.kubeblocks.io/backup-ns-wutxk-mysql-ysadrs-20250912135418 patched `kbcli cluster delete-backup mysql-ysadrs --name backup-ns-wutxk-mysql-ysadrs-20250912135418 --force --auto-approve --namespace ns-wutxk ` Backup backup-ns-wutxk-mysql-ysadrs-20250912135418 deleted No opsrequests found in ns-wutxk namespace. `kubectl get backupschedule -l app.kubernetes.io/instance=mysql-ysadrs ` `kubectl get backupschedule mysql-ysadrs-mysql-backup-schedule -ojsonpath='***.spec.schedules[*].backupMethod***' ` backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched check backup status `kbcli cluster list-backups mysql-ysadrs --namespace ns-wutxk ` No backups found in ns-wutxk namespace. No backups found in ns-wutxk namespace. backup_status:-- No backups found in ns-wutxk namespace. backup_status:-- No backups found in ns-wutxk namespace. backup_status:-- No backups found in ns-wutxk namespace. backup_status:-- No backups found in ns-wutxk namespace. backup_status:-- No backups found in ns-wutxk namespace. backup_status:-- No backups found in ns-wutxk namespace. backup_status:-- `kubectl get backupschedule -l app.kubernetes.io/instance=mysql-ysadrs ` `kubectl get backupschedule mysql-ysadrs-mysql-backup-schedule -ojsonpath='***.spec.schedules[*].backupMethod***' ` backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) backup_status:mysql-ysadrs-xtrabackup-Running check backup status done backup_status:mysql-ysadrs-xtrabackup-20250912055800 ns-wutxk mysql-ysadrs xtrabackup Completed 5169742 10s Delete Sep 12,2025 13:58 UTC+0800 Sep 12,2025 13:58 UTC+0800 Sep 20,2025 13:58 UTC+0800 `kubectl get backupschedule -l app.kubernetes.io/instance=mysql-ysadrs ` `kubectl get backupschedule mysql-ysadrs-mysql-backup-schedule -ojsonpath='***.spec.schedules[*].backupMethod***' ` backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) backupschedule.dataprotection.kubeblocks.io/mysql-ysadrs-mysql-backup-schedule patched (no change) cluster restore backup Error from server (NotFound): opsrequests.operations.kubeblocks.io "abk-ysadrs" not found `kbcli cluster describe-backup --names mysql-ysadrs-xtrabackup-20250912055800 --namespace ns-wutxk ` Name: mysql-ysadrs-xtrabackup-20250912055800 Cluster: mysql-ysadrs Namespace: ns-wutxk Spec: Method: xtrabackup Policy Name: mysql-ysadrs-mysql-backup-policy Actions: dp-backup-0: ActionType: Job WorkloadName: dp-backup-0-mysql-ysadrs-xtrabackup-20250912055800-569dc137 TargetPodName: mysql-ysadrs-mysql-0 Phase: Completed Start Time: Sep 12,2025 13:58 UTC+0800 Completion Time: Sep 12,2025 13:58 UTC+0800 Status: Phase: Completed Total Size: 5169742 ActionSet Name: mysql-xtrabackup-br Repository: backuprepo-kbcli-test Duration: 10s Expiration Time: Sep 20,2025 13:58 UTC+0800 Start Time: Sep 12,2025 13:58 UTC+0800 Completion Time: Sep 12,2025 13:58 UTC+0800 Path: /ns-wutxk/mysql-ysadrs-ddf05490-8f05-434d-906b-df50702a1c27/mysql/mysql-ysadrs-xtrabackup-20250912055800 Warning Events: `kbcli cluster restore abk-ysadrs --backup mysql-ysadrs-xtrabackup-20250912055800 --namespace ns-wutxk ` Cluster abk-ysadrs created check cluster status `kbcli cluster list abk-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS abk-ysadrs ns-wutxk mysql WipeOut Creating Sep 12,2025 13:58 UTC+0800 clusterdefinition.kubeblocks.io/name=mysql cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances abk-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME abk-ysadrs-mysql-0 ns-wutxk abk-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000000/10.224.0.5 Sep 12,2025 13:58 UTC+0800 abk-ysadrs-mysql-1 ns-wutxk abk-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 14:00 UTC+0800 check pod status done check cluster role check cluster role done primary: abk-ysadrs-mysql-0;secondary: abk-ysadrs-mysql-1 `kubectl get secrets -l app.kubernetes.io/instance=abk-ysadrs` set secret: abk-ysadrs-mysql-account-root `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it abk-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check cluster connect done `kbcli cluster describe-backup --names mysql-ysadrs-xtrabackup-20250912055800 --namespace ns-wutxk ` Name: mysql-ysadrs-xtrabackup-20250912055800 Cluster: mysql-ysadrs Namespace: ns-wutxk Spec: Method: xtrabackup Policy Name: mysql-ysadrs-mysql-backup-policy Actions: dp-backup-0: ActionType: Job WorkloadName: dp-backup-0-mysql-ysadrs-xtrabackup-20250912055800-569dc137 TargetPodName: mysql-ysadrs-mysql-0 Phase: Completed Start Time: Sep 12,2025 13:58 UTC+0800 Completion Time: Sep 12,2025 13:58 UTC+0800 Status: Phase: Completed Total Size: 5169742 ActionSet Name: mysql-xtrabackup-br Repository: backuprepo-kbcli-test Duration: 10s Expiration Time: Sep 20,2025 13:58 UTC+0800 Start Time: Sep 12,2025 13:58 UTC+0800 Completion Time: Sep 12,2025 13:58 UTC+0800 Path: /ns-wutxk/mysql-ysadrs-ddf05490-8f05-434d-906b-df50702a1c27/mysql/mysql-ysadrs-xtrabackup-20250912055800 Warning Events: cluster connect `kubectl get secrets -l app.kubernetes.io/instance=abk-ysadrs` set secret: abk-ysadrs-mysql-account-root `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets abk-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql Defaulted container "mysql" out of: mysql, kbagent, config-manager, init-data (init), init-jq (init), init-kbagent (init), kbagent-worker (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. *************************** 1. row *************************** Slave_IO_State: Waiting for source to send event Master_Host: abk-ysadrs-mysql-0.abk-ysadrs-mysql-headless Master_User: root Master_Port: 3306 Connect_Retry: 1 Master_Log_File: abk-ysadrs-mysql-0-bin.000001 Read_Master_Log_Pos: 2957 Relay_Log_File: relay-bin.000002 Relay_Log_Pos: 3199 Relay_Master_Log_File: abk-ysadrs-mysql-0-bin.000001 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 2957 Relay_Log_Space: 3403 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_UUID: a25e950f-8f9d-11f0-bb2a-46721addf229 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: a25e950f-8f9d-11f0-bb2a-46721addf229:1-8 Executed_Gtid_Set: a25e950f-8f9d-11f0-bb2a-46721addf229:1-8, a304d8b4-8f96-11f0-9954-b6896f7fd594:1-5796 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: Master_public_key_path: Get_master_public_key: 1 Network_Namespace: `echo " echo \"show variables like 'max_connections';\" | mysql -h127.0.0.1 -uroot -pEfu1819pJ1 -P3306 " | kubectl exec -it abk-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` Defaulted container "mysql" out of: mysql, kbagent, config-manager, init-data (init), init-jq (init), init-kbagent (init), kbagent-worker (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. Variable_name Value max_connections 100 connect cluster Success set max_connections to 100 delete cluster abk-ysadrs `kbcli cluster delete abk-ysadrs --auto-approve --namespace ns-wutxk ` Cluster abk-ysadrs deleted pod_info:abk-ysadrs-mysql-0 3/3 Running 0 2m40s abk-ysadrs-mysql-1 3/3 Running 0 52s pod_info:abk-ysadrs-mysql-0 3/3 Terminating 0 3m abk-ysadrs-mysql-1 3/3 Terminating 0 72s No resources found in ns-wutxk namespace. delete cluster pod done No resources found in ns-wutxk namespace. check cluster resource non-exist OK: pvc No resources found in ns-wutxk namespace. delete cluster done No resources found in ns-wutxk namespace. No resources found in ns-wutxk namespace. No resources found in ns-wutxk namespace. cluster delete backup `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge backups mysql-ysadrs-xtrabackup-20250912055800 --namespace ns-wutxk ` backup.dataprotection.kubeblocks.io/mysql-ysadrs-xtrabackup-20250912055800 patched `kbcli cluster delete-backup mysql-ysadrs --name mysql-ysadrs-xtrabackup-20250912055800 --force --auto-approve --namespace ns-wutxk ` Backup mysql-ysadrs-xtrabackup-20250912055800 deleted No opsrequests found in ns-wutxk namespace. cluster list-logs `kbcli cluster list-logs mysql-ysadrs --namespace ns-wutxk ` No log files found. Error from server (NotFound): pods "mysql-ysadrs-mysql-1" not found cluster logs `kbcli cluster logs mysql-ysadrs --tail 30 --namespace ns-wutxk ` Defaulted container "mysql" out of: mysql, kbagent, config-manager, init-data (init), init-jq (init), init-kbagent (init), kbagent-worker (init) 2025-09-12 05:45:04+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.30-1.el8 started. 2025-09-12 05:45:04+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2025-09-12 05:45:04+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.30-1.el8 started. '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' cluster logs slow `kbcli cluster logs mysql-ysadrs --tail 30 --file-type=slow --namespace ns-wutxk ` error: can't get file path pattern by type slow cluster logs error `kbcli cluster logs mysql-ysadrs --tail 30 --file-type=error --namespace ns-wutxk ` error: can't get file path pattern by type error LB_TYPE is set to: internet cluster expose check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster expose mysql-ysadrs --auto-approve --force=true --type internet --enable false --components mysql --role-selector primary --namespace ns-wutxk ` OpsRequest mysql-ysadrs-expose-xxtdq created successfully, you can view the progress: kbcli cluster describe-ops mysql-ysadrs-expose-xxtdq -n ns-wutxk check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-expose-xxtdq ns-wutxk Expose mysql-ysadrs mysql Running 0/1 Sep 12,2025 14:02 UTC+0800 check cluster status `kbcli cluster list mysql-ysadrs --show-labels --namespace ns-wutxk ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS mysql-ysadrs ns-wutxk mysql WipeOut Running Sep 12,2025 13:08 UTC+0800 app.kubernetes.io/instance=mysql-ysadrs,clusterdefinition.kubeblocks.io/name=mysql check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances mysql-ysadrs --namespace ns-wutxk ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME mysql-ysadrs-mysql-0 ns-wutxk mysql-ysadrs mysql Running secondary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000001/10.224.0.7 Sep 12,2025 13:40 UTC+0800 mysql-ysadrs-mysql-1 ns-wutxk mysql-ysadrs mysql Running primary 0 600m / 600m 644245094400m / 644245094400m data:11Gi aks-cicdamdpool-13759654-vmss000002/10.224.0.6 Sep 12,2025 13:39 UTC+0800 check pod status done check cluster role check cluster role done primary: mysql-ysadrs-mysql-1;secondary: mysql-ysadrs-mysql-0 `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check cluster connect `echo " echo \"SHOW SLAVE STATUS\G;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check cluster connect done check ops status `kbcli cluster list-ops mysql-ysadrs --status all --namespace ns-wutxk ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME mysql-ysadrs-expose-xxtdq ns-wutxk Expose mysql-ysadrs mysql Running 0/1 Sep 12,2025 14:02 UTC+0800 ops_status:mysql-ysadrs-expose-xxtdq ns-wutxk Expose mysql-ysadrs mysql Running 0/1 Sep 12,2025 14:02 UTC+0800 check ops status done ops_status:mysql-ysadrs-expose-xxtdq ns-wutxk Expose mysql-ysadrs mysql Succeed 1/1 Sep 12,2025 14:02 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations mysql-ysadrs-expose-xxtdq --namespace ns-wutxk ` opsrequest.operations.kubeblocks.io/mysql-ysadrs-expose-xxtdq patched `kbcli cluster delete-ops --name mysql-ysadrs-expose-xxtdq --force --auto-approve --namespace ns-wutxk ` OpsRequest mysql-ysadrs-expose-xxtdq deleted `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -hmysql-ysadrs-mysql-server.ns-wutxk.svc.cluster.local -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-1 --namespace ns-wutxk -- bash ` check db_client batch data Success `kubectl get secrets -l app.kubernetes.io/instance=mysql-ysadrs` set secret: mysql-ysadrs-mysql-account-root `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.username***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.password***"` `kubectl get secrets mysql-ysadrs-mysql-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:Efu1819pJ1;DB_PORT:3306;DB_DATABASE:mysql check readonly db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P3306 -h127.0.0.1 -uroot -p'Efu1819pJ1' " | kubectl exec -it mysql-ysadrs-mysql-0 --namespace ns-wutxk -- bash ` check readonly db_client batch data Success delete cluster mysql-ysadrs `kbcli cluster delete mysql-ysadrs --auto-approve --namespace ns-wutxk ` Cluster mysql-ysadrs deleted pod_info:mysql-ysadrs-mysql-0 3/3 Running 0 22m mysql-ysadrs-mysql-1 3/3 Running 2 (18m ago) 23m pod_info:mysql-ysadrs-mysql-0 3/3 Terminating 0 22m mysql-ysadrs-mysql-1 3/3 Terminating 2 (18m ago) 23m No resources found in ns-wutxk namespace. delete cluster pod done No resources found in ns-wutxk namespace. check cluster resource non-exist OK: pvc No resources found in ns-wutxk namespace. delete cluster done No resources found in ns-wutxk namespace. No resources found in ns-wutxk namespace. No resources found in ns-wutxk namespace. Mysql Test Suite All Done! delete cluster orcm-ysadrs `kbcli cluster delete orcm-ysadrs --auto-approve --namespace ns-wutxk ` Cluster orcm-ysadrs deleted pod_info:orcm-ysadrs-orchestrator-0 2/2 Running 0 58m orcm-ysadrs-orchestrator-1 2/2 Running 0 57m orcm-ysadrs-orchestrator-2 2/2 Running 0 56m pod_info:orcm-ysadrs-orchestrator-0 2/2 Terminating 0 58m orcm-ysadrs-orchestrator-1 2/2 Terminating 0 57m orcm-ysadrs-orchestrator-2 2/2 Terminating 0 57m No resources found in ns-wutxk namespace. delete cluster pod done No resources found in ns-wutxk namespace. check cluster resource non-exist OK: pvc No resources found in ns-wutxk namespace. delete cluster done No resources found in ns-wutxk namespace. No resources found in ns-wutxk namespace. No resources found in ns-wutxk namespace. Test Engine: mysql Test Type: 21 [PASSED]|[Create]|[ComponentDefinition=orchestrator-raft-1.0.1;ServiceVersion=3.2.6;]|[Description=Create a cluster with the specified component definition orchestrator-raft-1.0.1 and service version 3.2.6] --------------------------------------Mysql Orchestrator (Topology = orc Replicas 2) Test Result-------------------------------------- [PASSED]|[Create]|[ComponentDefinition=mysql-8.0-1.0.1;ComponentVersion=mysql;ServiceVersion=8.0.30;]|[Description=Create a cluster with the specified component definition mysql-8.0-1.0.1 and component version mysql and service version 8.0.30] [PASSED]|[Connect]|[ComponentName=mysql]|[Description=Connect to the cluster] [PASSED]|[Expose]|[Enable=true;TYPE=internet;ComponentName=mysql]|[Description=Expose Enable the internet service with mysql component] [PASSED]|[Update]|[Monitor=true]|[Description=Update the cluster Monitor enable] [PASSED]|[No-Failover]|[HA=Connection Stress;ComponentName=mysql]|[Description=Simulates conditions where pods experience connection stress either due to expected/undesired processes thereby testing the application's resilience to potential slowness/unavailability of some replicas due to high Connection load.] [PASSED]|[Reconfiguring]|[ComponentName=mysql;binlog_expire_logs_seconds=691200]|[Description=Reconfiguring the cluster specify component mysql set binlog_expire_logs_seconds=691200] [PASSED]|[No-Failover]|[HA=DNS Error;Durations=2m;ComponentName=mysql]|[Description=Simulates conditions where pods experience DNS service errors for a period of time either due to expected/undesired processes thereby testing the application's resilience to potential slowness/unavailability of some replicas due to DNS service errors.] [PASSED]|[Stop]|[-]|[Description=Stop the cluster] [PASSED]|[Start]|[-]|[Description=Start the cluster] [PASSED]|[Restart]|[-]|[Description=Restart the cluster] [PASSED]|[No-Failover]|[HA=Network Partition;Durations=2m;ComponentName=mysql]|[Description=Simulates network partition fault thereby testing the application's resilience to potential slowness/unavailability of some replicas due to partition network.] [PASSED]|[No-Failover]|[HA=Network Delay;Durations=2m;ComponentName=mysql]|[Description=Simulates network delay fault thereby testing the application's resilience to potential slowness/unavailability of some replicas due to delay network.] [PASSED]|[Failover]|[HA=Network Corrupt;Durations=2m;ComponentName=mysql]|[Description=Simulates network corrupt fault thereby testing the application's resilience to potential slowness/unavailability of some replicas due to corrupt network.] [PASSED]|[No-Failover]|[HA=DNS Random;Durations=2m;ComponentName=mysql]|[Description=Simulates conditions where pods experience random IP addresses being returned by the DNS service for a period of time either due to expected/undesired processes thereby testing the application's resilience to potential slowness/unavailability of some replicas due to the DNS service returning random IP addresses.] [PASSED]|[VolumeExpansion]|[ComponentName=mysql]|[Description=VolumeExpansion the cluster specify component mysql] [PASSED]|[No-Failover]|[HA=Full CPU;Durations=2m;ComponentName=mysql]|[Description=Simulates conditions where pods experience CPU full either due to expected/undesired processes thereby testing the application's resilience to potential slowness/unavailability of some replicas due to high CPU load.] [PASSED]|[VerticalScaling]|[ComponentName=mysql]|[Description=VerticalScaling the cluster specify component mysql] [PASSED]|[No-Failover]|[HA=Network Loss;Durations=2m;ComponentName=mysql]|[Description=Simulates network loss fault thereby testing the application's resilience to potential slowness/unavailability of some replicas due to loss network.] [PASSED]|[Failover]|[HA=OOM;Durations=2m;ComponentName=mysql]|[Description=Simulates conditions where pods experience OOM either due to expected/undesired processes thereby testing the application's resilience to potential slowness/unavailability of some replicas due to high Memory load.] [PASSED]|[No-Failover]|[HA=Time Offset;Durations=2m;ComponentName=mysql]|[Description=Simulates a time offset scenario thereby testing the application's resilience to potential slowness/unavailability of some replicas due to time offset.] [PASSED]|[Bench]|[HostType=LB;ComponentName=mysql]|[Description=Bench the cluster LB service with mysql component] [PASSED]|[No-Failover]|[HA=Network Duplicate;Durations=2m;ComponentName=mysql]|[Description=Simulates network duplicate fault thereby testing the application's resilience to potential slowness/unavailability of some replicas due to duplicate network.] [PASSED]|[Failover]|[HA=Network Bandwidth;Durations=2m;ComponentName=mysql]|[Description=Simulates network bandwidth fault thereby testing the application's resilience to potential slowness/unavailability of some replicas due to bandwidth network.] [PASSED]|[Update]|[TerminationPolicy=WipeOut]|[Description=Update the cluster TerminationPolicy WipeOut] [PASSED]|[Backup]|[BackupMethod=xtrabackup]|[Description=The cluster xtrabackup Backup] [PASSED]|[Restore]|[BackupMethod=xtrabackup]|[Description=The cluster xtrabackup Restore] [PASSED]|[Connect]|[ComponentName=mysql]|[Description=Connect to the cluster] [PASSED]|[Delete Restore Cluster]|[BackupMethod=xtrabackup]|[Description=Delete the xtrabackup restore cluster] [PASSED]|[Backup]|[Schedule=true;BackupMethod=xtrabackup]|[Description=The cluster Schedule xtrabackup Backup] [PASSED]|[Restore]|[Schedule=true;BackupMethod=xtrabackup]|[Description=The cluster Schedule xtrabackup Restore] [PASSED]|[Connect]|[ComponentName=mysql]|[Description=Connect to the cluster] [PASSED]|[Delete Restore Cluster]|[Schedule=true;BackupMethod=xtrabackup]|[Description=Delete the Schedule xtrabackup restore cluster] [PASSED]|[Expose]|[Disable=true;TYPE=internet;ComponentName=mysql]|[Description=Expose Disable the internet service with mysql component] [PASSED]|[Delete]|[-]|[Description=Delete the cluster] [END]