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