Slide 1

Slide 1 text

RDS Aurora ͷσʔλΛ ͳΔ΂҆͘શʹ෼ੳͱ͔ݕূʹ ࢖͑ΔΑ͏ʹͪ͠·͓͏ JAWS-UG ͍ͨ͞·ࢧ෦ ୈ9ճษڧձ ʙ೥ॳΊ೔ຊͰҰ൪ૣ͍re:Cap & ৽೥ձʙ 2018/01/13

Slide 2

Slide 2 text

ࣗݾ঺հ ໊લɿপ୔ Ұथ ॴଐɿmediba ΍ͬͯΔ͜ͱɿ ɹAWS Λ࢖ͬͨ Web αʔϏεͷઃܭɾߏஙɾӡ༻ ޷͖ͳAWSαʔϏεɿLambda, SSM Facebookɿhttps://www.facebook.com/numazawa.kazuki

Slide 3

Slide 3 text

RDS Aurora ʁ ͬͯͳΜ΍ͶΜ

Slide 4

Slide 4 text

·ͣ Aurora ͬͯͳΜ΍ͶΜ

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

No content

Slide 7

Slide 7 text

MySQL ͷ5ഒͷ ύϑΥʔϚϯεΛୟ͖ग़͢ RDB(ύϫʔϫʔυ)

Slide 8

Slide 8 text

҆શʹ෼ੳ/ݕূͬͯʁ

Slide 9

Slide 9 text

ຊ൪؀ڥͷσʔλͷ׆༻ • ຊ൪ͷσʔλΛ෼ੳʹ͔͚͍ͨʂ • ຊ൪ͷσʔλͰιʔείʔυΛݕূ͍ͨ͠ʂ • ຊ൪ͷσʔλͱಉ͡σʔλͰҧ͏WebαΠτΛ࡞ Γ͍ͨʂ • ͔͠΋ຊ൪σʔλͱͷࠩ෼ΛͳΔ΂͘খͨ͘͞͠ ͍ʂ

Slide 10

Slide 10 text

• ຊ൪ͷσʔλΛ෼ੳʹ͔͚͍ͨʂ • ຊ൪ͷσʔλͰιʔείʔυΛݕূ͍ͨ͠ʂ • ຊ൪ͷσʔλͱಉ͡σʔλͰҧ͏WebαΠτΛ࡞ Γ͍ͨʂ • ͔͠΋ຊ൪σʔλͱͷࠩ෼ΛͳΔ΂͘খͨ͘͞͠ ͍ʂ ͜ΕΒΛͳΔ΂҆͘શʹ ޮ཰Α͘ ΍Γ͍ͨʂ ຊ൪؀ڥͷσʔλͷ׆༻

Slide 11

Slide 11 text

Ͳ͏΍ͬͯʁ

Slide 12

Slide 12 text

Master (Writer) ಉ࢜Λ ϨϓϦέʔγϣϯ

Slide 13

Slide 13 text

Aurora ͰϚελʔΛ̎ͭʹ͢ Δ͢Δͬͯ͜ͱʁ ͦΕͬͯڈ೥ͷ re:Invent Ͱग़ͨΑͶʁ

Slide 14

Slide 14 text

Aurora Multi-Master

Slide 15

Slide 15 text

Aurora Multi-Master • re:Invent 2017 Ͱൃද͞ΕͨɺAurora ͷ৽ػೳ(ϓϨϏϡʔ) • ཁ͸ Aurora ͷ Writer ΠϯελϯεΛεέʔϧΞ΢τ͢Δ΋ͷ • ैདྷ͸ Writer Πϯελϯε͸Ϋϥελʔ಺ʹ1୆ͷΈͰɺWriter Πϯελ ϯεͷো֐࣌ʹ͸ Reader ΠϯελϯεʹϑΣΠϧΦʔόʔ͢Δ͜ͱͰՄ༻ ੑΛอ͍ͬͯͨ • ࢀߟ • Amazon Aurora Multi-Master ͷϓϨϏϡʔਃ͠ࠐΈ։࢝ • https://aws.amazon.com/jp/blogs/news/sign-up-for-the-preview-of-amazon-aurora-multi- master/ • ʲ଎ใʳAmazon AuroraͷϚϧνϚελػೳ͕ൃද͞Ε·ͨ͠ʂ • https://dev.classmethod.jp/cloud/aws/reinvent-2017-aurora-multi-master/

Slide 16

Slide 16 text

Aurora Multi-Master ͸ • Aurora Ϋϥελʔ಺ʹ Master(Writer) ͕ෳ਺࡞੒ Մೳ • ॻ͖ࠐΈੑೳͷେ෯ͳ޲্͕ݟࠐΊΔ • Writer ͕1ͭࢮΜͰ΋ϑΣΠϧΦʔόʔ͕࣮࣭ແ͍ • θϩμ΢ϯλΠϜͷ࣮ݱ • ͋͘·Ͱ1Ϋϥελʔ಺ͷ࿩

Slide 17

Slide 17 text

Πϝʔδਤ ※ৄࡉͳυΩϡϝϯτ౳͕·ͩແ͍ͷͰڪΒ͘͜ΜͳΠ ϝʔδ

Slide 18

Slide 18 text

͜Εͱ͸ҧ͍·͢ ࠓճ΍Ζ͏ͱ͍ͯ͠Δ͜ͱ͸

Slide 19

Slide 19 text

͡Ό͋Ͳ͏͢ΔΜʁ ʙϘπҊΛఴ͑ͯʙ

Slide 20

Slide 20 text

࠶ ܝ ຊ൪؀ڥͷσʔλͷ׆༻ • ຊ൪ͷσʔλΛ෼ੳʹ͔͚͍ͨʂ • ຊ൪ͷσʔλͰιʔείʔυΛݕূ͍ͨ͠ʂ • ຊ൪ͷσʔλͱಉ͡σʔλͰҧ͏WebαΠτΛ࡞ Γ͍ͨʂ • ͔͠΋ຊ൪σʔλͱͷࠩ෼ΛͳΔ΂͘খͨ͘͞͠ ͍ʂ

Slide 21

Slide 21 text

ϘπҊᶃ • ຊ൪༻ Aurora ͷࣗಈεφοϓγϣοτ͔ Β Aurora ΫϥελʔΛ࡞੒͢Δ(෮ݩ) • ࣗಈεφοϓγϣοτ͸1೔1ճऔΒΕΔͷ ͰɺͦΕΛݩʹ1೔1ճɺຖ೔࡞Γ௚͢

Slide 22

Slide 22 text

ϘπҊᶃ Ϙπͷཧ༝ ࠷΋҆શͰ͸͋Δ͕ɺσʔλ͕࠷৽Ͱ͸ͳ͍ ͳΔ΂͘࠷৽ͷঢ়ଶͷσʔλΛ࢖͍͍ͨʂํ๏͕ ଞʹ΋͋ΔͷͰ͸ͳ͍͔ʁͱͳͬͯҰ୴ϖϯσΟ ϯάɻ →࠷ऴతʹϘπ

Slide 23

Slide 23 text

ϘπҊᶄ • ຊ൪༻ Aurora ͷ Reader Πϯελϯεͷ1 ͭΛΤϯυϙΠϯτ௚ࢦఆͰ࢖͏ • ௨ৗͷΞϓϦέʔγϣϯ͔Β͸ Reader Τ ϯυϙΠϯτΛར༻

Slide 24

Slide 24 text

ϘπҊᶄ Ϙπͷཧ༝ ࠷΋࠷৽Ͱ͸͋Δ͕ɺ1୆͚ͩߴෛՙʹͳΔ ϦεΫ͕͕͕ ͜ͷϦεΫ͸औΕͳ͔ͬͨͷͰϘπʂ

Slide 25

Slide 25 text

࠾༻Ҋ • ຊ൪༻ͱ͸ผʹɺ΋͏1ͭ Aurora Ϋϥε λʔΛ༻ҙ • Ϋϥελʔͷ Master(Writer) ಉ࢜ͰϨϓϦ έʔγϣϯ

Slide 26

Slide 26 text

࠾༻ཧ༝ ຊ൪༻ͷ Aurora Ϋϥελʔʹ͸΄΅ӨڹΛ ༩͑ͣɺσʔλ΋΄΅ϦΞϧλΠϜͰ࠷৽

Slide 27

Slide 27 text

஫ҙ఺ ॻ͖ࠐΈྔͷ૿Ճʹ൐ͬͯɺຊ൪༻ͷ Aurora Ϋϥελʔͷ Writer ͷෛՙ্͕͕Δݒ೦͕͋ Δ…ʂ ॠؒͰେྔͷॻ͖ࠐΈ͕༧૝͞ΕΔΑ͏ͳαʔ ϏεͰ͸ਪ঑͠ͳ͍

Slide 28

Slide 28 text

Ͳ͏΍ͬͯʁ

Slide 29

Slide 29 text

ૉ੖Β͠΍ެࣜυΩϡϝϯτ Aurora ͱ MySQL ͱͷؒɺ·ͨ͸ Aurora ͱผͷ Aurora DB Ϋ ϥελʔͱͷؒͷϨϓϦέʔγϣϯ https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/ UserGuide/AuroraMySQL.Replication.MySQL.html

Slide 30

Slide 30 text

جຊతʹ͸ ͜ͷυΩϡϝϯτ௨Γʹઃఆ͍ͯ͘͜͠ͱͰ࣮ ݱՄೳ

Slide 31

Slide 31 text

༨ஊɿϨϓϦέʔγϣϯํࣜ ࠓճͷ Aurora ͸ MySQL 5.6 ޓ׵ͷ Aurora Λର৅ͱ͍ͯ͠Δ MySQL 5.6 Ͱ͸ɺGTID (Global Transaction ID) ʹΑΔϨϓϦέʔ γϣϯํ͕ࣜ࠾༻͞ΕɺࠓޙҰൠԽ͍ͯ͘͠Α͏ʹݟ͑Δ͕ɺRDS Ͱ͸ MariaDB Ҏ֎͸ GTID Λ࢖͑ͳ͍ͬΆ͍(※ͪΌΜͱௐ΂ͯͳ ͍) υΩϡϝϯτʹ΋͋Δ௨Γɺࠓճ͸ binlog ํࣜͰͷϨϓϦέʔγϣ ϯΛ͢Δ͚ͩͳͷͰɺMySQL ʹ໌Δ͍ํʑʹ͸ɺͳΜͩͦΜͳ͜ ͱ͔ͱམ୾ͤͯ͞͠·ͬͨ͜ͱͰ͠ΐ͏ ਃ͠༁ͳ͍͆

Slide 32

Slide 32 text

΍ͬͯΈͨ ͱΓ͋͑ͣ

Slide 33

Slide 33 text

׬੒Πϝʔδਤ

Slide 34

Slide 34 text

ϙΠϯτ • ຊ൪༻ͱ෼ੳ౳༻ͰVPCΛ෼͚Δ • ෼཭͢Δ͜ͱͰΞΫηε੍ݶΛγϯϓϧʹ͠΍ ͍͢ • VPC Peering ͰΫϩʔζͳ௨৴ʹ͢Δ • ֎෦͔Βׯব͞Εͳ͍ • ϨΠςϯγΛۃྗ૿΍͞ͳ͍

Slide 35

Slide 35 text

લఏ৚݅ • ҎԼ͸ׂѪ • VPC ࡞੒ͱ VPC Peering ͷઃఆ • DB ઀ଓ༻ͷ EC2 ͷ࡞੒ • ηΩϡϦςΟάϧʔϓͷ࡞੒ • ຊ൪༻ͷ Aurora Ϋϥελʔ͸طʹ͋Γɺσʔλ΋ೖ͍ͬͯΔ΋ͷͱ͢Δ • ຊ൪༻ͷ Aurora Ϋϥελʔ͸࣍ทͷΑ͏ͳঢ়ଶͱ͢Δ • ࢦఆͷͳ͍߲໨ͳͲ͸σϑΥϧτ஋Λ૝ఆ(΋͘͠͸೚ҙͰઃఆ)

Slide 36

Slide 36 text

લఏ৚݅ • VPC: “master-vpc” • DB Ϋϥελʔࣝผࢠ: “master-cluster” • Writer: “master1”(AZ-a) • Reader: “master2”(AZ-c), “master3”(AZ-a) • Writer 1୆ɺReader 2୆ͷ Multi-AZ ߏ੒ • σϑΥϧτ஋͔Βมߋͷͳ͍ “cluster-param-group” ͱ͍͏Ϋϥελʔ ύϥϝʔλάϧʔϓ • ύϒϦοΫΞΫηε: ͍͍͑

Slide 37

Slide 37 text

͜Μͳঢ়ଶ(Πϝʔδਤ)

Slide 38

Slide 38 text

• σϑΥϧτ͕ "OFF" ͷͨΊඞͣมߋ͢Δ • ROW, STATEMENT Ͱ΋ྑ͍Α͏͕ͩɺެࣜυΩϡϝϯτͰ͸ɺಛʹඞཁੑ ͕ͳ͍৔߹͸ MIXED Λਪ঑͍ͯ͠Δ • ͜ͷύϥϝʔλͷ൓өʹ͸࠶ىಈ͕ඞཁ • ՔಇதͷΫϥελʔͷ৔߹͸ཁ஫ҙ • Multi-AZ ߏ੒Ͱ΋ 1 ෼ະຬͷμ΢ϯλΠϜ • ݸਓతͳ࣮੷Ͱ͸20ඵߦ͔ͳ͍͜ͱ͕΄ͱΜͲ(ࢀߟ·Ͱ) binlog_format Λ MIXED ʹมߋ "cluster-param-group" Λฤू

Slide 39

Slide 39 text

binlog_format Λ MIXED ʹมߋ

Slide 40

Slide 40 text

binlog ͷอ࣋ظؒΛઃఆ • “master-cluster” ͷΫϥελʔΤϯυϙΠϯτ΁ MySQL Ϋϥ ΠΞϯτͰ઀ଓ • ࣍ทͷίϚϯυͰ “binlog retention hours” ͷ஋Λ೚ҙʹࢦ ఆ͢Δ • ࠓճ͸1िؒ(168࣌ؒ)Λࢦఆ • ͜ͷઃఆมߋͰ͸μ΢ϯλΠϜ͸ൃੜ͠ͳ͍

Slide 41

Slide 41 text

mysql> CALL mysql.rds_set_configuration('binlog retention hours', 168); Query OK, 0 rows affected (0.05 sec) mysql> mysql> CALL mysql.rds_show_configuration()\G *************************** 1. row *************************** name: binlog retention hours value: 168 description: binlog retention hours specifies the duration in hours before binary logs are automatically deleted. 1 row in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) binlog ͷอ࣋ظؒΛઃఆ ࣌ؒʹઃఆ

Slide 42

Slide 42 text

ϨϓϦέʔγϣϯ༻Ϣʔβ࡞੒ • ϨϓϦέʔγϣϯઐ༻ϢʔβΛ “master-cluster” ಺ʹ࡞੒ • Ϣʔβ໊΍ύεϫʔυɺ઀ଓݩϗετ౳͸ཁ݅ʹ߹Θͤͯదٓ ઃఆ

Slide 43

Slide 43 text

mysql> GRANT REPLICATION Slave ON *.* TO 'repl'@'%' IDENTIFIED BY “hogehoge"; Query OK, 0 rows affected (0.03 sec) mysql> mysql> SELECT user,host FROM mysql.user where user = "repl"; +------+------+ | user | host | +------+------+ | repl | % | +------+------+ 1 row in set (0.00 sec) ϨϓϦέʔγϣϯ༻Ϣʔβ࡞੒ ࠓճ͸lSFQMzϢʔβΛ࡞੒

Slide 44

Slide 44 text

Slave ΫϥελʔΛ༻ҙ • લఏ৚݅ͷΫϥελʔ͸ Master ͱͳΔΫϥελʔ • ͔͜͜Β͸ϨϓϦέʔγϣϯઌͱͳΔ Slave ΫϥελʔΛ࡞੒ • طଘͷσʔλ͕͋Δͱ͍͏લఏͳͷͰɺʮಛఆ࣌఺΁ͷ෮ݩʯ Λ࢖ͬͯۃྗ࠷৽ঢ়ଶͷσʔλΛ࣋ͬͨΫϥελʔΛ࡞੒

Slide 45

Slide 45 text

• DB Πϯελϯεࣝผࢠ: “slave1" • ͜͜Ͱࢦఆͨ͠΋ͷ͕ Writer Πϯελϯε໊ͱΫϥελʔ໊ʹͳΔ • ޙͰΫϥελʔ໊͸ϦωʔϜ͢Δ(೚ҙ)(ޙड़) • ʮ෮ݩՄೳͳ࠷৽࣌ࠁΛ࢖༻͢ΔʯΛબ୒ • VPC: “slave-vpc” • ΞϕΠϥϏϦςΟʔκʔϯ: ap-northeast-1a • AZ ͸ “master-cluster” ͷΠϯελϯεͱ߹Θͤͱ͘ Slave ΫϥελʔΛ༻ҙ “master1” Ͱʮಛఆ࣌఺΁ͷ෮ݩʯΛ࣮ࢪ

Slide 46

Slide 46 text

Slave ΫϥελʔΛ༻ҙ “master1” Ͱʮಛఆ࣌఺΁ͷ෮ݩʯΛ࣮ࢪ

Slide 47

Slide 47 text

Slave ΫϥελʔΛ༻ҙ “master1” Ͱʮಛఆ࣌఺΁ͷ෮ݩʯΛ࣮ࢪ

Slide 48

Slide 48 text

Slave ΫϥελʔΛ༻ҙ “master1” Ͱʮಛఆ࣌఺΁ͷ෮ݩʯΛ࣮ࢪ

Slide 49

Slide 49 text

Slave ΫϥελʔΛ༻ҙ “master1” Ͱʮಛఆ࣌఺΁ͷ෮ݩʯΛ࣮ࢪ

Slide 50

Slide 50 text

Slave ΫϥελʔΛ༻ҙ Reader ΠϯελϯεΛ௥Ճ (slave2, slave3) • "slave1" ΠϯελϯεͰʮAurora ϨϓϦΧͷ࡞੒ʯΛબ୒ • DB Πϯελϯεࣝผࢠ: “slave2” • ΞϕΠϥϏϦςΟʔκʔϯ: ap-northeast-1c • ༏ઌ౓: ൣғ -1 • DB Πϯελϯεࣝผࢠ:“slave3” • ΞϕΠϥϏϦςΟʔκʔϯ: ap-northeast-1a • ༏ઌ౓: ൣғ -2

Slide 51

Slide 51 text

Slave ΫϥελʔΛ༻ҙ Reader ΠϯελϯεΛ௥Ճ (slave2, slave3)

Slide 52

Slide 52 text

Slave ΫϥελʔΛ༻ҙ Reader ΠϯελϯεΛ௥Ճ (slave2, slave3)

Slide 53

Slide 53 text

Slave ΫϥελʔΛ༻ҙ Reader ΠϯελϯεΛ௥Ճ (slave2, slave3)

Slide 54

Slide 54 text

Slave ΫϥελʔΛ༻ҙ Slave Ϋϥελʔ໊ΛϦωʔϜ(೚ҙ) • ͜ͷ࣌఺ͰɺSlave Ϋϥελʔ໊͸ “slave1-cluster” ͱͳ͍ͬͯΔ • ඞਢͷ࡞ۀͰ͸ͳ͍͕ɺΫϥελʔ໊ʹ “1” ͱ෇͍͍ͯΔͷ͕ؾʹͳΔͷͰ ௚͓͖͍ͯͨ͠(޷Έͷ໰୊) • "slave1-cluster" ͰʮΫϥελʔͷมߋʯΛબ୒ • DB Ϋϥελʔࣝผࢠ: “slave-cluster” • ʮ͙͢ʹద༻ʯʹνΣοΫ

Slide 55

Slide 55 text

Slave ΫϥελʔΛ༻ҙ Slave Ϋϥελʔ໊ΛϦωʔϜ(೚ҙ)

Slide 56

Slide 56 text

Slave ΫϥελʔΛ༻ҙ Slave Ϋϥελʔ໊ΛϦωʔϜ(೚ҙ)

Slide 57

Slide 57 text

Slave ΫϥελʔΛ༻ҙ Slave Ϋϥελʔ໊ΛϦωʔϜ(೚ҙ)

Slide 58

Slide 58 text

ݱࡏ͜Μͳঢ়ଶ

Slide 59

Slide 59 text

ݱࡏ͜Μͳঢ়ଶ(Πϝʔδਤ)

Slide 60

Slide 60 text

ϨϓϦέʔγϣϯͷઃఆ • ྆ΫϥελʔͷΫϥελʔΤϯυϙΠϯτʹ MySQL ઀ଓ • "show binary logs;" Λ࣮ߦ • ్த·Ͱͷϩάঢ়ଶ͕Ұக͍ͯ͠Δ͜ͱΛ֬ೝ • binlog ͷঢ়ଶʹ͕ࠩग़͍ͯΔͱ͜ΖΛ֬ೝ • Slave ͷ Log_name, File_size ͷ஋ΛϝϞ binlog ͷঢ়ଶΛ֬ೝ

Slide 61

Slide 61 text

ϨϓϦέʔγϣϯͷઃఆ binlog ͷঢ়ଶΛ֬ೝ(Master) mysql> show binary logs; +----------------------------+-----------+ | Log_name | File_size | +----------------------------+-----------+ | mysql-bin-changelog.000001 | 120 | | mysql-bin-changelog.000002 | 21660 | +----------------------------+-----------+ 2 rows in set (0.00 sec)

Slide 62

Slide 62 text

ϨϓϦέʔγϣϯͷઃఆ binlog ͷঢ়ଶΛ֬ೝ(Slave) mysql> show binary logs; +----------------------------+-----------+ | Log_name | File_size | +----------------------------+-----------+ | mysql-bin-changelog.000001 | 120 | | mysql-bin-changelog.000002 | 2484 | | mysql-bin-changelog.000003 | 120 | | mysql-bin-changelog.000004 | 120 | | mysql-bin-changelog.000005 | 704 | +----------------------------+-----------+ 5 rows in set (0.01 sec) ͜͜Ͱࠩ෼͕ग़ͯΔͷͰɺ ͜ͷߦͷ஋ΛϝϞ

Slide 63

Slide 63 text

ϨϓϦέʔγϣϯͷઃఆ Slave ଆͰϨϓϦέʔγϣϯઃఆίϚϯυΛ࣮ߦ mysql> CALL mysql.rds_set_external_master ( mysql> 'master-cluster.cluster-xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com', mysql> 3306, mysql> 'repl', mysql> 'xxxxxxxx', mysql> 'mysql-bin-changelog.000002', mysql> 2484, mysql> 0 mysql> ); Query OK, 0 rows affected (0.19 sec) NZTRMSET@TFU@FYUFSOBM@NBTUFSͰϨϓϦέʔγϣϯઃఆ Ҿ਺͸্͔Βɺ ɾNBTUFSDMVTUFSͷΫϥελʔΤϯυϙΠϯτ ɾNBTUFSDMVTUFS΁ͷ઀ଓϙʔτ ɾNBTUFSDMVTUFSʹ࡞੒ͨ͠ϨϓϦέʔγϣϯ༻Ϣʔβ ɾϨϓϦέʔγϣϯ༻Ϣʔβͷύεϫʔυ ɾϝϞͨ͠CJOMPHͷϑΝΠϧ໊ ɾϝϞͨ͠CJOMPHͷϑΝΠϧαΠζ ϙδγϣϯ ɾ44-҉߸Խ ݱ࣌఺Ͱະ࣮૷ͱͷ͜ͱͳͷͰݻఆ ࢀߟ: https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/UserGuide/mysql_rds_set_external_master.html

Slide 64

Slide 64 text

ϨϓϦέʔγϣϯͷ։࢝ Slave ଆͰϨϓϦέʔγϣϯ։࢝ίϚϯυΛ࣮ߦ mysql> CALL mysql.rds_start_replication; NZTRMSET@TUBSU@SFQMJDBUJPOͰ ϨϓϦέʔγϣϯ։࢝ ࢀߟ: https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/UserGuide/mysql_rds_start_replication.html

Slide 65

Slide 65 text

ϨϓϦέʔγϣϯͷঢ়ଶ֬ೝ Master ଆͷঢ়ଶΛ֬ೝ mysql> show master status\G *************************** 1. row *************************** File: mysql-bin-changelog.000002 Position: 21660 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 1 row in set (0.00 sec) CJOMPHϑΝΠϧ໊ CJOMPHϙδγϣϯ

Slide 66

Slide 66 text

ϨϓϦέʔγϣϯͷঢ়ଶ֬ೝ Slave ଆͷঢ়ଶΛ֬ೝ mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for Master to send event Master_Host: master-cluster.cluster-xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin-changelog.000002 Read_Master_Log_Pos: 21660 Relay_Log_File: relaylog.000002 Relay_Log_Pos: 19469 Relay_Master_Log_File: mysql-bin-changelog.000002 Slave_IO_Running: Yes Slave_SQL_Running: Yes .... .BTUFSଆͷCJOMPHϑΝΠϧ໊ͱҰக .BTUFSଆͷCJOMPHϙδγϣϯͱҰக ͜Ε͕:FTʹͳͬͯΕ͹0,

Slide 67

Slide 67 text

͜ΕͰ͜ͷঢ়ଶ͕׬੒

Slide 68

Slide 68 text

master ʹෛՙ͕͔͔Βͳ͍

Slide 69

Slide 69 text

master ΁ෆඞཁͳΞΫηεΛͤ͞ͳ͍

Slide 70

Slide 70 text

΋͏ͪͬͱ͚ͩଓ͘Μ͡Ό

Slide 71

Slide 71 text

͜Ε͚ͩ͡ΌυΩϡϝϯτ௨Γʹ΍͚ͬͨͩͰ ऴΘͬͯ͠·͏ͷͰ…

Slide 72

Slide 72 text

ϑΣΠϧΦʔόʔ࣌ͷ ڍಈΛݕূ

Slide 73

Slide 73 text

master-cluster ͷ ϑΣΠϧΦʔόʔ

Slide 74

Slide 74 text

ҎԼͷखॱͰ master-cluster ͷ F/O ޙͷঢ়ଶΛ֬ೝ͢Δ • master-clusterΛखಈͰϑΣΠϧΦʔόʔ • master-cluster ʹద౰ʹॻ͖ࠐΉ(ׂѪ) • MasterɺSlave ͦΕͧΕͰϨϓϦέʔγϣϯͷঢ়ଶ Λ֬ೝ master-cluster F/O

Slide 75

Slide 75 text

master-cluster F/O master-clusterΛखಈͰϑΣΠϧΦʔόʔ

Slide 76

Slide 76 text

master-clusterΛखಈͰϑΣΠϧΦʔόʔ master-cluster F/O

Slide 77

Slide 77 text

ϨϓϦέʔγϣϯͷঢ়ଶΛ֬ೝ(Master) master-cluster F/O mysql> show master status\G *************************** 1. row *************************** File: mysql-bin-changelog.000003 Position: 38257 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 1 row in set (0.00 sec) CJOMPHϑΝΠϧ໊ CJOMPHϙδγϣϯ

Slide 78

Slide 78 text

mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: master-cluster.cluster-xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin-changelog.000003 Read_Master_Log_Pos: 38257 Relay_Log_File: relaylog.000008 Relay_Log_Pos: 38430 Relay_Master_Log_File: mysql-bin-changelog.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes .... .BTUFSଆͷCJOMPHϑΝΠϧ໊ͱҰக .BTUFSଆͷCJOMPHϙδγϣϯͱҰக ͜Ε͕:FTͷ··ͳͷͰ0, master-cluster F/O ϨϓϦέʔγϣϯͷঢ়ଶΛ֬ೝ(Slave)

Slide 79

Slide 79 text

master-cluster ͰϑΣΠϧΦʔόʔ͕ൃੜͯ͠΋ɺϨ ϓϦέʔγϣϯ͸్੾Εͳ͔ͬͨʂ master-cluster F/O

Slide 80

Slide 80 text

slave-cluster ͷ ϑΣΠϧΦʔόʔ

Slide 81

Slide 81 text

ҎԼͷखॱͰ slave-cluster ͷ F/O ޙͷঢ়ଶΛ֬ೝ͢Δ • slave-cluster ΛखಈͰϑΣΠϧΦʔόʔ • master-cluster ʹద౰ʹॻ͖ࠐΉ(ׂѪ) • MasterɺSlave ͦΕͧΕͰϨϓϦέʔγϣϯͷঢ়ଶ Λ֬ೝ slave-cluster F/O

Slide 82

Slide 82 text

slave-cluster F/O slave-clusterΛखಈͰϑΣΠϧΦʔόʔ

Slide 83

Slide 83 text

slave-clusterΛखಈͰϑΣΠϧΦʔόʔ slave-cluster F/O

Slide 84

Slide 84 text

ϨϓϦέʔγϣϯͷঢ়ଶΛ֬ೝ(Master) slave-cluster F/O mysql> show master status\G *************************** 1. row *************************** File: mysql-bin-changelog.000013 Position: 27917068 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 1 row in set (0.00 sec) CJOMPHϑΝΠϧ໊ CJOMPHϙδγϣϯ

Slide 85

Slide 85 text

mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: master-cluster.cluster-xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin-changelog.000013 Read_Master_Log_Pos: 27917068 Relay_Log_File: relaylog.000099 Relay_Log_Pos: 4730917 Relay_Master_Log_File: mysql-bin-changelog.000013 Slave_IO_Running: Yes Slave_SQL_Running: Yes .... .BTUFSଆͷCJOMPHϑΝΠϧ໊ͱҰக .BTUFSଆͷCJOMPHϙδγϣϯͱҰக ͜Ε͕:FTͷ··ͳͷͰ0, slave-cluster F/O ϨϓϦέʔγϣϯͷঢ়ଶΛ֬ೝ(Slave)

Slide 86

Slide 86 text

slave-cluster ͰϑΣΠϧΦʔόʔ͕ൃੜͯ͠΋ɺϨϓ Ϧέʔγϣϯ͸్੾Εͳ͔ͬͨʂ slave-cluster F/O ※ͨͩ͠ɺϨϓϦέʔγϣϯ͕࠶։͢Δ·Ͱʹ 1ʙ2 ෼ఔ౓ͷϥά͕͋ͬͨ