Centos, Redhat 계열

# EC2 Disk 는 최소 32G 이상 확보

sudo yum -y upgrade

sudo yum install -y python3 pip3

sudo yum -y install docker

sudo service docker start

sudo usermod -aG docker ec2-user 

# Server Rebooting ( Or sudo su - ec2-user )

sudo curl -L https://github.com/docker/compose/releases/download/1.28.0-rc2/docker-compose-$(uname -s)-$(uname -m) -o /usr/local/bin/docker-compose

sudo chmod +x /usr/local/bin/docker-compose

sudo pip3 install docker

sudo pip3 install docker-compose

# sudo 로 docker-compose 실행시 Not found. sudo vi /etc/sudoers 내 secure_path 에 /usr/local/bin/ 추가후 실행

# sudo 없이 설치할 경우 참조
# sudo usermod -aG docker $USER # 현재 접속중인 사용자에게 권한주기
# sudo usermod -aG docker your-user # your-user 사용자에게 권한주기

# AWS 보안 그룹에 80 등 필요한 포트 추가할 것

Centos6 에서 오류시 참조 : https://storycode.tistory.com/484

Ubuntu 계열

# 참조 : https://blog.dalso.org/linux/ubuntu-20-04-lts/13118
# EC2 Disk 는 최소 32G 이상 확보

> cat /etc/issue # Ubuntu 20.04.2 LTS \n \l

> sudo apt update

> sudo apt upgrade

> sudo apt-get install apt-transport-https ca-certificates curl gnupg-agent software-properties-common

> curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add

> arch # x86_64 확인

> sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable"

> sudo apt-get update && sudo apt-get install docker-ce docker-ce-cli containerd.io

> sudo usermod -aG docker "ubuntu계정"

# Server Rebooting ( Or sudo su - "ubuntu계정" )

> docker -v # Docker version 20.10.7. build f0df350

> sudo systemctl enable docker && sudo service docker start

> service docker status # Acitive: active (running) 확인

> sudo curl -L "https://github.com/docker/compose/releases/download/1.29.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose

> sudo chmod +x /usr/local/bin/docker-compose

> sudo ln -s /usr/local/bin/docker-compose /usr/bin/docker-compose

> docker-compose -version

> sudo apt install python3-pip

# 스크립트로 설치
curl -fsSL https://get.docker.com -o get-docker.sh
sudo sh get-docker.sh

# 그룹추가
sudo groupadd docker
sudo usermod -aG docker $USER
newgrp docker

# daemon에 권한 설정
sudo mkdir -p /etc/systemd/system/docker.service.d
sudo vim /etc/systemd/system/docker.service.d/override.conf

[Service]
ExecStartPost=/bin/chmod 666 /var/run/docker.sock

sudo systemctl daemon-reload
sudo systemctl restart docker

mysql -u root -p

* 참조 : computingforgeeks.com/how-to-install-mariadb-on-ubuntu-focal-fossa/

sudo apt update && sudo apt upgrade
sudo apt -y install software-properties-common

sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'

sudo add-apt-repository 'deb [arch=amd64] http://mariadb.mirror.globo.tech/repo/10.5/ubuntu focal main'

sudo apt update
sudo apt install mariadb-server mariadb-client

sudo mysql_secure_installation
# 대답은 전부 Y 로 함.
systemctl status mysql

# mysql5.7 / mariadb10.1 이상의 root 계정은 터미널에서만 사용만 가능.

CREATE USER '아이디'@'%' IDENTIFIED BY '비밀번호';
GRANT ALL PRIVILEGES ON *.* TO '아이디'@'%';

# root 권한 부여
UPDATE mysql.user SET GRANT_PRIV = 'Y', SUPER_PRIV = 'Y' WHERE USER = '아이디';
FLUSH PRIVILEGES;

* UDF.system call

sudo apt-get install make gcc
sudo apt-get install libmysqlclient-dev 
sudo apt install libmariadb-dev
sudo apt install default-libmysqlclient-dev
# libmysqlclient15-dev 는 안됨.



mysql_config --include
>> -I/usr/include/mariadb -I/usr/include/mariadb/mysql : 여기에 my_global.h, m_ctype.h 등이 있어야 함.

# "lib_mysqludf_sys.c" 에서, 

아래 삭제후 저장
    #include <my_global.h>
    #include <my_sys.h>
    #include <m_ctype.h>
    #include <m_string.h>

#include <mysql.h> 가 include 되는 게 중요.

sudo ./install.sh # so 생성을 위해서



mysql> SHOW VARIABLES LIKE 'plugin_dir';
+---------------+------------------------+
| Variable_name | Value                  |
+---------------+------------------------+
| plugin_dir    | /usr/lib/mysql/plugin/ |
+---------------+------------------------+
1 row in set (0.001 sec)

# /usr/lib/mysql/plugin/ 에 so 가 있어야 함.
sudo cp /usr/lib/lib_mysqludf_sys.so /usr/lib/mysql/plugin/

sudo ./install.sh # so 를 function 에 등록을 위해서

docs.aws.amazon.com/ko_kr/efs/latest/ug/efs-onpremises.html