PHPConference_LT_PHPでGoogleCloudSpannerをつかってみる

1)1Ͱ (PPHMF$MPVE4QBOOFSΛ ͔ͭͬͯΈΔ גࣜձࣾαΠόʔΤʔδΣϯτɹനҪɹӳ QIQDPOQIQDPO

• גࣜձࣾαΠόʔΤʔδΣϯτ • 4(&౷ׅຊ෦ٕज़౷ׅࣨ$50 • നҪɹӳ • ΤϯδχΞ • 5XJUUFS
!HPPEPP • #MPH IUUQBNFCMPKQHPPEPP • %2 ͙ͪ͢Ή '# ϓΫϦϙ ཱྀܳਓ ͓લɺ୭Α

ηογϣϯࢿྉ͸ͷͪ΄Ͳެ։͠·͢ɻ ࣸਅࡱӨ͸ߏ͍·ͤΜ͕ɺҎԼΛक͍ͬͯͩ͘͞ γϟολʔԻΛফڈ͢Δ  ޙΖͷํͷअຐΛ͠ͳ͍

"HFOEB w(PPHMF$MPVE4QBOOFSͱ͸ w1)1ͷରԠঢ়گ wαϯϓϧΞϓϦέʔγϣϯ w·ͱΊ

(PPHMF$MPVE 4QBOOFSͱ͸

w ஍ٿن໛%#ɿେ཮ɾϦʔδϣϯؒࣗಈϨϓϦΧ w εέʔϧɿΦʔτγϟʔσΟϯά w μ΢ϯλΠϜͳ͠ɺ4-"  (PPHMFͷ ϦϨʔγϣφϧσʔλϕʔεαʔϏε

wάϩʔόϧͳεέʔϥϏϦςΟ wϑϧϚωʔδυ wϦϨʔγϣφϧηϚϯςΟΫε wτϥϯβΫγϣϯͷ੔߹ੑ wߴՄ༻ੑ 4QBOOFSͷಛ௃ 引用：https://cloud.google.com/spanner/ ɿϊʔυ͕̍୆͔Β਺ઍ୆·Ͱ ɿϨϓϦέʔγϣϯͱϝϯςφϯε͕ࣗಈ ɿεΩʔϚɺ42-ΫΤϦ
"/4* ɿڧྗ͔ͭάϩʔόϧ ɿ

ઃܭɺύϑΥʔϚϯεͷ࿩͸ ҎԼͷࢀߟจݙ΁ https://www.slideshare.net/ HammoudiSamir/cloud-spanner-78081604 https://www.slideshare.net/ ssuserc49633/20170822-cloud-spanner

1)1ͷରԠঢ়گ

ެࣜϗʔϜϖʔδΛ ΈͯΈΔͱɾɾɾ

ӳޠ൛ʹ͋ͬͨɾɾɾ https://github.com/GoogleCloudPlatform/php-docs-samples/tree/master/spanner νϡʔτϦΞϧιʔε͸ͪ͜Β

(PPHMF$MPVE4QBOOFS༻ 1)1ͷϥΠϒϥϦ͸ʁ

IUUQTHPPHMFDMPVEQMBUGPSNHJUIVCJPHPPHMFDMPVEQIQEPDTDMPVETQBOOFS MBUFTUTQBOOFSTQBOOFSDMJFOU

DPNQPTFSͰ͸͍Δ ͨͩ͠ɺH31$1)1&YUFOTJPO͕ඞཁ $ pecl install grpc

αϯϓϧΞϓϦέʔγϣϯ

#PPLTIFMGΞϓϦ

(PPHMF͕༻ҙͨ͠νϡʔτϦΞϧ༻ΞϓϦ https://github.com/GoogleCloudPlatform/getting-started-php σʔλετϨʔδͱͯ͠ w%BUBTUPSF w.POHP%# w.Z42- w1PTUHSF42- ʹରԠ͍ͯ͠Δ

4QBOOFSରԠ൛Λ ͭ͘Γ·ͨ͠

https://github.com/shirai-suguru/getting-started-php ˞PQUJPOBMDPNQVUFFOHJOFͷষ͔͠ରԠ͍ͯ͠ͳ͍Ͱ͢

.Z42-ͱ࢖͍উखΛ ͘Β΂ͯΈΔ

4&-&$5 όΠϯσΟϯά ݁Ռηοτͷૢ࡞

4&-&$5͸ɺ΄΅ಉ͡

61%"5& ओΩʔΛؚΉ࿈૝഑ྻͰ มߋσʔλΛҾ਺ʹઃఆ ओΩʔΛ ,FZ4FUܕͰ Ҿ਺ʹઃఆ %&-&5&

61%"5& %&-&5&͸ ओΩʔΛࢦఆͯ͠ͷมߋͷΈ

42-ͷ8)&3&۟Ͱࢦఆͨ͠ ৚݅ʹҰகͨ͠ߦͷมߋ͸ 61%"5& %&-&5&͚ͩͰ͸ ࣮ݱͰ͖ͳ͍

42-ͷ8)&3&۟Ͱࢦఆͨ͠ ৚݅ʹҰகͨ͠ߦͷมߋ͸ Ұ౓4&-&$5ͯ͠ ओΩʔΛऔಘͯ͠ 61%"5& %&-&5&͢Δ

*/4&35 τϥϯβΫγϣϯ */4&35

"650@*/$3&.&/5͕ͳ͍ ˞4QBOOFSͰ͸Ξϯνύλʔϯ ϗοτεϙοτʢαʔόͷภΓʣ͕ൃੜ͢ΔͨΊ

"650@*/$3&./5 ʹ͋ͨΔॲཧ

τϥϯβΫγϣϯͷѻ͍஫ҙ

σϑΥϧτͷઃఆ͸ τϥϯβΫγϣϯதͷॲཧ SVO5SBOTBDUJPO಺ͷؔ਺ ͕ ࣦഊͨ͠ΒϦτϥΠ͞ΕΔ

ෳ਺ճ࣮ߦ ͯ͠΋ େৎ෉͔ʁ ͜ͷιʔε͸/(

͜ͷιʔε͸ ͨͿΜ 0, .Z42-ͷ POEVQMJDBUFLFZVQEBUF ʹ͋ͨΔॲཧ

.Z42-ʹൺ΂Δͱ ࢖͍উख͕ɾɾɾ 1%0΄͍͠Ͱ͢ΑͶ

4QBOOFS༻1%0Λ ͭͬͯ͘Δ్த ؒʹ߹Θͳ͔ͬͨ

·ͱΊ

w4QBOOFS͸ϑϧϚωʔδυͷεέʔ ϥϒϧͳ3%#.4 w1)1͔ΒͰ΋ѻ͑Δ wαϯϓϧΞϓϦΛੋඇͭͬͯ͘Έͯʂ wτϥϯβΫγϣϯ஫ҙɺบ͕͋Δ w1%0ͭͬͯ͘·͢

w ௒࣮ફ$MPVE4QBOOFSઃܭߨ࠲ - https://www.slideshare.net/HammoudiSamir/cloud-spanner-78081604 w ී௨ͷΤϯδχΞ͕ʲ$MPVE4QBOOFSʳ࢖ͬͯΈͨ - https://www.slideshare.net/ssuserc49633/20170822-cloud-spanner w (FUUJOH4UBSUFEXJUI$MPVE4QBOOFSJO1)1
- https://cloud.google.com/spanner/docs/getting-started/php/ w $POUBJOFS&OHJOFͰͷ1)1#PPLTIFMGͷ࣮ߦ - https://cloud.google.com/php/tutorials/bookshelf-on-compute-engine w (PPHMF$MPVE$MJFOU-JCSBSZGPS1)1 - https://googlecloudplatform.github.io/google-cloud-php/#/docs/cloud- spanner/latest/spanner/spannerclient ࢀߟจݙ XFC

͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠

PHPConference_LT_PHPでGoogleCloudSpannerをつかってみる

PHPConference_LT_PHPでGoogleCloudSpannerをつかってみる

More Decks by CyberAgent SGE Engineer

Other Decks in Technology

Featured

Transcript