9주차-3 Wordpress & WooCommerce 웹서버 & DB서버 구성 + WooCommerce 설정 실습

아이수베어·2022년 1월 21일

AFOS[2기]aws

AFOS[2기]

목록 보기

22/29

2대 EC2로 구성 : Web/PHP 인스턴스 + MariaDB 인스턴스 구성

WebSrv1: 10.1.1.10
DBSrv: 10.1.2.20

기본 설정은 CloudFormation 으로 설정 완료 - User Data 내용

WebSrv

#!/bin/bash
hostnamectl --static set-hostname WebSrv
amazon-linux-extras install lamp-mariadb10.2-php7.2 php7.2 -y
yum install httpd htop -y
systemctl start httpd && systemctl enable httpd
echo "<?php phpinfo(); ?>" > /var/www/html/phpinfo.php
yum install gcc php-xml php-mbstring php-sodium php-devel php-pear ImageMagick-devel ghostscript -y
cat <<EOT> /etc/php.d/40-imagick.ini
; Enable imagick extension module
extension = imagick.so
EOT
printf "\n" | pecl install imagick
sed -i 's/^upload_max_filesize = 2M/upload_max_filesize = 64M/g' /etc/php.ini
sed -i 's/^post_max_size = 8M/post_max_size = 64M/g' /etc/php.ini
sed -i 's/^max_execution_time = 30/max_execution_time = 300/g' /etc/php.ini
sed -i 's/^memory_limit = 128M/memory_limit = 256/g' /etc/php.ini
wget https://ko.wordpress.org/wordpress-latest-ko_KR.zip
unzip wordpress-latest-ko_KR.zip
cp wordpress/wp-config-sample.php wordpress/wp-config.php
sed -i "s/localhost/10.1.2.20/g" wordpress/wp-config.php
sed -i "s/database_name_here/wordpressdb/g" wordpress/wp-config.php
sed -i "s/username_here/root/g" wordpress/wp-config.php
sed -i "s/password_here/qwe123/g" wordpress/wp-config.php
cat <<EOT>> wordpress/wp-config.php
define('WP_MEMORY_LIMIT', '256M');
EOT
cp -r wordpress/* /var/www/html/
chown -R apache /var/www
chgrp -R apache /var/www
chmod 2775 /var/www
find /var/www -type d -exec chmod 2775 {} \;
find /var/www -type f -exec chmod 0664 {} \;
systemctl restart php-fpm
systemctl restart httpd

DBSrv

#!/bin/bash
hostnamectl --static set-hostname DBSrv
amazon-linux-extras install lamp-mariadb10.2-php7.2
yum install mariadb-server htop -y
systemctl start mariadb && systemctl enable mariadb
echo -e "\n\nqwe123\nqwe123\ny\nn\ny\ny\n" | /usr/bin/mysql_secure_installation
sed -i'' -r -e "/\[mysqld\]/a\character-set-server=utf8" /etc/my.cnf.d/mariadb-server.cnf
sed -i'' -r -e "/\[mysqld\]/a\collation-server=utf8_general_ci" /etc/my.cnf.d/mariadb-server.cnf
sed -i'' -r -e "/\[mysqld\]/a\init_connect=\"SET NAMES utf8\"" /etc/my.cnf.d/mariadb-server.cnf
sed -i'' -r -e "/\[mysqld\]/a\init_connect=\"SET collation_connection = utf8_general_ci\"" /etc/my.cnf.d/mariadb-server.cnf
sed -i'' -r -e "/\[client\]/a\default-character-set=utf8" /etc/my.cnf.d/client.cnf
sed -i'' -r -e "/\[mysql\]/a\default-character-set=utf8" /etc/my.cnf.d/mysql-clients.cnf
sed -i'' -r -e "/\[mysqldump\]/a\default-character-set=utf8" /etc/my.cnf.d/mysql-clients.cnf
mysql -uroot -pqwe123 -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'qwe123';"
mysql -uroot -pqwe123 -e "CREATE DATABASE wordpressdb"
systemctl restart mariadb