1,查看操作系统
lsb_release -a
#Distributor ID: Ubuntu
#Description: Ubuntu 22.04.3 LTS
#Release: 22.04
#Codename: jammy
2,安装zip,mysql-client
apt install mysql-client
apt install zip
3,安装jdk
apt install openjdk-8-jdk -y
java -version
#openjdk version "1.8.0_402"
#OpenJDK Runtime Environment (build 1.8.0_402-8u402-ga-2ubuntu1~22.04-b06)
#OpenJDK 64-Bit Server VM (build 25.402-b06, mixed mode)
4,设置JAVA_HOME
vi /etc/profile
export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
export PATH=$PATH:$JAVA_HOME/bin
source /etc/profile
5,关闭swap
swapoff -a
在 /etc/fstab中注释掉swap挂载
6,设置系统最大打开文件句柄数
vi /etc/security/limits.conf
* soft nofile 65536
* hard nofile 65536
注意:设置后root用户不受影响,创建的Doris用户的ulimit -n 变成65536,如果想让root生效,需要把*替换为root
7,设置时间同步
vi /etc/systemd/timesyncd.conf
修改
NTP=ntp.tencent.com
FallbackNTP=ntp1.tencent.com,ntp2.tencent.com,ntp3.tencent.com
service systemd-timesyncd restart
systemctl status systemd-timesyncd.service
查看同步状态
timedatectl
#Local time: Tue 2024-04-09 16:59:05 CST
#Universal time: Tue 2024-04-09 08:59:05 UTC
#RTC time: Tue 2024-04-09 08:59:05
#Time zone: Asia/Shanghai (CST, +0800)
#System clock synchronized: yes
#NTP service: active
#RTC in local TZ: no
8,设置域名
如果是数据中心,需要找管理员配置
9,创建doris用户
adduser doris
10,下载doris
cd /home/doris/opt
wget https://apache-doris-releases.oss-accelerate.aliyuncs.com/apache-doris-2.0.7-bin-x64.tar.gz
tar -zxvf apache-doris-2.0.7-bin-x64.tar.gz
ln -s /home/doris/opt/apache-doris-2.0.7-bin-x64 /home/doris/opt/doris
11,创建元数据目录和数据目录
mkdir -p /data/doris-meta
mkdir -p /data/doris-data
chown -R doris:doris /data
12,配置FE和BE
FE配置
priority_networks=192.168.1.0/24
meta_dir= /data/doris-meta
lower_case_table_names=1 // 这个确保表名大小写不敏感,这个在集群第一次启动的时候生效,之后无法修改
BE配置
priority_networks=192.168.1.0/24
storage_root_path=/data/doris-data
13,启动FE,BE
sysctl -w vm.max_map_count=2000000
/home/doris/opt/doris/be/bin/start_be.sh --daemon
/home/doris/opt/doris/be/bin/stop_be.sh
/home/doris/opt/doris/fe/bin/start_fe.sh --daemon
/home/doris/opt/doris/fe/bin/stop_fe.sh
/home/doris/opt/doris/fe/bin/start_fe.sh --helper 192.168.1.109:9010 --daemon
14,查看lower_case_table_names是否生效
SHOW VARIABLES;
SHOW VARIABLES LIKE '%lower_case_table_names%';
15,组成集群
mysql -h 192.168.1.108 -P9030 -uroot -p
ALTER SYSTEM ADD BACKEND "192.168.1.106:9050";
ALTER SYSTEM ADD BACKEND "192.168.1.107:9050";
ALTER SYSTEM ADD BACKEND "192.168.1.108:9050";
ALTER SYSTEM ADD OBSERVER "192.168.1.108:9010";
16,修改密码
mysql -h 192.168.1.108 -P9030 -uroot -p
SET PASSWORD FOR 'root' = PASSWORD('xxxxxx');
17,安装审计日志plugin
INSTALL PLUGIN FROM "/home/doris/opt/doris/extensions/audit_loader/auditloader.zip";
UNINSTALL PLUGIN AuditLoader;
审计日志
select * from doris_audit_db__.doris_audit_log_tbl__ ;
select * from doris_audit_db__.doris_auDit_log_tbL__ ;
select Time,User,stmT, client_ip from doris_audit_db__.doris_auDit_log_tbL__ order by time desc ;
慢查询日志
select * from doris_audit_db__.doris_slow_log_tbl__ ;