HCIE2.0-CloudSA云上可扩展性设计实验

创建有状态实例:Mysql

CCE创建Mysql需要配置环境变量:
MYSQL_ROOT_PASSWORD 
MYSQL_DATABASE


数据存储创建动态存储,挂载路径:
/var/lib/mysql

创建无状态实例:nextcloud

设置环境变量,使nextcloud可以访问mariadb数据库。其中需要设置以下几个变量:
MYSQL_DB_HOST:mariadb.default.svc.cluster.local:3306 (mariadb的内部服务地址)
MYSQL_DB_USER: root
MYSQL_DB_PASSWORD: 创建Mysql时候设置的密码
MYSQL_DB_NAME: nextcloud

 

报错:

0/1 nodes are available: 1 Insufficient memory.

0/1节点可用:1内存不足。
如果在nextcloud安装页面出现如下报错:
Error while trying to initialise the database: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
请登录到mariadb容器中,进行如下操作,然后再次重新安装即可。

解决方法:

1.进入mariadb控制台,键入以下命令并回车;
mysql -u root -p
2.输入mariadb的root密码,回车登录;
3.输入以下命令并回车;
SET GLOBAL innodb_read_only_compressed=OFF;
这时候再次注册nextcloud,发现成功解决。

 

user@i5015cfnpt2cobm-machine:~$ kubectl get deployment
NAME    READY   UP-TO-DATE   AVAILABLE   AGE
cloud   10/10   10           10          21m
user@i5015cfnpt2cobm-machine:~$ kubectl get statefulset
NAME    READY   AGE
mysql   1/1     15m
user@i5015cfnpt2cobm-machine:~$ kubectl get pod
NAME                     READY   STATUS    RESTARTS   AGE
cloud-5fbd94c7bf-9fxr9   1/1     Running   0          3m2s
cloud-5fbd94c7bf-b74n9   1/1     Running   0          3m2s
cloud-5fbd94c7bf-dcvmc   1/1     Running   0          5m2s
cloud-5fbd94c7bf-dg7jq   1/1     Running   0          3m2s
cloud-5fbd94c7bf-g7hg4   1/1     Running   0          3m2s
cloud-5fbd94c7bf-jrb4c   1/1     Running   0          5m3s
cloud-5fbd94c7bf-pf8nc   1/1     Running   0          3m2s
cloud-5fbd94c7bf-sfdq2   1/1     Running   0          3m2s
cloud-5fbd94c7bf-tfrc4   1/1     Running   0          3m2s
cloud-5fbd94c7bf-v8dcz   1/1     Running   0          3m2s
mysql-0                  1/1     Running   0          15m
user@i5015cfnpt2cobm-machine:~$ kubectl get node
NAME            STATUS   ROLES    AGE     VERSION
192.168.0.10    Ready    <none>   4m13s   v1.23.3-r0-CCE22.5.1
192.168.0.132   Ready    <none>   86m     v1.23.3-r0-CCE22.5.1
192.168.0.172   Ready    <none>   5m17s   v1.23.3-r0-CCE22.5.1
192.168.0.228   Ready    <none>   4m27s   v1.23.3-r0-CCE22.5.1
user@i5015cfnpt2cobm-machine:~$