CloudGarageでWordPressをWebサーバ＋DBサーバの構成にしてみた

2017/09/02(土)　CloudGarage Release Tour in Okayamaでの発表。
CloudGarage上でWordPressをWebサーバ＋DBサーバの構成にしてみたお話。

Transcript

1. CloudGarageͰWordPressΛ
   WebαʔόʴDBαʔόͷߏ੒ʹͯ͠Έͨ
   2017/09/02(౔)ɹCloudGarage Release Tour in Okayama
   ҳݟ ੣(@mako_wis)
   

   View Slide

2. ࣗݾ঺հ
   w ҳݟ੣ ΁ΜΈ·͜ͱ
   
   w 5XJUUFS!NBLP@XJT
   w גࣜձࣾΫϨΦϑʔΨ
   w ϑϩϯταʔόʔαΠυΤϯδχ
   ΞɾՐݩ؅ཧ੹೚ऀ
   

   View Slide

3. Իָؔ܎ͷ࢓ࣄͯ͠·͢
   

   View Slide

4. Իָؔ܎ͷ
   ʢձࣾͰϓϩάϥϚʔͷʣ
   ࢓ࣄͯ͠·͢
   

   View Slide

5. ࠓճ΍Γ͍ͨ͜ͱ※ΠϝʔδͰ͢
   DBαʔό WEBαʔό
   WordPressαΠτ
   

   View Slide

6. ·ͣ͸Webαʔό
   

   View Slide

7. ΞϓϦέʔγϣϯͷ
   ςϯϓϨʔτΛ࢖͍·͢
   

   View Slide

8. View Slide

9. View Slide

10. Webαʔό
    • ΞϓϦέʔγϣϯςϯϓϨʔτ
    • WordPress
    • ઀ଓڐՄϙʔτ
    • HTTP, HTTPS, (SSH)
    

    View Slide

11. Ұ୴ɺ͜͜·Ͱ
    

    View Slide

12. ࣍͸ DBαʔό
    

    View Slide

13. ΞϓϦέʔγϣϯͷ
    ςϯϓϨʔτ͕ͳ͍ͷͰ
    ࣗ෼Ͱཱͯ·͢
    

    View Slide

14. ʢMySQLͱPostgresSQLͷ
    ΞϓϦέʔγϣϯͷ
    ςϯϓϨʔτཉ͍͠ɻόʔδϣ
    ϯબͼ͍ͨɻʣ
    

    View Slide

15. View Slide

16. View Slide

17. DBαʔό
    • OSΠϝʔδ
    • CentOS7.3_64bit
    • ઀ଓڐՄϙʔτ
    • (SSH)
    

    View Slide

18. MySQLΛΠϯετʔϧ
    

    View Slide

19. खॱ͸লུ͠·͢
    

    View Slide

20. MySQLͷॳظઃఆ·Ͱ
    ऴΘΒͤΔ
    

    View Slide

21. WordPressͷͨΊͷ
    ઃఆΛ͢Δ
    

    View Slide

22. View Slide

23. View Slide

24. DBαʔόʔଆʹWordPress༻
    ͷσʔλϕʔεΛ࡞੒
    ※͔͜͜Β͠͹Β͘DBαʔόʔଆͷ࡞ۀͰ͢
    

    View Slide

25. View Slide

26. σʔλϕʔε࡞੒
    mysql> CREATE DATABASE ʻDB_NAMEʼ;
    ※ʹ͸೚ҙͷ໊લΛೖΕ͍ͯͩ͘͞
    

    View Slide

27. ઀ଓϢʔβʔ࡞੒
    ※͜ͷ··ͩͱDBαʔόʔ಺෦͔Β͔͠ܨ͕Βͳ͍
    ͷͰઃఆΛม͑·͢
    mysql> GRANT ALL PRIVILEGES ON ʻ
    DB_NAMEʼ.* to ʻDB_USERʼ@localhost
    identified by 'ʻDB_PASSWORDʼ';
    

    View Slide

28. WebαʔόଆͷϓϥΠϖʔτIPΛ֬ೝ
    

    View Slide

29. ઀ଓϢʔβʔ࡞੒
    localhostΛWebαʔόʔଆͷIPʹมߋ
    mysql> GRANT ALL PRIVILEGES ON ʻDB_NAME
    ʼ.* to ʻDB_USERʼ@192.168.0.9 identified
    by ‘ʻDB_PASSWORDʼ';
    ※ʻDB_USERʼʻDB_PASSWORDʼʹ͸೚ҙͷ஋ΛೖΕ͍ͯͩ͘͞
    

    View Slide

30. มߋΛ൓өͯ͠ऴྃ
    mysql> FLUSH PRIVILEGES;
    mysql> EXIT
    

    View Slide

31. DBଆͷઃఆऴΘΓ
    

    View Slide

32. WebαʔόʔଆͰWordPress
    ͷઃఆΛߦ͏
    ※͔͜͜Β͠͹Β͘Webαʔόʔଆͷ࡞ۀͰ͢
    

    View Slide

33. ্͔Βॱʹखॱ௨Γ΍Γ·͢
    

    View Slide

34. ͜͜͸ͦͷ··
    

    View Slide

35. ͜͜͸গ͠ઃఆΛม͑·͢
    

    View Slide

36. DBαʔόଆͰઃఆͨ͠஋ΛͦΕͧΕઃఆ
    ʻDB_USERʼʻDB_PASSWORDʼ
    

    View Slide

37. DBαʔόͷઃఆΛ֬ೝͯ͠मਖ਼͢Δ
    

    View Slide

38. DBαʔόଆͷϓϥΠϖʔτIPΛ֬ೝ
    

    View Slide

39. localhostΛ192.168.0.8ʹมߋ
    

    View Slide

40. खॱʹैͬͯηοτΞοϓͯ͠׬ྃ
    

    View Slide

41. ·ͱΊͱॴײ
    • WebαʔόͱDBαʔόͷߏ੒Λ࡞੒
    • αʔόؒͷϩʔΧϧωοτʔϫʔΫͷઃఆ͕σϑΥϧ
    τͰ͞ΕͯΔͷͰָ
    • ղ์͢ΔϙʔτΛ؅ཧը໘Ͱ؆୯ʹมߋͰ͖ΔͷͰָ
    • σʔλϕʔεͷΞϓϦέʔγϣϯςϯϓϨʔτཉ͍͠
    

    View Slide