@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