PHPConference_LT_PHPでGoogleCloudSpannerをつかってみる

by CyberAgent SGE Engineer

Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

(PPHMF$MPVE 4QBOOFSͱ͸

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

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

Slide 8

Slide 8 text

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

Slide 9

Slide 9 text

1)1ͷରԠঢ়گ

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

IUUQTHPPHMFDMPVEQMBUGPSNHJUIVCJPHPPHMFDMPVEQIQEPDTDMPVETQBOOFS MBUFTUTQBOOFSTQBOOFSDMJFOU

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

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

Slide 16

Slide 16 text

#PPLTIFMGΞϓϦ

Slide 17

Slide 17 text

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

Slide 18

Slide 18 text

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

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

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

Slide 22

Slide 22 text

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

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

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

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

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

Slide 27

Slide 27 text

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

Slide 28

Slide 28 text

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

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

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

Slide 31

Slide 31 text

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

Slide 32

Slide 32 text

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

Slide 33

Slide 33 text

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

Slide 34

Slide 34 text

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

Slide 35

Slide 35 text

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

Slide 36

Slide 36 text

·ͱΊ

Slide 37

Slide 37 text

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

Slide 38

Slide 38 text

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

Slide 39

Slide 39 text

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