doris2.0.7 安装

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__ ;