{"id":3159,"date":"2024-12-05T16:06:57","date_gmt":"2024-12-05T08:06:57","guid":{"rendered":"https:\/\/199604.com\/?p=3159"},"modified":"2025-01-07T16:16:16","modified_gmt":"2025-01-07T08:16:16","slug":"apache-doris-%e5%bf%ab%e9%80%9f%e5%ae%89%e8%a3%85%e4%bd%93%e9%aa%8c","status":"publish","type":"post","link":"https:\/\/199604.com\/3159","title":{"rendered":"Apache doris \u5feb\u901f\u5b89\u88c5\u4f53\u9a8c"},"content":{"rendered":"

Apache doris \u5feb\u901f\u5b89\u88c5\u4f53\u9a8c<\/h1>\n

\u73af\u5883\u51c6\u5907<\/h2>\n

1.\u9009\u62e9\u4e00\u4e2a x86-64 \u4e0a\u7684\u4e3b\u6d41 Linux \u73af\u5883\uff0c\u63a8\u8350 CentOS 7.1 \u6216\u8005 Ubuntu 16.04 \u4ee5\u4e0a\u7248\u672c\u3002\u66f4\u591a\u8fd0\u884c\u73af\u5883\u8bf7\u53c2\u8003\u5b89\u88c5\u90e8\u7f72\u90e8\u5206\u3002<\/p>\n

2.Java 8 \u8fd0\u884c\u73af\u5883<\/p>\n

3.\u5173\u95edswap\u548c\u4fee\u6539limits.conf<\/p>\n

# \u5173\u95ed\u9632\u706b\u5899\nsystemctl stop firewalld\nsystemctl disable firewalld\n\n# \u5173\u95edSELinux\ncat \/etc\/selinux\/config\nsetenforce 0 && sed -i 's\/^SELINUX=.*\/SELINUX=disabled\/' \/etc\/selinux\/config && getenforce\ncat \/etc\/selinux\/config\n\ncp -a \/etc\/security\/limits.conf  \/etc\/security\/limits.conf.backup\ncat >> \/etc\/security\/limits.conf << EOF\n* soft nofile 65535\n* hard nofile 65535\n* soft nproc 65565\n* hard nproc 65565\nEOF\ncp -a \/etc\/sysctl.conf  \/etc\/sysctl.conf.bak\necho \"vm.max_map_count=2000000\"  >> \/etc\/sysctl.conf\nsysctl -p\nswapoff -a && sudo sed -i '\/swap\/s\/^\/#\/' \/etc\/fstab\n<\/code><\/pre>\n
4.\u4e0b\u8f7d\u4e8c\u8fdb\u5236\u5305\uff0c\u6b64\u6b21\u4f7f\u7528\u7684\u7248\u672c\u662f\uff1aapache-doris-2.1.7-bin-x64.tar.gz<\/code><\/p>\n
\u5b89\u88c5 Doris<\/h2>\n
\u89e3\u538bdoris\u8f6f\u4ef6<\/h3>\n
tar -zxvf apache-doris-2.1.7-bin-x64.tar.gz\nmv apache-doris-2.1.7-bin-x64 apache-doris\n#----------------------------------------------\n[root@localhost apache-doris]# ll\n\u603b\u7528\u91cf 0\ndrwxr-xr-x 11 root root 160 11\u6708  6 15:36 be\ndrwxr-xr-x  3 root root  32 11\u6708  6 15:36 extensions\ndrwxr-xr-x 14 root root 243 12\u6708  4 23:13 fe\n<\/code><\/pre>\n
\u914d\u7f6e FE<\/h3>\n
FE \u7684\u914d\u7f6e\u6587\u4ef6\u4e3a apache-doris\/fe\/conf\/fe.conf<\/code>\u3002<\/p>\n
\u9700\u8981\u914d\u7f6epriority_networks<\/code>\u6307\u5b9aip\uff0c\u5176\u5b83\u914d\u7f6e\uff0c\u53ef\u4ee5\u4f7f\u7528\u9ed8\u8ba4\u503c\uff0c\u5373\u53ef\u652f\u6301\u5355\u673a\u5feb\u901f\u4f53\u9a8c\u3002<\/p>\n
\u5982\u6211\u5f53\u524d\u865a\u62df\u673aip\u662f192.168.100.150<\/code><\/p>\n
\"image-20241205154620744\"<\/div><\/p>\n
\n  # FE \u5143\u6570\u636e\u5b58\u653e\u7684\u76ee\u5f55\uff0c\u9ed8\u8ba4\u662f\u5728 DORIS_HOME \u4e0b\u7684 doris-meta \u76ee\u5f55\u3002\u5df2\u7ecf\u521b\u5efa\uff0c\u53ef\u4ee5\u66f4\u6539\u4e3a\u4f60\u7684\u5143\u6570\u636e\u5b58\u50a8\u8def\u5f84\u3002
\n  #meta_dir = ${DORIS_HOME}\/doris-meta<\/code>\n<\/p><\/blockquote>\n
\u542f\u52a8 FE<\/h3>\n
\u5728apache-doris\/fe<\/code>\u4e0b\uff0c\u8fd0\u884c\u4e0b\u9762\u547d\u4ee4\u542f\u52a8 FE\u3002<\/p>\n
# \u5c06 FE \u542f\u52a8\u6210\u540e\u53f0\u8fd0\u884c\u6a21\u5f0f\uff0c\u8fd9\u6837\u786e\u4fdd\u9000\u51fa\u7ec8\u7aef\u540e\uff0c\u8fdb\u7a0b\u4f9d\u65e7\u8fd0\u884c\u3002\n[root@localhost fe]# .\/bin\/start_fe.sh --daemon\n[root@localhost fe]#\n[root@localhost fe]# ps -ef| grep fe\nroot         66      2  0 15:17 ?        00:00:00 [deferwq]\nroot       9122      1 77 15:47 pts\/0    00:00:03 \/usr\/local\/jdk\/bin\/java -Dfile.encoding=UTF-8 -Djavax.security.auth.useSubjectCredsOnly=false -Xss4m -Xmx8192m -XX:+UnlockExperimentalVMOptions -XX:+UseG1GC -XX:MaxGCPauseMillis=200 -XX:+PrintGCDateStamps -XX:+PrintGCDetails -Xloggc:\/AppHome\/doris\/apache-doris\/fe\/log\/fe.gc.log.20241205-154728 -Dlog4j2.formatMsgNoLookups=true -XX:-OmitStackTraceInFastThrow -XX:OnOutOfMemoryError=kill -9 %p org.apache.doris.DorisFE\nroot       9141   8543  0 15:47 pts\/0    00:00:00 grep --color=auto fe\n\n<\/code><\/pre>\n
\u914d\u7f6e BE<\/h3>\n
BE \u7684\u914d\u7f6e\u6587\u4ef6\u4e3a apache-doris\/be\/conf\/be.conf<\/code><\/p>\n
\u9700\u8981\u914d\u7f6epriority_networks<\/code>\u6307\u5b9aip\uff0c\u5176\u5b83\u914d\u7f6e\uff0c\u53ef\u4ee5\u4f7f\u7528\u9ed8\u8ba4\u503c\uff0c\u5373\u53ef\u652f\u6301\u5355\u673a\u5feb\u901f\u4f53\u9a8c\u3002<\/p>\n
\u5982\u6211\u5f53\u524d\u865a\u62df\u673aip\u662f192.168.100.150<\/code><\/p>\n
\"image-20241205154620744\"<\/div><\/p>\n
\n  # BE \u6570\u636e\u5b58\u653e\u7684\u76ee\u5f55\uff0c\u9ed8\u8ba4\u662f\u5728 DORIS_HOME \u4e0b\u7684 storage \u4e0b\uff0c\u9ed8\u8ba4\u5df2\u7ecf\u521b\u5efa\uff0c\u53ef\u4ee5\u66f4\u6539\u4e3a\u4f60\u7684\u6570\u636e\u5b58\u50a8\u8def\u5f84
\n  # storage_root_path = ${DORIS_HOME}\/storage<\/code>\n<\/p><\/blockquote>\n
\u542f\u52a8 BE<\/h3>\n
\u5728 apache-doris\/be<\/code> \u4e0b\uff0c\u8fd0\u884c\u4e0b\u9762\u547d\u4ee4\u542f\u52a8 BE\u3002<\/p>\n
[root@localhost be]# .\/bin\/start_be.sh --daemon\n\n[root@localhost be]# ps -ef |grep \/doris_be\nroot      10098      1 68 15:51 pts\/0    00:00:42 \/AppHome\/doris\/apache-doris\/be\/lib\/doris_be\nroot      12131   8543  0 15:52 pts\/0    00:00:00 grep --color=auto \/doris_be\n\n<\/code><\/pre>\n
\u8fde\u63a5 Apache Doris FE<\/h3>\n
\u901a\u8fc7 MySQL \u5ba2\u6237\u7aef\u6765\u8fde\u63a5 Apache Doris FE\uff0c\u4e0b\u8f7d\u514d\u5b89\u88c5\u7684 MySQL \u5ba2\u6237\u7aef<\/a>\u3002\u89e3\u538b\u521a\u624d\u4e0b\u8f7d\u7684 MySQL \u5ba2\u6237\u7aef\uff0c\u5728 bin\/<\/code> \u76ee\u5f55\u4e0b\u53ef\u4ee5\u627e\u5230 mysql<\/code> \u547d\u4ee4\u884c\u5de5\u5177\u3002\u7136\u540e\u6267\u884c\u4e0b\u9762\u7684\u547d\u4ee4\u8fde\u63a5 Apache Doris\u3002<\/p>\n
mysql -uroot -P9030 -h127.0.0.1<\/code><\/p>\n
\u6211\u8fd9\u8fb9\u4f7f\u7528\u7684\u662fdbeaver\u8fde\u63a5\u7684\uff0c\u9ed8\u8ba4root\u65e0\u5bc6\u7801<\/p>\n
\"image-20241205155433636\"<\/div><\/p>\n
\u6ce8\u518cBE\u5230FE\u4e2d<\/h3>\n
\u5728 MySQL \u5ba2\u6237\u7aef\u6267\u884c\u7c7b\u4f3c\u4e0b\u9762\u7684 SQL\uff0c\u5c06 BE \u6dfb\u52a0\u5230\u96c6\u7fa4\u4e2d<\/p>\n
 # ALTER SYSTEM ADD BACKEND \"be_host_ip:heartbeat_service_port\";\n ALTER SYSTEM ADD BACKEND \"192.168.100.150:9050\";\n<\/code><\/pre>\n
\u67e5\u770bBE\uff0cFE\u72b6\u6001<\/h4>\n
show proc '\/backends';\nBackendId|Host           |HeartbeatPort|BePort|HttpPort|BrpcPort|ArrowFlightSqlPort|LastStartTime      |LastHeartbeat      |Alive|SystemDecommissioned|TabletNum|DataUsedCapacity|TrashUsedCapacity|AvailCapacity|TotalCapacity|UsedPct|MaxDiskUsedPct|RemoteUsedCapacity|Tag                     |ErrMsg|Version                    |Status                                                                                                                       |HeartbeatFailureCounter|NodeRole|\n---------+---------------+-------------+------+--------+--------+------------------+-------------------+-------------------+-----+--------------------+---------+----------------+-----------------+-------------+-------------+-------+--------------+------------------+------------------------+------+---------------------------+-----------------------------------------------------------------------------------------------------------------------------+-----------------------+--------+\n10069    |192.168.100.150|9050         |9060  |8040    |8060    |-1                |2024-12-05 15:52:05|2024-12-05 15:57:01|true |false               |24       |0.000           |0.000            |74.180 GB    |99.976 GB    |25.80 %|25.80 %       |0.000             |{\"location\" : \"default\"}|      |doris-2.1.7-rc03-443e87e203|{\"lastSuccessReportTabletsTime\":\"2024-12-05 15:56:26\",\"lastStreamLoadTime\":-1,\"isQueryDisabled\":false,\"isLoadDisabled\":false}|0                      |mix     |\n\nshow proc '\/frontends';\nName                                   |Host           |EditLogPort|HttpPort|QueryPort|RpcPort|ArrowFlightSqlPort|Role    |IsMaster|ClusterId |Join|Alive|ReplayedJournalId|LastStartTime      |LastHeartbeat      |IsHelper|ErrMsg|Version                    |CurrentConnected|\n---------------------------------------+---------------+-----------+--------+---------+-------+------------------+--------+--------+----------+----+-----+-----------------+-------------------+-------------------+--------+------+---------------------------+----------------+\nfe_72ca5633_c907_4063_8351_b50252ae0503|192.168.100.150|9010       |8030    |9030     |9020   |-1                |FOLLOWER|true    |1556370489|true|true |7618             |2024-12-05 15:47:59|2024-12-05 15:56:21|true    |      |doris-2.1.7-rc03-443e87e203|Yes             |\n\n<\/code><\/pre>\n
\u4fee\u6539 Root \u7528\u6237\u548c Admin \u7528\u6237\u7684\u5bc6\u7801<\/h3>\n
\u5728 MySQL \u5ba2\u6237\u7aef\uff0c\u6267\u884c\u7c7b\u4f3c\u4e0b\u9762\u7684 SQL\uff0c\u4e3a Root \u7528\u6237\u548c Admin \u7528\u6237\u8bbe\u7f6e\u65b0\u5bc6\u7801<\/p>\n
#SET PASSWORD FOR 'root' = PASSWORD('doris-root-password'); \nmysql> SET PASSWORD FOR 'root' = PASSWORD('123456'); \nQuery OK, 0 rows affected (0.01 sec)\n#SET PASSWORD FOR 'admin' = PASSWORD('doris-admin-password');   \nmysql> SET PASSWORD FOR 'admin' = PASSWORD('123456');\nQuery OK, 0 rows affected (0.00 sec)\n<\/code><\/pre>\n
\n  Root \u7528\u6237\u548c Admin \u7528\u6237\u7684\u533a\u522b<\/p>\n
  Root \u7528\u6237\u548c Admin \u7528\u6237\u90fd\u5c5e\u4e8e Apache Doris \u5b89\u88c5\u5b8c\u9ed8\u8ba4\u5b58\u5728\u7684 2 \u4e2a\u8d26\u6237\u3002\u5176\u4e2d Root \u7528\u6237\u62e5\u6709\u6574\u4e2a\u96c6\u7fa4\u7684\u8d85\u7ea7\u6743\u9650\uff0c\u53ef\u4ee5\u5bf9\u96c6\u7fa4\u5b8c\u6210\u5404\u79cd\u7ba1\u7406\u64cd\u4f5c\uff0c\u6bd4\u5982\u6dfb\u52a0\u8282\u70b9\uff0c\u53bb\u9664\u8282\u70b9\u3002Admin \u7528\u6237\u6ca1\u6709\u7ba1\u7406\u6743\u9650\uff0c\u662f\u96c6\u7fa4\u4e2d\u7684 Superuser\uff0c\u62e5\u6709\u9664\u96c6\u7fa4\u7ba1\u7406\u76f8\u5173\u4ee5\u5916\u7684\u6240\u6709\u6743\u9650\u3002\u5efa\u8bae\u53ea\u6709\u5728\u9700\u8981\u5bf9\u96c6\u7fa4\u8fdb\u884c\u8fd0\u7ef4\u7ba1\u7406\u8d85\u7ea7\u6743\u9650\u65f6\u624d\u4f7f\u7528 Root \u6743\u9650\u3002\n<\/p><\/blockquote>\n
\u4f7f\u7528doris\u9875\u9762\u8bbf\u95ee<\/h2>\n
\u8bbf\u95eehttp:\/\/ip:8030\/home<\/code>\u5373\u53ef\u8bbf\u95ee\u9875\u9762<\/p>\n
\"image-20241205160448231\"<\/div><\/p>\n
Doris \u9ed8\u8ba4\u7aef\u53e3\u4ecb\u7ecd<\/h2>\n
Doris \u7684\u5404\u4e2a\u5b9e\u4f8b\u901a\u8fc7\u7f51\u7edc\u8fdb\u884c\u901a\u4fe1\uff0c\u5176\u6b63\u5e38\u8fd0\u884c\u9700\u8981\u7f51\u7edc\u73af\u5883\u63d0\u4f9b\u4ee5\u4e0b\u7aef\u53e3\u3002\u7ba1\u7406\u5458\u53ef\u4ee5\u6839\u636e\u5b9e\u9645\u73af\u5883\u81ea\u884c\u8c03\u6574 Doris \u7684\u7aef\u53e3\u914d\u7f6e\uff1a<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u5b9e\u4f8b\u540d\u79f0<\/th>\n\u7aef\u53e3\u540d\u79f0<\/th>\n\u9ed8\u8ba4\u7aef\u53e3<\/th>\n\u901a\u4fe1\u65b9\u5411<\/th>\n\u8bf4\u660e<\/th>\n<\/tr>\n<\/thead>\n
BE<\/td>\nbe_port<\/td>\n9060<\/td>\nFE -> BE<\/td>\nBE \u4e0a Thrift Server \u7684\u7aef\u53e3\uff0c\u7528\u4e8e\u63a5\u6536\u6765\u81ea FE \u7684\u8bf7\u6c42<\/td>\n<\/tr>\n
BE<\/td>\nwebserver_port<\/td>\n8040<\/td>\nBE <-> BE\uff0cClient <-> FE<\/td>\nBE \u4e0a\u7684 HTTP Server \u7aef\u53e3<\/td>\n<\/tr>\n
BE<\/td>\nheartbeat_service_port<\/td>\n9050<\/td>\nFE -> BE<\/td>\nBE \u4e0a\u7684\u5fc3\u8df3\u670d\u52a1\u7aef\u53e3\uff08Thrift\uff09\uff0c\u7528\u4e8e\u63a5\u6536\u6765\u81ea FE \u7684\u5fc3\u8df3<\/td>\n<\/tr>\n
BE<\/td>\nbrpc_port<\/td>\n8060<\/td>\nFE <-> BE\uff0cBE <-> BE<\/td>\nBE \u4e0a\u7684 BRPC \u7aef\u53e3\uff0c\u7528\u4e8e BE \u4e4b\u95f4\u7684\u901a\u4fe1<\/td>\n<\/tr>\n
FE<\/td>\nhttp_port<\/td>\n8030<\/td>\nFE <-> FE\uff0cClient <-> FE<\/td>\nFE \u4e0a\u7684 HTTP Server \u7aef\u53e3<\/td>\n<\/tr>\n
FE<\/td>\nrpc_port<\/td>\n9020<\/td>\nBE -> FE\uff0cFE <-> FE<\/td>\nFE \u4e0a\u7684 Thrift Server \u7aef\u53e3\uff0c\u6bcf\u4e2a FE \u7684\u914d\u7f6e\u9700\u4fdd\u6301\u4e00\u81f4<\/td>\n<\/tr>\n
FE<\/td>\nquery_port<\/td>\n9030<\/td>\nClient <-> FE<\/td>\nFE \u4e0a\u7684 MySQL Server \u7aef\u53e3<\/td>\n<\/tr>\n
FE<\/td>\nedit_log_port<\/td>\n9010<\/td>\nFE <-> FE<\/td>\nFE \u4e0a\u7684 bdbje \u901a\u4fe1\u7aef\u53e3<\/td>\n<\/tr>\n
Broker<\/td>\nbroker_ipc_port<\/td>\n8000<\/td>\nFE -> Broker\uff0cBE -> Broker<\/td>\nBroker \u4e0a\u7684 Thrift Server \u7aef\u53e3\uff0c\u7528\u4e8e\u63a5\u6536\u8bf7\u6c42<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u505c\u6b62 Apache Doris<\/h2>\n
\u505c\u6b62 FE<\/h3>\n
\u5728apache-doris\/fe<\/code> \u4e0b\uff0c\u8fd0\u884c\u4e0b\u9762\u547d\u4ee4\u505c\u6b62 FE\u3002<\/p>\n
 .\/bin\/stop_fe.sh\n<\/code><\/pre>\n
\u505c\u6b62 BE<\/h3>\n
\u5728 apache-doris\/be<\/code>\u4e0b\uff0c\u8fd0\u884c\u4e0b\u9762\u547d\u4ee4\u505c\u6b62 BE\u3002<\/p>\n
.\/bin\/stop_be.sh\n<\/code><\/pre>\n
\u53c2\u8003<\/h2>\n
1.https:\/\/doris.apache.org\/zh-CN\/docs\/gettingStarted\/quick-start<\/code><\/p>\n
2.https:\/\/doris.apache.org\/zh-CN\/docs\/install\/cluster-deployment\/standard-deployment?_highlight=%E7%AB%AF%E5%8F%A3#%E7%AB%AF%E5%8F%A3%E8%A7%84%E5%88%92<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"
Apache doris \u5feb\u901f\u5b89\u88c5\u4f53\u9a8c \u73af\u5883\u51c6\u5907 1.\u9009\u62e9\u4e00\u4e2a x86-64 \u4e0a\u7684\u4e3b\u6d41 Linux \u73af\u5883\uff0c\u63a8\u8350 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[541],"tags":[542],"class_list":["post-3159","post","type-post","status-publish","format-standard","hentry","category-doris","tag-doris"],"_links":{"self":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts\/3159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/comments?post=3159"}],"version-history":[{"count":3,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts\/3159\/revisions"}],"predecessor-version":[{"id":3211,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts\/3159\/revisions\/3211"}],"wp:attachment":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/media?parent=3159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/categories?post=3159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/tags?post=3159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}