Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Trinoの長期運用から学んだこと

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers.

 Trinoの長期運用から学んだこと

「Trino Japan Community Meetup 2024」での発表資料です。

More Decks by LINEヤフーTech (LY Corporation Tech)

Other Decks in Technology

Transcript

  1. ˜-:$PSQPSBUJPO ໊લɿ 1PPO :BU4JOH ϋϯ ΠοηΠ /JDLOBNFɿ 4UBS ελʔ ܦྺɿ

    • Ϡϑʔ ݱ-*/&Ϡϑʔ ΁৽ଔೖࣾ • 1SFTUPνʔϜʹॴଐ • 1SFTUP5SJOPͷ։ൃ΍ӡ༻ͳͲ • d5FDI-FBEΛ୲౰ झຯɿ • ݘͱཱྀߦ (JU)VC!POFPOFTUBS 4FMG*OUSPEVDUJPO  ࣗݾ঺հ
  2. ˜-:$PSQPSBUJPO • ྑ͍͜ͱɿ • ηΩϡϦςΟཁ͓݅ΑͼίϯϓϥΠΞϯεཁ݅΁ͷରԠ • υοάϑʔσΟϯά • 0+5ͷֶशग़ൃ఺ •

    5SJOPϢʔβʔ΋खܰʹΞΫηεՄೳ • ՝୊ɿ • 5SJOPόʔδϣϯΞοϓલޙϩάͷޓ׵ੑ • 42-Ͱ෼ੳ͠ʹ͍͘ΧϥϜ͕ଘࡏ • ؔ࿈γεςϜͷো֐ൃੜ࣌ʹϩάࢀরෆՄ  ΫΤϦͷϩά 5SJOP )%'4 .2 ϩάΛॻ͘ &WFOU-JTUFOFS ϩάΛಡΉ 5SJOP2VFSZ"VEJU-PH
  3. ˜-:$PSQPSBUJPO • ྑ͍͜ͱɿ • *OGSBTUSVDUVSFBTDPEF *B$ • એݴܕίϯϑΟά؅ཧ • ίϯςφʔͰґଘΛ؅ཧ

    • ๛෋ͳπʔϧͱαϙʔτ • ՝୊ɿ • ੑೳ໰୊ • ,4ͷεέʔϥϏϦςΟ $POGJHVSBUJPOBOE%FQMPZNFOUNBOBHFNFOU  ίϯϑΟάͱσϓϩΠͷ؅ཧ 5SJOP 5SJOP 5SJOP ,VCFSOFUFT $*$%1JQFMJOF 5SJOP0QFSBUPS 5SJOPDPOGJH 5SJOP$3%:".- QSFTUPBENJO .VMUJTTI $IFG .FTPT ,VCFSOFUFT ਐԽྺ࢙ɿ
  4. ˜-:$PSQPSBUJPO • ؂ࢹର৅ɿ • 5SJOP • ΫΤϦͷϩά • ґଘγεςϜ •

    4-0ఆٛ಺༰ɿ • 6QUJNF • 3FTQPOTF5JNF • Τϥʔ཰ͳͲ • ՝୊ɿ • 1SPNFUIFVTͷεέʔϥϏϦςΟ • .FUSJDͷҙຯ • .FUSJDTͷूܭํ๏ .POJUPSJOH  ؂ࢹ 5SJOP 5SJOP 5SJOP ,VCFSOFUFT 1SPNFUIFVT (SBGBOB #MBDL#PY .POJUPS ఆظ1SPCF 5SJOP )%'4 .2 ϩάΛॻ͘ ϩάΛಡΉ #*5PPM
  5. ˜-:$PSQPSBUJPO • 3FTPVSDF(SPVQTͱ4FTTJPO1SPQFSUZ.BOBHFSΛ׆༻ • ແఀࢭϝϯςφϯε͕େࣄ • ґଘ͍ͯ͠ΔγεςϜͷεέʔϥϏϦςΟ໰୊ • Ϣʔβʔͷ࢖͍ํʹཁ஫ҙ •

     ΧϥϜ͕͋Δςʔϒϧ • ҟৗʹෳࡶͳΫΤϦ • Ұ࣌తͳςʔϒϧ΍1BSUJUJPOΛେྔ࡞੒ • +%#$Ͱ਺े(#ͷΫΤϦ݁ՌΛऔΔ 0UIFS5JQT  ͦͷଞͷώϯτ
  6. ˜-:$PSQPSBUJPO *NQSPWF8PSL&GGJDJFODZ  ۀ຿ޮ཰ͷ޲্ ࢓ࣄ ޮ཰Խ ӡ༻࡞ۀ ӡ༻ͷࣗಈԽ ৽ػೳ։ൃ΍ಋೖ ࣾ಺ษڧձɺ044΁ͷίϛοτ

    ໰͍߹ΘͤରԠ υΩϡϝϯτͷ੔උɺ$IBU(15Λར༻ ࣾ಺γεςϜͱͷ੔߹ ίϛϡχέʔγϣϯνϟϯωϧͷ੔උ ΠϯγσϯτରԠ ݪҼͷਂ۷Γͱ࠶ൃ๷ࢭ όάରԠ 044΁ͷίϛοτɺґଘγεςϜͱͷ࿈ܞ 5SJOPόʔδϣϯΞοϓ ݕূͷࣗಈԽɺϫʔΫϑϩʔͷվળ
  7. ˜-:$PSQPSBUJPO • ௕ظαϙʔτ -54 ͕ͳ͍ • ࣾ಺ಠࣗͷ-54ӡ༻ • ࠷৽ͷ+BWB΁ͷґଘ •

    +BWBͷඞਢཁ݅ • ࣾ಺ج൫ͷαϙʔτൣғ֎ • ޓ׵ੑ͕ͳ͍ • ϢʔβʔଆରԠඞਢͳมߋ • ಺෦ͷίʔυมߋ • ݕূ͕೉͍͠ • 8PSLMPBEͷ࠶ݱ • ಛผͳϢʔεέʔεͷݕূ 6OJRVF$IBMMFOHFTPG6QHSBEJOH5SJOP  5SJOPόʔδϣϯΞοϓͷ՝୊ 5SJOP  &0- &0- 5SJOP  5SJOP  dिؒ 5SJOP &0- 5SJOP dϲ݄ ࣾ಺ͷ5SJOP-JGFDZDMF dϲ݄ 5SJOP044 dिؒ dिؒ
  8. ˜-:$PSQPSBUJPO "EWBOUBHFTBOE%JTBEWBOUBHFTPG6QHSBEJOH'SFRVFOUMZ  όʔδϣϯΞοϓͷස౓ʹΑΔϝϦοτɾσϝϦοτ ߴස౓ ௿ස౓ ৽ػೳ͕࢖͑Δ ੑೳվળ #BDLQPSU͕ൃੜ ίϛϡχςΟͷαϙʔτ͕ͳ͍

    όʔδϣϯΞοϓͷࠩ෼͕େ͖͘ͳΔ ϝϦοτ σϝϦοτ ҆ఆੑվળ طଘͷόά͕௚͞Εͨ ੬ऑੑରԠ ৽όʔδϣϯͷόάΛૺ۰ ৽όʔδϣϯͷݕূͱಋೖίετ ରԠ޻਺Λ཈͑Δ ӡ༻ίετΛ཈͑Δ 5SJOPӡ༻νʔϜࢹ఺ 5SJOPϢʔβʔࢹ఺ Ϗδωεཁ݅Ͱ͸ͳ͍ͷʹ ରԠ޻਺͕͔͔Δ ཉ͍͠ػೳ͕࢖͑ͳ͍
  9. ˜-:$PSQPSBUJPO ଞͷ։ൃ΍࡞ۀ • όʔδϣϯΞοϓͷϙϦγʔ • 9ϲ݄ʹճͷόʔδϣϯΞοϓΛ࣮ࢪ • ޓ׵ੑͷඇ୲อ • Ϣʔβʔͷڠྗ

    • ࣾ಺ύονͷ࠷খԽ • 044΁ͷίϛοτΛਪਐ • ௕ظӡ༻ίετͷߴ͞Λೝࣝ • 5SJOPίϛϡχςΟͱͷ࿈ܞ • 044ͷ։ൃঢ়گΛ೺Ѳ • *TTVFͷใࠂ 5JQTGPSVQHSBEJOH5SJOP  5SJOPόʔδϣϯΞοϓͷώϯτ 5SJOP 5SJOP όʔδϣϯΞοϓͷࣄલ४උ όʔδϣϯΛݕূ όάௐࠪ΍मਖ਼ όʔδϣϯΞοϓ࡞ۀ τϥϒϧରԠ όʔδϣϯΞοϓظؒ ଞͷ։ൃ΍࡞ۀ dϲ݄̍ճ ໌֬తͳӡ༻$ZDMF
  10. ˜-:$PSQPSBUJPO • 5SJOP(BUFXBZΛಋೖ • ΧφϦΞϦϦʔεͰόʔδϣϯΞοϓ • #MBDL#PY؂ࢹ • 5SJOPΫϥελʔ෼ׂʹΑΔϦιʔε࠷దԽ •

    5SJOPίϛϡχςΟͱ࿈ܞ • ࣾ಺ύονΛ044Խ • $POUSJCVUPSNFFUJOHTΛࢀՃ 'VUVSF  ࠓޙͷऔΓ૊Έ 5SJOP 5SJOP 5SJOP (BUFXBZ