Slide 1

Slide 1 text

PostgreSQLΛAWS DMSͰ ҆৺҆શόʔδϣϯΞοϓ 2018-12-01 தࠃ஍ํDBษڧձ in ௗऔ(૔٢) ೔ຊPostgreSQLϢʔβʔձ தࠃ஍ํࢧ෦௕ ߴڮ Ұٍ 1

Slide 2

Slide 2 text

͓͠ͳ͕͖ 1. ࣗݾ঺հ 2. DMSόʔδϣϯΞοϓͷΞʔΩςΫνϟߟ࡯ 3. AWS Database Migration Service ͱ͸ 4. σϞ 5. AWS DMS ׆༻ࣄྫ 6. ·ͱΊ 2

Slide 3

Slide 3 text

஫ҙࣄ߲ • εϥΠυ͸ެ։͠·͢ɻ • ࣭໰ͱ͔͝ࢦఠͱ͔ॾʑͷϑΟʔυόοΫ͕͍͟͝·ͨ͠Β #ChugokuDB ΁ ͓ئ͍க͠·͢ɻ • RDSͳͲͷAWSͷαʔϏεͷࣄલ஌͕ࣝඞཁͰ͢ɻ • RDS: AWS͕ఏڙ͢ΔϚωʔδυRDBαʔϏε 3

Slide 4

Slide 4 text

1. ࣗݾ঺հ • ߴڮ Ұٍ • Ԭࢁࡏॅ • גࣜձࣾΦϛΧϨ WebΤϯδχΞ • ೔ຊPostgreSQLϢʔβʔձ தࠃࢧ෦௕ • PostgreSQLྺ 5ϲ݄ ! 4

Slide 5

Slide 5 text

גࣜձࣾΦϛΧϨ (ࣗࣾʹ͍ͭͯͪΐͬͱએ఻) શࠃ35,000݅ͷࠗ׆ύʔςΟΛ ܝࡌͨ͠ϙʔλϧαΠτ 25ສਓڧͷձһͷํʑʹ͝ར༻௖͍͍ͯ· ͢ɻ ࠗ׆ͱݴ͑͹ΦϛΧϨʂ \\݁ࠗ͸͍͍ͧʂʂ// 5

Slide 6

Slide 6 text

ʮPostgreSQLΛDMSͰ҆৺҆શόʔδϣϯΞοϓʯ ΦϛΧϨͰ͸ݱࡏਐߦܗͰDMSΛར༻ͯ͠ DBϦϑΝΫλϦϯάϓϩδΣΫτΛߦ͍ͬͯ·͢ɻ ࠓճ͸DMSΛ׆༻ͯ͠ όʔδϣϯΞοϓ͕ʮग़དྷͦ͏ʯͳͷͰߟ͑ͯΈͨɻͬͯൃද಺༰Ͱ ※ ʮϕετϓϥΫςΟεʯͰ͸͋Γ·ͤΜɻ • DMSͬͯԿʁ • DMSΛΑΓόʔδϣϯΞοϓʹ׆͔͢ҝʹग़དྷΔࣄ. • DMSͷػೳ͚ͩͰߦ͑Δখ͞ͳϦϑΝΫλϦϯάɻ • DMSͰ͸Ҡߦग़དྷͳ͍΋ͷɻ 6

Slide 7

Slide 7 text

2. DMSόʔδϣϯΞοϓͷ ΞʔΩςΫνϟߟ࡯ 7

Slide 8

Slide 8 text

DMSͱ͸ • ؆୯ʹઆ໌͢ΔͱɺωοτϫʔΫӽ͠ʹσʔλҠߦΛߦ͏ࣄ ͕ग़དྷΔαʔϏεɻ • ࠓճ͸͜ͷDMSΛ׆༻ͯ͠ϝδϟʔόʔδϣϯΞοϓΛߦ͏ ࢼΈΛͯ͠Έ·͢ɻ ※ DMSʹ͍ͭͯ͸ޙͰৄ͘͠આ໌͠·͢ 8

Slide 9

Slide 9 text

DMSͷόʔδϣϯΞοϓͷ ΞʔΩςΫνϟΛߟ͑Δ 9

Slide 10

Slide 10 text

10

Slide 11

Slide 11 text

DMSΛߏஙͯ͠ ݱࡏͷRDSͱ͸ผʹཱͯͨ ϝδϟʔόʔδϣϯΞοϓޙͷRDS΁ ϨϓϦέʔγϣϯ͢Δɻ ϝϦοτ • DMS͸͍ΘΏΔඇಉظͷ ϨϓϦέʔγϣϯαʔϏεͳͷͰ ݱࡏͷWebαʔϏεͷߏஙͱ͸ ׬શʹಠཱͯ͠Քಇग़དྷΔɻ 11

Slide 12

Slide 12 text

WebαʔϏεΛఀࢭͯ͠ɺ DBࢀরΛVer11.0ͷํʹ੾Γସ͑·͢ɻ 12

Slide 13

Slide 13 text

DMSͷॲཧͷऴྃΛ֬ೝޙ WebαʔϏεΛ࠶։ͤ͞·͢ɻ ͜ΕʹΑͬͯɺ αʔϏεͷόοΫΤϯυ͕ΊͰͨ͘ PostgreSQL Ver.11ʹͳΓ όʔδϣϯΞοϓ͕׬ྃͰ͢ɻ 13

Slide 14

Slide 14 text

͜ͷखॱͷϝϦοτɾσϝϦοτ ϝϦοτ • DMSͷϨϓϦέʔγϣϯͷ஗Ԇ͕ Max500msʙMin10ms ͱ͔ͳͷͰ࠷খͷμ΢ϯλΠϜͰ Ҡߦ͸ߦ͏ࣄ͕ग़དྷΔɻ • DMSͷՔಇ͕WebαʔϏεͱಠཱͯ͠ΔͷͰ όʔδϣϯΞοϓޙͷσʔλϕʔεʹ࠷ॳ͔Β खΛՃ͓͑ͯ͘ࣄ͕ग़དྷΔɻ • ݹ͍όʔδϣϯͷRDS͕࢒͍ͬͯΔͷͰ Կ͔͋ͬͨΒDBࢀরΛ໭͢ࣄͰݩͷ؀ڥΛ෮ݩग़དྷΔɻ 14

Slide 15

Slide 15 text

͜ͷखॱͷϝϦοτɾσϝϦοτ σϝϦοτ • ඞͣఀࢭ͕൐͏ɻ • ҠߦλεΫͷઃఆ͸ࣗ෼Ͱߦ͏ඞཁ͕͋ΔͷͰ σʔλҠߦ׬ྃͷ୲อ͸ࣗ෼Ͱ͢Δඞཁ͕͋Δɻ • શͯͷύλʔϯʹ࢖͑ΔΘ͚Ͱ͸ແͦ͞͏ɻ (DMSͰҠߦग़དྷͳ͍΋ͷ͕͋Δ) 15

Slide 16

Slide 16 text

ୈҰষ·ͱΊ • ৽όʔδϣϯͷRDSΛཱͯɺͦͷRDSʹDMSͰσʔλΛྲྀ͢ɻ • αʔϏεͷՔಇΛͤͭͭ͞ɺϨϓϦέʔγϣϯΛਐΊΔࣄ͕ ग़དྷΔɻ • ఀࢭ͕൐͏΋ͷͷ ࠷খݶͷμ΢ϯλΠϜͰϨϓϦέʔγϣϯ ΛਐΊΔࣄ͕ग़དྷΔɻ • Կ͔͋ͬͨ࣌ʹ͙͢ʹ໭͢ࣄ͕ग़དྷΔɻ 16

Slide 17

Slide 17 text

3. AWS Database Migration Service ͱ͸ 17

Slide 18

Slide 18 text

(ૣ͘ຊ୊ʹ͍ͬͯཉ͍͠) Θ͔Δ 18

Slide 19

Slide 19 text

AWS Database Migration Service ωοτϫʔΫӽ͠ʹ σʔλҠߦΛߦ͏ࣄ͕ग़དྷΔαʔϏε ಄จࣈΛऔͬͯɺDMSͱݺ͹ΕΔɻ ※ ੍ݶ͕͋ͬͯɺίϐʔݩɾίϐʔઌͷ ͲͪΒ͔͕AWSͷΤϯυϙΠϯτͰແ ͍ͱɺϨϓϦέʔγϣϯΛ͢Δࣄ͕ग़དྷ ͳ͍ɻ 19

Slide 20

Slide 20 text

AWS Database Migration Serviceͷ͝঺հ • AWS DMS Ͱ࢖ΘΕΔΩʔϫʔυ • ϨϓϦέʔγϣϯΠϯελϯεʹ͍ͭͯ • λεΫͷৼΔ෣͍ʹ͍ͭͯ • λεΫͷઃఆํ๏ʹ͍ͭͯ • ҟछDBؒҠߦͷࡍͷΧϥϜͷܕม׵ʹ͍ͭͯ • αϙʔτDBΤϯδϯɾόʔδϣϯʹ͍ͭͯ 20

Slide 21

Slide 21 text

AWS DMS Ͱ࢖ΘΕΔΩʔϫʔυ • ιʔεΤϯυϙΠϯτ • σʔλͷίϐʔݩɻEC2onDB, RDS, ΦϯϓϨDB, S3 ͳͲɻ • λʔήοτΤϯυϙΠϯτ • σʔλͷίϐʔઌɻEC2onDB, RDS, ΦϯϓϨDB, S3, DynamoDB ͳͲɻ • ϨϓϦέʔγϣϯΠϯελϯε • ίϐʔݩ͔Βίϐʔઌ΁σʔλͷϨϓϦέʔγϣϯΛߦ͏Πϯελϯεɻ • λεΫ • ιʔεɺλʔήοτɺϨϓϦέʔγϣϯΛ૊Έ߹Θͤͯ ͲͷςʔϒϧΛͲͷΑ͏ʹҠߦ͢Δ͔ΛఆΊͨϧʔϧɻ 21

Slide 22

Slide 22 text

ϨϓϦέʔγϣϯΠϯελϯεʹ͍ͭͯ • ΠϯελϯεΫϥε͸ T2, C4, R4ͷ̏छྨΛαϙʔτ. • T2: ։ൃɾݕূ༻ • C4: େྔͷԋࢉΛߦ͏৔߹ʹ໾ཱͭɻ (AWSతʹ͸ ҟछDBҠߦ͸͜ΕΛ͢͢Ί͍ͯΔ) • R4: ϝϞϦ૿ՃΠϯελϯεɻ (ҰճͷτϥϯβΫγϣϯ΍σʔλྔ͕େ͖͍࣌͸͜Ε.) • ϚϧνAZʹରԠ͍ͯͯ͠ɺϑΣΠϧΦʔόʔΛαϙʔτ. • ࣮ࡍɺDMSͱ͓͕͔͔ͯۚ͠Δͷ͸Πϯελϯεར༻ྉͱετϨʔδ͚ͩɻ 22

Slide 23

Slide 23 text

λεΫͷৼΔ෣͍ͷछྨʹ͍ͭͯ λεΫͷৼΔ෣͍͸ओʹ3λΠϓ͋Δɻ • શϩʔυ+ܧଓతͳϨϓϦέʔγϣϯ(CDC). • طଘͷσʔλΛϑϧϩʔυͨ͠ޙ(PostgreSQLͩͱCOPYจͰߦ͏.) ͦͷޙ͸τϥϯβΫγϣϯϩά͔ΒܧଓతʹϨϓϦέʔγϣϯΛߦ͏. ֤DBΤϯδϯຖʹઐ༻ͷػೳΛ࢖͏ɻ(PostgreSQLͰ͸test_decodingϓϥ άΠϯͰ) • ࢦఆҐஔ͔ΒܧଓతͳϨϓϦέʔγϣϯ(CDC) • શϩʔυͷΈ 23

Slide 24

Slide 24 text

λεΫͷઃఆํ๏ʹ͍ͭͯ • ϨϓϦέʔγϣϯΛߦ͏ςʔϒϧͷࢦఆํ๏͸̎छྨ • userɿ จࣈྻҰகͰ user ςʔϒϧͷΈΛର৅ͱ͢Δɻ • user_%ɿ ਖ਼نදݱͰ user_xxx ςʔϒϧʹ߹க͢ΔશͯͷςʔϒϧΛର৅ͱ ͢Δɻ • ਖ਼نදݱͳͲͰෳ਺ࢦఆͨ͠৔߹͸λεΫ಺ͰฒྻͰςʔϒϧ͕ϩʔυ͞ΕΔɻ (σϑΥϧτͰ͸8ςʔϒϧ) • ·ͨɺλεΫʹ͸ΑΓ଎౓Λ্͛ΔҝʹϢχʔΫΠϯσοΫεΛ ࠷ޙʹషΔͳͲͷॲཧΛ΍ͬͯ͘ΕΔΦϓγϣϯͳͲ͕͋Δɻ 24

Slide 25

Slide 25 text

λεΫͷઃఆํ๏ʹ͍ͭͯ • ·ͨɺ֤ςʔϒϧʹରͯ͠ৄࡉʹҠߦϧʔϧΛઃఆ͢Δࣄ͕ ग़དྷΔɻ • ྫ͑͹Ҡߦޙͷςʔϒϧ໊/ΧϥϜ໊Λมߋͨ͠Γ ର৅ͷσʔλΛWHERE۟ͷΑ͏ʹϧʔϧͰߜΓࠐΜͩΓ ग़དྷΔɻ 25

Slide 26

Slide 26 text

ࢀߟ ΦϛΧϨͷλεΫӡ༻ํ਑ άϧʔϓ୯ҐͰখ͘͞ϨϓϦέʔγϣϯλεΫΛઃఆͯ͠ ҠߦΛਐΊ͍ͯΔɻ ྫɿ ϢʔβʔҠߦλεΫ, ύʔςΟҠߦλεΫ, ༧໿ҠߦλεΫ, ... • ཧ༝ Ҡߦ׬ྃͨ͠ςʔϒϧΑΓDMSͷλεΫΛ࡟আ͍ͯ͘͠ࣄΛ ૝ఆ͍ͯ͠ΔͨΊɻ ӡ༻Λͯ͠ؾ෇͍͕ͨɺখ͘͞λεΫΛ෼ׂ͓ͯ͘͠ࣄͰҰݸͷςʔϒϧҠߦ͕ ࣦഊͨ࣌͠ʹαʔϏεશମͷো֐ʹͳΒͳ͍ɻ ࠓճͷ૝ఆͱͯ͠͸௕ظʹ౉ͬͯϨϓϦέʔγϣϯΛ͢Δ૝ఆͰແ͍ͷͰɺ ҰׅͰઃఆ͢Ε͹ྑͦ͞͏ɻ 26

Slide 27

Slide 27 text

DBҠߦͷࡍͷΧϥϜͷܕม׵ʹ͍ͭͯ • ιʔεͷܕ → DMSઐ༻ͷܕʹΩϟετ → λʔήοτͷܕʹΩϟετ ͱม׵͢Δɻ DMSͷܕ ಺༰ STRING จࣈྻ DATE ೔෇஋ DATETIME λΠϜελϯϓ஋ INT1 1όΠτɺූ߸෇͖੔਺ (INT2, INT4, INT8͕͋Δ) BOOLEAN ϒʔϧ஋ BLOB όΠφϦϥʔδΦϒδΣΫτ ※ ͦͷଞ 27

Slide 28

Slide 28 text

αϙʔτͯ͠ΔDBΤϯδϯ͓Αͼόʔδϣϯ ιʔε • PostgreSQL: 9.4Ҡߦ • MySQL: 5.5Ҡߦ • SQLServer: 2008R2Ҏ߱ (※ Express͸ඇαϙʔτ) • S3 • ͳͲ... 28

Slide 29

Slide 29 text

αϙʔτͯ͠ΔDBΤϯδϯ͓Αͼόʔδϣϯ λʔήοτ • PostgreSQL: 9.4Ҡߦ • MySQL: 5.5Ҡߦ • SQLServer: 2008R2Ҏ߱ (※ Express͸ඇαϙʔτ) • RedShift • DynamoDB • S3 • ͳͲ 29

Slide 30

Slide 30 text

3. AWS DMSʹ͍ͭͯ ·ͱΊ • DMS͸ωοτϫʔΫӽ͠ʹϨϓϦέʔγϣϯΛ࣮ݱ͢ΔαʔϏε. • σʔλͷίϐʔݩͱઌΛࢦఆͯ͠ҠߦϧʔϧͱͳΔλεΫΛ࡞੒͢ΔࣄͰ σʔλͷҠߦ͸શͯDMSͷ੹຿Ͱ࣮ݱͯ͘͠ΕΔɻ • λεΫͷཻ౓Λଟͨ͘͠Γখͨ͘͞͠Γ͢ΔࣄͰ શମͷϨϓϦέʔγϣϯͷཻ౓Λௐ੔ग़དྷΔɻ • DMS୯ମͱͯ͠͸ϨϓϦέʔγϣϯΠϯελϯεͷӡ༻අ͕͔͔Δఔ౓Ͱ ҆ՁͰਐΊΔࣄ͕ग़དྷΔɻ 30

Slide 31

Slide 31 text

4. σϞ 31

Slide 32

Slide 32 text

RDSΛ2୆ཱͯΔ(ׂѪ͢Δ) • PostgreSQL9.6 ͱ PostgreSQL10.5ΛཱͯΔ. • ιʔεͷRDSʹ͸ rds.logical_replication ʹ1ͱઃఆ͢Δඞཁ͕͋Δɻ • PostgreSQL9.6 ʹ users ςʔϒϧͳͲΛ࡞੒͢Δ. DMSͷΠϯελϯεΛཱͯΔ • ϨϓϦέʔγϣϯΠϯελϯε • ιʔεɺλʔήοτΛఆٛ. • ྫ) usersͷλεΫΛઃఆͯ͠ΈΔɻ 32

Slide 33

Slide 33 text

ग़དྷͨ 33

Slide 34

Slide 34 text

usersςʔϒϧͷൺֱ ͯ͠ΈΔ 34

Slide 35

Slide 35 text

• users ςʔϒϧൺֱʢݩʣ CREATE TABLE public.users ( id integer NOT NULL, email character varying(255) NOT NULL, password character varying(255) NOT NULL, created_at timestamp with time zone NOT NULL, updated_at timestamp with time zone NOT NULL ); ALTER TABLE public.users OWNER TO chugokudb; CREATE SEQUENCE public.users_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.users_id_seq OWNER TO chugokudb; ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id; ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass); ALTER TABLE ONLY public.users ADD CONSTRAINT users_email_key UNIQUE (email); ALTER TABLE ONLY public.users ADD CONSTRAINT users_pkey PRIMARY KEY (id); 35

Slide 36

Slide 36 text

• users ςʔϒϧൺֱʢҠߦઌʣ CREATE TABLE public.users ( id integer NOT NULL, email character varying(255) NOT NULL, password character varying(255) NOT NULL, created_at timestamp(6) with time zone NOT NULL, updated_at timestamp(6) with time zone NOT NULL ); ALTER TABLE public.users OWNER TO chugokudb; ALTER TABLE ONLY public.users ADD CONSTRAINT users_pkey PRIMARY KEY (id); 36

Slide 37

Slide 37 text

ׂͱҧ͏(׼) 37

Slide 38

Slide 38 text

38

Slide 39

Slide 39 text

ҧ͍ • idΧϥϜ͕ serialͰͳ͘ͳͬͯΔɻ • emailʹݩʑுͬͯͨunique੍໿͕ແ͍ɻ 39

Slide 40

Slide 40 text

஫ҙࣄ߲ "AWS DMS͸ɺςʔϒϧɺϓϥΠϚϦΩʔɺ৔߹ʹΑͬͯ͸Ұ ҙͷΠϯσοΫεΛ࡞੒͠·͕͢ɺޮ཰తʹιʔε͔Βσʔλ ΛҠߦ͢ΔҝʹඞཁͰ͸ແ͍ଞͷΦϒδΣΫτ͸࡞੒͞Ε·ͤ Μɻ" ͸͍ɻ 40

Slide 41

Slide 41 text

DMSͷ௕ॴ • σʔλͷϨϓϦέʔγϣϯ͕ಘҙ => ͜Εʹਚ͖Δɻա౓ͳظ଴͸ͩΊɻ 41

Slide 42

Slide 42 text

DBఆٛΛ͋ΘͤΔํ๏ • ํ๏1. ςʔϒϧఆٛͷΈΛpg_dumpͨ͠ޙɺ ͦͷϑΝΠϧΛϦετΞ͢Δɻ • ํ๏2. SCTΛ࢖༻͢Δɻ 42

Slide 43

Slide 43 text

SCT ͱ͸ • Schema Conversion Tool • ΫϩεϓϥοτϑΥʔϜ(Linux, macOS, Windows)্Ͱಈ͘ε λϯυΞϩϯΞϓϦέʔγϣϯ. • ιʔεσʔλϕʔεͷεΩʔϚΛλʔήοτͷRDSΠϯελ ϯεͱޓ׵ੑͷ͋Δܗࣜʹࣗಈม׵ͯ͘͠ΕΔπʔϧɻ 43

Slide 44

Slide 44 text

ͬ͘͟Γ࢖͍ํ SCT_1 • ProjectΛ࡞੒͢Δɻ • Projectʹ͸ ιʔεͷΤϯδϯͱ λʔήοτͷΤϯδϯΛઃఆ͢Δɻ 44

Slide 45

Slide 45 text

ͬ͘͟Γ࢖͍ํ SCT_2 • ProjectΛ࡞੒͢Δɻ • Projectʹ͸ ιʔεͷΤϯδϯͱ λʔήοτͷΤϯδϯΛઃఆ͢Δɻ 45

Slide 46

Slide 46 text

ͬ͘͟Γ࢖͍͔Β SCT_3 46

Slide 47

Slide 47 text

ͬ͘͟Γ࢖͍ํ SCT_4 • ϙνϙνͱςʔϒϧΛҎ͍߱ͯ͘͠ɻ • SchemaΛબ୒ͯ͠ Convert Schemaͱ ͢Δͱྑ͍Α͏ʹςʔϒϧఆٛΛΠϯ ϙʔτͯ͘͠ΕΔɻ • ӈଆͷεΩʔϚ΍ςʔϒϧΛબ୒ͯ͠ Apply ͢Δͱ൓ө͞ΕΔɻ • ※ ֎෦Ωʔ੍໿ுͬͯΔ৔߹͸Τϥʔ ʹͳΒͳ͍Α͏ʹࣗ෼ͰؤுΔɻ • (ઈົʹ࢖͍ͮΒ͍..) 47

Slide 48

Slide 48 text

usersͷൺֱ 48

Slide 49

Slide 49 text

49

Slide 50

Slide 50 text

ؤுΕ͹ಉ͡DBΛ࡞Δࣄ͸ग़དྷΔ 50

Slide 51

Slide 51 text

ॴײ • DBͷఆٛͷΈɺϦετΞͨ͠ํָ͕ͦ͏ɻɻɻ 51

Slide 52

Slide 52 text

࠷ऴతͳҠߦΞʔΩςΫνϟ 1. pg_dumpͰ৽DBଆ΁ςʔϒϧఆٛͷΈΛઌʹద༻͢Δɻ 2. dmsλεΫΛ࡞੒ͯ͠σʔλΛίϐʔ͢Δɻ 3. DBΛࢀর͍ͯ͠ΔαʔϏεΛࢭΊΔɻ 4. ιʔεDBଆʹϚʔΧʔͱͳΔσʔλΛҰ݅Insert͢Δɻ 5. ϚʔΧʔ͕DMSͰλʔήοτDBʹҠߦ͞ΕΔࣄΛ֬ೝ͢Δɻ 6. αʔϏεͷDBͷࢀরΛλʔήοτଆ΁มߋ͢Δɻ 52

Slide 53

Slide 53 text

Ҡߦ࣌ʹࢀߟͱͳΔϝτϦΫε CDCLatencySource • ιʔεDBͰ࣮ߦ͞Ε͔ͨ࣌ؒΒDMSΠϯελϯε͕ COMMITΛݕ஌ͨ࣌ؒ͠ͷฏۉඵ CDCLatencyTarget • DMSΠϯελϯε͕COMMITΛݕ஌͔ͨ࣌ؒ͠Βλʔήοτ ʹద༻ͨ͠·Ͱͷฏۉඵ 53

Slide 54

Slide 54 text

4. σϞ ·ͱΊ • DMSͰͷDBఆٛͷҠߦ͸೉͍͠ɻ • ఘΊ͸؊৺ͰɺSCTͰؤுΔ͔ pg_dumpͰςʔϒϧఆٛͷΈ Λઌʹ࡞͓ͬͯ͘ࣄΛ͓͢͢Ί͢Δɻ • σʔλͷҠߦͷΈΛDMSͷ੹຿Ͱ΍Δɻ 54

Slide 55

Slide 55 text

5. ·ͱΊ 55

Slide 56

Slide 56 text

ࢥͬͯͨΜͱͪΌ͏͔ͬͨɾɾ DMSΛ࢖ͬͨDBόʔδϣϯΞοϓ͸ ׂͱ؆୯ʹग़དྷΔͩΖ͏ɺͬͯࢥ͕ͬͯͨ DMS͚ͩͰ͸DBόʔδϣϯΞοϓΛߦ͏ͷ͸೉ͦ͠͏Ͱͨ͠ɻ ظ଴͞Εͯͨํɺ͢Έ·ͤΜɻ • ੹຿Λ੾Γ෼͚ͯɺDMS͸σʔλͷϨϓϦέʔγϣϯͷΈΛ ߦ͏ͷ͕ྑ͍Ͱ͢ɻ 56

Slide 57

Slide 57 text

͜ͷΞʔΩςΫνϟͷதͰͷ࠷େͷϝϦοτ • ༧Ίόʔδϣϯͷ্͕ͬͨDBΠϯελϯεͱ Ҡߦ͞Εͨσʔλ͕͋ΔͷͰɺ લ΋ͬͯ઀ଓͯ͠ςετ͢Δࣄ͕ग़དྷΔɻ • CDCLatencyͷϝτϦΫεΛࢀߟʹఀࢭ࣌ؒΛݟੵ΋Δࣄ͕ ग़དྷΔɻ => ׂͱʮ͍͑΍ͬʯͬͯ΍Γ͕ͪͳϝδϟʔόʔδϣϯΞοϓ ʹ͍ͭͯɺສશͷମ੍Ͱ๬ΊΔɻ 57

Slide 58

Slide 58 text

ࠂ஌ 58

Slide 59

Slide 59 text

Πϕϯτࠂ஌ • ୈ26ճ தࠃ஍ํDBษڧձ in Ԭࢁ • 2018-02-02(౔) 13:00ʙ 59

Slide 60

Slide 60 text

͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝· ͨ͠ʂʂ 60