{"id":69226,"date":"2026-01-31T09:08:52","date_gmt":"2026-01-31T01:08:52","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/69226.html"},"modified":"2026-01-31T09:08:52","modified_gmt":"2026-01-31T01:08:52","slug":"mysql-operator-for-kubernetes%e8%87%aa%e5%8a%a8%e5%ae%9e%e7%8e%b0%e6%95%b4%e4%b8%aa%e7%94%9f%e5%91%bd%e5%91%a8%e6%9c%9f","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/69226.html","title":{"rendered":"MySQL Operator for Kubernetes\u81ea\u52a8\u5b9e\u73b0\u6574\u4e2a\u751f\u547d\u5468\u671f"},"content":{"rendered":"

\u5b98\u7f51\u5730\u5740：MySQL :: MySQL Operator for Kubernetes Manual<\/p>\n

\u5f00\u6e90\u5730\u5740：mysql\/mysql-operator: MySQL Operator for Kubernetes<\/p>\n

\u4e00\u3001\u5f15\u8a00\u4e0e\u4ecb\u7ecd<\/h2>\n

MySQL Operator for Kubernetes \u662f Kubernetes \u751f\u6001\u4e2d\u4e13\u4e3a MySQL \u8bbe\u8ba1\u7684\u4e13\u5c5e\u8fd0\u7ef4\u5de5\u5177，\u6838\u5fc3\u57fa\u4e8eCRD（\u81ea\u5b9a\u4e49\u8d44\u6e90） \u5b9e\u73b0，\u65e8\u5728\u5f7b\u5e95\u7b80\u5316 MySQL InnoDB Cluster \u7684\u90e8\u7f72\u3001\u8fd0\u7ef4\u4e0e\u6269\u5c55，\u5176\u6838\u5fc3\u903b\u8f91\u4e0e\u7ec4\u4ef6\u4ef7\u503c\u53ef\u901a\u8fc7\u4e09\u5c42\u6e05\u6670\u62c6\u89e3：<\/p>\n

1. \u57fa\u7840\u6838\u5fc3<\/h3>\n

\u6574\u4e2a\u65b9\u6848\u7684\u8fd0\u4f5c\u8d77\u70b9\u662f Kubernetes \u7684 CRD \u6269\u5c55 \u2014\u2014InnoDBCluster \u4f5c\u4e3a\u81ea\u5b9a\u4e49\u8d44\u6e90，\u4e3a MySQL \u96c6\u7fa4\u63d0\u4f9b\u4e86\u6807\u51c6\u5316\u7684\u914d\u7f6e\u5165\u53e3\u3002\u7528\u6237\u53ea\u9700\u5b9a\u4e49InnoDBCluster\u8d44\u6e90\u7684 yaml \u6e05\u5355（\u6307\u5b9a\u5b9e\u4f8b\u6570\u91cf\u3001\u914d\u7f6e\u53c2\u6570\u7b49），\u63d0\u4ea4\u81f3 K8s \u96c6\u7fa4\u540e，\u4fbf\u4f1a\u6210\u4e3a Operator \u7684 \u201c\u64cd\u4f5c\u6307\u4ee4\u201d，\u6240\u6709\u540e\u7eed\u7684\u96c6\u7fa4\u642d\u5efa\u3001\u7ef4\u62a4\u52a8\u4f5c，\u5747\u7531 Operator \u57fa\u4e8e\u8be5 CRD \u8d44\u6e90\u7684\u72b6\u6001\u89e6\u53d1，\u8fd9\u662f\u5b9e\u73b0\u96c6\u7fa4\u81ea\u52a8\u5316\u7ba1\u7406\u7684\u6838\u5fc3\u57fa\u7840\u3002<\/p>\n

2. \u6838\u5fc3\u7ec4\u4ef6<\/h3>\n

（1）MySQL Operator：\u96c6\u7fa4\u7684 \u201c\u81ea\u52a8\u5316\u7ba1\u5bb6\u201d<\/h4>\n

\u4f5c\u4e3a\u65b9\u6848\u7684\u6838\u5fc3\u6267\u884c\u8005，Operator \u8fd0\u884c\u4e8e K8s \u96c6\u7fa4\u7684mysql-operator\u547d\u540d\u7a7a\u95f4（\u9ed8\u8ba4），\u901a\u8fc7 Kubernetes Deployment \u4fdd\u969c\u81ea\u8eab\u9ad8\u53ef\u7528\u3002\u5176\u6838\u5fc3\u4f5c\u7528\u662f\u6301\u7eed\u76d1\u542cInnoDBCluster\u81ea\u5b9a\u4e49\u8d44\u6e90\u7684\u72b6\u6001\u53d8\u5316：\u4e00\u65e6\u68c0\u6d4b\u5230\u8d44\u6e90\u521b\u5efa\u3001\u66f4\u65b0\u6216\u5f02\u5e38，\u4fbf\u81ea\u52a8\u89e6\u53d1\u4e00\u7cfb\u5217\u8fd0\u7ef4\u64cd\u4f5c \u2014\u2014 \u5305\u62ec\u521b\u5efa\u7ba1\u7406 MySQL \u670d\u52a1\u5668\u7684 StatefulSet（\u7ed1\u5b9a\u5b58\u50a8\u5377\u3001\u914d\u7f6e\u5bb9\u5668\u7ec4）\u3001\u90e8\u7f72 MySQL Router\u3001\u751f\u6210 ConfigMap（MySQL \u914d\u7f6e）\u4e0e Secret（\u8ba4\u8bc1\u51ed\u8bc1），\u540c\u65f6\u81ea\u52a8\u914d\u7f6e MySQL Group Replication \u5b9e\u73b0\u6570\u636e\u540c\u6b65，\u5168\u7a0b\u65e0\u9700\u4eba\u5de5\u4ecb\u5165\u590d\u6742\u914d\u7f6e\u3002<\/p>\n

（2）InnoDB Cluster：\u6570\u636e\u5e93\u96c6\u7fa4\u7684 \u201c\u6838\u5fc3\u5b9e\u4f53\u201d<\/h4>\n

InnoDBCluster\u4e0d\u4ec5\u662f CRD \u8d44\u6e90\u540d\u79f0，\u66f4\u662f\u5b9e\u9645\u8fd0\u884c\u7684 MySQL \u6570\u636e\u5e93\u96c6\u7fa4\u6838\u5fc3 \u2014\u2014 \u7531\u4e00\u7ec4 MySQL \u670d\u52a1\u5668（Primary\/Secondary \u8282\u70b9）\u7ec4\u6210，\u901a\u8fc7 Operator \u914d\u7f6e\u7684 Group Replication \u5b9e\u73b0\u6570\u636e\u5b9e\u65f6\u540c\u6b65，\u5929\u7136\u5177\u5907\u9ad8\u53ef\u7528\u7279\u6027\u3002\u5b83\u662f\u5b58\u50a8\u6570\u636e\u3001\u5904\u7406\u4e1a\u52a1\u8bf7\u6c42\u7684\u6838\u5fc3\u8f7d\u4f53，Operator \u901a\u8fc7\u7ef4\u62a4\u5176\u8282\u70b9\u72b6\u6001\u3001\u590d\u5236\u94fe\u8def，\u786e\u4fdd\u96c6\u7fa4\u7a33\u5b9a\u8fd0\u884c，\u907f\u514d\u5355\u70b9\u6545\u969c\u3002<\/p>\n

（3）MySQL Router：\u5e94\u7528\u4e0e\u96c6\u7fa4\u7684 \u201c\u667a\u80fd\u7f51\u5173\u201d<\/h4>\n

MySQL Router \u662f Operator \u81ea\u52a8\u90e8\u7f72\u7684\u65e0\u72b6\u6001\u8def\u7531\u7ec4\u4ef6（\u901a\u8fc7 K8s Deployment \u7ba1\u7406，\u652f\u6301\u5f39\u6027\u6269\u7f29\u5bb9）\u3002\u5176\u6838\u5fc3\u4f5c\u7528\u662f\u4f5c\u4e3a\u5e94\u7528\u4e0e InnoDB Cluster \u4e4b\u95f4\u7684\u4e2d\u95f4\u5c42：\u4e00\u65b9\u9762\u4e3a\u5e94\u7528\u63d0\u4f9b\u7a33\u5b9a\u7684\u8bbf\u95ee\u5165\u53e3（\u901a\u8fc7 K8s Service \u66b4\u9732），\u5c4f\u853d\u96c6\u7fa4\u8282\u70b9\u62d3\u6251\u53d8\u5316；\u53e6\u4e00\u65b9\u9762\u6839\u636e\u5e94\u7528\u9700\u6c42\u667a\u80fd\u8def\u7531\u8bf7\u6c42 \u2014\u2014 \u5c06\u5199\u8bf7\u6c42\u8f6c\u53d1\u81f3 Primary \u8282\u70b9，\u8bfb\u8bf7\u6c42\u5206\u53d1\u81f3 Secondary \u8282\u70b9，\u65e2\u7b80\u5316\u4e86\u5e94\u7528\u8fde\u63a5\u914d\u7f6e，\u53c8\u5b9e\u73b0\u4e86\u8bfb\u5199\u5206\u79bb\u4e0e\u8d1f\u8f7d\u5747\u8861\u3002<\/p>\n

3. \u6838\u5fc3\u4ef7\u503c<\/h3>\n

\u501f\u52a9 CRD \u7684\u6807\u51c6\u5316\u914d\u7f6e\u4e0e Operator \u7684\u81ea\u52a8\u5316\u7ba1\u7406，\u5f00\u53d1\u8005\u65e0\u9700\u6df1\u5165 MySQL \u5e95\u5c42\u8fd0\u7ef4\u7ec6\u8282，\u4ec5\u901a\u8fc7\u5b9a\u4e49InnoDBCluster\u8d44\u6e90\u5373\u53ef\u5feb\u901f\u642d\u5efa\u9ad8\u53ef\u7528 MySQL \u96c6\u7fa4；\u800c MySQL Router \u7684\u8def\u7531\u80fd\u529b\u4e0e InnoDB Cluster \u7684\u590d\u5236\u673a\u5236，\u65e2\u786e\u4fdd\u4e86\u5e94\u7528\u8bbf\u95ee\u7684\u7a33\u5b9a\u6027（\u65e0\u9700\u5173\u5fc3\u8282\u70b9\u5207\u6362），\u53c8\u652f\u6301\u6839\u636e\u4e1a\u52a1\u8d1f\u8f7d\u5f39\u6027\u6269\u5c55，\u5b8c\u7f8e\u9002\u914d Kubernetes \u7684\u5bb9\u5668\u5316\u3001\u4e91\u539f\u751f\u573a\u666f\u3002<\/p>\n

Kubernetes\u7684MySQL\u4f5c\u7b26\u67b6\u6784\u56fe<\/p>\n

\"\"<\/p>\n

\u672c\u6587\u91c7\u7528\u5b8c\u5168\u8d44\u6e90\u6e05\u5355\u7684\u65b9\u5f0f\u53bb\u90e8\u7f72，\u56e0\u4e3aHelm\u6211\u6ca1\u770b\u5230\u5b98\u65b9\u7684\u4e00\u4e2a\u5b9a\u4e49，\u627e\u4e0d\u5230\u6807\u51c6\u7684\u8d44\u6e90\u955c\u50cf，\u7136\u540e\u6211\u5c31\u61d2\u5f97\u53bbinstall Chart\u5305\u53bb\u4fee\u6539values\u4e0b\u9762\u7684\u955c\u50cftag\u4e86，\u7d22\u6027\u76f4\u63a5\u4f7f\u7528\u8d44\u6e90\u6e05\u5355\u90e8\u7f72\u4e86\u3002<\/p>\n

\u5c31\u6bd4\u5982\u6211\u8981\u90e8\u7f728.4.8-2.1.10\u7248\u672c\u7684Chart，\u7136\u540e\u6211\u8981\u53bb\u63d0\u524d\u62c9\u53d6\u955c\u50cf\u561b\u3002（\u56e0\u4e3a\u6211\u7b2c\u4e00\u6b21\u4e5f\u662f\u76f4\u63a5helm install \u4f46\u662f\u53d1\u73b0\u62c9\u53d6\u7684\u955c\u50cf\u662f8.4.8）<\/p>\n

\"\"<\/p>\n

\u6211\u5c31\u767b\u5f55\u5230\u4e86Oracle Container Registry\u4ed3\u5e93，\u4f46\u662f\u6ca1\u6709\u627e\u52308.4.8-2.1.10\u7684\u955c\u50cf，\u7136\u540e\u6211\u8fd8\u6ca1\u6709\u627e\u5230\u5b98\u65b9\u7684Helm\u7684\u5b9a\u4e49，\u6211\u5c31\u6ca1\u6709\u4e0b\u8f7d8.4.8\u7684chart\u7136\u540e\u4fee\u6539\u955c\u50cf\u4e3a8.4.7，\u6211\u6015CRD\u5230\u65f6\u5019\u4f1a\u6709\u4e0d\u517c\u5bb9\u4e4b\u7c7b\u7684\u60c5\u51b5，\u6240\u4ee5\u8fd9\u91cc\u5c31\u76f4\u63a5\u4f7f\u75288.4.7\u53bb\u90e8\u7f72\u4e86\u4e00\u5957\u81ea\u52a8\u5316\u67b6\u6784\u3002<\/p>\n

\"\"<\/p>\n

\u96be\u9053\u5728\u4e0d\u540c\u7684\u4ed3\u5e93？\u672c\u4eba\u6ca1\u7814\u7a76\u8fd9\u4e2a\u67b6\u6784\u592a\u957f\u65f6\u95f4，\u6709\u61c2\u5f97\u53ef\u4ee5\u89e3\u91ca\u4e00\u4e0b\u3002<\/p>\n

\u4e8c\u3001 \u67b6\u6784\u7684\u5b9e\u73b0<\/h2>\n

\u672c\u6587\u91c7\u7528\u7684\u6240\u6709\u8d44\u6e90\u6807\u51c6\u5747\u4e3a\u81ea\u5df1\u7684\u5b9e\u9a8c\u73af\u5883，\u8bf7\u751f\u6210\u73af\u5883\u81ea\u52a9\u8c03\u6574\u8d44\u6e90\u914d\u7f6e\u5927\u5c0f\u3002<\/p>\n<\/p>\n

\u8d44\u6e90\u6e05\u5355\u65b9\u5f0f\u5b89\u88c58.4.7mysql-operator\/deploy at 8.4.7-2.1.9 \u00b7 mysql\/mysql-operator<\/p>\n

2.1. \u5b89\u88c5Operator\u4e0eCRD\u8d44\u6e90<\/h3>\n

[root@k8s-master ~\/mysql-operator]# kubectl apply -f https:\/\/github.com\/mysql\/mysql-operator\/blob\/8.4.7-2.1.9\/deploy\/deploy-crds.yaml
\n[root@k8s-master ~\/mysql-operator]# kubectl apply -f https:\/\/github.com\/mysql\/mysql-operator\/blob\/8.4.7-2.1.9\/deploy\/deploy-operator.yaml<\/p>\n

[root@k8s-master ~\/mysql-operator]# kubectl -n mysql-operator get all -o wide
\nNAME READY STATUS RESTARTS AGE IP NODE NOMINATED NODE READINESS GATES
\npod\/mysql-operator-6c49944b64-fmbwq 1\/1 Running 0 18s 10.200.36.75 k8s-node1 <none> <none><\/p>\n

NAME READY UP-TO-DATE AVAILABLE AGE CONTAINERS IMAGES SELECTOR
\ndeployment.apps\/mysql-operator 1\/1 1 1 18s mysql-operator container-registry.oracle.com\/mysql\/community-operator:8.4.7-2.1.9 name=mysql-operator<\/p>\n

NAME DESIRED CURRENT READY AGE CONTAINERS IMAGES SELECTOR
\nreplicaset.apps\/mysql-operator-6c49944b64 1 1 1 18s mysql-operator container-registry.oracle.com\/mysql\/community-operator:8.4.7-2.1.9 name=mysql-operator,pod-template-hash=6c49944b64 <\/p>\n

\u5f69\u86cb：\u955c\u50cf\u62c9\u53d6\u65b9\u6cd5<\/h3>\n

\u767b\u5f55Oracle Container Registry：Oracle Container Registry<\/p>\n

\"\"<\/p>\n

\u767b\u5f55\u5b8c\u6210\u70b9\u51fb\u53f3\u4e0a\u89d2Auth Token\u53bb\u65b0\u5efaToken<\/p>\n

\"\"<\/p>\n

\u7136\u540e\u5c06\u81ea\u5df1\u751f\u6210\u7684Token\u590d\u5236\u4fdd\u5b58\u4e0b\u6765\u3002<\/p>\n

\"\"<\/p>\n

\u8bb0\u4f4f\u62f7\u8d1d\u81ea\u5df1\u7684Secret<\/p>\n

ehaR9Dqba1cbkYxcMpfJ <\/p>\n

docker\u767b\u5f55\u955c\u50cf\u4ed3\u5e93<\/p>\n

[root@k8s-master ~]# docker login container-registry.oracle.com
\nUsername: 914XXXXX@qq.com
\nPassword: # \u8f93\u5165\u81ea\u5df1\u751f\u6210\u7684Secret\u4f5c\u4e3a\u5bc6\u7801<\/p>\n

WARNING! Your credentials are stored unencrypted in '\/root\/.docker\/config.json'.
\nConfigure a credential helper to remove this warning. See
\nhttps:\/\/docs.docker.com\/go\/credential-store\/<\/p>\n

Login Succeeded<\/p>\n

# \u62c9\u53d6\u955c\u50cf\u5373\u53ef，\u6ce8\u610fK8S\u96c6\u7fa4\u6700\u597d\u90fd\u5b58\u5728\u6b64\u955c\u50cf\u3002
\n[root@k8s-master ~]# docker pull container-registry.oracle.com\/mysql\/community-operator:8.4.7-2.1.9
\n8.4.7-2.1.9: Pulling from mysql\/community-operator
\n034ed5741540: Pull complete
\n8850e9060076: Pull complete
\n72a19e97697b: Pull complete
\ncb8069ff2565: Pull complete
\n20b9802feff4: Pull complete
\n3290b0b94ed1: Pull complete
\ncea3ba72d0c2: Pull complete
\nDigest: sha256:f04a98bba815c33f649a802a1669f85ebe5ead4dcb54264babd8749b70b056f2
\nStatus: Downloaded newer image for container-registry.oracle.com\/mysql\/community-operator:8.4.7-2.1.9
\ncontainer-registry.oracle.com\/mysql\/community-operator:8.4.7-2.1.9
\n[root@k8s-master ~]# docker pull container-registry.oracle.com\/mysql\/community-router:8.4.7
\n8.4.7: Pulling from mysql\/community-router
\n63ce17d7402e: Pull complete
\nc1796c1f2872: Pull complete
\nb54c084a1ded: Pull complete
\nDigest: sha256:b1d63a7ee895db71d9c763085192a378958d2cc5bf3ec6a2a1feb9f21652d9ba
\nStatus: Downloaded newer image for container-registry.oracle.com\/mysql\/community-router:8.4.7
\ncontainer-registry.oracle.com\/mysql\/community-router:8.4.7 <\/p>\n

2.2.\u00a0\u90e8\u7f72InnoDBCluster+Router<\/h3>\n

\u8981\u7528 kubectl \u521b\u5efa InnoDB \u96c6\u7fa4， \u9996\u5148\u521b\u5efa\u4e00\u4e2a\u5305\u542b\u65b0MySQL\u51ed\u8bc1\u7684\u79d8\u5bc6 root \u7528\u6237，\u4e00\u4e2a\u540d\u4e3a\u201cmy-root-secret\u201d\u7684\u79d8\u5bc6\u793a\u4f8b：<\/p>\n

[root@k8s-master ~\/mysql-operator]# kubectl create ns mysql-cluster
\nnamespace\/mysql-cluster created
\n[root@k8s-master ~\/mysql-operator]# kubectl create secret generic my-root-secret \\\\
\n –from-literal=rootUser=root \\\\
\n –from-literal=rootHost=% \\\\
\n –from-literal=rootPassword='String@1307!' \\\\
\n –namespace mysql-cluster
\nsecret\/my-root-secret created <\/p>\n

\u7528\u65b0\u521b\u5efa\u7684\u7528\u6237\u914d\u7f6e\u65b0\u7684MySQL InnoDB\u96c6\u7fa4\u3002\u8fd9\u4e2a\u4f8b\u5b50\u662fInnoDBCluster\u5b9a\u4e49 \u521b\u5efa\u4e09\u4e2a MySQL \u670d\u52a1\u5668\u5b9e\u4f8b\u548c\u4e24\u4e2a MySQL \u8def\u7531\u5668\u5b9e\u4f8b：<\/p>\n

[root@k8s-master ~\/mysql-operator\/resource-yaml]# cat mysql-innodb-cluster.yaml
\napiVersion: mysql.oracle.com\/v2
\nkind: InnoDBCluster
\nmetadata:
\n name: my-cluster
\n namespace: mysql-cluster
\nspec:
\n version: "8.4.7"
\n instances: 3
\n secretName: my-root-secret
\n edition: community
\n tlsUseSelfSigned: true<\/p>\n

# — 1. \u5907\u4efd\u7b56\u7565\u914d\u7f6e (\u5173\u952e\u4fee\u590d\u70b9) —
\n backupProfiles:
\n – name: nfs-profile
\n dumpInstance:
\n storage:
\n # \u5fc5\u987b\u4f7f\u7528\u5168\u79f0
\n persistentVolumeClaim:
\n claimName: mysql-backup-pvc<\/p>\n

# — 2. \u6570\u636e\u5e93\u53c2\u6570\u4f18\u5316 (\u9488\u5bf9 4G \u5185\u5b58\u73af\u5883) —
\n mycnf: |
\n [mysqld]
\n # \u9650\u5236\u5185\u5b58\u6c60\u4e3a 512M，\u7ed9\u7cfb\u7edf\u7559\u4f59\u5730
\n innodb_buffer_pool_size=512M
\n # \u5f00\u542f\u6027\u80fd\u76d1\u63a7\u4ee5\u652f\u6301 InnoDB \u96c6\u7fa4
\n performance_schema=ON
\n max_connections=150
\n innodb_log_file_size=128M
\n binlog_expire_logs_seconds=604800
\n # \u51cf\u5c11\u6587\u4ef6\u7cfb\u7edf\u7f13\u5b58\u538b\u529b
\n innodb_flush_method=O_DIRECT<\/p>\n

# — 3. \u8d44\u6e90\u914d\u989d (QoS) —
\n podSpec:
\n resources:
\n limits:
\n cpu: "500m"
\n memory: "1.5Gi"
\n requests:
\n cpu: "100m"
\n memory: "512Mi"<\/p>\n

# — 4. \u6570\u636e\u5b58\u50a8\u914d\u7f6e —
\n datadirVolumeClaimTemplate:
\n storageClassName: "nfs-csi"
\n accessModes:
\n – ReadWriteOnce
\n resources:
\n requests:
\n storage: 10Gi<\/p>\n

# — 5. \u8bfb\u5199\u5206\u79bb Router \u914d\u7f6e —
\n router:
\n instances: 2
\n podSpec:
\n # \u5f3a\u5236\u8c03\u5ea6\u5230\u6253\u8fc7\u6807\u7b7e\u7684\u8282\u70b9
\n nodeSelector:
\n mysql-router: "true"
\n containers:
\n – name: router
\n image: container-registry.oracle.com\/mysql\/community-router:8.4.7
\n imagePullPolicy: IfNotPresent
\n resources:
\n requests:
\n cpu: "100m"
\n memory: "128Mi"
\n limits:
\n cpu: "200m"
\n memory: "256Mi" <\/p>\n

\u5728\u628a\u5907\u4efd\u8981\u7528\u5230\u4e86PV\u7ed9\u521b\u5efa\u51fa\u6765<\/p>\n

[root@k8s-master ~\/mysql-operator\/resource-yaml]# cat mysql-backup-pvc.yaml
\napiVersion: v1
\nkind: PersistentVolumeClaim
\nmetadata:
\n name: mysql-backup-pvc
\n namespace: mysql-cluster
\nspec:
\n # \u786e\u4fdd\u8fd9\u91cc\u7528\u7684\u662f\u4f60\u96c6\u7fa4\u91cc\u6b63\u786e\u7684 NFS StorageClass \u540d\u5b57
\n storageClassName: "nfs-csi"
\n accessModes:
\n – ReadWriteMany # \u63a8\u8350：NFS \u4e00\u822c\u652f\u6301\u591a\u8bfb\u5199，\u65b9\u4fbf\u67e5\u770b
\n resources:
\n requests:
\n storage: 10Gi <\/p>\n

\u7136\u540e\u5c06\u8d44\u6e90\u7ed9\u521b\u5efa\u51fa\u6765<\/p>\n

[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl apply -f mysql-backup-pvc.yaml
\n[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl get -f mysql-backup-pvc.yaml
\nNAME STATUS VOLUME CAPACITY ACCESS MODES STORAGECLASS VOLUMEATTRIBUTESCLASS AGE
\nmysql-backup-pvc Bound pvc-2c7017a9-75ef-4523-94c9-dfcf6a30b819 10Gi RWX nfs-csi <unset> 3m37s <\/p>\n

\u6ce8\u610f，\u5728\u521b\u5efaInnoDBCluster\u4e4b\u524d，\u8bf7\u5c06\u4e24\u4e2a\u8981\u90e8\u7f72Router\u7684\u8282\u70b9\u6253\u4e0a\u5bf9\u5e94\u7684\u6807\u7b7e，\u6765\u65b9\u4fbf\u5206\u8282\u70b9\u8c03\u5ea6\u3002<\/p>\n

[root@k8s-master ~]# kubectl label nodes k8s-node1 mysql-router=true
\nnode\/k8s-node1 labeled
\n[root@k8s-master ~]# kubectl label nodes k8s-node2 mysql-router=true
\nnode\/k8s-node2 labeled
\n[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl apply -f mysql-innodb-cluster.yaml <\/p>\n

[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl -n mysql-cluster get po,pv,pvc -o wide
\nNAME READY STATUS RESTARTS AGE IP NODE NOMINATED NODE READINESS GATES
\npod\/my-cluster-0 2\/2 Running 0 4m37s 10.200.36.82 k8s-node1 <none> 2\/2
\npod\/my-cluster-1 2\/2 Running 0 4m37s 10.200.36.81 k8s-node1 <none> 2\/2
\npod\/my-cluster-2 2\/2 Running 0 4m37s 10.200.169.167 k8s-node2 <none> 2\/2
\npod\/my-cluster-router-67fd998b7-6m865 1\/1 Running 0 2m39s 10.200.36.83 k8s-node1 <none> <none>
\npod\/my-cluster-router-67fd998b7-xrrx7 1\/1 Running 0 2m39s 10.200.169.168 k8s-node2 <none> <none><\/p>\n

NAME CAPACITY ACCESS MODES RECLAIM POLICY STATUS CLAIM STORAGECLASS VOLUMEATTRIBUTESCLASS REASON AGE VOLUMEMODE
\npersistentvolume\/pvc-2c7017a9-75ef-4523-94c9-dfcf6a30b819 10Gi RWX Delete Bound mysql-cluster\/mysql-backup-pvc nfs-csi <unset> 4m50s Filesystem
\npersistentvolume\/pvc-4df4cd5a-35c8-40de-a500-922ebfd8dc2d 10Gi RWO Delete Bound mysql-cluster\/datadir-my-cluster-2 nfs-csi <unset> 4m36s Filesystem
\npersistentvolume\/pvc-c0d0a765-00bd-4d4c-be94-2f2f79d7acc4 10Gi RWO Delete Bound mysql-cluster\/datadir-my-cluster-1 nfs-csi <unset> 4m36s Filesystem
\npersistentvolume\/pvc-e5d7e917-d24e-4835-9798-03de85a6c054 10Gi RWO Delete Bound mysql-cluster\/datadir-my-cluster-0 nfs-csi <unset> 4m37s Filesystem<\/p>\n

NAME STATUS VOLUME CAPACITY ACCESS MODES STORAGECLASS VOLUMEATTRIBUTESCLASS AGE VOLUMEMODE
\npersistentvolumeclaim\/datadir-my-cluster-0 Bound pvc-e5d7e917-d24e-4835-9798-03de85a6c054 10Gi RWO nfs-csi <unset> 4m37s Filesystem
\npersistentvolumeclaim\/datadir-my-cluster-1 Bound pvc-c0d0a765-00bd-4d4c-be94-2f2f79d7acc4 10Gi RWO nfs-csi <unset> 4m37s Filesystem
\npersistentvolumeclaim\/datadir-my-cluster-2 Bound pvc-4df4cd5a-35c8-40de-a500-922ebfd8dc2d 10Gi RWO nfs-csi <unset> 4m37s Filesystem
\npersistentvolumeclaim\/mysql-backup-pvc Bound pvc-2c7017a9-75ef-4523-94c9-dfcf6a30b819 10Gi RWX nfs-csi <unset> 4m50s Filesystem<\/p>\n

# \u786e\u4fdd\u4e09\u4e2a\u90fd\u5df2\u7ecf\u5728\u7ebf\u5373\u53ef
\n[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl -n mysql-cluster get innodbclusters.mysql.oracle.com
\nNAME STATUS ONLINE INSTANCES ROUTERS AGE
\nmy-cluster ONLINE 3 3 2 4m58s <\/p>\n

\u8d44\u6e90\u521b\u5efa\u5b8c\u6210\u4e4b\u540e\u53ef\u4ee5\u67e5\u770b\u5bf9\u5e94\u7684\u6570\u636e\u76ee\u5f55\u662f\u5426\u4ee5\u53ca\u521d\u59cb\u5316\u5230\u4e86\u6570\u636e<\/p>\n

# \u67e5\u770b\u6570\u636e\u76ee\u5f55
\n[root@k8s-master ~\/mysql-operator\/resource-yaml]# cd \/data\/nfs-server\/pvc-4df4cd5a-35c8-40de-a500-922ebfd8dc2d\/
\n[root@k8s-master \/data\/nfs-server\/pvc-4df4cd5a-35c8-40de-a500-922ebfd8dc2d]# ll
\ntotal 135792
\n-rw-r—– 1 27 sudo 4194304 Jan 27 10:29 '#ib_16384_0.dblwr'
\n-rw-r—– 1 27 sudo 12582912 Jan 27 09:46 '#ib_16384_1.dblwr'
\ndrwxr-s— 2 27 sudo 4096 Jan 27 09:47 '#innodb_redo'\/
\ndrwxr-s— 2 27 sudo 4096 Jan 27 09:47 '#innodb_temp'\/
\n-rw-r—– 1 27 sudo 0 Jan 27 09:48 GCS_DEBUG_TRACE
\n-rw-r—– 1 27 sudo 56 Jan 27 09:46 auto.cnf
\n-rw——- 1 27 sudo 1705 Jan 27 09:46 ca-key.pem
\n-rw-r–r– 1 27 sudo 1108 Jan 27 09:46 ca.pem
\n-rw-r–r– 1 27 sudo 1108 Jan 27 09:46 client-cert.pem
\n-rw——- 1 27 sudo 1705 Jan 27 09:46 client-key.pem
\n-rw-r—– 1 27 sudo 5721 Jan 27 09:47 ib_buffer_pool
\n-rw-r—– 1 27 sudo 12582912 Jan 27 10:29 ibdata1
\n-rw-r—– 1 27 sudo 12582912 Jan 27 09:47 ibtmp1
\n-rw-r—– 1 27 sudo 236 Jan 27 09:48 my-cluster-2-relay-bin-group_replication_applier.000001
\n-rw-r—– 1 27 sudo 15400214 Jan 27 10:29 my-cluster-2-relay-bin-group_replication_applier.000002
\n-rw-r—– 1 27 sudo 116 Jan 27 09:48 my-cluster-2-relay-bin-group_replication_applier.index
\n-rw-r—– 1 27 sudo 158 Jan 27 09:48 my-cluster-2-relay-bin-group_replication_recovery.000001
\n-rw-r—– 1 27 sudo 59 Jan 27 09:48 my-cluster-2-relay-bin-group_replication_recovery.index
\n-rw-r—– 1 27 sudo 2 Jan 27 09:47 my-cluster-2.pid
\n-rw-r—– 1 27 sudo 181 Jan 27 09:46 my-cluster.000001
\n-rw-r—– 1 27 sudo 181 Jan 27 09:47 my-cluster.000002
\n-rw-r—– 1 27 sudo 15528012 Jan 27 10:29 my-cluster.000003
\n-rw-r—– 1 27 sudo 60 Jan 27 09:47 my-cluster.index
\ndrwxr-s— 2 27 sudo 4096 Jan 27 09:46 mysql\/
\n-rw-r—– 1 27 sudo 32505856 Jan 27 10:29 mysql.ibd
\ndrwxr-s— 2 27 sudo 4096 Jan 27 09:48 mysql_innodb_cluster_metadata\/
\n-rw-r—– 1 27 sudo 124 Jan 27 09:46 mysql_upgrade_history
\n-rw-r—– 1 27 sudo 1771 Jan 27 09:48 mysqld-auto.cnf
\ndrwxr-s— 2 27 sudo 4096 Jan 27 09:48 performance_schema\/
\n-rw——- 1 27 sudo 1705 Jan 27 09:46 private_key.pem
\n-rw-r–r– 1 27 sudo 452 Jan 27 09:46 public_key.pem
\n-rw-r–r– 1 27 sudo 1108 Jan 27 09:46 server-cert.pem
\n-rw——- 1 27 sudo 1705 Jan 27 09:46 server-key.pem
\ndrwxr-s— 2 27 sudo 4096 Jan 27 09:46 sys\/
\n-rw-r—– 1 27 sudo 16777216 Jan 27 10:29 undo_001
\n-rw-r—– 1 27 sudo 16777216 Jan 27 10:29 undo_002 <\/p>\n

2.3 \u5c06Router\u66b4\u9732\u51fa\u53bb<\/h3>\n

# \u521b\u5efaRoute\u7684SVC\u7aef\u53e3\u66b4\u9732，\u53ef\u4ee5\u5728\u5916\u90e8\u4f7f\u7528\u56fe\u5f62\u5316\u5de5\u5177\u76f4\u63a5\u8fd0\u7ef4
\n[root@k8s-master ~\/mysql-operator\/resource-yaml]# cat mysql-route-svc.yaml
\napiVersion: v1
\nkind: Service
\nmetadata:
\n name: my-cluster-router-lb
\n namespace: mysql-cluster
\n labels:
\n app.kubernetes.io\/name: my-cluster-router-lb
\nspec:
\n type: NodePort
\n selector:
\n app.kubernetes.io\/component: router
\n app.kubernetes.io\/name: mysql-router
\n ports:
\n – name: mysql-rw
\n port: 30306
\n targetPort: 6446
\n nodePort: 30306 # \u8bfb\u5199\u7aef\u53e3\u66b4\u9732\u7ed9\u5916\u90e8
\n – name: mysql-ro
\n port: 30307
\n targetPort: 6447
\n nodePort: 30307 # \u53ea\u8bfb\u7aef\u53e3\u66b4\u9732\u7ed9\u5916\u90e8
\n sessionAffinity: None<\/p>\n

[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl apply -f mysql-route-svc.yaml
\nservice\/my-cluster-router-lb created
\n[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl -n mysql-cluster get svc
\nNAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE
\nmy-cluster ClusterIP 10.110.26.7 <none> 3306\/TCP,33060\/TCP,6446\/TCP,6448\/TCP,6447\/TCP,6449\/TCP,6450\/TCP,8443\/TCP 13m
\nmy-cluster-instances ClusterIP None <none> 3306\/TCP,33060\/TCP,33061\/TCP 13m
\nmy-cluster-router-lb NodePort 10.102.39.114 <none> 30306:30306\/TCP,30307:30307\/TCP 7s <\/p>\n

\u6d4b\u8bd5\u8fde\u63a5<\/p>\n

[root@k8s-master ~\/mysql-operator\/resource-yaml]# telnet 10.0.0.6 30306
\nTrying 10.0.0.6…
\nConnected to 10.0.0.6.
\nEscape character is '^]'.
\nP
\n8.4.7-router~
\n b1\u07eenC1Cn,H$o8q~caching_sha2_password^]
\ntelnet> quit
\nConnection closed.
\n[root@k8s-master ~\/mysql-operator\/resource-yaml]# telnet 10.0.0.6 30307
\nTrying 10.0.0.6…
\nConnected to 10.0.0.6.
\nEscape character is '^]'.
\nP
\n8.4.7-routerAh@#N!W\u07eehPmW0Igu]^4!caching_sha2_password^]
\ntelnet> quit
\nConnection closed. <\/p>\n

\u4e5f\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528Navicat\u8fdb\u884c\u8fde\u63a5<\/p>\n

\"\"<\/p>\n

\u4e09\u3001\u5907\u4efd\u529f\u80fd<\/h2>\n

3.1 \u9a8c\u8bc1\u5907\u4efd（dumpInstance）<\/h3>\n

[root@k8s-master ~\/mysql-operator\/resource-yaml]# cat test-backup.yaml
\napiVersion: mysql.oracle.com\/v2
\nkind: MySQLBackup
\nmetadata:
\n name: test-backup-01
\n namespace: mysql-cluster
\nspec:
\n clusterName: my-cluster
\n # \u8fd9\u91cc\u5f15\u7528\u7684\u5c31\u662f\u6211\u4eec\u5728\u7b2c\u4e09\u6b65\u91cc\u5b9a\u4e49\u7684 profile \u540d\u5b57
\n backupProfileName: nfs-profile<\/p>\n

# \u67e5\u770b\u5907\u4efd\u72b6\u6001
\n[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl -n mysql-cluster get mysqlbackups.mysql.oracle.com -w
\nNAME CLUSTER STATUS OUTPUT AGE
\ntest-backup-01 my-cluster 6s
\ntest-backup-01 my-cluster Running test-backup-01-20260127-022008 14s
\ntest-backup-01 my-cluster Completed test-backup-01-20260127-022008 16s <\/p>\n

\u627e\u5230\u5907\u4efd\u76ee\u5f55MySQL Operator \u4e3a\u4e86\u907f\u514d\u5907\u4efd\u6570\u636e\u4e22\u5931，\u8bbe\u8ba1\u4e0a\u4f1a\u4e3a\u6bcf\u4e00\u6b21\u5907\u4efd\u751f\u6210\u4e00\u4e2a\u552f\u4e00\u7684\u76ee\u5f55\u540d，\u683c\u5f0f\u901a\u5e38\u662f：{\u5907\u4efd\u540d\u79f0}-{\u65e5\u671f}-{\u65f6\u95f4\u6233}\u3002<\/p>\n

[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl get pv -n mysql-cluster
\nNAME CAPACITY ACCESS MODES RECLAIM POLICY STATUS CLAIM STORAGECLASS VOLUMEATTRIBUTESCLASS REASON AGE
\npvc-2c7017a9-75ef-4523-94c9-dfcf6a30b819 10Gi RWX Delete Bound mysql-cluster\/mysql-backup-pvc nfs-csi <unset> 35m
\npvc-4df4cd5a-35c8-40de-a500-922ebfd8dc2d 10Gi RWO Delete Bound mysql-cluster\/datadir-my-cluster-2 nfs-csi <unset> 34m
\npvc-c0d0a765-00bd-4d4c-be94-2f2f79d7acc4 10Gi RWO Delete Bound mysql-cluster\/datadir-my-cluster-1 nfs-csi <unset> 34m
\npvc-e5d7e917-d24e-4835-9798-03de85a6c054 10Gi RWO Delete Bound mysql-cluster\/datadir-my-cluster-0 nfs-csi <unset> 34m
\n[root@k8s-master ~\/mysql-operator\/resource-yaml]# cd \/data\/nfs-server\/pvc-2c7017a9-75ef-4523-94c9-dfcf6a30b819\/test-backup-01-20260127-022008\/
\n[root@k8s-master \/data\/nfs-server\/pvc-2c7017a9-75ef-4523-94c9-dfcf6a30b819\/test-backup-01-20260127-022008]# ll
\ntotal 308
\n-rw-r—– 1 27 sudo 1504 Jan 27 10:20 @.done.json
\n-rw-r—– 1 27 sudo 1352 Jan 27 10:20 @.json
\n-rw-r—– 1 27 sudo 293 Jan 27 10:20 @.post.sql
\n-rw-r—– 1 27 sudo 293 Jan 27 10:20 @.sql
\n-rw-r—– 1 27 sudo 10021 Jan 27 10:20 @.users.sql
\n-rw-r—– 1 27 sudo 2937 Jan 27 10:20 mysql_innodb_cluster_metadata.json
\n-rw-r—– 1 27 sudo 25611 Jan 27 10:20 mysql_innodb_cluster_metadata.sql
\n-rw-r—– 1 27 sudo 819 Jan 27 10:20 mysql_innodb_cluster_metadata@async_cluster_members.json
\n-rw-r—– 1 27 sudo 1271 Jan 27 10:20 mysql_innodb_cluster_metadata@async_cluster_members.sql
\n-rw-r—– 1 27 sudo 9 Jan 27 10:20 mysql_innodb_cluster_metadata@async_cluster_members@@0.tsv.zst
\n-rw-r—– 1 27 sudo 8 Jan 27 10:20 mysql_innodb_cluster_metadata@async_cluster_members@@0.tsv.zst.idx
\n-rw-r—– 1 27 sudo 830 Jan 27 10:20 mysql_innodb_cluster_metadata@async_cluster_views.json
\n-rw-r—– 1 27 sudo 1235 Jan 27 10:20 mysql_innodb_cluster_metadata@async_cluster_views.sql
\n-rw-r—– 1 27 sudo 9 Jan 27 10:20 mysql_innodb_cluster_metadata@async_cluster_views@@0.tsv.zst
\n-rw-r—– 1 27 sudo 8 Jan 27 10:20
\n…… <\/p>\n

\u5907\u4efd\u6ca1\u6709\u95ee\u9898，\u7136\u540e\u5c31\u53ef\u4ee5\u5c06\u914d\u7f6e\u4e2d\u4fee\u6539\u4e3a\u5b9a\u65f6\u5907\u4efd\u3002apply\u4e00\u4e0b\u751f\u6548\u5373\u53ef\u3002<\/p>\n

# \u4fee\u6539mysql-innodb-cluster.yaml\u914d\u7f6e\u4e0b\u9762\u7684\u5907\u4efd\u914d\u7f6e
\n…<\/p>\n

backupProfiles:
\n – name: nfs-profile
\n # \u65b0\u589e：\u5b9a\u65f6\u5907\u4efd\u7684 cron \u8868\u8fbe\u5f0f（\u6bcf\u5929\u51cc\u66682\u70b9）
\n schedule: "0 2 * * *"
\n # \u5907\u4efd\u7c7b\u578b（dumpInstance \u8868\u793a\u903b\u8f91\u5907\u4efd）
\n dumpInstance:
\n storage:
\n # \u7ed1\u5b9a\u5df2\u521b\u5efa\u7684 PVC（\u5fc5\u987b\u7528\u5168\u79f0 persistentVolumeClaim，\u4e0d\u80fd\u7b80\u5199）
\n persistentVolumeClaim:
\n claimName: mysql-backup-pvc
\n # \u53ef\u9009：\u5907\u4efd\u4fdd\u7559\u7b56\u7565（\u907f\u514d\u5907\u4efd\u6587\u4ef6\u5360\u6ee1\u5b58\u50a8）
\n retention:
\n # \u4fdd\u7559\u6700\u8fd17\u5929\u7684\u5907\u4efd
\n days: 7
\n… <\/p>\n

3.2 \u6570\u636e\u6062\u590d\u8bbe\u8ba1<\/h3>\n

\u5b98\u65b9\u63a8\u8350\u6570\u636e\u6062\u590d：\u4f60\u9700\u8981\u521b\u5efa\u4e00\u4e2a\u5168\u65b0\u7684 InnoDBCluster，\u5e76\u5728\u521b\u5efa\u65f6\u544a\u8bc9\u5b83：\u201c\u8bf7\u7528\u8fd9\u4e2a\u5907\u4efd\u521d\u59cb\u5316\u81ea\u5df1\u201d\u3002 \u6838\u5fc3\u5b57\u6bb5\u662f spec.initDB\u3002<\/p>\n

apiVersion: mysql.oracle.com\/v2
\nkind: InnoDBCluster
\nmetadata:
\n name: my-cluster-restored # \u3010\u6ce8\u610f\u3011\u5fc5\u987b\u662f\u4e2a\u65b0\u540d\u5b57，\u4e0d\u80fd\u548c\u65e7\u96c6\u7fa4\u51b2\u7a81
\n namespace: mysql-cluster
\nspec:
\n version: "8.4.7"
\n instances: 3
\n router:
\n instances: 1
\n secretName: my-root-secret<\/p>\n

# — \u6838\u5fc3\u6062\u590d\u914d\u7f6e —
\n initDB:
\n dump:
\n name: nfs-backup-final-20260126-xxx # \u8fd9\u91cc\u586b\u4f60 NFS \u76ee\u5f55\u4e0b\u5177\u4f53\u7684\u90a3\u4e2a\u6587\u4ef6\u5939\u540d\u5b57
\n storage:
\n persistentVolumeClaim:
\n claimName: mysql-backup-pvc # \u6307\u5411\u5b58\u653e\u5907\u4efd\u7684\u90a3\u4e2a PVC <\/p>\n

\u4e3a\u4ec0\u4e48\u8fd9\u79cd\u65b9\u5f0f\u66f4\u597d？<\/p>\n

  • \n

    \u5b89\u5168：\u65e7\u96c6\u7fa4（\u6848\u53d1\u73b0\u573a）\u88ab\u4fdd\u7559\u4e0b\u6765\u4e86，\u5982\u679c\u6062\u590d\u5931\u8d25，\u4f60\u8fd8\u6709\u673a\u4f1a\u53bb\u65e7\u96c6\u7fa4\u91cc\u62a2\u6551\u6570\u636e\u3002<\/p>\n<\/li>\n

  • \n

    \u539f\u5b50\u6027：\u65b0\u96c6\u7fa4\u542f\u52a8\u65f6，\u8981\u4e48\u662f\u6ee1\u8840\u590d\u6d3b\u7684\u72b6\u6001，\u8981\u4e48\u5c31\u662f\u542f\u52a8\u5931\u8d25，\u4e0d\u4f1a\u51fa\u73b0\u201c\u6570\u636e\u6062\u590d\u4e86\u4e00\u534a\u201d\u7684\u5c34\u5c2c\u72b6\u6001\u3002<\/p>\n<\/li>\n

    3.3 MySQL shell\u6062\u590d（loadDump）<\/h3>\n

    MySQL :: MySQL Shell 8.4 :: 3.1 MySQL Shell Commands<\/p>\n

    \u5982\u679c\u4f60\u4e0d\u60f3\u6539\u540d\u5b57（\u56e0\u4e3a\u4e1a\u52a1\u4ee3\u7801\u53ef\u80fd\u5199\u6b7b\u4e86\u8fde\u63a5\u5730\u5740），\u6216\u8005 initDB \u65b9\u5f0f\u62a5\u9519（\u6709\u65f6\u5019 Operator \u5bf9 PVC \u7684\u6302\u8f7d\u8def\u5f84\u652f\u6301\u6709 Bug），\u90a3\u4e48\u6700\u7a33\u3001\u6700\u65e0\u89c6\u7248\u672c\u5dee\u5f02\u7684\u65b9\u6cd5，\u624b\u52a8 MySQL Shell \u5bfc\u5165\u6cd5\u3002<\/p>\n

    \u6e05\u7406\u65e7\u6570\u636e（\u614e\u7528）：<\/p>\n

    \u5982\u679c\u786e\u5b9a\u65e7\u6570\u636e\u4e0d\u8981\u4e86，\u76f4\u63a5\u8fdb\u6570\u636e\u5e93\u5220\u5e93，\u6216\u8005\u91cd\u5efa PVC\u3002 <\/p>\n

    \u7136\u540e\u4f7f\u7528NFS-Server\u7684\u5907\u4efd\u6062\u590d\u3002<\/p>\n

    mysqlsh -u root -p'String@1307!' -h 127.0.0.1 -P 30306 \\\\
    \n –util loadDump "\/data\/backup\/nfs-backup-final-xxx" \\\\
    \n –threads=4 \\\\
    \n –resetProgress <\/p>\n

    3.3 OCI\u5bf9\u8c61\u5b58\u50a8\u6062\u590d<\/h3>\n

    \u5728 MySQL Operator (8.4+) \u7684\u903b\u8f91\u4e2d，\u4ece OCI \u5bf9\u8c61\u5b58\u50a8\u6062\u590d\u548c\u4ece\u672c\u5730 PVC \u6062\u590d，\u4e0d\u4ec5\u64cd\u4f5c\u903b\u8f91\u4e0d\u540c，\u8fde\u80cc\u540e\u7684\u6280\u672f\u5b9e\u73b0\u90fd\u6709\u5f88\u5927\u5dee\u5f02\u3002<\/p>\n\n\u7ef4\u5ea6OCI Object Storage (\u5bf9\u8c61\u5b58\u50a8)PersistentVolumeClaim (\u4f60\u7684 NFS\/PV)<\/tr>\n\n\n\n\n\n
    \u6280\u672f\u8def\u5f84<\/td>\n\u771f\u6b63\u7684\u201c\u4e00\u952e\u6062\u590d\u201d<\/td>\n\u201c\u521d\u59cb\u5316\u201d\u6216\u201c\u624b\u52a8\u5bfc\u5165\u201d<\/td>\n<\/tr>\n
    Operator \u884c\u4e3a<\/td>\nOperator \u4f1a\u81ea\u52a8\u4e0b\u8f7d\u3001\u89e3\u538b\u3001\u6d41\u5f0f\u5bfc\u5165<\/td>\nOperator \u901a\u5e38\u53ea\u652f\u6301\u5728\u201c\u9996\u6b21\u542f\u52a8\u201d\u65f6\u6302\u8f7d<\/td>\n<\/tr>\n
    \u7075\u6d3b\u6027<\/td>\n\u652f\u6301\u4ece\u4e91\u7aef\u76f4\u63a5\u201c\u62c9\u53d6\u201d\u5230\u4efb\u4f55\u65b0\u96c6\u7fa4<\/td>\n\u4f9d\u8d56\u7269\u7406\u5377\u7684\u6302\u8f7d，\u8def\u5f84\u548c\u6743\u9650\u5f88\u6b7b\u677f<\/td>\n<\/tr>\n
    \u914d\u7f6e\u5b57\u6bb5<\/td>\n\u5b98\u65b9\u6587\u6863\u4e3b\u63a8 initDB.ociObjectStorage<\/td>\n\u5b98\u65b9\u6587\u6863\u5bf9 initDB.dump.persistentVolumeClaim \u63cf\u8ff0\u8f83\u5c11<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u5b98\u65b9（Oracle）\u7684\u903b\u8f91\u662f：\u5982\u679c\u4f60\u7528\u4ed6\u4eec\u7684\u4e91（OCI），\u5b83\u80fd\u5e2e\u4f60\u505a\u5f97\u975e\u5e38\u81ea\u52a8\u5316\u3002<\/p>\n

      \n
    • \n

      \u5bf9\u4e8e OCI：\u652f\u6301\u76f4\u63a5\u5728 InnoDBCluster \u8fd0\u884c\u65f6，\u901a\u8fc7\u67d0\u79cd\u89e6\u53d1\u673a\u5236\u6216\u8005 initDB \u5b8c\u7f8e\u62c9\u53d6\u3002<\/p>\n<\/li>\n

    • \n

      \u5bf9\u4e8e PVC：\u5b83\u66f4\u503e\u5411\u4e8e\u8ba4\u4e3a\u8fd9\u662f\u4e00\u4e2a\u201c\u5feb\u7167\u201d\u6216\u8005\u201c\u5bfc\u51fa\u76ee\u5f55\u201d\u3002\u6b63\u5982\u4f60\u770b\u5230\u7684，8.4 \u7248\u672c\u5220\u9664\u4e86 MySQLRestore \u8fd9\u79cd\u663e\u5f0f\u7684\u6062\u590d\u6307\u4ee4\u3002<\/p>\n<\/li>\n<\/ul>\n

      \u8fd9\u91cc\u7684OCIociObjectStorage \u53c2\u6570\u662f\u4e13\u4e3a\u7532\u9aa8\u6587\u4e91（Oracle Cloud Infrastructure）\u8bbe\u8ba1\u7684\u201c\u4eb2\u513f\u5b50\u201d\u529f\u80fd，\u5176\u4ed6\u4e91\u76ee\u524d\u6ca1\u6709\u8fd9\u79cd\u5f85\u9047，\u4f46\u662f\u4f60\u53ef\u4ee5\u5c06\u4f60\u7684\u5907\u4efd\u5b58\u50a8\u5230\u5176\u4ed6\u7684\u5bf9\u8c61\u5b58\u50a8\u4e0a\u3002<\/p>\n

      3.4\u00a0\u4f20\u7edf\u7684mysqldump\u548cXBK\u8fdb\u884c\u5907\u4efd<\/h3>\n

      \u4f46\u662f\u5907\u4efd\u65f6\u5fc5\u987b\u8fde 30307 (RO \u7aef\u53e3)：\u5229\u7528 Router \u7684\u8bfb\u5199\u5206\u79bb，\u628a\u5907\u4efd\u538b\u529b\u5378\u8f7d\u5230\u4ece\u5e93（Secondary）\u4e0a\u3002<\/p>\n

      \u65b9\u6848 A：\u4f7f\u7528 mysqldump（\u903b\u8f91\u5907\u4efd，\u6700\u7a33）<\/p>\n

      \u9002\u5408\u6570\u636e\u91cf\u5728 50G \u4ee5\u4e0b\u7684\u573a\u666f<\/p>\n

      mysqldump -u root -p'String@1307!' -h 127.0.0.1 -P 30307 \\\\
      \n –all-databases \\\\
      \n –single-transaction \\\\
      \n –triggers –routines –events \\\\
      \n –set-gtid-purged=ON \\\\
      \n –master-data=2 \\\\
      \n > \/data\/backup\/full_$(date +%F).sql <\/p>\n

      \u65b9\u6848 B：\u4f7f\u7528 Xtrabackup（\u7269\u7406\u5907\u4efd，\u6700\u5feb）<\/p>\n

      \u5982\u679c\u4f60\u7684\u6570\u636e\u8d85\u8fc7 100G，mysqldump \u6062\u590d\u592a\u6162，\u5efa\u8bae\u7528 XBK\u3002\u4f46\u5728 K8s \u4e2d，XBK \u65e0\u6cd5\u901a\u8fc7\u7f51\u7edc\u76f4\u63a5\u5907\u4efd，\u5b83\u9700\u8981\u7269\u7406\u63a5\u89e6\u6570\u636e\u6587\u4ef6<\/p>\n

      \u63a8\u8350\u505a\u6cd5（Sidecar \u6a21\u5f0f\u6216 CronJob）：<\/p>\n

    • \n

      \u521b\u5efa\u4e00\u4e2a\u4e34\u65f6 Pod，\u6302\u8f7d\u5176\u4e2d\u4e00\u4e2a\u4ece\u5e93（\u5982 my-cluster-2）\u7684 PVC\u3002<\/p>\n<\/li>\n

    • \n

      \u6216\u8005\u901a\u8fc7 kubectl exec \u8fdb\u5230\u4e00\u4e2a\u4ece\u5e93 Pod \u5185\u90e8\u6267\u884c：<\/p>\n<\/li>\n

      # \u8fdb\u5165\u4ece\u5e93\u6267\u884c，\u907f\u514d\u4e3b\u5e93 IO \u963b\u585e
      \nkubectl exec -it my-cluster-2 -n mysql-cluster — xtrabackup –backup \\\\
      \n –user=root –password='String@1307!' \\\\
      \n –target-dir=\/var\/lib\/mysql\/backup\/ <\/p>\n

      \u8003\u8651\u5230\u201c\u4e3b\u4ece\u5207\u6362\u201d\u7684\u7a33\u5065\u7b56\u7565<\/p>\n

      \u5728 K8s \u4e2d，Pod \u53ef\u80fd\u4f1a\u6f02\u79fb\u3002\u4e3a\u4e86\u786e\u4fdd\u5907\u4efd\u811a\u672c\u4e0d\u5931\u6548，\u81ea\u52a8\u5316\u811a\u672c\u5e94\u8be5\u8fd9\u6837\u5199：<\/p>\n

      \u903b\u8f91\u6d41：<\/p>\n

    • \n

      \u63a2\u6d4b\u8c01\u662f\u4ece\u5e93：\u901a\u8fc7 SQL select * from performance_schema.replication_group_members \u786e\u8ba4\u6210\u5458\u72b6\u6001\u3002<\/p>\n<\/li>\n

    • \n

      \u9501\u5b9a\u76ee\u6807：\u901a\u8fc7 Router \u7684 30307 \u7aef\u53e3\u8fdb\u884c\u8fde\u63a5\u3002\u5373\u4fbf\u53d1\u751f\u4e3b\u4ece\u5207\u6362，Router \u4f1a\u81ea\u52a8\u628a\u4f60\u7684\u5907\u4efd\u8bf7\u6c42\u5bfc\u5411\u65b0\u7684\u4ece\u5e93，\u811a\u672c\u65e0\u9700\u4fee\u6539 IP\u3002<\/p>\n<\/li>\n

    • \n

      \u5b9a\u671f\u6e05\u7406：\u5728 NFS \u4e0a\u4fdd\u7559\u6700\u8fd1 7 \u5929\u7684\u5907\u4efd\u3002<\/p>\n<\/li>\n

      \u5efa\u8bae\u7684\u5907\u4efd\u8ba1\u5212 (Crontab)<\/p>\n\n\u9891\u7387\u5907\u4efd\u65b9\u5f0f\u5b58\u50a8\u4f4d\u7f6e\u76ee\u7684<\/tr>\n\n\n\n\n
      \u6bcf 1 \u5c0f\u65f6<\/td>\n\u589e\u91cf\/\u65e5\u5fd7\u5907\u4efd<\/td>\nNFS<\/td>\n\u51cf\u5c11\u6570\u636e\u4e22\u5931\u7a97\u53e3<\/td>\n<\/tr>\n
      \u6bcf\u5929\u51cc\u6668 2 \u70b9<\/td>\nmysqldump \u5168\u91cf<\/td>\nNFS<\/td>\n\u957f\u671f\u5b58\u6863，\u5e94\u5bf9\u8bef\u5220\u5e93<\/td>\n<\/tr>\n
      \u6bcf\u5468\/\u6708<\/td>\nXtrabackup \u5168\u91cf<\/td>\n\u79bb\u7ebf\u5b58\u50a8<\/td>\n\u707e\u96be\u6027\u786c\u4ef6\u6545\u969c\u6062\u590d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      \u603b\u7ed3\u4e00\u53e5\u8bdd：\u5728 K8s \u91cc\u7528\u4f20\u7edf\u5de5\u5177，\u6838\u5fc3\u5c31\u662f\u201c\u8fde Router \u7684\u53ea\u8bfb\u7aef\u53e3\u505a\u5907\u4efd，\u8fde\u8bfb\u5199\u7aef\u53e3\u505a\u6062\u590d\u201d\u3002<\/p>\n

      \u56db\u3001\u9a8c\u8bc1\u96c6\u7fa4\u72b6\u6001<\/h2>\n

      4.1\u00a0\u67e5\u770b\u96c6\u7fa4\u72b6\u6001<\/h3>\n

      [root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl -n mysql-cluster exec -it my-cluster-0 — mysqlsh
      \nDefaulted container "sidecar" out of: sidecar, mysql, fixdatadir (init), initconf (init), initmysql (init)
      \nMySQL Shell 8.4.7<\/p>\n

      Copyright (c) 2016, 2025, Oracle and\/or its affiliates.
      \nOracle is a registered trademark of Oracle Corporation and\/or its affiliates.
      \nOther names may be trademarks of their respective owners.<\/p>\n

      Type '\\\\help' or '\\\\?' for help; '\\\\quit' to exit.<\/p>\n

      # \u8fde\u63a5\u96c6\u7fa4
      \n MySQL SQL > \\\\connect root@localhost
      \nCreating a session to 'root@localhost'
      \nPlease provide the password for 'root@localhost': ************
      \nFetching global names for auto-completion… Press ^C to stop.
      \nYour MySQL connection id is 17774 (X protocol)
      \nServer version: 8.4.7 MySQL Community Server – GPL
      \nNo default schema selected; type \\\\use <schema> to set one.<\/p>\n

      # \u6267\u884cSQL\u8bed\u53e5
      \n MySQL localhost:33060+ ssl SQL > show databases;
      \n+——————————-+
      \n| Database |
      \n+——————————-+
      \n| information_schema |
      \n| mysql |
      \n| mysql_innodb_cluster_metadata |
      \n| performance_schema |
      \n| sys |
      \n+——————————-+
      \n5 rows in set (0.0017 sec)<\/p>\n

      # \u5207\u6362\u8bed\u8a00\u7c7b\u578b
      \n MySQL localhost:33060+ ssl SQL > \\\\js
      \nSwitching to JavaScript mode…<\/p>\n

      # \u67e5\u770b\u96c6\u7fa4\u72b6\u6001
      \n MySQL localhost:33060+ ssl JS > dba.getCluster().status()
      \n{
      \n "clusterName": "my_cluster",
      \n "defaultReplicaSet": {
      \n "name": "default",
      \n "primary": "my-cluster-0.my-cluster-instances.mysql-cluster.svc.cluster.local:3306",
      \n "ssl": "REQUIRED",
      \n "status": "OK",
      \n "statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",
      \n "topology": {
      \n "my-cluster-0.my-cluster-instances.mysql-cluster.svc.cluster.local:3306": {
      \n "address": "my-cluster-0.my-cluster-instances.mysql-cluster.svc.cluster.local:3306",
      \n "memberRole": "PRIMARY",
      \n "mode": "R\/W",
      \n "readReplicas": {},
      \n "replicationLag": "applier_queue_applied",
      \n "role": "HA",
      \n "status": "ONLINE",
      \n "version": "8.4.7"
      \n },
      \n "my-cluster-1.my-cluster-instances.mysql-cluster.svc.cluster.local:3306": {
      \n "address": "my-cluster-1.my-cluster-instances.mysql-cluster.svc.cluster.local:3306",
      \n "memberRole": "SECONDARY",
      \n "mode": "R\/O",
      \n "readReplicas": {},
      \n "replicationLag": "applier_queue_applied",
      \n "role": "HA",
      \n "status": "ONLINE",
      \n "version": "8.4.7"
      \n },
      \n "my-cluster-2.my-cluster-instances.mysql-cluster.svc.cluster.local:3306": {
      \n "address": "my-cluster-2.my-cluster-instances.mysql-cluster.svc.cluster.local:3306",
      \n "memberRole": "SECONDARY",
      \n "mode": "R\/O",
      \n "readReplicas": {},
      \n "replicationLag": "applier_queue_applied",
      \n "role": "HA",
      \n "status": "ONLINE",
      \n "version": "8.4.7"
      \n }
      \n },
      \n "topologyMode": "Single-Primary"
      \n },
      \n "groupInformationSourceMember": "my-cluster-0.my-cluster-instances.mysql-cluster.svc.cluster.local:3306"
      \n}
      \n MySQL localhost:33060+ ssl JS > <\/p>\n

      4.2\u00a0\u6d4b\u8bd5\u4e3b\u4ece\u590d\u5236<\/h3>\n

      # \u4eceJS\u5207\u6362\u4e3aSQL\u8bed\u8a00
      \nMySQL localhost:33060+ ssl JS > \\\\sql
      \nSwitching to SQL mode… Commands end with ;
      \n— 1. \u521b\u5efa\u6570\u636e\u5e93
      \nCREATE DATABASE sync_test;<\/p>\n

      — 2. \u5207\u6362\u6570\u636e\u5e93
      \nUSE sync_test;<\/p>\n

      — 3. \u521b\u5efa\u8868
      \nCREATE TABLE users (
      \n id INT AUTO_INCREMENT PRIMARY KEY,
      \n name VARCHAR(50),
      \n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
      \n) ENGINE=InnoDB;<\/p>\n

      — 4. \u63d2\u5165\u4e00\u6761\u6570\u636e
      \nINSERT INTO users (name) VALUES ('Gemini_Test_Data');<\/p>\n

      — 5. \u67e5\u770b\u6570\u636e
      \n MySQL localhost:33060+ ssl sync_test SQL > SELECT * FROM users;
      \n+—-+——————+———————+
      \n| id | name | created_at |
      \n+—-+——————+———————+
      \n| 1 | Gemini_Test_Data | 2026-01-27 02:47:13 |
      \n+—-+——————+———————+
      \n1 row in set (0.0015 sec)
      \n# \u518d\u6253\u5f00\u4e00\u4e2a\u7a97\u53e3，\u8fde\u63a5\u4ece\u5e93\u67e5\u770b\u6570\u636e
      \n MySQL localhost:33060+ ssl SQL > SELECT * FROM sync_test.users;
      \n+—-+——————+———————+
      \n| id | name | created_at |
      \n+—-+——————+———————+
      \n| 1 | Gemini_Test_Data | 2026-01-27 02:47:13 |
      \n+—-+——————+———————+
      \n1 row in set (0.0008 sec)
      \n MySQL localhost:33060+ ssl
      \n\u4e3b\u8282\u70b9\u518d\u63d2\u5165\u6570\u636e\u7136\u540e\u4ece\u8282\u70b9\u67e5\u770b
      \n# master\u8282\u70b9
      \n MySQL localhost:33060+ ssl sync_test SQL > INSERT INTO sync_test.users (name) VALUES ('Illegal_Write');
      \nQuery OK, 1 row affected (0.0084 sec)
      \n MySQL localhost:33060+ ssl sync_test SQL > \\\\quit
      \nBye!
      \n#replicas\u8282\u70b9
      \n MySQL localhost:33060+ ssl SQL > SELECT * FROM sync_test.users;
      \n+—-+——————+———————+
      \n| id | name | created_at |
      \n+—-+——————+———————+
      \n| 1 | Gemini_Test_Data | 2026-01-27 02:47:13 |
      \n| 2 | Illegal_Write | 2026-01-27 02:49:20 |
      \n+—-+——————+———————+
      \n2 rows in set (0.0012 sec)
      \n MySQL localhost:33060+ ssl SQL > exit
      \n -> ^C
      \n MySQL localhost:33060+ ssl SQL > \\\\quit
      \nBye! <\/p>\n

      4.3 \u6d4b\u8bd5\u8bfb\u5199\u5206\u79bb<\/h3>\n

      \u7b2c\u4e00\u6b65：\u627e\u51c6\u7aef\u53e3<\/p>\n

      \u56e0\u4e3a\u76ee\u524d\u4f7f\u7528 NodePort \u66b4\u9732\u7684\u670d\u52a1，\u6bcf\u6b21\u91cd\u5efa\u7aef\u53e3\u53ef\u80fd\u4f1a\u53d8，\u6240\u4ee5\u5148\u786e\u8ba4\u4e00\u4e0b\u5f53\u524d\u7684\u7aef\u53e3\u6620\u5c04：<\/p>\n

      kubectl get svc -n mysql-cluster <\/p>\n

      \u8bf7\u91cd\u70b9\u770b my-cluster-router \u8fd9\u4e00\u884c，\u627e\u5230\u5bf9\u5e94\u7684\u6620\u5c04\u5173\u7cfb：<\/p>\n

        \n
      • \n

        RW \u7aef\u53e3 (\u8bfb\u5199)：\u627e\u5230\u6620\u5c04\u5230\u5bb9\u5668 6446 \u7684\u90a3\u4e2a\u7aef\u53e3（\u4f8b\u5982 30306）\u3002<\/p>\n<\/li>\n

      • \n

        RO \u7aef\u53e3 (\u53ea\u8bfb)：\u627e\u5230\u6620\u5c04\u5230\u5bb9\u5668 6447 \u7684\u90a3\u4e2a\u7aef\u53e3（\u4f8b\u5982 30307）\u3002<\/p>\n<\/li>\n<\/ul>\n

        \u7b2c\u4e8c\u6b65：\u9a8c\u8bc1\u201c\u8bfb\u5199\u7aef\u53e3\u201d (RW Port – 6446)<\/p>\n

        \u8fd9\u4e2a\u7aef\u53e3\u662f\u7ed9\u5199\u64cd\u4f5c\u7528\u7684，\u5b83\u5fc5\u987b\u59cb\u7ec8\u6307\u5411 Primary (\u4e3b\u8282\u70b9)\u3002\u6211\u4eec\u8fde\u67e5 3 \u6b21，\u5e94\u8be5\u6bcf\u6b21\u90fd\u8fd4\u56de\u540c\u4e00\u4e2a\u540d\u5b57\u3002<\/p>\n

        [root@k8s-master ~ ]# apt install -y mysql-client<\/p>\n

        # \u8bb0\u5f97\u66ff\u6362 -P \u540e\u9762\u7684\u7aef\u53e3\u4e3a\u4f60\u67e5\u5230\u7684 6446 \u6620\u5c04\u7aef\u53e3
        \n[root@k8s-master ~\/mysql-operator\/resource-yaml]# for i in {1..3}; do
        \n mysql -u root -p'String@1307!' -h 127.0.0.1 -P 30306 -e "select @@hostname;"
        \ndone
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-0 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-0 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-0 |
        \n+————–+ <\/p>\n

        \u2705 \u9884\u671f\u7ed3\u679c： \u8f93\u51fa\u7684 Hostname \u5b8c\u5168\u4e00\u6837（\u4f8b\u5982\u5168\u662f my-cluster-0）\u3002\u8fd9\u8bf4\u660e\u6d41\u91cf\u5f88\u7a33，\u6ca1\u4e71\u8dd1\u3002<\/p>\n

        \u7b2c\u4e09\u6b65：\u9a8c\u8bc1\u201c\u53ea\u8bfb\u7aef\u53e3\u201d (RO Port – 6447) \u2014\u2014 \u5173\u952e\u6b65\u9aa4<\/p>\n

        \u8fd9\u4e2a\u7aef\u53e3\u662f\u7ed9\u8bfb\u64cd\u4f5c\u7528\u7684，\u5b83\u5e94\u8be5\u5728\u6240\u6709 Secondary (\u4ece\u8282\u70b9) \u4e4b\u95f4\u505a\u8d1f\u8f7d\u5747\u8861\u3002\u6211\u4eec\u8fde\u67e5 5 \u6b21，\u5e94\u8be5\u770b\u5230\u540d\u5b57\u5728\u8f6e\u6362\u3002<\/p>\n

        [root@k8s-master ~\/mysql-operator\/resource-yaml]# # \u8bb0\u5f97\u66ff\u6362 -P \u540e\u9762\u7684\u7aef\u53e3\u4e3a\u4f60\u67e5\u5230\u7684 6447 \u6620\u5c04\u7aef\u53e3
        \nfor i in {1..5}; do
        \n mysql -u root -p'String@1307!' -h 127.0.0.1 -P 30307 -e "select @@hostname;"
        \ndone
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-2 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-1 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-2 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.<\/p>\n

        +————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-1 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-2 |
        \n+————–+ <\/p>\n

        \u2705 \u9884\u671f\u7ed3\u679c： \u8f93\u51fa\u7684 Hostname \u4f1a\u5728\u4e0d\u540c\u7684 Pod \u540d\u5b57\u4e4b\u95f4\u8df3\u53d8（\u4f8b\u5982 my-cluster-1 -> my-cluster-2 -> my-cluster-1…）\u3002<\/p>\n

        🎁 \u9644\u52a0\u9898：\u9a8c\u8bc1\u53ea\u8bfb\u5c5e\u6027 (\u9632\u8bef\u5199)<\/p>\n

        \u4e3a\u4e86\u8bc1\u660e RO \u7aef\u53e3\u771f\u7684\u662f\u201c\u53ea\u8bfb\u201d\u7684，\u54b1\u4eec\u5c1d\u8bd5\u5f80\u91cc\u9762\u63d2\u6570\u636e，\u770b\u770b\u5b83\u4f1a\u4e0d\u4f1a\u62a5\u9519\u3002<\/p>\n

        [root@k8s-master ~\/mysql-operator\/resource-yaml]# mysql -u root -p'String@1307!' -h 127.0.0.1 -P 30307 -e "create table test_db.should_fail(id int);"
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \nERROR 1290 (HY000) at line 1: The MySQL server is running with the –super-read-only option so it cannot execute this statement <\/p>\n

        \u6ca1\u95ee\u9898\u3002<\/p>\n

        4.4 \u6d4b\u8bd5\u9ad8\u53ef\u7528<\/h3>\n

        \u53ef\u4ee5\u770b\u5230\u76ee\u524dcluster-0\u662fPRIMARY\u72b6\u6001\u3002<\/p>\n

        MySQL localhost:33060+ ssl SQL > SELECT MEMBER_HOST, MEMBER_ROLE, MEMBER_STATE FROM performance_schema.replication_group_members;
        \n+——————————————————————-+————-+————–+
        \n| MEMBER_HOST | MEMBER_ROLE | MEMBER_STATE |
        \n+——————————————————————-+————-+————–+
        \n| my-cluster-1.my-cluster-instances.mysql-cluster.svc.cluster.local | SECONDARY | ONLINE |
        \n| my-cluster-0.my-cluster-instances.mysql-cluster.svc.cluster.local | PRIMARY | ONLINE |
        \n| my-cluster-2.my-cluster-instances.mysql-cluster.svc.cluster.local | SECONDARY | ONLINE |
        \n+——————————————————————-+————-+————–+
        \n3 rows in set (0.0007 sec) <\/p>\n

        \u6253\u5f00\u591a\u4e2a\u7a97\u53e3\u5b9e\u65f6\u76d1\u63a7MySQL-cluster\u548cinnoDBCluster\u7684\u72b6\u6001<\/p>\n

        [root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl -n mysql-cluster get po -w
        \nNAME READY STATUS RESTARTS AGE
        \nmy-cluster-0 2\/2 Running 0 67m
        \nmy-cluster-1 2\/2 Running 0 67m
        \nmy-cluster-2 2\/2 Running 0 67m
        \nmy-cluster-router-67fd998b7-6m865 1\/1 Running 0 65m
        \nmy-cluster-router-67fd998b7-xrrx7 1\/1 Running 0 65m
        \ntest-backup-01-20260127-022008-jjzzk 0\/1 Completed 0 34m<\/p>\n

        [root@k8s-master ~]# kubectl -n mysql-cluster get innodbclusters.mysql.oracle.com -w
        \nNAME STATUS ONLINE INSTANCES ROUTERS AGE
        \nmy-cluster ONLINE 3 3 2 68m<\/p>\n

        \u7136\u540e\u5728\u53e6\u5916\u7a97\u53e3\u76f4\u63a5delete\u6389Pod[\u6216\u8005\u76f4\u63a5\u5173\u673a\u4e5f\u884c]<\/p>\n

        [root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl get po -n mysql-cluster
        \nNAME READY STATUS RESTARTS AGE
        \nmy-cluster-0 2\/2 Running 0 68m
        \nmy-cluster-1 2\/2 Running 0 68m
        \nmy-cluster-2 2\/2 Running 0 68m
        \nmy-cluster-router-67fd998b7-6m865 1\/1 Running 0 66m
        \nmy-cluster-router-67fd998b7-xrrx7 1\/1 Running 0 66m
        \ntest-backup-01-20260127-022008-jjzzk 0\/1 Completed 0 35m
        \n[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl -n mysql-cluster delete po my-cluster-0
        \npod "my-cluster-0" deleted<\/p>\n

        \u7136\u540e\u6301\u7eed\u76d1\u63a7MySQL-cluster\u548cinnoDBCluster\u7684\u72b6\u6001，\u76f4\u5230\u96c6\u7fa4\u5728\u77ed\u671f\u5185\u81ea\u52a8\u6062\u590d\u6b63\u5e38<\/p>\n

        # Pod\u4ee5\u53ca\u81ea\u52a8\u6062\u590d
        \n[root@k8s-master ~\/mysql-operator\/resource-yaml]# kubectl -n mysql-cluster get po -w
        \nNAME READY STATUS RESTARTS AGE
        \nmy-cluster-0 2\/2 Running 0 67m
        \nmy-cluster-1 2\/2 Running 0 67m
        \nmy-cluster-2 2\/2 Running 0 67m
        \nmy-cluster-router-67fd998b7-6m865 1\/1 Running 0 65m
        \nmy-cluster-router-67fd998b7-xrrx7 1\/1 Running 0 65m
        \ntest-backup-01-20260127-022008-jjzzk 0\/1 Completed 0 34m
        \nmy-cluster-0 2\/2 Terminating 0 69m
        \nmy-cluster-0 2\/2 Terminating 0 69m
        \nmy-cluster-0 2\/2 Terminating 0 69m
        \nmy-cluster-0 2\/2 Terminating 0 69m
        \nmy-cluster-1 2\/2 Running 0 69m
        \nmy-cluster-1 2\/2 Running 0 69m
        \nmy-cluster-2 2\/2 Running 0 69m
        \nmy-cluster-2 2\/2 Running 0 69m
        \nmy-cluster-0 2\/2 Terminating 0 69m
        \nmy-cluster-1 2\/2 Running 0 69m
        \nmy-cluster-2 2\/2 Running 0 69m
        \nmy-cluster-0 2\/2 Terminating 0 70m
        \nmy-cluster-0 0\/2 Completed 0 70m
        \nmy-cluster-0 0\/2 Completed 0 70m
        \nmy-cluster-0 0\/2 Completed 0 70m
        \nmy-cluster-0 0\/2 Pending 0 0s
        \nmy-cluster-0 0\/2 Pending 0 0s
        \nmy-cluster-0 0\/2 Init:0\/3 0 0s
        \nmy-cluster-0 0\/2 Init:0\/3 0 0s
        \nmy-cluster-0 0\/2 Init:0\/3 0 0s
        \nmy-cluster-0 0\/2 Init:0\/3 0 1s
        \nmy-cluster-0 0\/2 Init:1\/3 0 5s
        \nmy-cluster-0 0\/2 Init:1\/3 0 8s
        \nmy-cluster-0 0\/2 Init:2\/3 0 10s
        \nmy-cluster-0 0\/2 PodInitializing 0 12s
        \nmy-cluster-0 1\/2 Running 0 19s
        \nmy-cluster-0 1\/2 Running 0 24s
        \nmy-cluster-0 1\/2 Running 0 25s
        \nmy-cluster-0 2\/2 Running 0 30s
        \n# InnoDB Cluster\u4e5f\u4ee5\u53ca\u6062\u590d
        \n[root@k8s-master ~]# kubectl -n mysql-cluster get innodbclusters.mysql.oracle.com -w
        \nNAME STATUS ONLINE INSTANCES ROUTERS AGE
        \nmy-cluster ONLINE 3 3 2 68m
        \nmy-cluster ONLINE 3 3 2 69m
        \nmy-cluster ONLINE_PARTIAL 2 3 2 69m
        \nmy-cluster ONLINE_PARTIAL 2 3 2 70m
        \nmy-cluster ONLINE 3 3 2 71m <\/p>\n

        \u518d\u6b21\u67e5\u770b\u4e3b\u4ece\u548c\u9ad8\u53ef\u7528\u7684\u5173\u7cfb，\u53ef\u4ee5\u770b\u5230cluster1\u53d8\u6210\u4e86\u65b0\u4e3b<\/p>\n

        MySQL localhost:33060+ ssl SQL > SELECT MEMBER_HOST, MEMBER_ROLE, MEMBER_STATE FROM performance_schema.replication_group_members;
        \n+——————————————————————-+————-+————–+
        \n| MEMBER_HOST | MEMBER_ROLE | MEMBER_STATE |
        \n+——————————————————————-+————-+————–+
        \n| my-cluster-1.my-cluster-instances.mysql-cluster.svc.cluster.local | PRIMARY | ONLINE |
        \n| my-cluster-0.my-cluster-instances.mysql-cluster.svc.cluster.local | SECONDARY | ONLINE |
        \n| my-cluster-2.my-cluster-instances.mysql-cluster.svc.cluster.local | SECONDARY | ONLINE |
        \n+——————————————————————-+————-+————–+
        \n3 rows in set (0.0009 sec) <\/p>\n

        4.5 \u68c0\u67e5\u96c6\u7fa4\u72b6\u6001<\/h3>\n

        \u68c0\u67e5\u8bfb\u5199\u5206\u79bb，\u6ca1\u6709\u95ee\u9898\u5373\u53ef\u3002<\/p>\n

        # \u8bfb\u5199\u5206\u79bb\u4f9d\u7136\u751f\u6548\u5c31\u6ca1\u6709\u95ee\u9898
        \n[root@k8s-master ~\/mysql-operator\/resource-yaml]# for i in {1..5}; do
        \n mysql -u root -p'String@1307!' -h 127.0.0.1 -P 30307 -e "select @@hostname;"
        \ndone
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-2 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-0 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-2 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-2 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-0 |
        \n+————–+
        \n[root@k8s-master ~\/mysql-operator\/resource-yaml]# for i in {1..3}; do
        \n mysql -u root -p'String@1307!' -h 127.0.0.1 -P 30306 -e "select @@hostname;"
        \ndone
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-1 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-1 |
        \n+————–+
        \nmysql: [Warning] Using a password on the command line interface can be insecure.
        \n+————–+
        \n| @@hostname |
        \n+————–+
        \n| my-cluster-1 |
        \n+————–+
        \n[root@k8s-master ~\/mysql-operator\/resource-yaml]#
        \n MySQL localhost:33060+ ssl JS > dba.getCluster().status()
        \n{
        \n "clusterName": "my_cluster",
        \n "defaultReplicaSet": {
        \n "name": "default",
        \n "primary": "my-cluster-1.my-cluster-instances.mysql-cluster.svc.cluster.local:3306",
        \n "ssl": "REQUIRED",
        \n "status": "OK",
        \n "statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",
        \n "topology": {
        \n "my-cluster-0.my-cluster-instances.mysql-cluster.svc.cluster.local:3306": {
        \n "address": "my-cluster-0.my-cluster-instances.mysql-cluster.svc.cluster.local:3306",
        \n "memberRole": "SECONDARY",
        \n "mode": "R\/O",
        \n "readReplicas": {},
        \n "replicationLag": "applier_queue_applied",
        \n "role": "HA",
        \n "status": "ONLINE",
        \n "version": "8.4.7"
        \n },
        \n "my-cluster-1.my-cluster-instances.mysql-cluster.svc.cluster.local:3306": {
        \n "address": "my-cluster-1.my-cluster-instances.mysql-cluster.svc.cluster.local:3306",
        \n "memberRole": "PRIMARY",
        \n "mode": "R\/W",
        \n "readReplicas": {},
        \n "replicationLag": "applier_queue_applied",
        \n "role": "HA",
        \n "status": "ONLINE",
        \n "version": "8.4.7"
        \n },
        \n "my-cluster-2.my-cluster-instances.mysql-cluster.svc.cluster.local:3306": {
        \n "address": "my-cluster-2.my-cluster-instances.mysql-cluster.svc.cluster.local:3306",
        \n "memberRole": "SECONDARY",
        \n "mode": "R\/O",
        \n "readReplicas": {},
        \n "replicationLag": "applier_queue_applied",
        \n "role": "HA",
        \n "status": "ONLINE",
        \n "version": "8.4.7"
        \n }
        \n },
        \n "topologyMode": "Single-Primary"
        \n },
        \n "groupInformationSourceMember": "my-cluster-1.my-cluster-instances.mysql-cluster.svc.cluster.local:3306"
        \n}
        \n MySQL localhost:33060+ ssl JS > \\\\quit
        \nBye! <\/p>\n

        \u4e94\u3001\u57fa\u7840\u8fd0\u7ef4MySQL Shell\u547d\u4ee4<\/h2>\n

        MySQL :: MySQL Shell 8.4<\/p>\n

        MySQL Shell \u662f Operator \u7684 \u201c\u5e95\u5c42\u6267\u884c\u5f15\u64ce\u201d，\u800c\u63a5\u89e6\u7684\u662f Operator \u5c01\u88c5\u540e\u7684 K8s CR\/Helm \u7b49 \u201c\u4e0a\u5c42\u8fd0\u7ef4\u63a5\u53e3\u201d\u3002<\/p>\n

        MySQL Operator \u5e95\u5c42\u51e0\u4e4e\u6240\u6709\u6838\u5fc3\u8fd0\u7ef4\u64cd\u4f5c，\u90fd\u662f\u901a\u8fc7\u8c03\u7528 MySQL Shell \u5b9e\u73b0\u7684，\u4f46\u4f60\u4f5c\u4e3a\u4f7f\u7528\u8005，\u65e5\u5e38\u8fd0\u7ef4\u5e76\u4e0d\u9700\u8981\u76f4\u63a5\u5199 MySQL Shell \u547d\u4ee4（\u9664\u975e\u662f\u624b\u52a8\u8c03\u8bd5 \/ \u6062\u590d\u8fd9\u7c7b\u7279\u6b8a\u573a\u666f）\u3002<\/p>\n

        5.1\u00a0\u6838\u5fc3\u8fde\u63a5\u4e0e\u4f1a\u8bdd\u7ba1\u7406<\/h3>\n\n\u547d\u4ee4（\u542b\u522b\u540d）\u6838\u5fc3\u529f\u80fd\u5b9e\u7528\u793a\u4f8b<\/tr>\n\n\n\n\n\n
        \\\\connect（\\\\c）<\/td>\n\u8fde\u63a5 MySQL \u5b9e\u4f8b（\u652f\u6301\u591a\u534f\u8bae）<\/td>\n\n

        \\\\c root@127.0.0.1:3306（\u7ecf\u5178\u534f\u8bae）；<\/p>\n

        \\\\c –mysqlx root@localhost:33060（X \u534f\u8bae）；<\/p>\n

        \\\\c –ssh root@192.168.1.100:22 root@localhost:3306（SSH \u96a7\u9053）<\/p>\n<\/td>\n<\/tr>\n

        \\\\reconnect<\/td>\n\u91cd\u65b0\u8fde\u63a5\u5f53\u524d\u5b9e\u4f8b（\u8fde\u63a5\u65ad\u5f00\u65f6\u7528）<\/td>\n\u76f4\u63a5\u8f93\u5165：\\\\reconnect<\/td>\n<\/tr>\n
        \\\\disconnect<\/td>\n\u65ad\u5f00\u5168\u5c40\u4f1a\u8bdd（\u4fdd\u7559 MySQL Shell \u4e0d\u9000\u51fa）<\/td>\n\u76f4\u63a5\u8f93\u5165：\\\\disconnect<\/td>\n<\/tr>\n
        \\\\status（\\\\s）<\/td>\n\u67e5\u770b\u5f53\u524d\u8fde\u63a5\u72b6\u6001（\u5b9e\u4f8b\u4fe1\u606f\u3001\u5b57\u7b26\u96c6\u3001 uptime \u7b49）<\/td>\n\u76f4\u63a5\u8f93\u5165：\\\\s<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        5.2 \u6a21\u5f0f\u5207\u6362\u4e0e\u811a\u672c\u6267\u884c（\u591a\u8bed\u8a00\u9002\u914d）<\/h3>\n\n\u547d\u4ee4\u6838\u5fc3\u529f\u80fd\u5b9e\u7528\u793a\u4f8b<\/tr>\n\n\n\n\n\n
        \\\\sql<\/td>\n\u5207\u6362\u5230 SQL \u6a21\u5f0f（\u6267\u884c\u6807\u51c6 SQL）<\/td>\n\u8f93\u5165 \\\\sql \u540e，\u76f4\u63a5\u5199 SQL：SELECT * FROM test.t1;<\/td>\n<\/tr>\n
        \\\\js<\/td>\n\u5207\u6362\u5230 JavaScript \u6a21\u5f0f（\u8c03\u7528 AdminAPI\/X DevAPI）<\/td>\n\u8f93\u5165 \\\\js \u540e，\u6267\u884c：dba.status()（\u96c6\u7fa4\u72b6\u6001）<\/td>\n<\/tr>\n
        \\\\py<\/td>\n\u5207\u6362\u5230 Python \u6a21\u5f0f（\u8bed\u6cd5\u9002\u914d Python）<\/td>\n\u8f93\u5165 \\\\py \u540e，\u6267\u884c：dba.get_cluster()<\/td>\n<\/tr>\n
        \\\\source（\\\\.\/source）<\/td>\n\u6267\u884c\u811a\u672c\u6587\u4ef6（\u6309\u5f53\u524d\u6a21\u5f0f\u89e3\u6790）<\/td>\n\\\\source \/tmp\/init.sql（SQL \u6a21\u5f0f\u6267\u884c SQL \u811a\u672c）；\\\\source \/tmp\/backup.js（JS \u6a21\u5f0f\u6267\u884c\u811a\u672c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        5.3\u00a0\u5907\u4efd\u6062\u590d\u4e0e\u96c6\u7fa4\u8fd0\u7ef4<\/h3>\n\n\u547d\u4ee4 \/ \u5de5\u5177\u7c7b\u6838\u5fc3\u529f\u80fd\u5b9e\u7528\u793a\u4f8b（\u7ed3\u5408\u4e4b\u524d\u573a\u666f）<\/tr>\n\n\n\n\n\n
        util.dumpInstance()<\/td>\n\u903b\u8f91\u5907\u4efd\u6574\u4e2a\u5b9e\u4f8b（Operator \u5907\u4efd\u5e95\u5c42\u547d\u4ee4）<\/td>\nJS \u6a21\u5f0f：util.dumpInstance('\/data\/backup', {threads:4})<\/td>\n<\/tr>\n
        util.loadDump()<\/td>\n\u6062\u590d dumpInstance \u5907\u4efd（\u9002\u914d Operator \u5907\u4efd\u6587\u4ef6）<\/td>\n\u547d\u4ee4\u884c\u76f4\u63a5\u6267\u884c：mysqlsh -u root -p'pass' –util loadDump \/data\/backup –threads=4<\/td>\n<\/tr>\n
        dba.createCluster()<\/td>\n\u521b\u5efa InnoDB Cluster（Operator \u96c6\u7fa4\u521d\u59cb\u5316\u5e95\u5c42\u547d\u4ee4）<\/td>\nJS \u6a21\u5f0f：dba.createCluster('mycluster')<\/td>\n<\/tr>\n
        dba.getCluster().status()<\/td>\n\u67e5\u770b\u96c6\u7fa4\u72b6\u6001（\u6545\u969c\u6392\u67e5\u7528）<\/td>\nJS \u6a21\u5f0f：var cluster = dba.getCluster(); cluster.status();<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        \u516d\u3001\u603b\u7ed3<\/h2>\n

        \u5728\u4e91\u539f\u751f\u6280\u672f\u5e2d\u5377\u5168\u7403\u7684\u5f53\u4e0b，\u6570\u636e\u5e93\u7684\u5bb9\u5668\u5316\u3001\u81ea\u52a8\u5316\u7ba1\u7406\u5df2\u6210\u4e3a\u4f01\u4e1a\u6570\u5b57\u5316\u8f6c\u578b\u7684\u6838\u5fc3\u9700\u6c42\u4e4b\u4e00，\u800c MySQL Operator for Kubernetes \u6b63\u662f\u4e3a\u89e3\u51b3\u8fd9\u4e00\u9700\u6c42\u800c\u751f\u7684\u6807\u6746\u65b9\u6848 \u2014\u2014 \u5b83\u4ee5 CRD（\u81ea\u5b9a\u4e49\u8d44\u6e90）\u4e3a\u5e95\u5c42\u57fa\u77f3，\u4e32\u8054\u8d77\u4ece\u90e8\u7f72\u3001\u8fd0\u7ef4\u3001\u9a8c\u8bc1\u5230\u6570\u636e\u5b89\u5168\u7684\u5168\u94fe\u8def\u80fd\u529b，\u5c06 MySQL \u7684\u9ad8\u53ef\u7528\u7279\u6027\u4e0e Kubernetes \u7684\u4e91\u539f\u751f\u4f18\u52bf\u6df1\u5ea6\u878d\u5408，\u4e3a MySQL \u96c6\u7fa4\u7ba1\u7406\u63d0\u4f9b\u4e86\u4e00\u5957\u6807\u51c6\u5316\u3001\u81ea\u52a8\u5316\u3001\u53ef\u6269\u5c55\u7684\u5b8c\u6574\u89e3\u51b3\u65b9\u6848\u3002<\/p>\n

        \u4ece\u6838\u5fc3\u903b\u8f91\u6765\u770b，\u6574\u5957\u65b9\u6848\u7684\u8bbe\u8ba1\u6781\u5177\u5de7\u601d：InnoDBCluster \u81ea\u5b9a\u4e49\u8d44\u6e90\u4f5c\u4e3a\u6807\u51c6\u5316\u914d\u7f6e\u5165\u53e3，\u8ba9\u7528\u6237\u65e0\u9700\u5173\u6ce8\u590d\u6742\u7684\u5e95\u5c42\u7ec6\u8282，\u4ec5\u901a\u8fc7\u7b80\u5355\u7684 YAML \u6e05\u5355\u5373\u53ef\u5b9a\u4e49\u96c6\u7fa4\u9700\u6c42；MySQL Operator \u626e\u6f14 \u201c\u81ea\u52a8\u5316\u7ba1\u5bb6\u201d \u7684\u6838\u5fc3\u89d2\u8272，\u6301\u7eed\u76d1\u542c CRD \u72b6\u6001\u53d8\u5316，\u81ea\u52a8\u5b8c\u6210 StatefulSet \u90e8\u7f72\u3001Group Replication \u914d\u7f6e\u3001Router \u642d\u5efa\u7b49\u4e00\u7cfb\u5217\u8fd0\u7ef4\u64cd\u4f5c，\u5168\u7a0b\u65e0\u9700\u4eba\u5de5\u4ecb\u5165；InnoDB Cluster \u4f5c\u4e3a\u6570\u636e\u5e93\u96c6\u7fa4\u7684 \u201c\u6838\u5fc3\u5b9e\u4f53\u201d，\u901a\u8fc7\u4e3b\u4ece\u590d\u5236\u5b9e\u73b0\u6570\u636e\u5b9e\u65f6\u540c\u6b65，\u5929\u7136\u89c4\u907f\u5355\u70b9\u6545\u969c；\u800c MySQL Router \u5219\u4ee5 \u201c\u667a\u80fd\u7f51\u5173\u201d \u8eab\u4efd，\u4e3a\u5e94\u7528\u63d0\u4f9b\u7a33\u5b9a\u8bbf\u95ee\u5165\u53e3\u4e0e\u8bfb\u5199\u5206\u79bb\u80fd\u529b，\u5b8c\u7f8e\u5c4f\u853d\u96c6\u7fa4\u62d3\u6251\u53d8\u5316\u5bf9\u4e0a\u5c42\u4e1a\u52a1\u7684\u5f71\u54cd\u3002\u8fd9\u56db\u5927\u6838\u5fc3\u8981\u7d20\u76f8\u4e92\u652f\u6491，\u6784\u5efa\u8d77\u4e00\u5957\u534f\u540c\u9ad8\u6548\u3001\u7a33\u5b9a\u53ef\u9760\u7684\u7ec4\u4ef6\u751f\u6001\u3002<\/p>\n

        \u5728\u843d\u5730\u5b9e\u8df5\u5c42\u9762，\u65b9\u6848\u7684\u6613\u7528\u6027\u4e0e\u5b9e\u7528\u6027\u5c24\u4e3a\u7a81\u51fa：\u67b6\u6784\u5b9e\u73b0\u9636\u6bb5，\u4ece Operator \u4e0e CRD \u7684\u5feb\u901f\u5b89\u88c5，\u5230 InnoDB Cluster \u4e0e Router \u7684\u4e00\u952e\u90e8\u7f72\u3001\u8def\u7531\u66b4\u9732，\u6d41\u7a0b\u7b80\u6d01\u6e05\u6670，\u914d\u5408\u955c\u50cf\u62c9\u53d6\u7b49\u5b9e\u7528\u5f69\u86cb，\u5927\u5e45\u964d\u4f4e\u4e86\u4e91\u539f\u751f\u65b0\u624b\u7684\u5165\u95e8\u95e8\u69db；\u6570\u636e\u5b89\u5168\u5c42\u9762，\u8986\u76d6 dumpInstance\/loadDump \u539f\u751f\u5de5\u5177\u3001OCI \u5bf9\u8c61\u5b58\u50a8\u5907\u4efd\u3001\u4f20\u7edf mysqldump \u4e0e XBK \u7b49\u591a\u79cd\u5907\u4efd\u6062\u590d\u65b9\u5f0f，\u65e2\u9002\u914d\u4e91\u539f\u751f\u573a\u666f，\u53c8\u517c\u5bb9\u4f20\u7edf\u8fd0\u7ef4\u4e60\u60ef，\u5168\u65b9\u4f4d\u4fdd\u969c\u6570\u636e\u4e0d\u4e22\u5931；\u96c6\u7fa4\u9a8c\u8bc1\u73af\u8282，\u901a\u8fc7\u96c6\u7fa4\u72b6\u6001\u67e5\u770b\u3001\u4e3b\u4ece\u590d\u5236\u6d4b\u8bd5\u3001\u8bfb\u5199\u5206\u79bb\u9a8c\u8bc1\u3001\u9ad8\u53ef\u7528\u6545\u969c\u6f14\u7ec3\u7b49\u5168\u65b9\u4f4d\u624b\u6bb5，\u5e2e\u52a9\u7528\u6237\u5feb\u901f\u786e\u8ba4\u96c6\u7fa4\u662f\u5426\u8fbe\u5230\u751f\u4ea7\u7ea7\u6807\u51c6；\u65e5\u5e38\u8fd0\u7ef4\u5c42\u9762，MySQL Shell \u63d0\u4f9b\u4e86\u7edf\u4e00\u7684\u547d\u4ee4\u96c6，\u6db5\u76d6\u8fde\u63a5\u7ba1\u7406\u3001\u6a21\u5f0f\u5207\u6362\u3001\u96c6\u7fa4\u8fd0\u7ef4\u3001\u5907\u4efd\u6062\u590d\u7b49\u6838\u5fc3\u80fd\u529b，\u4e14\u652f\u6301\u591a\u8bed\u8a00\u811a\u672c\u6267\u884c，\u663e\u8457\u964d\u4f4e\u4e86\u8fd0\u7ef4\u4eba\u5458\u7684\u5b66\u4e60\u6210\u672c\u4e0e\u64cd\u4f5c\u590d\u6742\u5ea6\u3002<\/p>\n

        \u66f4\u91cd\u8981\u7684\u662f，\u8fd9\u5957\u65b9\u6848\u5e76\u975e\u7b80\u5355\u7684 \u201c\u6280\u672f\u5806\u780c\u201d，\u800c\u662f\u771f\u6b63\u5207\u4e2d\u4e86\u5f00\u53d1\u8005\u4e0e\u8fd0\u7ef4\u4eba\u5458\u7684\u6838\u5fc3\u75db\u70b9：\u5f00\u53d1\u8005\u65e0\u9700\u6df1\u5165\u94bb\u7814 MySQL \u5e95\u5c42\u590d\u5236\u539f\u7406\u4e0e K8s \u8d44\u6e90\u8c03\u5ea6\u903b\u8f91，\u5373\u53ef\u5feb\u901f\u642d\u5efa\u9ad8\u53ef\u7528\u6d4b\u8bd5\u73af\u5883；\u8fd0\u7ef4\u4eba\u5458\u65e0\u9700\u9762\u5bf9\u7e41\u7410\u7684\u624b\u52a8\u914d\u7f6e\u4e0e\u6545\u969c\u6392\u67e5，\u5373\u53ef\u5b9e\u73b0\u96c6\u7fa4\u7684\u89c4\u6a21\u5316\u7ba1\u7406\u4e0e\u5f39\u6027\u6269\u5c55，\u5927\u5e45\u63d0\u5347\u8fd0\u7ef4\u6548\u7387\u3001\u964d\u4f4e\u4eba\u4e3a\u5931\u8bef\u98ce\u9669\u3002\u65e0\u8bba\u662f\u4e2d\u5c0f\u578b\u4f01\u4e1a\u7684\u8f7b\u91cf\u5316\u90e8\u7f72，\u8fd8\u662f\u5927\u578b\u4f01\u4e1a\u7684\u89c4\u6a21\u5316\u96c6\u7fa4\u7ba1\u7406，\u8fd9\u5957\u65b9\u6848\u90fd\u80fd\u51ed\u501f\u5176\u826f\u597d\u7684\u6269\u5c55\u6027\u4e0e\u9002\u914d\u6027\u7075\u6d3b\u5e94\u5bf9\u3002<\/p>\n

        \u603b\u800c\u8a00\u4e4b，MySQL Operator for Kubernetes \u4e0d\u4ec5\u662f\u4e00\u5957\u6570\u636e\u5e93\u7ba1\u7406\u5de5\u5177，\u66f4\u662f\u4e91\u539f\u751f\u65f6\u4ee3 MySQL \u9ad8\u53ef\u7528\u96c6\u7fa4\u7ba1\u7406\u7684 \u201c\u6700\u4f73\u5b9e\u8df5\u201d\u3002\u5b83\u4ee5\u81ea\u52a8\u5316\u7b80\u5316\u590d\u6742\u8fd0\u7ef4，\u4ee5\u6807\u51c6\u5316\u4fdd\u969c\u73af\u5883\u4e00\u81f4\u6027，\u4ee5\u591a\u573a\u666f\u9002\u914d\u6ee1\u8db3\u4e0d\u540c\u4e1a\u52a1\u9700\u6c42，\u8ba9 MySQL \u6570\u636e\u5e93\u5728\u5bb9\u5668\u5316\u751f\u6001\u4e2d\u5b9e\u73b0 \u201c\u5373\u90e8\u7f72\u3001\u5373\u53ef\u7528\u3001\u5373\u7a33\u5b9a\u201d，\u6210\u4e3a\u4f01\u4e1a\u5728\u4e91\u539f\u751f\u8f6c\u578b\u8def\u4e0a\u503c\u5f97\u4fe1\u8d56\u7684\u6570\u636e\u5e93\u7ba1\u7406\u4f18\u9009\u65b9\u6848\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

        \u5b98\u7f51\u5730\u5740：MySQL :: MySQL Operator for Kubernetes Manual \u5f00\u6e90\u5730\u5740：mysql\/mysql-operator: MySQL Operator for Kubernetes \u4e00\u3001\u5f15\u8a00\u4e0e\u4ecb\u7ecd
        \nMySQL Operator for Kubernetes \u662f Kubernetes \u751f\u6001\u4e2d\u4e13\u4e3a MySQL \u8bbe\u8ba1\u7684\u4e13\u5c5e\u8fd0\u7ef4\u5de5\u5177，\u6838\u5fc3\u57fa\u4e8eCRD（\u81ea\u5b9a\u4e49\u8d44\u6e90） \u5b9e\u73b0&#xff0<\/p>\n","protected":false},"author":2,"featured_media":69219,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[120,114,763],"topic":[],"class_list":["post-69226","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-kubernetes","tag-mysql","tag-763"],"yoast_head":"\nMySQL Operator for Kubernetes\u81ea\u52a8\u5b9e\u73b0\u6574\u4e2a\u751f\u547d\u5468\u671f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/69226.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Operator for Kubernetes\u81ea\u52a8\u5b9e\u73b0\u6574\u4e2a\u751f\u547d\u5468\u671f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u5b98\u7f51\u5730\u5740：MySQL :: MySQL Operator for Kubernetes Manual \u5f00\u6e90\u5730\u5740：mysql\/mysql-operator: MySQL Operator for Kubernetes \u4e00\u3001\u5f15\u8a00\u4e0e\u4ecb\u7ecd MySQL Operator for Kubernetes \u662f Kubernetes \u751f\u6001\u4e2d\u4e13\u4e3a MySQL \u8bbe\u8ba1\u7684\u4e13\u5c5e\u8fd0\u7ef4\u5de5\u5177，\u6838\u5fc3\u57fa\u4e8eCRD（\u81ea\u5b9a\u4e49\u8d44\u6e90） \u5b9e\u73b0&#xff0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/69226.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-31T01:08:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260131010849-697d5621199b9.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"21 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/69226.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/69226.html\",\"name\":\"MySQL Operator for Kubernetes\u81ea\u52a8\u5b9e\u73b0\u6574\u4e2a\u751f\u547d\u5468\u671f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-01-31T01:08:52+00:00\",\"dateModified\":\"2026-01-31T01:08:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/69226.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/69226.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/69226.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Operator for Kubernetes\u81ea\u52a8\u5b9e\u73b0\u6574\u4e2a\u751f\u547d\u5468\u671f\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Operator for Kubernetes\u81ea\u52a8\u5b9e\u73b0\u6574\u4e2a\u751f\u547d\u5468\u671f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/69226.html","og_locale":"zh_CN","og_type":"article","og_title":"MySQL Operator for Kubernetes\u81ea\u52a8\u5b9e\u73b0\u6574\u4e2a\u751f\u547d\u5468\u671f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u5b98\u7f51\u5730\u5740：MySQL :: MySQL Operator for Kubernetes Manual \u5f00\u6e90\u5730\u5740：mysql\/mysql-operator: MySQL Operator for Kubernetes \u4e00\u3001\u5f15\u8a00\u4e0e\u4ecb\u7ecd MySQL Operator for Kubernetes \u662f Kubernetes \u751f\u6001\u4e2d\u4e13\u4e3a MySQL \u8bbe\u8ba1\u7684\u4e13\u5c5e\u8fd0\u7ef4\u5de5\u5177，\u6838\u5fc3\u57fa\u4e8eCRD（\u81ea\u5b9a\u4e49\u8d44\u6e90） \u5b9e\u73b0&#xff0","og_url":"https:\/\/www.wsisp.com\/helps\/69226.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-01-31T01:08:52+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260131010849-697d5621199b9.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"21 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/69226.html","url":"https:\/\/www.wsisp.com\/helps\/69226.html","name":"MySQL Operator for Kubernetes\u81ea\u52a8\u5b9e\u73b0\u6574\u4e2a\u751f\u547d\u5468\u671f - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-01-31T01:08:52+00:00","dateModified":"2026-01-31T01:08:52+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/69226.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/69226.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/69226.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"MySQL Operator for Kubernetes\u81ea\u52a8\u5b9e\u73b0\u6574\u4e2a\u751f\u547d\u5468\u671f"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/69226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=69226"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/69226\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/69219"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=69226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=69226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=69226"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=69226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}