{"id":9516,"date":"2021-07-19T11:00:10","date_gmt":"2021-07-19T02:00:10","guid":{"rendered":"https:\/\/jennifersoft.com\/ko\/?p=9516"},"modified":"2023-08-02T15:33:32","modified_gmt":"2023-08-02T06:33:32","slug":"2021-07-19","status":"publish","type":"post","link":"https:\/\/jennifersoft.com\/ko\/blog\/tech\/2021-07-19\/","title":{"rendered":"\uc81c\ub2c8\ud37c \uc131\ub2a5 \ub370\uc774\ud130 RDB\uc5d0 \uc801\uc7ac\ud574\uc11c \ud65c\uc6a9\ud558\uae30"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

\uc81c\ub2c8\ud37c \uc131\ub2a5 \ub370\uc774\ud130\ub97c SQL\ub97c \ud65c\uc6a9\ud574\uc11c \uc0ac\uc6a9\ud558\uace0 \uc2f6\ub2e4\ub294 \uace0\uac1d \uc694\uad6c\uc0ac\ud56d\uc744 \uc704\ud574, \uc81c\ub2c8\ud37c R&D\ud300\uc5d0\uc11c \uc5f0\uad6c \uac1c\ubc1c \ud1b5\ud574 2\uac00\uc9c0 \ubc29\ubc95\uc73c\ub85c \uc81c\ub2c8\ud37c \ub370\uc774\ud130\ub97c SQL\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud55c\ub2e4\uace0 \uc774\uc804 \uae30\uc220 \ube14\ub85c\uadf8 \u201c\uc81c\ub2c8\ud37c API\uc11c\ubc84 \ud65c\uc6a9\ud558\uae30\u201d\uc5d0\uc11c \uc18c\uac1c\ud574 \ub4dc\ub838\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc774\ubc88 \uae00\uc740 \uc81c\ub2c8\ud37c \ub370\uc774\ud130 SQL\ub85c \ud65c\uc6a9\ud558\uae30 2\ubc88\uc9f8 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc81c\ub2c8\ud37c \ubdf0 \uc11c\ubc84\uac00 \uc81c\ub2c8\ud37c \uc131\ub2a5\ub370\uc774\ud130\ub97c \uc77d\uc5b4\uc11c \uc9c1\uc811 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc81c\ub2c8\ud37c \ub370\uc774\ud130\ub97c \uac01 \uc131\ub2a5\ubcc4 \ud14c\uc774\ube14\uc5d0 \uc801\uc7ac\ud558\uace0 \uc774\ub97c \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uc18d\ud574\uc11c \uc790\uc720\ub86d\uac8c \uc81c\ub2c8\ud37c \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud558\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc544\ub798\uc758 \uadf8\ub9bc\uc5d0\uc11c \ubcf4\uc2dc\ub294 \uac83\uacfc \uac19\uc774 \uc81c\ub2c8\ud37c \ubdf0 \uc11c\ubc84\uac00 \uc81c\ub2c8\ud37c \uc131\ub2a5\ub370\uc774\ud130\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4 (\uc624\ub77c\ud074, mysql, postgres)\uc5d0 \uc8fc\uae30\uc801\uc73c\ub85c \uc801\uc7ac\ud574 \uc8fc\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"
\uc81c\ub2c8\ud37c \uc131\ub2a5\ub370\uc774\ud130 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc801\uc7ac \ud750\ub984\ub3c4<\/figcaption><\/figure>\n\n\n\n

\ud604\uc7ac \uc81c\ub2c8\ud37c \ubdf0 \uc11c\ubc84\uc5d0\uc11c \uc131\ub2a5\ub370\uc774\ud130 \uc801\uc7ac\ub97c \uc704\ud574 \uc9c0\uc6d0\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc624\ub77c\ud074 12, Mysql 5.7, Postgres 9.x\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ub370\uc774\ud130 \uc885\ub958\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

  • \ub3c4\uba54\uc778 \uba54\ud2b8\ub9ad\uc2a4 (5\ubd84\/1\uc2dc\uac04\/\ud558\ub8e8)<\/li>
  • \uc778\uc2a4\ud134\uc2a4 \ub9e4\ud2b8\ub9ad\uc2a4 (5\ubd84\/1\uc2dc\uac04\/\ud558\ub8e8)<\/li>
  • \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub370\uc774\ud130 (\ud558\ub8e8)<\/li>
  • X-View \ub370\uc774\ud130(1\ubd84)<\/li><\/ul>\n\n\n\n

    <\/p>\n\n\n\n

    \uc5b4\ub5a4 \uc885\ub958\uc758 \ub370\uc774\ud130\uac00 \uc5b4\ub5a4 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub418\ub294\uc9c0\ub294 \uc544\ub798\uc758 \ud14c\uc774\ube14\uc744 \ucc38\uace0\ud574 \uc8fc\uc138\uc694.<\/p>\n\n\n\n

    \n\n\n\n\n\n\n\n\n
    DOMAIN_INFO<\/b><\/td>\n\ub3c4\uba54\uc778 \uc815\ubcf4 \uc800\uc7a5<\/b><\/td><\/tr>\n
    DOMAIN_METRIC_1DAY<\/td>\n\ud558\ub8e8\uce58 \ub3c4\uba54\uc778 \uba54\ud2b8\ub9ad \uc800\uc7a5(summary \uacc4\uc5f4\ub9cc \uc800\uc7a5)<\/td>\n<\/tr>\n
    DOMAIN_METRIC_1HOUR<\/td>\n\ud55c\uc2dc\uac04 \ud3c9\uade0 \ub3c4\uba54\uc778 \ub9e4\ud2b8\ub9ad \uc800\uc7a5<\/td>\n<\/tr>\n
    DOMAIN_METRIC_5MIN<\/td>\n5\ubd84\ud3c9\uade0 \ub3c4\uba54\uc778 \ub9e4\ud2b8\ub9ad \uc800\uc7a5<\/td>\n<\/tr>\n
    INSTANCE_INFO<\/td>\n\uc778\uc2a4\ud134\uc2a4 \uc815\ubcf4 \uc800\uc7a5<\/td>\n<\/tr>\n
    INSTANCE_METRIC_1DAY<\/td>\n\ud558\ub8e8\uce58 \uc778\uc2a4\ud134\uc2a4 \ub9e4\ud2b8\ub9ad \uc800\uc7a5(summary \uacc4\uc5f4\ub9cc \uc800\uc7a5)<\/td>\n<\/tr>\n
    INSTANCE_METRIC_1HOUR<\/td>\n\ud55c\uc2dc\uac04\ud3c9\uade0 \uc778\uc2a4\ud134\uc2a4 \ub9e4\ud2b8\ub9ad \uc800\uc7a5<\/td>\n<\/tr>\n
    INSTANCE_METRIC_5MIN<\/td>\n5\ubd84\ud3c9\uade0 \uc778\uc2a4\ud134\uc2a4 \ub9e4\ud2b8\ub9ad \uc800\uc7a5<\/td>\n<\/tr>\n
    APPLICATION_METRIC_1DAY<\/td>\n\ud558\ub8e8\uce58 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ud1b5\uacc4 \uc800\uc7a5 (\uc2dc\uac04\ub2e8\uc704\ub294 \uc9c0\uc6d0 \uc548\ud568)<\/td>\n<\/tr>\n
    TRANSACTION_{domain_id}_YYYYMMDD<\/td>\nX-View \ud2b8\ub79c\uc7ad\uc158 \ub370\uc774\ud130 \uc800\uc7a5<\/td>\n<\/tr>\n<\/tbody><\/table><\/div>\n\n\n\n

    \uc2e4\uc81c \uad6c\uc131\ud558\uace0 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcfc\uae4c\uc694?<\/p>\n\n\n\n

    \uc77c\ub2e8 server.vier\/lib\ub514\ub809\ud1a0\ub9ac\uc5d0 \uc81c\ub2c8\ud37c \uc131\ub2a5 \ub370\uc774\ud130\ub97c \uc801\uc7ac\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4jdbc \ub4dc\ub77c\uc774\ubc84\ub97c \ubcf5\uc0ac\ud574\uc11c \ub123\uc5b4 \uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n

    \uadf8\ub9ac\uace0 server.view\/conf\/server_view.conf\uc5d0 \uc544\ub798\uc758 \uc635\uc158\ub9cc \ucd94\uac00\ud574 \uc8fc\uc2dc\uba74 \uac04\ub2e8\ud558\uac8c \uc81c\ub2c8\ud37c \uc131\ub2a5 \ub370\uc774\ud130\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc801\uc7ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

    rdb_export_jdbc_driver_class_name=oracle.jdbc.OracleDriver\nrdb_export_jdbc_url=jdbc:oracle:thin:@192.168.9.210:1521\/JENNIFER\n\n# RDB \uc0ac\uc6a9\uc790 \ubc0f \uc554\ud638 \nrdb_export_jdbc_user=jennifer\nrdb_export_jdbc_password=jennifer\n\n# RDB\ub85c \uc800\uc7a5\ud560 \uc885\ub958\uc758 \ub3c4\uba54\uc778id\ub97c \ucf64\ub9c8\ub85c \ub123\ub294\ub2e4 \nrdb_export_instance_metric_domain=1004,7002,7908\nrdb_export_domain_metric_domain=1004,7002,7908\nrdb_export_application_metric_domain=1004,7002,7908\nrdb_export_transaction_domain=1004,7002,7908\n<\/pre>\n\n\n\n
    \uc124\uc815 \ud6c4 \uc81c\ub2c8\ud37c \ubdf0 \uc11c\ubc84\ub97c \uc7ac\uae30\ub3d9\ud558\uc2dc\uba74 \uadf8\uac78\ub85c \ubaa8\ub4e0 \uc124\uc815\uc740 \ub9c8\uce58\uac8c \ub429\ub2c8\ub2e4. 
    \uc815\uc0c1\uc801\uc73c\ub85c \ub370\uc774\ud130 \uc801\uc7ac\uac00 \uc774\ub8e8\uc5b4 \uc9c0\uace0 \uc788\ub2e4\uba74 \uc81c\ub2c8\ud37c \ubdf0 \uc11c\ubc84 \ub85c\uadf8\ud30c\uc77c\uc5d0\uc11c \uc544\ub798\uc640 \uac19\uc740 \ub85c\uadf8 \uba54\uc138\uc9c0\ub97c \ubcfc  \uc218 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
    2020-07-24 17:19:10.678 [main] INFO  com.aries.view.export.RDBExportLog - RDB Export: Enabled. config=RDBExportConfig(connection=Connection(driverClassName=oracle.jdbc.OracleDriver, url=jdbc:oracle:thin:@192.168.9.230:1521\/JENNIFER, user=jennifer, password=\u2588\u2588\u2588\u2588), instanceMetric=Category(domainIds=[1004, 7002, 7908], batch=false), domainMetric=Category(domainIds=[1004, 7002, 7908], batch=false), applicationMetric=Category(domainIds=[1004, 7002, 7908], batch=true), transaction=Category(domainIds=[1004, 7002, 7908], batch=false), batchMinuteOffsetInDay=925)\n2020-07-24 17:19:11.735 [:ME:RDBExportBatch:Running:com.aries.view.export.RDBExporter$start$1] INFO  com.aries.view.export.RDBExportLog - RDB Export: Test connection succeeded. url=jdbc:oracle:thin:@192.168.9.230:1521\/JENNIFER\n<\/pre>\n\n\n\n
    \uc5ec\uae30\uc11c \ub85c\uadf8 \uba54\uc2dc\uc9c0 \uc77d\ub294 \ubc95 \uba87 \uac00\uc9c0\ub97c \uc608\uc2dc\ub97c \ud1b5\ud574 \uc124\uba85\ud574 \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc608\uc81c 1)<\/strong><\/p>\n\n\n\n
    RDB Export: Exported. table=instance_metric_5min, domain=7002, range=2020-07-26T13:55~PT5M, records=3, elapsed=0s<\/pre>\n\n\n\n
    \uc774 \uba54\uc2dc\uc9c0\ub294 \ub3c4\uba54\uc778 7002\uc758 \uc778\uc2a4\ud134\uc2a4 \ub9e4\ud2b8\ub9ad\uc2a4 \uc911 13:55-14:00\uae4c\uc9c0\uc758 3\uac1c \uba54\ud2b8\ub9ad\uc744 \uc800\uc7a5\ud558\ub294\ub370 \uc18c\uc694\ub418\ub294 \uc2dc\uac04\uc740 0\ucd08\ub77c\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc608\uc81c 2)<\/strong><\/p>\n\n\n\n
    RDB Export: Exported. table=domain_metric_1hour, domain=1004, range=2020-07-26T13:00~PT1H, records=1, elapsed=0s<\/pre>\n\n\n\n
    \uc774 \uba54\uc2dc\uc9c0\ub294 \ub3c4\uba54\uc778 1004\uc758 \ub3c4\uba54\uc778 \ub9e4\ud2b8\ub9ad \uc911 13:00 \u2013 14:00\uae4c\uc9c0\uc758 1\uac1c \ub9e4\ud2b8\ub9ad\uc744 \uc800\uc7a5\ud558\ub294\ub370 \uc18c\uc694\ub418\ub294 \uc2dc\uac04\uc740 0\ucd08\ub77c\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc608\uc81c 3)<\/strong><\/p>\n\n\n\n
    RDB Export: Exported. table=application_metric_1day, domain=1004, range=2020-07-25T00:00~PT24H, records=1380, elapsed=0s<\/pre>\n\n\n\n
    \ub3c4\uba54\uc778 1004\uc758 7\uc6d4 25\uc77c \uc804\uccb4 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ud1b5\uacc4 1380\uac74\uc744 \uc800\uc7a5\ud558\ub294\ub370 \uac78\ub9b0 \uc2dc\uac04\uc740 0\ucd08\ub77c\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc608\uc81c 4)<\/strong><\/p>\n\n\n\n
    RDB Export: Exported. table=transaction_7908_20200726, domain=7908, range=2020-07-26T14:13~PT1M, records=634, elapsed=3s<\/pre>\n\n\n\n
    \ub3c4\uba54\uc778 7908\uc758 X-View \ub370\uc774\ud130 \uc911 14:13 \u2013 14:14\uae4c\uc9c0\uc758 \ub370\uc774\ud130 634\uac74\uc744 \uc800\uc7a5\ud558\ub294\ub370 \uac78\ub9b0\uc2dc\uac04\uc740 3\ucd08 \ub77c\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uba54\uc2dc\uc9c0 \ub0b4\uc6a9\uc774 \uc9c1\uad00\uc801\uc73c\ub85c \ud45c\ud604\ub418\uc5b4 \uc788\uc5b4 \uc27d\uac8c \uc77d\uace0 \ud655\uc778\ud560  \uc218  \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc774\uc81c \uc2e4\uc81c \ucffc\ub9ac\ub97c \uc218\ud589\ud574\uc11c \uc81c\ub2c8\ud37c \uc131\ub2a5 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
    \"\"
    \uc778\uc2a4\ud134\uc2a4 \ub9e4\ud2b8\ub9ad\uc2a4 5\ubd84 \ud3c9\uade0\ub370\uc774\ud130 \uc870\ud68c \uc608<\/figcaption><\/figure>\n\n\n\n
    \"\"
    \ub3c4\uba54\uc778  \ub9e4\ud2b8\ub9ad\uc2a4 1\uc2dc\uac04 \ud3c9\uade0 \ub370\uc774\ud130 \uc870\ud68c \uc608<\/figcaption><\/figure>\n\n\n\n
    \"\"
    X-View \ud2b8\ub79c\uc7ad\uc158 \ud14c\uc774\ud130 \uc870\ud68c \uc608<\/figcaption><\/figure>\n\n\n\n
    \"\"
    \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ud1b5\uacc4\uc815\ubcf4 \uc870\ud68c \uc608<\/figcaption><\/figure>\n\n\n\n
    \uc774\uc0c1\uc73c\ub85c \uc81c\ub2c8\ud37c \uc131\ub2a5\ub370\uc774\ud130 \ud65c\uc6a9\ud558\uae30 2\ubc88\uc9f8 \ubc29\ubc95\uc778 RDB\uc5d0 \uc801\uc7ac\ud574\uc11c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc880 \ub354 \uad6c\uccb4\uc801\uc778 \uc0ac\uc6a9 \ubc29\ubc95\uc774 \uad81\uae08\ud558\uc2dc\ub2e4\uba74 tech@jennifersoft.com\ub85c \ubb38\uc758\ud574 \uc8fc\uc138\uc694.<\/p>\n\n\n\n
    \uac10\uc0ac\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"\uc81c\ub2c8\ud37c \uc131\ub2a5 \ub370\uc774\ud130\ub97c SQL\ub97c \ud65c\uc6a9\ud574\uc11c \uc0ac\uc6a9\ud558\uace0 \uc2f6\ub2e4\ub294 \uace0\uac1d \uc694\uad6c\uc0ac\ud56d\uc744 \uc704\ud574, \uc81c\ub2c8\ud37c R&D\ud300\uc5d0\uc11c \uc5f0\uad6c \uac1c\ubc1c \ud1b5\ud574 2\uac00\uc9c0 \ubc29\ubc95\uc73c\ub85c \uc81c\ub2c8\ud37c \ub370\uc774\ud130\ub97c SQL\ub85c…","protected":false},"author":21,"featured_media":9603,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[204],"tags":[284,285,283],"class_list":["post-9516","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech","tag-rdb","tag-285"],"acf":[],"_links":{"self":[{"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/posts\/9516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/comments?post=9516"}],"version-history":[{"count":50,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/posts\/9516\/revisions"}],"predecessor-version":[{"id":10760,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/posts\/9516\/revisions\/10760"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/media\/9603"}],"wp:attachment":[{"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/media?parent=9516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/categories?post=9516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jennifersoft.com\/ko\/wp-json\/wp\/v2\/tags?post=9516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}