Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
[日本語]How to use Amazon RDS with AMIMOTO AMI WordPress
AMIMOTO
March 25, 2016
How-to & DIY
0
2k
[日本語]How to use Amazon RDS with AMIMOTO AMI WordPress
AMIMOTOでRDSを利用する方法
AMIMOTO
March 25, 2016
Tweet
Share
More Decks by AMIMOTO
See All by AMIMOTO
[日本語] AMIMOTO-AMI Lineup
amimoto
0
120
EdgeCase - A speaker series by J2 Design
amimoto
0
190
Progress the system operation drastically with Cloud Automator — AMIMOTO side—
amimoto
0
140
[東京]Cloud_Automatorで攻めのシステム運用 AMIMOTO スタック編
amimoto
0
670
AMIMOTO Design Pattern + Server-less Architecture
amimoto
0
450
WooCommerce with Elasticsearch
amimoto
1
420
[日本語] WooCommerce with Elasticsearch
amimoto
0
170
Amazon CloudFront with AWS Certificate Manager
amimoto
0
160
WordPress with CloudFront + AMAZON RDS + S3
amimoto
1
630
Other Decks in How-to & DIY
See All in How-to & DIY
mftokyo2021-penplotter
qx5k_iskw
0
190
Realforceを濡らしてしまった話
mattenn
0
110
おうちHackを取り入れた リノベーション事例
yusukeito
0
200
iPhoneで始める3Dスキャン生活
iwamah
0
670
はじめてのBabylon.js
a2k3ine
0
170
雑にならない雑談のはじめかた | チームの気まずさを無くし、楽しさを加速させる秘訣 / Joy work with chat
yasuakiomokawa
1
690
xID guide
xid
1
310
文系のシステム開発理系のコーディング
shirayanagiryuji
0
290
#ヒーローズリーグ から クリスマスプレゼントでもらったSwitch BotをLT中にハック #iotlt
n0bisuke2
0
190
すいか農園記
peacemaker07
2
290
06_Scratchオフラインエディターのダウンロード方法.pdf
keita_yoshikawa
0
290
TOMARIGIとfoxfoxZEROの合併計画
bigtree
0
710
Featured
See All Featured
Faster Mobile Websites
deanohume
294
28k
The Illustrated Children's Guide to Kubernetes
chrisshort
18
40k
Product Roadmaps are Hard
iamctodd
35
6.8k
Making the Leap to Tech Lead
cromwellryan
113
7.4k
JazzCon 2018 Closing Keynote - Leadership for the Reluctant Leader
reverentgeek
173
8.6k
Code Reviewing Like a Champion
maltzj
506
37k
Optimizing for Happiness
mojombo
365
63k
YesSQL, Process and Tooling at Scale
rocio
157
12k
Fireside Chat
paigeccino
13
1.4k
Rebuilding a faster, lazier Slack
samanthasiow
62
7.3k
Designing the Hi-DPI Web
ddemaree
272
32k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
236
1.1M
Transcript
@Amimoto_Ami amimoto-ami.com AMIMOTO (HHVM) + AMAZON RDS
AMAZON RDS ͱ
εέʔϥϒϧ ར༻Մೳͳ6ͭͷDB Τϯδϯ ϦϨʔγϣφϧσʔλϕʔε ༰қͳઃఆͱӡ༻
ϝϦοτ •εέʔϧՄೳͳ CPUɼIOPSɼετϨʔδ •ࣗಈ·ͨҙͷόοΫΞοϓ͕ εφοϓγϣοτ͔ΒՄೳ • ϚϧνΞϕΠϥϏϦςΟκʔϯͷσϓϩΠ • ϓϥΠϚϦͷোൃੜ࣌ʹ ଈ࠲ʹηΧϯμϦΓସ͑Մೳ
σϝϦοτ • DB ͷγΣϧΞΫηε͕Ͱ͖ͳ͍ • Ϣʔβݖݶʹ੍͕͋Δ • MySQL ͰͷϨϓϦέʔγϣϯ͕ແޮ •
ि4࣌ؒͷϝϯςφϯεΟϯυදࣔ • ࢭΊΒΕͳ͍ RDS Πϯελϯε
RDS DBΛ Ҡߦ͠Α͏
RDS ͷͳ͍ΞʔΩςΫνϟ
RDS ͷ͋ΔΞʔΩςΫνϟ
AWS ίϯιʔϧ ϩάΠϯ
MySQL Λ Amazon RDS ʹ࡞
σʔλϕʔεΤϯδϯͷબ
σʔλϕʔεΤϯδϯͷબ
σʔλϕʔεͷ֤छઃఆ
σʔλϕʔεͷৄࡉઃఆ
σʔλϕʔεͷ࡞
࡞͞Εͨ σʔλϕʔε
SSH ͰΠϯελϯεϩάΠϯ
EC2 Λ RDS ଓ͠·͢ 1. SSH Ͱαʔόଓ͠·͢: $ ssh
-i /Users/USERNAME/Desktop/example.pem ec2-user@instance_ip or domain 2. ࣍ͷίϚϯυΛ࣮ߦͯ͠ MySQL ଓ͍ͯͩ͘͠͞: $ mysql -h {endpoint} -P 3306 -u {mymasteruser} -p
{endpoint} AWS Management Console ͷ RDS ใͰ֬ೝͰ͖·͢ {mymasteruser} ͱ
ύεϫʔυ RDS ࡞࣌ʹࢦఆͨ͠ͷΛೖྗ͍ͯͩ͘͠͞
σʔλϕʔεͷϚΠάϨʔγϣϯ wp-cli Ͱ MySQL ͔ΒσʔλΛΤΫεϙʔτ͠·͢: $ wp --path=/path/to/wordpress db
export /path/to/wordpress WordPress ͷΠϯετʔϧσΟϨΫτϦΛࢦఆ͍ͯͩ͘͠͞ɻ AMIMOTO AMI Ͱ௨ৗ /var/www/vhosts/{instance_id} ͱͳ͍ͬͯ·͢ɻ
σʔλϕʔεͷϚΠάϨʔγϣϯ ΤΫεϙʔτͨ͠σʔλΛ RDS Πϯϙʔτ͠·͢: $ mysql -h {endpoint} -P
3306 -u {mymasteruser} -p {databasename} < dump.sql {endpoint} AWS Management Console ͷ RDS ใͰ֬ೝͰ͖·͢ɻ {mymasteruser} ͱ {databasename} RDS ࡞࣌ʹࢦఆͨ͠ͷΛೖྗ͍ͯͩ͘͠͞
wp-config.php ͷฤू // ** MySQL settings - You can get
this info from your web host ** // $db_data = false; if ( file_exists('/opt/aws/cloud_formation.json') ) { $db_data = json_decode(file_get_contents('/opt/aws/ cloud_formation.json'), true); if ( isset($db_data['rds']) ) { $db_data = $db_data['rds']; $db_data['host'] = $db_data['endpoint'] . ':' . $db_data['port']; } } if ( !$db_data ) { $db_data = array( 'database' => 'RDS_DATABASE_NAME_HERE', 'username' => 'RDS_USER_NAME_HERE', 'password' => 'RDS_PASSWORD_HERE', 'host' => 'RDS_ENDPOINT_HERE', ); }
wp-config.php ͷฤू RDS_DATABASE_NAME_HERE: σʔϕʔεͷৄࡉઃఆͰઃఆࡁΈͷσʔλϕʔε໊ RDS_USER_NAME_HERE: σʔλϕʔεͷ֤छઃఆͰઃఆࡁΈͷϢʔβ໊ RDS_PASSWORD_HERE: σʔλϕʔεͷ֤छઃఆͰઃఆࡁΈͷύεϫʔυ RDS_ENDPOINT_HERE: RDS
ͷΤϯυϙΠϯτ wp-config.php ্ͷઃఆΛೖΕͨ͋ͱ WordPress ʹଓͰ͖Δ͔͔͘Μ͍ͯͩ͘͠͞ɻ
AMIMOTO AMI ͷ MySQL ΛࢭΊΔ MySQL Λ RDS Ҡಈͤ͞Δͱ AMIMOTO
AMI ͷ MySQL ϓϩηε͕ෆཁʹͳΓ·͢ɻ ઃఆϑΝΠϧΛฤूͯ͠ MySQL ϓϩηεΛऴ͍ྃͤͯͩ͘͞͞ɻ AMIMOTO AMI ͰϛυϧΣΞͷઃఆ /opt/local/amimoto.json ʹ͋Δ chef-solo Λ͍ͬͯ·͢ɻ
AMIMOTO AMI ͷ MySQL ΛࢭΊΔ MySQL Λ RDS Ҡಈͤ͞Δͱ AMIMOTO
AMI ͷ MySQL ϓϩηε͕ෆཁʹͳΓ·͢ɻ ઃఆϑΝΠϧΛฤूͯ͠ MySQL ϓϩηεΛऴ͍ྃͤͯͩ͘͞͞ɻ AMIMOTO AMI ͰϛυϧΣΞͷઃఆ /opt/local/amimoto.json ʹ͋Δ chef-solo Λ͍ͬͯ·͢ɻ MySQL Λఀࢭͤ͞ΔʹϑΝΠϧΛ࣍ͷΑ͏ʹॻ͖͍͑ͯͩ͘͞: { "nginx" : { "config" : { "user" : "nginx", "group" : "nginx" } }, "php" : { "config" : { "user" : "nginx", "group" : "nginx" } }, "mysql" : { "enabled" : false }, "phpfpm" : { "enabled" : true }, "run_list" : [ "recipe[amimoto]" ] }
AMIMOTO AMI ͷ MySQL ΛࢭΊΔ AMIMOTO AMI HHVM ൛ͷ߹ҎԼͷΑ͏ʹมߋ͍ͯͩ͘͠͞: {
"nginx" : { "config" : { "user" : "nginx", "group" : "nginx" } }, "php" : { "config" : { "user" : "nginx", "group" : "nginx" } }, "mysql" : { "enabled" : false }, "hhvm" : { "enabled" : true }, "run_list" : [ "recipe[amimoto]" ] }
AMIMOTO AMI ͷ MySQL ΛࢭΊΔ ࠷ޙʹ࣍ͷίϚϯυΛ࣮ߦ͍ͯͩ͘͠͞: $ sudo /opt/local/proviosion
$ mysql stop service
ja.amimoto-ami.com/slack ࣭͓͝ड͚͍ͨ͠·͢:
@Amimoto_Ami amimoto-ami.com THANK YOU! AMIMOTO (HHVM) + AMAZON RDS