BLOG main image
분류 전체보기 (111)
주절주절 (16)
Tabex (4)
클라우드 관련 (12)
Linux (23)
CruiseControl (3)
XP (1)
C (4)
C++ (1)
C# (2)
Boost (3)
Java (0)
DataBase (4)
Algorithm (17)
Network (1)
OS (1)
UML (1)
상식 (3)
좋은 글 (3)
회사에서... (0)
Node.js (1)
EKS (1)
Mac (2)
Visitors up to today!
Today hit, Yesterday hit
daisy rss
tistory 티스토리 가입하기!
2024. 3. 18. 18:10

 

root@gitlab:/# gitlab-psql
psql (12.7)
Type "help" for help.

gitlabhq_production=# UPDATE projects SET runners_token = null, runners_token_encrypted = null;
UPDATE 346
gitlabhq_production=# UPDATE namespaces SET runners_token = null, runners_token_encrypted = null;
UPDATE 129
gitlabhq_production=# UPDATE application_settings SET runners_registration_token_encrypted = null;
UPDATE 1
gitlabhq_production=# UPDATE application_settings SET encrypted_ci_jwt_signing_key = null;
UPDATE 1
gitlabhq_production=# UPDATE ci_runners SET token = null, token_encrypted = null;
UPDATE 3
gitlabhq_production=# UPDATE ci_builds SET token_encrypted = null;
UPDATE 4039

 

2024. 2. 20. 11:41

Mysql 8 버전 기준

 

CREATE USER 'josungwoo'@'%' IDENTIFIED BY '패스워드';

GRANT ALL PRIVILEGES ON `sungwoodb`.* TO 'josungwoo'@'%';

flush privileges;

 

 

읽기 권한만 주고싶다..

 

CREATE USER 'josungwoo'@'%' IDENTIFIED BY '패스워드';
GRANTSELECT ON `sungwoodb`.* TO 'josungwoo'@'%';
flush privileges;

 

 

RDS Aurora로 생성하고 파라미터 그룹 생성하고 편집에서 

 

charater set 과 time zone 세팅

2024. 2. 7. 10:03
[EKS]
admin@josungwoo-MBP eks % eksctl delete cluster --name eks-tutorial
2024-02-07 09:54:57 [ℹ]  deleting EKS cluster "eks-tutorial"
2024-02-07 09:54:57 [ℹ]  will drain 1 unmanaged nodegroup(s) in cluster "eks-tutorial"
2024-02-07 09:54:57 [ℹ]  starting parallel draining, max in-flight of 1


2024-02-07 09:55:58 [!]  1 pods are unevictable from node ip-192-168-9-219.ap-northeast-2.compute.internal
2024-02-07 09:56:58 [!]  1 pods are unevictable from node ip-192-168-9-219.ap-northeast-2.compute.internal

 

계속 펜딩 상태...

 

아래 옵션을 주어서 삭제

eksctl delete cluster --name eks-tutorial --disable-nodegroup-eviction

 

 

admin@josungwoo-MBP eks % eksctl delete cluster --name eks-tutorial --disable-nodegroup-eviction
2024-02-07 09:59:45 [ℹ]  deleting EKS cluster "eks-tutorial"
2024-02-07 09:59:45 [ℹ]  will drain 1 unmanaged nodegroup(s) in cluster "eks-tutorial"
2024-02-07 09:59:45 [ℹ]  starting parallel draining, max in-flight of 1
2024-02-07 10:00:01 [✔]  drained all nodes: [ip-192-168-85-198.ap-northeast-2.compute.internal ip-192-168-22-84.ap-northeast-2.compute.internal ip-192-168-9-219.ap-northeast-2.compute.internal]
2024-02-07 10:00:02 [ℹ]  deleted 0 Fargate profile(s)
2024-02-07 10:00:02 [✔]  kubeconfig has been updated
2024-02-07 10:00:02 [ℹ]  cleaning up AWS load balancers created by Kubernetes objects of Kind Service or Ingress
2024-02-07 10:00:04 [ℹ]
2 sequential tasks: { delete nodegroup "ng-1", delete cluster control plane "eks-tutorial" [async]
}
2024-02-07 10:00:04 [ℹ]  will delete stack "eksctl-eks-tutorial-nodegroup-ng-1"
2024-02-07 10:00:04 [ℹ]  waiting for stack "eksctl-eks-tutorial-nodegroup-ng-1" to get deleted
2024-02-07 10:00:04 [ℹ]  waiting for CloudFormation stack "eksctl-eks-tutorial-nodegroup-ng-1"
2024-02-07 10:00:34 [ℹ]  waiting for CloudFormation stack "eksctl-eks-tutorial-nodegroup-ng-1"
2024-02-07 10:01:32 [ℹ]  waiting for CloudFormation stack "eksctl-eks-tutorial-nodegroup-ng-1"

2024-02-07 10:03:11 [ℹ]  waiting for CloudFormation stack "eksctl-eks-tutorial-nodegroup-ng-1"
2024-02-07 10:03:11 [ℹ]  will delete stack "eksctl-eks-tutorial-cluster"
2024-02-07 10:03:11 [✔]  all cluster resources were deleted

https://github.com/eksctl-io/eksctl/issues/6287