Talk on Database (ja)

Transcript

1. 1.

   σʔλϕʔεͷ͸ͳ͠ Basho Japan KK Kota UENISHI 2014/1/31

2. 2.

   ͲͪΒ༷Ͱ͔͢ʁ •  @kuenishi •  NTTݚڀॴ ˠ Basho •  Erlang/OTPΛॻ͍ͯ࢓ࣄΛ͍ͯ͠·͢ • 

   ෼ࢄσʔλϕʔεɾ෼ࢄγεςϜͷ঎༻։ൃྺ 6೥ •  ϛυϧ΢ΣΞతͳ΋ͷ͕ൺֱతಘҙͰ͢
3. 3.

   •  Riakͱ͍͏OSSͷ෼ࢄσʔλϕʔε Λ࡞ͬͯച͍ͬͯ·͢ •  Riak CSͱ͍͏OSSͷΫϥ΢υετ ϨʔδΛ࡞ͬͯଧ͍ͬͯ·͢ •  ʮ෼ࢄਥʯΧϯϑΝϨϯε
   Ricon.io • 

   Basho.com 3
4. 4.

   ͖͔͚ͬ 4 தུ ʮ಺༰ͱͯ͠͸riakͱ ɹNoSQLΛؚΊͯ ɹ௖͚ͨΒʯ

5. 5.

   ࠓ೔͓΅͑ͯ΋Β͏͜ͱ •  NoSQL͸όζϫʔυͰ͋Γɺఆٛ͸ͳ͍ •  ͍Ζ͍ΖͳσʔλετΞͱͦͷ෼ྨɺ࢖͍෼͚ͷίπ •  ෼ࢄγεςϜ΍σʔλϕʔεपลͷ໰୊ɺ၆ᛌਤ •  Riak͸ૉ੖Β͍͠σʔλϕʔεͰ͋Δ

6. 6.

   ͦ΋ͦ΋ σʔλϕʔεͱ͸Կʁ •  ΞϓϦέʔγϣϯͷσʔλΛίϯϐϡʔλʹอଘ͢Δ ͨΊͷιϑτ΢ΣΞʢϥΠϒϥϦ or αʔόʔʣ 6 01010110100001001011 11001010101010100101

   01001010101001010100 10101010010111111110 00000101111100101010 00000010010101001001 01001010010010100
7. 7.

   อଘ͢Δͱ͖ͷཁٻ •  σʔλΛਖ਼͘͠ॻ͖ࠐΉ͜ͱɺσʔλͷߋ৽͕த్൒ ୺ͳঢ়ଶͰࣦഊ͠ͳ͍͜ͱ •  ॻ͖ࠐΜͩσʔλΛਖ਼͘͠ಡΈग़͢͜ͱ •  ॻ͖ࠐΜͩσʔλΛผܗࣜʹม׵ͯ͠ಡΈͩ͢͜ͱ •  ϋʔυ΢ΣΞੑೳͷݶք·Ͱߴ଎ʹอଘ͢Δ͜ͱ

   •  ϋʔυ΢ΣΞੑೳͷݶք·Ͱߴ଎ʹಡΈग़͢͜ͱ •  σʔλ͕ফ͑Δ৚͕݅ਖ਼֬ʹ൑໌͍ͯ͠Δ͜ͱ 7
8. 8.

   ྺ্࢙ͷσʔλϕʔε •  IDS (GE, 1963) •  ֊૚ܕDB •  IMS (IBM,

   1966 -), •  ωοτϫʔΫܕDB •  CODASYL (1969, COBOL), •  ࠓ΋ಈ͍͍ͯΔ੡඼΋͋Δ 8
9. 9.

   1977೥ System R (IBM) •  ؔ܎୅਺ͷཧ࿦ʹج͍ͮͨσʔλૢ࡞ݴޠ SQLΛ࣮૷ͨ͠ੈքॳͷσʔλϕʔε •  Ұ؏ͨ͠σʔλʹର͢Δෳ਺ͷૢ࡞Λશͯ ੒ޭɾશࣦͯഊʹ·ͱΊɺෳ਺ͷߋ৽ཁٻ

   Λฒߦ੍ޚ͠ɺσʔλΛӬଓԽ͢Δτϥϯ βΫγϣϯॲཧΛ࣮૷ͨ͠ੈքॳͷσʔλ ϕʔε •  ۀ຿ॲཧͷϞσϧʹඇৗʹΑ͘Ϛονͨ͠ ͨΊɺരൃతʹීٴɹˠISOͰඪ४Խ •  1983೥ Oracle v3 •  1987೥ Sybase SQL Server (ݱMicrosoft SQL Server) 9
10. 10.

    ͸͡Ί͔ΒSQLͩͬͨΘ͚Ͱ΋ϦϨʔγϣφϧ ͩͬͨΘ͚Ͱ΋ͳ͍ ͭ·Γ… 10

11. 11.

    RDBMSͷ࣌୅ •  ACIDಛੑʹج͍ͮͨτϥϯβΫγϣϯ؅ཧ
    •  SQLͱ͍͏౷Ұ͞ΕͨΠϯλʔϑΣʔε •  ੈքதͷΤϯλʔϓϥΠζͷσʔλ؅ཧ͸ΦϑΟεͷOA ԽɾγεςϜͷΦʔϓϯԽʹ൐͍RDBMS͕ओྲྀʹ •  εέʔϧΞοϓͷ࣌୅Ͱ΋͋Δ

    •  1995೥ͷHDDͷGB୯Ձ: ~7.5ສԁ
    / GB 11
12. 12.

    •  2003೥ʙɹITόϒϧ่յޙ •  Ոఉ༻ίϯϐϡʔλɺϒϩʔυόϯυͷීٴ •  Web 2.0ɺϒϩάɺWikipediaɺEϝʔϧɺWebݕࡧɺEC •  1998೥ Google૑ۀ

    •  1995೥ Amazon૑ۀ •  “Web Scale” ͷσʔλྔ 12 Webͷ࣌୅
13. 13.

    •  ٻΊΒΕΔ͜ͱ͕มԽ: ߏ଄͸؆୯Ͱ΋ɺྔ΍τϥ ϑΟοΫɺϨεϙϯεɺՄ༻ੑͳͲͷཁٻ͕ଟ༷ Խɾߴ౓Խ •  σʔλͷ୯Ձ͕͍҆etc •  RDBMSͰ͸ղܾͰ͖ͳ͍Φʔμʔ·Ͱσʔλྔ͕ ૿Ճ͢ΔʹैͬͯɺͦΕΛղܾ͢Δٕज़͕ొ৔

    •  ؔ܎ϞσϧɺSQLͰ͸ѻ͍ʹ͍͘σʔλϞσϧʢ୯ ७͕ͩΑ͘มԽ͢Δσʔλߏ଄ʣ •  2003೥ͷHDDͷGB୯Ձ: 100ԁ / GBɹ(120GB) 13 “Web Scale”
14. 14.

    Web Scale΁ͷΞϓϩʔν •  Ոఉ༻ίϯϐϡʔλͱಉ͡HW •  LAMP + Memcached(2003) •  Redis

    (2009) •  Google: GFS(2003), BigTable(2006) •  Hadoop (2006), HBase (2006) •  Amazon: Dynamo(2006) •  Cassandra (2008), Riak (2009) 14
15. 15.

    ຊ౰ʹղ͖͍ͨ໰୊ 15

16. 16.

    εέʔϦϯάͷ໰୊ 16

17. 17.

    εέʔϦϯάͷํ๏ •  ෳ਺୆ͷϊʔυʹσʔλΛ෼ࢄอ࣋ͯ͠ྔΛՔ͙ •  ʮͲͷσʔλ͕Ͳͷαʔόʔʹೖ͍ͬͯΔ͔ʁʯ 17

18. 18.

    18

19. 19.

    ϋογϡతϧʔςΟϯά •  Riak, Cassie, DynamoͳͲ •  Կ͕Ͳ͜ʹ͋Δ͔ Θ͔Γʹ͍͘ •  εέʔϧΞ΢τɺ

    ෛՙ෼ࢄ͕؆୯ 19 node1 node2 node3 node4
20. 20.

    “ϋογϡత” •  ΩʔͱϊʔυIDΛϋογϡԽͯ͠ಉ໊͡લۭؒʹஔ͘ •  ϋογϡͷ୯ҐͰσʔλΛ෼ׂͯ͠഑ஔ •  ϊʔυ௥Ճɾ࡟আͷͱ͖ͷσʔλ࠶഑ஔΛ࠷খݶʹͰ ͖Δ 20 {foo,

    SomeData}! Hash(foo)%N! Hash(node1)%N!
21. 21.

    21 Locality vs Load Balancing - Use Cases • ઌಡΈΛޮ͔ͤͯόϧΫͰγʔέϯγϟϧΞ

    Ϋηε • - HBase, BigTable, etc • ϋογϡͰ෼ࢄͤͯ͞ෛՙ෼ࢄͯ͠ϥϯμϜ ΞΫηε • - Riak, Cassie, etc
22. 22.

    ੔߹ੑͷ໰୊ 22

23. 23.

    Q. ੔߹ੑͬͯͳΜͩͱ ͓΋͍·͔͢ʁ 23

24. 24.

    ੔߹ੑʹ͸2ͭͷจ຺͕͋Δ •  ڞ௨͢Δͷ͸ʮ୭͕ݟͯ΋ಉ͡Α͏ʹݟ͑Δ͜ͱʯ •  ෳ਺छྨͷσʔλؒͷInvariant͕कΒΕ͍ͯΔ͜ͱ •  “ACID” తͳAnomaly͕ൃੜ͠ͳ͍͜ͱ •  Phantom

    Read, Write Skew, etc etc… •  ෳ਺ͷσʔλͷίϐʔ͕ಉ͡Ͱ͋Δ͜ͱ •  ෳ਺ͷίϐʔΛ҆શʹߋ৽Ͱ͖Δ͜ͱ •  ผʑͷਓͰ΋ಉ͡σʔλΛݟΕ͍ͯΔ͜ͱ
25. 25.

    25 Consistent Replication is Difficult • ϨϓϦέʔγϣϯ͸ॱ൪͕ೖΕସΘΔ • CPUͷΞ΢τΦϒΦʔμʔ࣮ߦͱಉ͡ w1

    w1 w1 w2 w2 w2 Actor 0 Actor 1 Actor 2 w2 w2 w1
26. 26.

    ෼ࢄ߹ҙ໰୊ •  ʮෳ੡͕͢΂ͯಉ͡Ͱ͋Δʯ •  ʹʮશһ͕ͻͱͭͷ஋ʹ߹ҙͰ͖͍ͯΔঢ়ଶʯ •  ΞϠγ͍ಈ࡞Λ͢ΔՄೳੑ͕͋Δ΋ͷ •  ωοτϫʔΫ • 

    ߹ҙ͢Δ૬ख •  ੍ݶ࣌ؒɿແݶ 26
27. 27.

    ·͡Ίʹॻ͘ͱ… •  ͍ͭͰ΋յΕΔՄೳੑͷ͋Δෳ਺ͷϊʔυ͕ɺ •  յΕͯ·ͨ෮ؼ͢ΔՄೳੑ΋͋Δ •  ฦࣄ͕஗͍͚ͩͷ৔߹΋ •  ৴པੑͷ௿͍ϊʔυؒ௨৴Λ࢖ͬͯ • 

    ΋ͷ͘͢͝஗Ԇ͍ͯ͠Δ͚Ͳ࣮͸ಧ͘ •  ͻͱͭͷ஋Λ߹ҙ͢ΔʢͷʹͲͷΑ͏ͳ৚݅ͱϓϩτ ίϧ͕͋Ε͹Α͍͔ʁʣ 27
28. 28.

    ͳͥ೉͍͠ͷ͔ •  ࢮ׆؂ࢹ͕೉͍͠ •  ϦʔμʔΛఘΊΔɺϚελʔΛఘΊΔɺetc •  ࢳి࿩Ͱࢮ׆؂ࢹ͢Δ࿅श •  ނোϞσϧͷ͸ͳ͕͍͠Ζ͍Ζ͋Δ 28

29. 29.

    ࢮ׆؂ࢹ͸೉͍͠ •  ʮࢮΜͩ͜ͱʯΛਖ਼͘͠ݟ͚ͭΔͷ͸೉͍͠ •  ࣮ݧʢ͕࣌ؒ͋Ε͹ʣ 29

30. 30.

    ʮࢮΜͰ͍Δʯ is Կ 30 © ʮ๺ేͷݓʯݪ఩෉ɺ෢࿦ଚ

31. 31.

    ނোతࠔΔ͜ͱͷ෼ྨ Crash Failure ɹ (fail-stop, fail-safe) ނোͨ͠Βࢭ·Δɺࢭ·ͬͨ͜ͱ͕͢ ͙ʹ෼͔Δ Crash Failure

    (fail-silent) ໧ͬͯࢮ͵ Crash Recovery ނোͨ͠ϑϦͯ͠஌ΒΜ΀Γͯ͠ؼͬͯ ͘Δ Omission Failure (receive / send) ϝοηʔδܽམ Timing Failure ·ͱ΋ͳ଎౓Ͱಈ͔ͳ͘ͳΔ Response Failure Ϩεϙϯε͕͓͔͍͠ʢσʔλ͕յΕͯ ͍Δetcʣ Arbitrary Failure Ϗβϯνϯނোɺѱҙͷ͋ΔϠπ͕͍Δ 31
32. 32.

    ෼ࢄ߹ҙͷछྨ •  ʮΞτϛοΫϒϩʔυΩϟετϓϩτίϧʯ •  ͓͓·͔ʹ͍ͬͯ෼ࢄ߹ҙ͢ΔͨΊͷϓϩτίϧΛ ૯শͯ͠ •  ΞτϛοΫ͡Όͳ͍ϒϩʔυΩϟετ΋୔ࢁ͋ͬͯͦ ΕͳΓʹಈ͍͍ͯΔ • 

    ୅දతͳ΋ͷ
    Paxos, Rafter, ZAB 32
33. 33.

    33 Consensus Based Replication • ϨϓϦέʔγϣϯͷϦʔμʔΛଟ਺ܾͰબग़ • or ϨϓϦέʔγϣϯຖʹଟ਺ܾ w1

    w1 w1 w2 w2 w2 Actor 0 Actor 1 Actor 2 w2 w2 w1
34. 34.

    34 What is PAXOS? – Example
      Two phase election

    – phase 1  Larger n is prior 21:32 8ß: ¼ ÛËÙêîĝ
    21:36 O2Ě
    21:35 [_ÕðJK
    21:36 O2ÙÐÄorz 21:38 O2ÙÐÞorz n=3
    n=1
    n=2
    8
35. 35.

    35 What is PAXOS? – Example
      Two phase election

    – phase 2  confirmation 21:42 Ãğ
    21:41 O2ÙÀÀ ëÞĝĚ
    21:43 a~Å…
    21:44 Ãğ 21:43 GJ proposer
    21:43 ÀêO2ÚyÁËÚ Ù|N`çÜßÙ
    n=4
    9
36. 36.

    Մ༻ੑͷ໰୊ •  σʔλΛ͍͟ॻ͖ࠐ΋͏ͱࢥͬͨॠؒʹσʔλ͕σʔλϕʔε ͕མ͍ͪͯͨΓݻ·͍ͬͯͯ͸ϏδωενϟϯεΛಀ͢ 36

37. 37.

    CAPఆཧ ͲΜͳނোʹରͯ͠΋
    QBSUJUJPO
    UPMFSBODF
    σʔλ͸ৗʹ੔߹͓ͯ͠Γ
    DPOTJTUFODZ
    γεςϜ͕ࢭ·Δ͜ͱ͸ͳ͍
    BWBJMBCJMJUZ
    

    • ͜ͷ3ͭΛಉ࣌ʹຬͨ͢γεςϜ͸ଘࡏ͠ͳ͍ • ͜Ε·ͰͷRDBMS͸CAॏࢹ 37
38. 38.

    CAPఆཧ
    ʢCॏࢹͷ৔߹ʣ •  n1ͱn2ͷϨϓϦΧΛৗʹ੔߹͓ͤͯ͘͞ •  ωοτϫʔΫ͕੾ΕͨΓނোͨ͠ΒࢭΊΔˠՄ༻ੑˣ 38 w1 w2 n1 n2

39. 39.

    CAPఆཧ
    ʢAॏࢹͷ৔߹ʣ •  n1ͱn2ͷϨϓϦΧΛৗʹ࢖͑ΔΑ͏ʹ͢Δ •  ωοτϫʔΫ͕੾ΕͨΓނোͯ͠΋ॻ͚Δˠ੔߹ੑˣ 39 w1 w2 n1 n2

40. 40.

    CAPఆཧ
    ʢPॏࢹͷ৔߹ʣ •  n1ͱn2ͷϨϓϦΧΛΤεύʔʹ͢Δ •  ωοτϫʔΫ͕੾ΕͨΒਖ਼͍͠ํ͕Θ͔ΔˠՄ༻ੑͪ ΐͬͱˣ 40 w1 w2 n1

    n2
41. 41.

    Amazon’s Dynamo •  ʮσʔλϕʔε͸ϦϨʔγϣφϧ͚ͩ͡Όͳ͍ɺ੔߹ ੑ͚ͩ͡Όͳ͍ɺՄ༻ੑ͕େࣄͳ৔߹΋͋ΔΜͩʯ •  ΞϚκϯͷγϣοϐϯάΧʔτʹ࢖ΘΕ͍ͯͨ •  Vector Clocks

    •  Handoff •  (CRDT in Riak) 41
42. 42.

    ʮͱΓ͋͑ͣॻ͘ʯͱ͍͏ߟ͑ •  “Hinted Handoff” Ϧϯάͷ࣍ͷਓ ʹͱΓ͋͑ͣ౉͓ͯ͘͠ •  ނো͔Β໭͖ͬͯͨΒฦ͢ •  ॻ͖ࠐΈ͕ॏෳͨ͠Βʁ

    42 w1
43. 43.

    ͱΓ͋͑ͣॻ͍͓͍ͯͯ ॻ͖ࠐΈ͕িಥͨ͠Βʁ •  ྆ํ͓͍࣋ͬͯͯɺিಥͨ͠σʔ λͷʮҼՌؔ܎ʯΛ໌Β͔ʹ͢Δ •  “Vector Clock” •  {a:

    1, b:2, c:1} ͱ {a: 2, b:2, c:1} •  {a: 1, b:2, c:1} ͱ {a: 1, c:1, d:1} •  িಥͨ͠΋ͷ͸ΞϓϦͰղܾ 43 w1 w2 r
44. 44.

    44 CRDT • CRDT (Conflict-Free Replicated Data Types • “AP”

    Λαϙʔτ • Counter, Register, Sets, Maps • →ผεϥΠυʁ
45. 45.

    45 CRDTͰͷRead • ॱ൪͕ೖΕସΘͬͯ΋݁Ռ͕มΘΒͳ͍ܕ • update(w1, update(w2, Data0) = update(w2,

    update(w1, Data0) = Data w1 w1 w1 w2 w2 w2 Actor 0 Actor 1 Actor 2 w1(w2(Data0)) => Data w1(w2(Data0)) => Data w2(w1(Data0)) => Data
46. 46.

    ACID vs BASE ACID BASE ੔߹͍ͯ͠ͳͯ͘΋ ৗʹσʔλʹΞΫη εͰ͖Δ Basically Avaiable

    Atomicity ෳ਺ͷૢ࡞ͷ੒ޭɾ ࣦഊΛ·ͱΊΔ Consistency ৑௕Խ͞Εͨσʔλ ΍ෳ਺ͷϦϨʔγϣ ϯ͕ৗʹ੔߹͍ͯ͠ Δ ࠷ऴతʹ੔߹ͨ͠ঢ় ଶʹͳΔ͜ͱ͕อূ ͞Ε͍ͯΕ͹Α͍ Eventually Consistent Isolation ฒߦ؅ཧͯ͠ߋ৽్ தͷঢ়ଶΛݟͤͳ͍ Durability σʔλΛӬଓԽͯ͠ ࣦΘͳ͍ ϨϓϦΧ͸ܾఆ࿦త Ͱ͸ͳ͘ɺ֬཰తͰ ͋ͬͨΓɺάϩʔό ϧʹҰ؏͍ͯ͠ͳ͘ ͯ΋Α͍ Soft-state 46
47. 47.

    σʔλετΞͷ෼ྨ࣠ 47

48. 48.

    ΫΠζɿͲ͜·Ͱ͕DB? Ͳ͔͜Β͕NoSQL? ACIDͳτϥϯβΫγϣϯ τϥϯβΫγϣϯͳ͠ SQLΠϯλʔϑ Σʔε Oracle MySQL PostgreSQL SQL

    Server, DB2 Cassandra (CQL) Hive, Presto Impala ಠࣗAPI InnoDB BerkeleyDB FoundationDB Riak MongoDB Redis 48
49. 49.

    ςετʹग़ͳ͍ຊ౰ͷ͜ͱ 49

50. 50.

    CAPఆཧ͔ΒΈͨ੡඼ͷ෼ྨ •  CAॏࢹ •  RDBMS, MongoDB, HBase, etc… •  ੔߹ੑҡ࣋ͷͨΊͷ෼ࢄ߹ҙʢਖ਼͘͠ϑΣΠϧΦʔ

    όʔ͢ΔͨΊʣͷ࢓૊Έ͕ඞཁ •  APॏࢹ •  Cassandra, Riak, CouchDB •  ෼ࢄ߹ҙͷ࢓૊Έ͕ෆཁʹ࣮૷΋ӡ༻΋؆୯ 50
51. 51.

    ͜͜·Ͱͷ·ͱΊ: ͱͯ΋ᐆດͳද CAॏࢹ APॏࢹ RDBMS HBase MongoDB Cassandra CouchDB Riak

    51
52. 52.

    ϦϨʔγϣφϧϞσϧΛఘΊΔ 52 •  ςʔϒϧߏ଄ => KVS (Mapߏ଄) •  Pkey͸ΧϥϜͷͻͱ͔ͭΒબͿ΋ͷ
    => ඞਢͷ΋ͷ

    •  JOINΛͤ͞ͳ͍ •  ͜ΕʹΑΓεέʔϧΞ΢τܕͷ෼ࢄ͕Մೳʹ •  εΩʔϚΛࣄલఆٛ͠ͳ͍
53. 53.

    εΩʔϚ: σʔλϕʔεͷσʔλߏ଄ΛܾΊΔ΋ͷ •  εΩʔϚΛࣄલʹఆٛ: ϦϨʔγϣφϧϞσϧʹԊͬͨ࢖͍ํ •  Pros: σʔλߏ଄ʹڧྗͳ੍໿Λ՝ͨ͢Ί࠷దԽ͠΍͍͢ˍΞϓϦ Λ։ൃ͠΍͍͢ • 

    Cons: ΞϓϦͷมߋίετ͕ߴ͍ˍ࠷ॳʹద੾ʹઃܭ͠ͳ͍ͱ͔ͳ Γมߋʹऑ͍ •  εΩʔϚΛࣄલʹܾΊΔඞཁ͕ͳ͍৔߹ •  Pro: σʔλߏ଄Λޙ͔ΒͰ΋͔ͳΓॊೈʹมߋͰ͖Δ •  Con: ςετ͕ͳ͍ͱόά͕ग़΍͍͢ɺσʔλߏ଄͕ෳࡶͩͱ࠷ద Խ͠ʹ͍͘ 53
54. 54.

    ৽͍͠σʔλϞσϧ ΧϥϜࢦ޲ •  ΧϥϜΛ͍͘ΒͰ΋૿΍ ͢͜ͱ͕Ͱ͖Δ •  Query LanguageΛ࡞Δ •  ʮΧϥϜϑΝϛϦʔʯ

    •  HBase, Cassandra υΩϡϝϯτࢦ޲ •  ݸʑͷϨίʔυ͕ࣗ༝ͳ ܗࣜΛ࣋ͭ •  MapReduceͰΫΤϦ •  XML, JSON, etc … •  CouchDB, MongoDB 54
55. 55.

    ͜͜·Ͱͷ·ͱΊ: ͱͯ΋ᐆດͳද2 CAॏࢹ APॏࢹ SQL RDBMS - ΧϥϜࢦ޲ HBase Cassandra

    υΩϡϝϯτࢦ޲ MongoDB CouchDB (blob) Riak 55
56. 56.

    ΋͏ͻͱͭσʔλϞσϧ Graph •  Semantic Webతͳσʔλߏ଄Λѻ͏ͨΊͷDB •  ;ͨͭͷํ޲ੑ •  ϊʔυͱΤοδΛਂ͘୳ࡧ͍ͨ͠ • 

    ϊʔυͱΤοδ͕ଟ͗͢Δ 56
57. 57.

    σʔλϕʔε͕ಈ͘ॲཧܥ •  ωΠςΟϒ •  ଎͍ɺϝϞϦ؅ཧɺGC͕ͳ͍ •  JVM •  ଎͍ɺϝϞϦ؅ཧ͠ͳ͍͍ͯ͘ɺGC͕ى͖Δ • 

    Erlang VM •  ͦͦ͜͜଎͍ɺϝϞϦ؅ཧ͠ͳ͍͍ͯ͘ɺGCͰࢭ ·Βͳ͍ 57
58. 58.

    58

59. 59.

    ͍··Ͱઆ໌͖ͯͨ͠ͷͰ؆୯ ໰୊ Riak͸Ͳ͏͍ͯ͠Δ͔ εέʔϦϯά ϋογϡతϧʔςΟϯάͰGossipͳਫฏ෼ࢄ ੔߹ੑͷ؅ཧ Vector Clocks, CRDTͳͲRead࣌ʹղܾ 2.0Ͱ͸Paxos΋ೖΔ

    Մ༻ੑͷอূ Hinted HandoffΛ࢖ͬͯৗʹॻ͖ࠐΈ͕Ͱ͖ΔΑ͏ ʹ͍ͯ͠Δ σʔλϞσϧ Blob + Document Based ΠϯσοΫεΛ͸ΕΔ MapReduce͕Ͱ͖Δ ॲཧܥ Erlang VM 59
60. 60.

    ࣮૷໘ͰͷRiakͷಛ௃ •  ʮ໷தʹΞϥʔτͰى͜͞Εͳ͍ʯ͜ͱΛ໨ࢦͨ͠ •  Erlang VMΛ࢖༻ •  GCʹΑΔఀࢭ͕࣌ؒͳ͍ •  ແఀࢭͰͷύονద༻ɺղੳɺૢ࡞͕Մೳ

    •  ίϚϯυମܥɾϑΝΠϧߏ଄ɾσʔλߏ଄ΛͳΔ΂͘γϯϓϧʹઃ ܭ͠ӡ༻ෛ୲Λ௿ݮ •  ҆ఆੑΛॏࢹͨ͠ઃܭ •  ίϯύΫγϣϯɺ༧ଌՄೳੑ 60
61. 61.

    ݁ہɺͲ͏͍͏ͱ͖ʹͲΕΛ࢖͑͹Α͍ͷ͔ʁ 61

62. 62.

    ࣮૷໘΋ߟྀͨ͠ ੡඼બ୒ͷϙΠϯτ •  JOINͳͲσʔλͷਖ਼نԽ͕ඞཁͳͱ͖: RDBMS •  ΦϯϝϞϦͰ࠷৽ͷ࣌ܥྻσʔλΛݟ͍ͨͱ͖: MongoDB •  ΧϥϜΛ͍͘ΒͰ΋૿΍͍ͨ͠ͱ͖

    •  SQL෩ͷΫΤϦΛ͍ͨ͠ͱ͖ or Մ༻ੑ: Cassandra •  େྔσʔλʹޮ཰తʹόονॲཧΛ͍ͨ͠ͱ͖: Hbase •  σʔλΛͳ͘͞ͳ͍&μ΢ϯλΠϜΛͳ͍ͨ͘͠ͱ͖: Riak 62
63. 63.

    ·ͱΊ •  σʔλϕʔεͷྺ࢙తʹNoSQL͸৽͘͠͸ͳ͍ •  SQLͱACID͸ผͷ͸ͳ͠ɺNoSQLͱ͍͏ΑΓNoACID •  εέʔϦϯά͸ʢཧ۶͸ʣ೉͘͠ͳ͍ •  ੔߹ੑ͸ཧ۶͔Βͯͦ͠΋ͦ΋೉͍͠ • 

    Մ༻ੑ͸ͦΜͳʹ೉͘͠ͳ͍ •  Riak͸Մ༻ੑͱεέʔϥϏϦςΟ͕ಘҙ 63
64. 64.

    Questions? 64 ࢀߟจݙϦετ: https://gist.github.com/kuenishi/8296883#refs