things to do after centos minimal installation...
DBMS / Redis 설치

Redis 설치
yum -y install redis
systemctl enable redis
systemctl restart redis
MySQL/Maria DB 설치
MySQL 5.7
​MySQL 5.7 설치​
repository 설치
rpm -ivh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
MySQL 설치
yum install mysql-community-server
기존 암호 규칙을 사용하기 위해 password 정책 수정
echo 'validate_password_policy=LOW' >> /etc/my.cnf
echo 'default_password_lifetime=0' >> /etc/my.cnf
MySQL 초기 암호 확인
grep 'temporary password' /var/log/mysqld.log
MySQL root 로 로그인
   mysql -u root -p
MySQL 초기 암호 변경
mysql> set password=password('qwert123');
mysql> flush privileges;
systemctl 로 자동 구동
systemctl enable mysqld
systemctl start mysqld
설정
my.cnf 설정
시스템별 최적 설정은 https://tools.percona.com/wizard 에서 설정
  vim /etc/my.cnf
   [mysqld]
   collation-server = utf8mb4_unicode_ci
   character-set-server = utf8mb4
   skip-character-set-client-handshake
​
   default-storage-engine         = InnoDB
   socket                         = /var/lib/mysql/mysql.sock
   pid-file                       = /var/lib/mysql/mysql.pid
​
   max-allowed-packet             = 256M
   datadir                        = /var/lib/mysql/
​
   # # LOGGING #
   log-error                      = /var/lib/mysql/mysql-error.log
   log-queries-not-using-indexes  = 1
   slow-query-log                 = 1
   slow-query-log-file            = /var/lib/mysql/mysql-slow.log
​
   # Disabling symbolic-links is recommended to prevent assorted security risks
   symbolic-links=0
​
   validate_password_policy=LOW
   default_password_lifetime=0
Python 서비스 환경 구성
Last updated 1 year ago