Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

Makoto Henmi
September 07, 2017

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

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

Makoto Henmi

September 07, 2017
Tweet

More Decks by Makoto Henmi

Other Decks in Technology

Transcript

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

    View Slide

  2. ࣗݾ঺հ
    w ҳݟ੣ ΁ΜΈ·͜ͱ

    w [email protected]
    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