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

Upgrade over 10 years php from 4.3 to 5.6

linyows
June 27, 2015

Upgrade over 10 years php from 4.3 to 5.6

linyows

June 27, 2015
Tweet

More Decks by linyows

Other Decks in Technology

Transcript

  1. ೥௒͑ΔαʔϏεͷ
    QIQόʔδϣϯΛ
    ͔Β࠷৽ʹ͢Δ࿩
    !MJOZPXT1)1ΧϯϑΝϨϯε෱Ԭ

    View full-size slide

  2. ΞδΣϯμ
    w ࣗݾ঺հ
    w ͋ΔαʔϏεͷ౰࣌ͷঢ়ଶ
    w ՝୊
    w ϩʔυϚοϓ
    w ֤ରԠʹ͍ͭͯ
    w ·ͱΊ

    View full-size slide

  3. 5PNPIJTB0EB!MJOZPXT

    View full-size slide

  4. (.0QFQBCPٕज़ج൫νʔϜ

    View full-size slide

  5. ೥Ҏ্ଓ͍͍ͯΔ
    ͋ΔαʔϏεͷ
    ౰࣌ͷঢ়ଶ

    View full-size slide

  6. ։ൃ؀ڥɿ̍୆ΛαʔόΛෳ਺ਓͰ

    View full-size slide

  7. ຊ൪ɿ͓ख੡ͷ̍୆

    View full-size slide

  8. BQBDIFNPE@QIQ

    View full-size slide

  9. '51ͰσϓϩΠʂʂ

    View full-size slide

  10. ςετ͕ͳ͍
    ɹɹɹɹ͟Θ͟Θ

    View full-size slide

  11. ౰࣌ͷঢ়ଶ
    w ։ൃ؀ڥ͸Ұ୆ͷαʔόΛෳ਺ਓͰ࢖༻
    w ຊ൪͸͓ख੡ͷ̍୆αʔό
    w BQBDIFNPE@QIQ
    w QIQͷόʔδϣϯ͸
    w '51ͰσϓϩΠ
    w ςετ͕ͳ͍

    View full-size slide

  12. ՝୊ɿϨΨγʔ؀ڥΛ
    ͱ͜Ζ͔·Θͣվળ͢Δ

    View full-size slide

  13. ৬ਓʹΑͬͯ
    ςετΛ͢Δ

    View full-size slide

  14. ͦͯ͠
    ͪΐͬͱͣͭϦϦʔε

    View full-size slide

  15. -#
    DVSSFOU OFX

    View full-size slide

  16. -#
    DVSSFOU OFX OFX

    View full-size slide

  17. -#
    DVSSFOU OFX OFX

    View full-size slide

  18. LBHF΍EFMUB͸ʁ

    View full-size slide

  19. ϩʔυϚοϓ
    w WBHSBOU؀ڥͷߏங
    w DBQJTUSBOPͰEFQMPZ
    w DIFGͰαʔόΛίʔυԽɺ৑௕ߏ੒Λͭ͘Δ
    w QIQͷόʔδϣϯΞοϓ
    w -#ʹ৽چ؀ڥΛϦϦʔε
    w چ؀ڥͷୀ໾

    View full-size slide

  20. 7BHSBOU؀ڥΛͭ͘Δ
    IUUQEDPOG
    4FU&OW'00@&/7EFWFMPQNFOU
    JG FSFHJ l XXXGPPDPN
    z FYFD bIPTUOBNF


    \
    JG HFUFOW b'00@&/7`
    QSPEVDUJPO
    \

    View full-size slide

  21. w ؀ڥґଘ෦෼͸ϑΝΠϧʹ·ͱΊΔ
    DPOpHFOWJSPONFOUTQSPEVDUJPOQIQ
    EFWFMPQNFOUQIQ
    w ൿಗ৘ใ͸ҰͭͷϑΝΠϧʹ·ͱΊΔ
    DPOpHTFDSFUQIQ

    View full-size slide

  22. $BQJTUSBOPͰσϓϩΠ
    w ຊ൪αʔόͱϦϙδτϦͷࠩҟΛνΣοΫ
    w DBQλεΫΛ࣮૷
    w DBQJTUSBOPXJUISTZOD
    w DBQJTUSBOPHJUIVCSFMFBTFT
    w DBQJTUSBOPJLBDIBO
    w όονΛόοναʔόʹҠઃ

    View full-size slide

  23. $IFGͰXFCαʔόͭ͘Δ
    w DIFGW
    w LOJGFTPMP͔ΒLOJGF[FSP
    w QIQFOW
    w TFSWFSTQFD
    w ESPOFJP ࠷ॳ͸XFSDLFS࢖ͬͯͨ
    ͰDIFGͷ$*

    View full-size slide

  24. ͞ɺ1)1ͷ͸ͳ͠

    View full-size slide

  25. γϯλοΫεΤϥʔͷνΣοΫ
    GPSGJOApOEUZQFGOBNFQIQAEP
    QIQMG
    EPOFcHSFQW/PTZOUBYFSSPST

    View full-size slide

  26. TIBMMPXDPQZ࡟আ
    GVODUJPOHFU*OTUBODF

    GVODUJPOHFU*OTUBODF

    UIJT@FSSPS&SSPSHFU*OTUBODF

    UIJT@FSSPS&SSPSHFU*OTUBODF

    GVODUJPOPQFO QBSTFS UBH BUUSJCVUFT
    \
    GVODUJPOPQFO QBSTFS UBH BUUSJCVUFT
    \

    View full-size slide

  27. BSSBZ@NFSHF
    ͷҾ਺͕഑ྻҎ֎ͷ࣌ʹOVMMʹͳΔ
    BSSBZ@NFSHF GPP CBS

    BSSBZ@NFSHF BSSBZ
    GPP BSSBZ
    CBS

    View full-size slide

  28. ݺͼग़͢ϝιουͷҾ਺͕ࢀর౉͠ͷ৔߹ɺ8BSOJOHͱͳΔ
    GVODUJPOGPP.FUIPE BSH BSH

    DBMM@VTFS@GVOD bGPP.FUIPE` BSH BSH

    TXJUDI NFUIPE
    \
    DBTFbGPP.FUIPE`
    GPP.FUIPE BSH BSH

    View full-size slide

  29. w JOܥؔ਺͕࡟আ
    JO@KB@KQ@IBOUP[FO
    ΛNC@DPOWFSU@LBOB
    ʹஔ͖׵͑
    w TFTTJPO@SFHJTUFS
    TFTTJPO@VOSFHJTUFS
    ͕࡟আ

    @4&44*0/୅ೖΛ࢖͍ɺVOTFU @4&44*0/
    Λ࢖͏

    View full-size slide

  30. .Z42-/BUJWF%SJWFSͩͱ
    NZTRMͷύεϫʔυ͸
    MPOHQBTTXPSEͰͳ͚Ε͹͍͚ͳ͍

    View full-size slide

  31. mysql> SELECT PASSWORD('mypass');
    +--------------------+
    | PASSWORD('mypass') |
    +--------------------+
    | 6f8c114b58f2ce9e |
    +——————————+
    mysql> SET @@session.old_passwords = 0;
    Query OK, 0 rows affected (0.00 sec)
    mysql> SELECT PASSWORD('mypass');
    +-------------------------------------------+
    | PASSWORD('mypass') |
    +-------------------------------------------+
    | *6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4 |
    +-------------------------------------------+

    View full-size slide

  32. _人人人人人人人人人人人人人人人_
    > 突然のmysqlバージョンアップ <
     ̄Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y^Y ̄

    View full-size slide

  33. ͔͋ͨ΋஋͍࣋ͬͯ·͢งғؾ
    ͷม਺͕6OEFpOFEWBSJBCMF
    Λు͍͍ͯΔͷΛ໨ܸ͢Δ

    View full-size slide

  34. SFHJTUFS@HMPCBMTͱͷઓ͍

    View full-size slide

  35. w ม਺Λશ෦໨ࢹ֬ೝ͢Δͷ͸ແཧ
    w (&5΍1045Ͱ࢖͍ͬͯΔ΋ͷΛHSFQͯ͠ௐ΂ͨ
    QUa@(&5<cHSFQa@(&5<cTFETa
    @(&5< <"[>
    >acTPSUcVOJRDc
    TPSULOScOM

    View full-size slide

  36. QIQͰ࢖͍ͬͯͨͷ1&"3໰୊
    ϥΠϒϥϦ͸͢΂ͯϦϙδτϦʹಥͬࠐΜͰҰॹ
    ʹQIQରԠ

    View full-size slide

  37. GTPDLFUPQFO΍pMF@HFU@DPOUFOUTͳͲͷετϦʔ
    Ϝܥͷؔ਺ͰTTM઀ଓ͢Δ৔߹ɺূ໌ॻΛਖ਼͘͠ݟ
    ΔΑ͏ʹͳ͍ͬͯΔ
    ূ໌ূΛങ͍·͠ΐ͏

    View full-size slide

  38. - $fp = @$openfunc($this->addr, $this->port, $errno, $errstr, $timeout);
    + if (in_array($this->port, array(443, 8443, 9443))) {
    + $context = stream_context_create();
    + stream_context_set_option($context, 'ssl', 'verify_peer', false);
    + stream_context_set_option($context, 'ssl', 'verify_host', false);
    + stream_context_set_option($context, 'ssl', 'allow_self_signed', true);
    + $fp = stream_socket_client($this->addr . ':' . $this->port,
    + $errno, $errstr, $timeout, STREAM_CLIENT_CONNECT, $context);
    + } else {
    + $fp = @$openfunc($this->addr, $this->port, $errno, $errstr, $timeout);
    + }

    View full-size slide

  39. ·ͱΊ
    w ςετ͸ͪΌΜͱॻ͖·͠ΐ͏
    w ূ໌ॻ͸ങ͍·͠ΐ͏
    w ڊେϑϨʔϜϫʔΫ΍୔ࢁͷ֎෦ϥΠϒϥϦ࢖ͬͯͳ͔ͬ
    ͨͷ͕ٯʹྑ͔ͬͨͷ͔΋ʢQIQͳΜͰʜ
    w όʔδϣϯΞοϓ͸͜·Ίʹ΍Γ·͠ΐ͏
    w େ͖ͳվળ΋·ͨίετ͕͔͔ΔͷͰ೔ʑͷখ͞ͳश
    ׳͕େ੾

    View full-size slide

  40. એ఻
    w ϖύϘͰ͸ΤϯδχΞΛืू͓ͯ͠Γ·͢ɻ
    w ڞʹαʔϏεΛੜΈग़͠ҭͯͯ͘ΕΔ৽͍͠஥
    ؒΛ଴͍ͬͯ·͢ɻ
    w IUUQQFQBCPDPNSFDSVJUDBSFFS

    View full-size slide

  41. ͓ΘΓ
    UXJUUFS!MJOZPXT

    View full-size slide