ソーシャルゲームでDB水平分散 #mdb_casual

Slide 1

Slide 1 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ا٦ءٍٕ؜٦يד %#宏䎂ⴓ侔 HVTTBO!%SFDPN$P -UE

Slide 2

Slide 2 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 荈䊹稱➜ HVTTBO %SFDPN$P -UE ٓ؎ـٓٔծىسٕؐؑ،

Slide 3

Slide 3 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE %SFDPN

Slide 4

Slide 4 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 鑧ֿׅה ٥3BJMTד宏䎂ⴓ侔 ٥㼪Ⰵ٥麊欽ך鑧 ٥תה׭

Slide 5

Slide 5 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 宏䎂ⴓ侔

Slide 6

Slide 6 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ך⵸ח

Slide 7

Slide 7 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 㘋湫ⴓ侔

Slide 8

Slide 8 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 㘋湫ⴓ侔堣腉嫣ח%#؟٦غ׾ⴓֽ׷ ٥剅ֹ鴥׫頾蚚׾ⴓ侔ׇׁ׋ְ ! "1 6TFS %# &WFOU %#

Slide 9

Slide 9 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 㘋湫ⴓ侔ךא׵׫ 盖椚 ٥ذ٦ـٕ%# ٥NPEFM鷄⸇׃׋׵䟝㹀㢩ך%#

Slide 10

Slide 10 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 㘋湫ⴓ侔ךא׵׫ 頾蚚ך⨉׶ ٥؜٦يⰻ؎كٝز

Slide 11

Slide 11 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE %#؟٦غ頾蚚׾黝ⴖח؝ٝزٗ٦ٕ׃ծ أ؛٦ٕ׃זְ朐屣׾䩧灶׃׋ְ

Slide 12

Slide 12 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 宏䎂ⴓ侔

Slide 13

Slide 13 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 0DUPQVT

Slide 14

Slide 14 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 0DUPQVT 0DUPQVTVTJOH VTFS EP 6TFSOE YYY FOE

Slide 15

Slide 15 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ד׮ְְֽו

Slide 16

Slide 16 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ،فٔ؛٦ءّٝٗآحؙח䩛׾Ⰵ׸זְ

Slide 17

Slide 17 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ׮׏הؕآُ،ٕח宏䎂ⴓ侔׃׋ְ

Slide 18

Slide 18 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE HFN⡲׏׋

Slide 19

Slide 19 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE BDUJWFSFDPSEUVSOUBCMF "3׾宏䎂ⴓ侔ח㼎䘔ׇׁ׷HFN LFZךⰻ㺁ד醱侧%#חⴓֽג呓秛 ! ! %# %# %# "QQ VTFS@JE VTFS@JE

Slide 20

Slide 20 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 湡垥 ،فٔ؛٦ءّٝ׾剅ֻ➂ח 宏䎂ⴓ侔׾䠐陎ׇׁזְ

Slide 21

Slide 21 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 堣腉 ؙؒٔ荈⹛䮶׶ⴓֽ 䱰殢堣圓 ׉ך➭

Slide 22

Slide 22 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 堣腉 ؙؒٔ荈⹛䮶׶ⴓֽ 䱰殢堣圓 ׉ך➭

Slide 23

Slide 23 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ؙؒٔ荈⹛䮶׶ⴓֽ ٥ⴓⶴؗ٦׾TDPQFח鷄⸇ ̔42-ػ٦أ ̔%#鼅䫛 ̔醱侧%#ך穠卓و٦آ

Slide 24

Slide 24 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 麩ְ class User < ActiveRecord::Base turntable :user_cluster, :id end ! # on Octopus User.using(:xxx).where(id: 10) ! # on Turntable User.where(id: 10)

Slide 25

Slide 25 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 6TFSOE VTFS6TFSpOE <"DUJWF3FDPSE5VSOUBCMF>4FOEJOHNFUIPETFMFDU@BMM TRMTOJQ TIBSET <VTFS@TIBSE@> $IBOHJOH6TFSTTIBSEUPVTFS@TIBSE@ 6TFS-PBE NT <4IBSEVTFS@TIBSE@>4&-&$5AVTFSTA'30.AVTFSTA 8)&3&AVTFSTAAJEA-*.*5 $IBOHJOH6TFSTTIBSEUPNBTUFS 6TFSJE OJDLOBNFOJM TOJQ *%͕ଘࡏ͢Δ %#ͷΈʹ ΫΤϦΛ౤͛Δ

Slide 26

Slide 26 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 6TFSBMMUP@B 6TFSBMMUP@B <"DUJWF3FDPSE5VSOUBCMF>4FOEJOHNFUIPETFMFDU@BMM TRMTOJQ TIBSET <VTFS@TIBSE@ VTFS@TIBSE@ VTFS@TIBSE@> 6TFS-PBE NT <4IBSEVTFS@TIBSE@>4&-&$5AVTFSTA'30.AVTFSTA 6TFS-PBE NT <4IBSEVTFS@TIBSE@>4&-&$5AVTFSTA'30.AVTFSTA 6TFS-PBE NT <4IBSEVTFS@TIBSE@>4&-&$5AVTFSTA'30.AVTFSTA <6TFSJE OJDLOBNFOJM TOJQ 6TFSJE OJDLOBNFOJM TOJQ 6TFSJE OJDLOBNFOJM TOJQ 6TFSJE OJDLOBNFOJM TOJQ> શͯͷ%#ʹΞΫηε ݁ՌΛϚʔδ

Slide 27

Slide 27 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 6QEBUF VTFSVQEBUF@BUUSJCVUFT OJDLOBNFIPHFIPHF NT <4IBSEVTFS@TIBSE@>#&(*/ <"DUJWF3FDPSE5VSOUBCMF>4FOEJOHNFUIPEVQEBUF TRMTOJQTIBSET <VTFS@TIBSE@> $IBOHJOH6TFSTTIBSEUPVTFS@TIBSE@ 42- NT <4IBSEVTFS@TIBSE@>61%"5&AVTFSTA4&5AOJDLOBNFAʜTOJQ $IBOHJOH6TFSTTIBSEUPNBTUFS NT <4IBSEVTFS@TIBSE@>$0..*5 USVF ର৅%#ͷΈ6QEBUF

Slide 28

Slide 28 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 堣腉 ؙؒٔ荈⹛䮶׶ⴓֽ 䱰殢堣圓 ׉ך➭

Slide 29

Slide 29 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 䱰殢堣圓䱰殢׾%#דװ׷ה؟٦غ꟦ד*%ָ遼瑱 ٥ؔـآؙؑزך嫰鯰 ٥ؙٓأةךⱄ圓䧭儗 ؙٓأةⰋ⡤ה׃גِص٦ؙז䱰殢堣圓

Slide 30

Slide 30 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 䱰殢 CBSSBHFHFN ٥TOPXBLFMJLFז䱰殢 խ٥׌ְ׋ְ傻갫ծꬊ鸬竲 խ٥ぐXPSLFSָꬊず劍涸ח䱰殢〳腉

Slide 31

Slide 31 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 堣腉 ؙؒٔ荈⹛䮶׶ⴓֽ 䱰殢堣圓 ׉ך➭

Slide 32

Slide 32 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ׉ך➭ ٥Ⰻ%#חずׄNJHSBUJPO׾黝欽 ٥ؙٓأةⰋ⡤פך5SBOTBDUJPO

Slide 33

Slide 33 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE BDUJWFSFDPSEUVSOUBCMF ،فٔ؛٦ءّٝؒٝآص،ָ噰⸂䩛׾ַ ֽ׆ח幥׬宏䎂ⴓ侔׾㹋植

Slide 34

Slide 34 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 㼪Ⰵ٥麊欽

Slide 35

Slide 35 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 㼪Ⰵ 㼎韋麊欽⚥ך؜٦ي NPEFM侧

Slide 36

Slide 36 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ؟٦غ圓䧭 EC EC EC EC EC EC "1 EC EC EC EC

Slide 37

Slide 37 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ⴓ侔 ٥傀ח麊欽⚥ך،فٔ ٥%"6ծ竰竲桦ծ頾蚚朐屣ד✮庠

Slide 38

Slide 38 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 㼎䘔؝٦س䊴ⴓ $MBTT -0$ "EE %FM NPEFMT DPOUSPMMFS T

Slide 39

Slide 39 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ر٦ة獳遤⡲噟傀㶷%#ךر٦ة׾ⴓⶴׅ׷ 鷄⸇ׅ׷؟٦غ׾TMBWFה׃גאזּ ♶䗳銲זر٦ة׾⵴ꤐ

Slide 40

Slide 40 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 㼪Ⰵ

Slide 41

Slide 41 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 侧ؕ剢䖓

Slide 42

Slide 42 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 䠬䟝׾耀ְג׫׋ չוֲד׃׋պ

Slide 43

Slide 43 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 䠬䟝׾耀ְג׫׋ 1.孑չ׮ֲ✳䏝ה  װ׶׋ֻזְדׅיպ

Slide 44

Slide 44 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE sĪ

Slide 45

Slide 45 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE וך鴟ָא׵ְ

Slide 46

Slide 46 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 宏䎂ⴓ侔ךא׵׫ 堣腉ⵖꣲ 1MVHJO&OHJOFך娤 ؒٝآص،פךワ濼

Slide 47

Slide 47 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 堣腉ⵖꣲ ! ٥⢪ִזְָؙ֮ؒٔ׷ ٥QBHJOBUJPO ٥꧊鎘Ⳣ椚 ٥⦐ⴽ%#פ㉏ְさ׻ׇ穠卓׾و٦آ ٥堣腉荈⡤׾⵴ꤐׅ׷ֿה׮ 4&-&$5'30.VTFST03%&3#:JE-*.*5

Slide 48

Slide 48 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 1MVHJO&OHJOFך娤 ٥%#禸ךQMVHJO㠨徦 ٥BSJNQPSU BDUT@BT@BSDIJWF ٥&OHJOF ٥UVSOUBCMF㼎䘔ꬊ㼎䘔

Slide 49

Slide 49 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ワ濼宏䎂ⴓ侔ך罋䣁 ٥ٕ٦ٕך䗡䎿ծ5*14ךⰟ剣 %#鏣鎘 խ٥%#"׾❛ִ׋ٖؽُ٦

Slide 50

Slide 50 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 麊欽⚥ ٥宏䎂ⴓ侔ꟼ鸬ךꥺ㹱כ➙ךהֿ׹搀׃ ٥֮ת׶ח׮农럀ח׃ֺׅ׋䠬

Slide 51

Slide 51 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE תה׭

Slide 52

Slide 52 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE תה׭ ٥3BJMTד宏䎂ⴓ侔׾$BTVBMח䪔ֲ倯岀 ٥麊欽ח鯹ׇ׷ךכ$BTVBMהכְַזְ

Slide 53

Slide 53 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE BDUJWFSFDPSEUVSOUBCMF SFMFBTF ! 3BJMT 㼎䘔 IUUQTHJUIVCDPNESFDPN BDUJWFSFDPSEUVSOUBCMF

Slide 54

Slide 54 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE ׀幠耮֮׶ָהֲ׀ְׂת׃׋

Slide 55

Slide 55 text

$PQZSJHIU%SFDPN$P -UE"MM3JHIUT3FTFSWFE 株式会社ドリコム会社概要  http://www.drecom.co.jp/ 社名：設⽴立立：証券コード：本社：電話番号：社員数：資本⾦金金：事業内容： ! ! ! ! 株式会社ドリコム 2001年年11⽉月13⽇日 3793 （東証マザーズ）〒153-‐‑‒0064 　東京都⽬目⿊黒区下⽬目⿊黒１丁⽬目8-‐‑‒1 　アルコタワー17F TEL:03-‐‑‒6682-‐‑‒5700 　FAX:03-‐‑‒6682-‐‑‒5711 227名（正社員・契約社員のみ）※2014年年3⽉月31⽇日現在 1,124百万円　※2014年年3⽉月31⽇日現在ソーシャルゲーム事業、ソーシャルラーニング事業、広告事業、メディア事業