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

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

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

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

LY Corporation Tech

July 11, 2024
Tweet

More Decks by 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