创建有状态实例: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:~$