move to mysql5.6

C786d7772602b488a7972c38c143f61c?s=47 con_mame
October 25, 2013

move to mysql5.6

MySQL Casual Talks#5で発表した資料です

C786d7772602b488a7972c38c143f61c?s=128

con_mame

October 25, 2013
Tweet

Transcript

  1. ๻ୡͷ.Z42-Ҡߦه

  2. ੕໺๛ !DPO@NBNF ΫοΫύουגࣜձࣾΠϯϑϥετϥΫνϟʔ෦ "84.Z42-3FETIJGU%BUB4UPSFFUD IUUQEDPONBNF IUUQGBDFCPPLDPNDPONBNF

  3. 

  4. ࢖ͬͯ·͔͢ʁ

  5. PS PS 

  6. .Z42-PO&$ BOE 3%4

  7. None
  8. NEW NEW update update

  9. .BOBHFNFOUUPPMT %FWFMPQNFOU "OBMZTJT FYDMVEFTFDVSF UBCMFXJUINZTRM BVEJU

  10. .PWFUPPO"84

  11. ʙ 

  12. DPPLQBEओཁ%#Λʹ VQEBUF 3FQMJDBUJPOΛͭͭ͠ຊ൪Ͱ ྲྀΕΔΫΤϦΛྲྀ͢ ৽ػೳͷ$POGJHVSBUJPO Λࢼ͍ͯ͘͠

  13. DPPLQBEओཁ%#Λʹ VQEBUF 3FQMJDBUJPOΛͭͭ͠ຊ൪Ͱ ྲྀΕΔΫΤϦΛྲྀ͢ ৽ػೳͷ$POGJHVSBUJPO Λࢼ͍ͯ͘͠ ҙ֎ͱૉ௚ʹਐΜͩʂʂʂ

  14. DPPLQBEओཁ%#Λʹ VQEBUF 3FQMJDBUJPOΛͭͭ͠ຊ൪Ͱ ྲྀΕΔΫΤϦΛྲྀ͢ ৽ػೳͷ$POGJHVSBUJPO Λࢼ͍ͯ͘͠ ҙ֎ͱૉ௚ʹਐΜͩʂʂʂ ࠷ॳ͚ͩ ҙ֎ͱૉ௚ʹਐΜͩʂʂʂ

  15. 6QHSBEF

  16. %#܈Λ༻ҙͯ͠TXJUDI ϝϯςφϯεͰNZTRM@VQHSBEF

  17. replication OLD Master OLD Slave OLD Slave 5.6 Master 5.6

    Slave replication 5.6 Slave
  18. replication OLD Master OLD Slave OLD Slave 5.6 Master 5.6

    Slave replication 5.6 Slave &#44OBQTIPUΛ ࡞੒ͯ͠܈Λ ࡞੒
  19. replication OLD Master OLD Slave OLD Slave 5.6 Master 5.6

    Slave replication 5.6 Slave
  20. ݕূ

  21. ਖ਼ৗʹNZTRM@VQHSBEF͕ग़དྷΔ͔ طଘεΩʔϚɾΫΤϦͰXBSOJOHͱ͔ग़ͳ͍͔ ύϑΥʔϚϯε ϨϓϦέʔγϣϯ͸͏·͍͜ͱߦ͔͘ ৽ػೳɾύϥϝʔλͲ͏͢Δ͔ ΞϓϦέʔγϣϯαʔόͳͲͷϥΠϒϥϦ ӡ༻ #6(

  22. ਖ਼ৗʹNZTRM@VQHSBEF͕ग़དྷΔ͔ طଘεΩʔϚɾΫΤϦͰXBSOJOHͱ͔ग़ͳ͍͔ ύϑΥʔϚϯε ϨϓϦέʔγϣϯ͸͏·͍͜ͱߦ͔͘ ৽ػೳɾύϥϝʔλͲ͏͢Δ͔ ΞϓϦέʔγϣϯαʔόͳͲͷϥΠϒϥϦ ӡ༻ #6(

  23. ΞϓϦέʔγϣϯαʔόͳͲͷϥΠϒϥϦɾ ಈ࡞ MJCNZTRMNZTRMHFNMPH ύϑΥʔϚϯε TMPXRVFSZϨεϙϯε଎౓$16 NFNPSZ طଘεΩʔϚɾΫΤϦͰXBSOJOHͱ͔ग़ͳ͍͔ ৽ύϥϝʔλͱ͔Ͱ%&13&$"5&%ͳ΋ͷ͕ͳ ͍͔

  24. ,BHF

  25. https:/ /github.com/cookpad/kage https:/ /rubygems.org/gems/kage

  26. OLD DB M proxy kage app new app OLD DB

    S 5.6 DB M 5.6 DB S
  27. OLD DB M proxy kage app new app OLD DB

    S 5.6 DB M 5.6 DB S ϥΠϒϥϦ ΞϓϦέʔγϣϯͷಈ࡞
  28. OLD DB M proxy kage app new app OLD DB

    S 5.6 DB M 5.6 DB S ϥΠϒϥϦ ΞϓϦέʔγϣϯͷಈ࡞ XBSOJOH νϡʔχϯάɾಈ࡞
  29. ࣮ࡍͷϦΫΤετͰൃߦ͞ΕΔΫΤϦͰςετ͕ߦ͑Δ ࿙Ε͕গͳ͘SFBEXSJUFΛ࣮ࡍʹಈ࡞Λͤ͞ͳ͕Β ֬ೝग़དྷΔ %#ࣗମͷෛՙࢼݧ͸ผ్ߦ͏ ςετ͕ߦ͍қ͘ΞϓϦέʔγϣϯɾ%#֤ϨΠϠʔͰ໰ ୊Λݟ͚ͭ΍͍͢ɾ௚͠ͳ͕Βςετग़དྷΔ

  30. ଞʹ΋

  31. ։ൃɾݕূ༻ͷ%#ͱͯ͠όʔδϣϯɾઃఆΛม͑ͯಈ࡞ ͤ͞Δ ։ൃதͷΫΤϦ͸࣮ࡍʹ࢖༻͞ΕΔࣄ͕༧ଌ͞ΕΔ ࠓޙͷόʔδϣϯΞοϓͰ໰୊͕ग़ͳ͍͔֬ೝ͠΍͢ ͍ όʔδϣϯΛ্͛ͨ৔߹ʹJOEFYͷ࢖ΘΕํ͕มΘΔͳ ͲΛݟ͚ͭ΍͍͢ .Z42-ͷύϑΥʔϚϯε޲্ʹΑΓௐࠪΫΤϦ͕ߴ଎Խ ͢Δ͜ͱ΋

  32. ༻ҙ͍ͯ͠Δ؀ڥ ௒ݕূ༻ Y ओʹDPO@NBNF༻ ݕূ༻  ։ൃ༻%#ௐࠪ༻%# ຊ൪ Y ຊ൪$*

    ໾ׂ ௒ݕূ༻#6(ௐࠪ΍৽ػೳɾνϡʔχϯάݕূ༻ ݕূ༻ຊ൪σʔλΛϨϓϦέʔγϣϯͯ͠։ൃத ΍ௐࠪ༻ͷΫΤϦΛड͚෇͚༷ͤͯ͞ࢠΛݟΔɻ໰୊ ͕͋Ε͹௒ݕূ༻ΠϯελϯεͰௐࠪ
  33. replication production Master 5.6 or 5.5 or older... ௒ݕূ༻ ݕূ༻

    ຊ൪    Y  &#44OBQTIPUͱ".*Ͱ໰୊͕ىͬͨ͜όʔ δϣϯΛ௚͙ʹىಈͯ͠ௐࠪ ຊ൪αʔόͷ&#4͸Ұఆ ͓͖࣌ؒʹ4OBQTIPU͕ ͱΒΕ͍ͯΔ
  34. ਖ਼ৗʹNZTRM@VQHSBEF͕ग़དྷΔ͔ طଘεΩʔϚɾΫΤϦͰXBSOJOHͱ͔ग़ͳ͍͔ ύϑΥʔϚϯε ϨϓϦέʔγϣϯ͸͏·͍͜ͱߦ͔͘ ৽ػೳɾύϥϝʔλͲ͏͢Δ͔ ΞϓϦέʔγϣϯαʔόͳͲͷϥΠϒϥϦ ӡ༻ #6(

  35. 

  36. (5*% ӡ༻ෛՙ͕ҙ֎ͱେ͖͍ IUUQEDPONBNFFOUSZ σϑΥϧτ஋ͷมߋ΍ඇਪનͳ෺ FYQMJDJU@EFGBVMUT@GPS@UJNFTUBNQ CJOMPH@DIFDLTVNɹͱ͔ͱ͔ IUUQEFWNZTRMDPNEPDSFGNBOFOVQHSBEJOH GSPNQSFWJPVTTFSJFTIUNM 1FSGPSNBODF4DIFNFϝϞϦ৯͍·͘Γ

  37. ϐʔΫλΠϜͰϨϓϦέʔγϣϯΤϥʔىͬͨ͜Β ͜ͷखॱ͸ʜ  

  38. #6( ମݧࡁͷҰ෦PS[ NZTRMTMBWF@NBTUFS@JOGPJTOPUVQEBUFEIUUQ CVHTNZTRMDPNCVHQIQ JE "SFHSFTTJPOJODSBTISFDPWFSZBUPNJDJUZ IUUQCVHTNZTRMDPNCVHQIQ JE NFNPSZMFBLXJUIJOOPECNFNDBDIFEQMVHJOGPSTUBMF DPOOFDUJPOIUUQCVHTNZTRMDPNCVHQIQ

    JE SFQMJDBUJPOXBTCSPLFOXIJMFFYFDVUJOHGMVTI UBCMFTIUUQCVHTNZTRMDPNCVHQIQ JE *OWBMJEVTFPG(3"/5DPNNBOECSFBLTSFQMJDBUJPO IUUQCVHTNZTRMDPNCVHQIQ JE
  39. $PODMVTJPO

  40. ͸ͦΖͦΖؾܰʹ࢖͑ΔΑ͏ʹͳͬͨ (5*%1FSGPSNBODF4DIFNF "84্Ͱݕূ͢ΔͳΒɺ$BTVBMʹݕূͰ͖Δ &#44OBQTIPU".* ݕূ͸͔ͬ͠Γͱ ,BHFศར

  41. ͸ͦΖͦΖؾܰʹ࢖͑ΔΑ͏ʹͳͬͨ (5*%1FSGPSNBODF4DIFNF "84্Ͱݕূ͢ΔͳΒɺ$BTVBMʹݕূͰ͖Δ &#44OBQTIPU".* ݕূ͸͔ͬ͠Γͱ ,BHFศར IUUQCVHTNZTRMDPN ݟͯ·͢ΑͶʁ

  42. 5IBOLZPV