Kubernetes是開源的容器編排系統，可用于自動化部署、擴展和管理容器化應用程序。MySQL作為一個常用的關系型數據庫，也可以在Kubernetes上運行。

在MySQL集群中，雙主架構可以提高可用性和故障恢復性。Kubernetes與MySQL的集成可以實現自動化部署和水平擴展。下面我們將講解如何在Kubernetes上實現MySQL雙主架構。

首先我們需要在Kubernetes上創建一個MySQL服務，并設置雙主架構。我們可以通過如下yaml文件創建MySQL服務：

apiVersion: v1
kind: Service
metadata:
name: mysql
labels:
app: mysql
spec:
ports:
- name: mysql1
port: 3306
targetPort: 3306
- name: mysql2
port: 3307
targetPort: 3307
selector:
app: mysql
type: ClusterIP

創建完成后，我們需要在Kubernetes上部署兩個MySQL實例并設置雙主同步。我們可以通過如下yaml文件創建MySQL Pod：

apiVersion: v1
kind: Pod
metadata:
name: mysql-0
labels:
app: mysql
spec:
containers:
- name: mysql
image: mysql
env:
- name: MYSQL_ROOT_PASSWORD
value: "password"
- name: MYSQL_DATABASE
value: "mydb"
volumeMounts:
- name: mysql-persistent-storage
mountPath: /var/lib/mysql
volumes:
- name: mysql-persistent-storage
persistentVolumeClaim:
claimName: mysql-pv-claim
---
apiVersion: v1
kind: Pod
metadata:
name: mysql-1
labels:
app: mysql
spec:
containers:
- name: mysql
image: mysql
env:
- name: MYSQL_ROOT_PASSWORD
value: "password"
- name: MYSQL_DATABASE
value: "mydb"
volumeMounts:
- name: mysql-persistent-storage
mountPath: /var/lib/mysql
volumes:
- name: mysql-persistent-storage
persistentVolumeClaim:
claimName: mysql-pv-claim

創建完成后，我們需要設置兩個MySQL實例之間的雙主同步。我們可以通過mysql shell執行以下命令完成設置：

mysql>CREATE USER 'replication'@'%' IDENTIFIED BY 'password';
mysql>GRANT REPLICATION SLAVE ON *.* TO 'replication'@'%';
mysql>CHANGE MASTER TO MASTER_HOST='mysql-0', MASTER_USER='replication', MASTER_PASSWORD='password' FOR CHANNEL 'group_replication_recovery';
mysql>CHANGE MASTER TO MASTER_HOST='mysql-1', MASTER_USER='replication', MASTER_PASSWORD='password' FOR CHANNEL 'group_replication_recovery';
mysql>START GROUP_REPLICATION;

完成以上步驟后，我們就可以在Kubernetes上成功實現MySQL雙主架構了。