Kubernetes (k8s) MySQL生產環境的搭建對于企業而言非常重要。下面是一個基本的k8s MySQL部署示例代碼：

apiVersion: v1
kind: Secret
metadata:
name: mysql-secrets
type: Opaque
data:
# Encode your password as base64
password: c3VwZXJzZWNyZXQ=  
---
apiVersion: v1
kind: ConfigMap
metadata:
name: mysql-config
data:
# Define your MySQL Configuration
my.cnf: |
[mysqld]
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.sock
user=mysql
port=3306
---
apiVersion: apps/v1
kind: StatefulSet
metadata:
name: mysql
spec:
serviceName: mysql
replicas: 1
selector:
matchLabels:
app: mysql
template:
metadata:
labels:
app: mysql
spec:
containers:
- name: mysql
image: mysql:5.7
ports:
- containerPort: 3306
env:
- name: MYSQL_ROOT_PASSWORD
valueFrom:
secretKeyRef:
name: mysql-secrets
key: password
volumeMounts:
- name: persistent-storage
mountPath: /var/lib/mysql
- name: mysql-config
mountPath: /etc/mysql/conf.d/my.cnf
subPath: my.cnf
volumes:
- name: persistent-storage
persistentVolumeClaim:
claimName: mysql-pvc
- name: mysql-config
configMap:
name: mysql-config
restartPolicy: Always
volumeClaimTemplates:
- metadata:
name: mysql-pvc
annotations:
volume.beta.kubernetes.io/storage-class: "standard"
spec:
accessModes: [ "ReadWriteOnce" ]
resources:
requests:
storage: 10Gi

這段代碼說明了在k8s環境中如何使用MySQL。其中涉及到了Secrets，ConfigMap和StatefulSet等k8s概念。Secrets用于存儲密碼，不會被明文傳輸；ConfigMap指定了MySQL配置；StatefulSet是維護有狀態應用的控制器，確保容器具有唯一的網絡標識符和磁盤標識符。

有了這些基本的部署代碼，企業就可以在k8s環境中愉快地使用MySQL了。這非常適合需要高可用、可擴展性和安全性的生產環境。