Intall Mysql Operator in K8S
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #install kind and create local K8S cluster | |
| #kind create cluster –name local | |
| helm repo add mysql-operator https://mysql.github.io/mysql-operator/ | |
| helm repo update | |
| MYSQL_OPERATOR_NS=mysql-operator | |
| helm install mysql-operator mysql-operator/mysql-operator –namespace ${MYSQL_OPERATOR_NS} –create-namespace | |
| MYSQL_NAME=mysql | |
| MYSQL_NS=mysql | |
| MYSQL_USER=root | |
| MYSQL_PWD=root | |
| MYSQL_SERVER_INSTANCE=1 | |
| MYSQL_ROUTER_INSTANCE=1 | |
| helm install ${MYSQL_NAME} mysql-operator/mysql-innodbcluster \ | |
| –namespace ${MYSQL_NS} \ | |
| –create-namespace \ | |
| –version 2.0.5 \ | |
| –set credentials.root.user=${MYSQL_USER} \ | |
| –set credentials.root.password=${MYSQL_PWD} \ | |
| –set credentials.root.host='%' \ | |
| –set serverInstances=${MYSQL_SERVER_INSTANCE} \ | |
| –set routerInstances=${MYSQL_ROUTER_INSTANCE} \ | |
| –set tls.useSelfSigned=true | |
| kubectl get service -n ${MYSQL_NS} | |
| kubectl port-forward service/${MYSQL_NAME} 3306:3306 -n ${MYSQL_NS} | |
| #run mysql client | |
| #kubectl run mysql-client –image=mysql:5.7 -it –rm –restart=Never \ | |
| #— mysql -h${MYSQL_NAME}.${MYSQL_NS}.svc.cluster.local -P3306 -u${MYSQL_USER} -p${MYSQL_PWD} | |
| kubectl run mysql-client –image=mysql:5.7 -it –rm –restart=Never /bin/bash | |
| mysql -hmysql.mysql.svc.cluster.local -P3306 -uroot -proot | |
| #mysql -h127.0.0.1 -P3306 -uroot -p |
Wang's Tech Blog 
Reply