인프런 커뮤니티 질문&답변

helm 실습 도중 mysql이 정상적으로 실행이 되지 않는 것 같아 문의드립니다.

helm install mydb bitnami/mysql -f my-values.yaml
NAME: mydb
LAST DEPLOYED: Sun Jan 21 03:15:02 2024
NAMESPACE: default
STATUS: deployed
REVISION: 1
TEST SUITE: None
NOTES:
CHART NAME: mysql
CHART VERSION: 9.18.0
APP VERSION: 8.0.36

** Please be patient while the chart is being deployed **

Tip:

  Watch the deployment status using the command: kubectl get pods -w --namespace default

Services:

  echo Primary: mydb-mysql.default.svc.cluster.local:3306

Execute the following to get the administrator credentials:

  echo Username: root
  MYSQL_ROOT_PASSWORD=$(kubectl get secret --namespace default mydb-mysql -o jsonpath="{.data.mysql-root-password}" | base64 -d)

To connect to your database:

  1. Run a pod that you can use as a client:

      kubectl run mydb-mysql-client --rm --tty -i --restart='Never' --image  docker.io/bitnami/mysql:8.0.36-debian-11-r0 --namespace default --env MYSQL_ROOT_PASSWORD=$MYSQL_ROOT_PASSWORD --command -- bash

  2. To connect to primary service (read/write):

      mysql -h mydb-mysql.default.svc.cluster.local -uroot -p"$MYSQL_ROOT_PASSWORD"

my-values.yaml을 이용해서 helm mysql을 띄우고 있습니다.

kctl get pods
NAME           READY   STATUS    RESTARTS   AGE
mydb-mysql-0   0/1     Running   0          35s

위의 Ready가 1로 바뀌지 않습니다.

아래와 같이 접속이 되지 않습니다

kubectl run mydb-mysql-client --rm --tty -i --restart='Never' --image  docker.io/bitnami/mysql:8.0.36-debian-11-r0 --namespace default --env MYSQL_ROOT_PASSWORD=$MYSQL_ROOT_PASSWORD --command -- bash
If you don't see a command prompt, try pressing enter.
I have no name!@mydb-mysql-client:/$ 

# 실행이 되지 않는 부분
I have no name!@mydb-mysql-client:/$ mysql -h mydb-mysql.default.svc.cluster.local -uroot -p"$MYSQL_ROOT_PASSWORD"
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2003 (HY000): Can't connect to MySQL server on 'mydb-mysql.default.svc.cluster.local:3306' (111)
I have no name!@mydb-mysql-client:/$ 

문제가 있는 pod의 로그를 남깁니다.

제가 조치해야할 부분에 대해 답변 해주시면 감사드리겠습니다.

kubectl logs mydb-mysql-0 -n default
mysql 18:16:54.38 INFO  ==> 
mysql 18:16:54.38 INFO  ==> Welcome to the Bitnami mysql container
mysql 18:16:54.38 INFO  ==> Subscribe to project updates by watching https://github.com/bitnami/containers
mysql 18:16:54.38 INFO  ==> Submit issues and feature requests at https://github.com/bitnami/containers/issues
mysql 18:16:54.38 INFO  ==> 
mysql 18:16:54.38 INFO  ==> ** Starting MySQL setup **
mysql 18:16:54.39 INFO  ==> Validating settings in MYSQL_*/MARIADB_* env vars
mysql 18:16:54.40 INFO  ==> Initializing mysql database
mysql 18:16:54.40 WARN  ==> The mysql configuration file '/opt/bitnami/mysql/conf/my.cnf' is not writable. Configurations based on environment variables will not be applied for this file.
mysql 18:16:54.40 INFO  ==> Using persisted data
mysql 18:16:54.42 INFO  ==> Running mysql_upgrade
mysql 18:16:54.42 INFO  ==> Starting mysql in background
2024-01-20T18:16:54.827769Z 0 [Warning] [MY-011068] [Server] The syntax 'skip_slave_start' is deprecated and will be removed in a future release. Please use skip_replica_start instead.
2024-01-20T18:16:54.827877Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-01-20T18:16:54.827893Z 0 [System] [MY-010116] [Server] /opt/bitnami/mysql/bin/mysqld (mysqld 8.0.36) starting as process 46
2024-01-20T18:16:54.833609Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-01-20T18:16:54.842169Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-01-20T18:16:55.006185Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-01-20T18:16:55.095907Z 4 [System] [MY-013381] [Server] Server upgrade from '80036' to '80036' started.
2024-01-20T18:16:57.163961Z 4 [System] [MY-013381] [Server] Server upgrade from '80036' to '80036' completed.
2024-01-20T18:16:57.288943Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-01-20T18:16:57.289454Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-01-20T18:16:57.304275Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2024-01-20T18:16:57.304353Z 0 [System] [MY-010931] [Server] /opt/bitnami/mysql/bin/mysqld: ready for connections. Version: '8.0.36'  socket: '/opt/bitnami/mysql/tmp/mysql.sock'  port: 3306  Source distribution.
find: '/docker-entrypoint-startdb.d/': No such file or directory
mysql 18:16:58.45 INFO  ==> Stopping mysql
2024-01-20T18:16:58.468953Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.36).
2024-01-20T18:17:00.619438Z 0 [System] [MY-010910] [Server] /opt/bitnami/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36)  Source distribution.
mysql 18:17:01.54 INFO  ==> ** MySQL setup finished! **

mysql 18:17:01.58 INFO  ==> ** Starting MySQL **
2024-01-20T18:17:01.948065Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-01-20T18:17:01.948084Z 0 [System] [MY-010116] [Server] /opt/bitnami/mysql/bin/mysqld (mysqld 8.0.36) starting as process 1
2024-01-20T18:17:01.957828Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2024-01-20T18:17:01.968662Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-01-20T18:17:02.085467Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-01-20T18:17:02.232037Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-01-20T18:17:02.232066Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-01-20T18:17:02.245171Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2024-01-20T18:17:02.245200Z 0 [System] [MY-010931] [Server] /opt/bitnami/mysql/bin/mysqld: ready for connections. Version: '8.0.36'  socket: '/opt/bitnami/mysql/tmp/mysql.sock'  port: 3306  Source distribution.
2024-01-20T18:17:13.205722Z 8 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-01-20T18:17:23.196807Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-01-20T18:17:34.146016Z 10 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-01-20T18:17:43.208718Z 11 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'