doris4.0.8单机部署
环境:
OS:ubuntu 26
doris:4.0.8
1.查看机器是否支持avx2
[root@host113 ~]# cat /proc/cpuinfo |grep avx2
没有输出,代表不支持,有输出代表是支持的
1.下载安装介质
https://doris.apache.org/zh-CN/download/
根据实际情况进行下载,我这里下载的是
cd /soft
wget https://apache-doris-releases.oss-accelerate.aliyuncs.com/apache-doris-4.0.8-bin-x64.tar.gz
2.安装java环境
安装部署请参考
https://www.cnblogs.com/hxlasky/p/14775706.html
我这里的java版本如下
root@dify:/soft# java -version
java version "17.0.20.1" 2026-08-18 LTS
Java(TM) SE Runtime Environment (build 17.0.20.1+1-LTS-4)
Java HotSpot(TM) 64-Bit Server VM (build 17.0.20.1+1-LTS-4, mixed mode, sharing)
3.设置系统最大打开文件句柄数
vi /etc/security/limits.conf
* soft nofile 655350
* hard nofile 655350
root soft nofile 655350
root hard nofile 655350
4.关闭交换分区
swapoff -a ##临时关闭
永久删除Swap挂载
vim /etc/fstab
# 注释 swap 行
重启系统
5.关闭防火墙
root@dify:~# ufw disable
Firewall stopped and disabled on system startup
root@dify:~# ufw status
Status: inactive
##################################安装fe#################################
1.解压
每个节点上都要操作
root@dify:/soft# cd /soft
root@dify:/soft# tar -xvf apache-doris-4.0.8-bin-x64.tar.gz
root@dify:/soft# mv apache-doris-4.0.8-bin-x64 /opt/doris
2.创建相应的目录
程序目录和数据目录分离
每个节点上都要操作
mkdir -p /data/doris/fe/doris-meta
mkdir -p /data/doris/fe/log
3.修改fe配置参数
每个节点上都要操作
修改第一个节点的配置
vi /opt/doris/fe/conf/fe.conf
LOG_DIR = /data/doris/fe/log
meta_dir = /data/doris/fe/doris-meta
priority_networks = 192.168.12.0/24 #新增该字段，特别是多网卡服务器上，该参数必须添加
qe_query_timeout_second=3000 ##超时设置，最大只能设置259200秒,即72小时enable_outfile_to_local = true ##支持使用export命令导出数据enable_batch_delete_by_default=true ##启用批量删除
4.启动
[root@host01 ~]#/opt/doris/fe/bin/start_fe.sh --daemon
[root@host01 ~]#/opt/doris/fe/bin/stop_fe.sh ##停止命令
查看是否启动
[root@host01 doris]# jps
16986 DorisFE
17210 Jps
查看相应端口情况
[root@host01 fe]# ss -nlp|grep 9030
[root@host01 fe]# ss -nlp|grep 8030
[root@host01 fe]# ss -nlp|grep 9020
[root@host01 fe]# ss -nlp|grep 9010
端口说明:
http_port = 8030
rpc_port = 9020
query_port = 9030
edit_log_port = 9010
5.mysql客户端登录fe
需要在节点上安装mysql客户端,或是直接解压mysql安装包即可使用
mysql -uroot -P 9030 -h 127.0.0.1 #直接回车，默认没有密码
root@dify:/opt# mysql -uroot -P 9030 -h 127.0.0.
mysql> show frontends\G;
*************************** 1. row ***************************
Name: fe_cb825e83_9536_4ff2_90b0_f61edf00d9a9
Host: 192.168.12.87
EditLogPort: 9010
HttpPort: 8030
QueryPort: 9030
RpcPort: 9020
ArrowFlightSqlPort: 8070
Role: FOLLOWER
IsMaster: true
ClusterId: 550088712
Join: true
Alive: true
ReplayedJournalId: 23
LastStartTime: 2026-11-03 16:26:48
LastHeartbeat: 2026-11-03 16:27:58
IsHelper: true
ErrMsg:
Version: doris-4.0.8-rc02-bc8ea1bac6d
CurrentConnected: Yes
LiveSince: NULL
1 row in set (0.02 sec)
ERROR:
No query specified
##################################部署be############################
1.创建相应的目录
每个节点都有要操作
mkdir -p /data/doris/be/storage
mkdir -p /data/doris/be/log
2.修改be配置文件
在节点1上配置好之后,然后scp到另外的节点
vi /opt/doris/be/conf/be.conf
LOG_DIR="/data/doris/be/log/"
priority_networks = 192.168.12.0/24
storage_root_path = /data/doris/be/storage
3.启动BE
每个节点都需要启动
/opt/doris/be/bin/start_be.sh --daemon
报错误:
[root@host134 conf]# /opt/doris/be/bin/start_be.sh --daemon
Set kernel parameter 'vm.max_map_count' to a value greater than 2000000, example: 'sysctl -w vm.max_map_count=2000000'
解决办法:
echo "vm.max_map_count = 2000000" >> /etc/sysctl.conf
# 加载配置
sysctl -p
4.登录fe添加be
mysql -uroot -P9030 -h 192.168.12.87
SQL>ALTER SYSTEM ADD BACKEND "192.168.12.87:9050";
mysql> SHOW PROC '/backends' \G;
*************************** 1. row ***************************
BackendId: 1793694408180
Host: 192.168.12.87
HeartbeatPort: 9050
BePort: 9060
HttpPort: 8040
BrpcPort: 8060
ArrowFlightSqlPort: 8050
LastStartTime: 2026-11-03 16:43:22
LastHeartbeat: 2026-11-03 16:44:39
Alive: true
SystemDecommissioned: false
TabletNum: 22
DataUsedCapacity: 0.000
TrashUsedCapacity: 0.000
AvailCapacity: 211.117 GB
TotalCapacity: 465.377 GB
UsedPct: 54.64 %
MaxDiskUsedPct: 54.64 %
RemoteUsedCapacity: 0.000
Tag: {"location" : "default"}
ErrMsg:
Version: doris-4.0.8-rc02-bc8ea1bac6d
Status: {"lastSuccessReportTabletsTime":"2026-11-03 16:44:41","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false,"isActive":true,"isShutdown":false,"currentFragmentNum":0,"lastFragmentUpdateTime":1793695401662}
HeartbeatFailureCounter: 0
CpuCores: 24
Memory: 22.64 GB
LiveSince: 2026-11-03 16:44:39
RunningTasks: 0
NodeRole: mix
1 row in set (0.01 sec)
###########################创建数据库和账号##################
1.建库
[root@localhost conf]#mysql -uroot -P9030 -h 192.168.12.87
mysql> create database db_test;
2.创建用户
CREATE USER 'hxl' IDENTIFIED BY 'mysql';
GRANT ALL ON db_test.* TO 'hxl'@'%';
3.修改root账号的密码
mysql> SET PASSWORD FOR 'root' = PASSWORD('mysql');
4.建表
use db_test;
CREATE TABLE tb_hxl (
`id` largeint NOT NULL COMMENT "id",
`name1` varchar(20) NULL,
`name2` varchar(20) NULL,
`name3` varchar(20) NULL,
`name4` varchar(20) NULL,
`name5` varchar(20) NULL,
`name6` varchar(20) NULL,
`name7` varchar(20) NULL,
`name8` varchar(20) NULL,
`name9` varchar(20) NULL,
`name10` varchar(20) NULL,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=OLAP
UNIQUE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);
###########################界面访问fe########################
http://192.168.12.87:8030
浙公网安备 33010602011771号