• StarRocks安装


    安装参考:

    https://blog.51cto.com/u_15318160/5063646

    官方文档:

    https://docs.starrocks.com/zh-cn/main/quick_start/Deploy

    其它文档:

    https://blog.csdn.net/ult_me/article/details/121427926

    一、部署 FE 节点

    1、设置 JAVA_HOME 变量

    export JAVA_HOME=/usr/java/jdk1.8.0_311-amd64/

    2、

    创建目录

    
    [root@mysql fe]# pwd
    
    /root/StarRocks-2.2.1/fe
    
    [root@mysql fe]# mkdir -p meta
    

    3、启动 FE 节点

    
    [root@mysql bin]# ./start_fe.sh --daemon
    
    [root@mysql bin]# ps -ef|grep StarRocks
    
    root 11393 1 11 18:13 pts/0 00:00:05 /usr/java/jdk1.8.0_311-amd64//bin/java -Dlog4j2.formatMsgNoLookups=true -Xmx1024m -XX:+UseMembar -XX:SurvivorRatio=8 -XX:MaxTenuringThreshold=7 -XX:+PrintGCDateStamps -XX:+PrintGCDetails -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled -XX:-CMSParallelRemarkEnabled -XX:CMSInitiatingOccupancyFraction=80 -XX:SoftRefLRUPolicyMSPerMB=0 -Xloggc:/root/StarRocks-2.2.1/fe/log/fe.gc.log.20220622-181345 com.starrocks.StarRocksFE
    
    root 11541 12354 0 18:14 pts/0 00:00:00 grep --color=auto StarRocks
    
    [root@mysql bin]#
    

    4、查看启动日志

    
    [root@mysql log]# pwd
    
    /root/StarRocks-2.2.1/fe/log
    
    [root@mysql log]# tail -f fe.log
    
    TStat num of replica missing error: 0 (+0)
    
    TStat num of replica version missing error: 0 (+0)
    
    TStat num of replica unavailable error: 0 (+0)
    
    TStat num of replica redundant error: 0 (+0)
    
    TStat num of replica missing in cluster error: 0 (+0)
    
    TStat num of balance scheduled: 0 (+0)
    
    TStat num of colocate replica mismatch: 0 (+0)
    
    TStat num of colocate replica redundant: 0 (+0)
    
    2022-06-22 18:14:48,494 INFO (tablet scheduler|30) [TabletScheduler.adjustPriorities():382] adjust priority for all tablets. changed: 0, total: 0
    
    2022-06-22 18:14:58,457 INFO (Routine load scheduler|36) [RoutineLoadScheduler.process():76] there are 0 job need schedule
    
    2022-06-22 18:14:58,459 WARN (Routine load task scheduler|37) [RoutineLoadTaskScheduler.process():103] no available be slot to scheduler tasks, wait for 10 seconds to scheduler again, you can set max_routine_load_task_num_per_be bigger in fe.conf, current value is 5
    

    5、登录 FE 节点。

    
    [root@mysql log]# mysql -uroot -P9030 -p -h172.16.1.10     【密码为空】
    
    Enter password:
    
    mysql> show databases;
    
    +--------------------+
    
    | Database |
    
    +--------------------+
    
    | information_schema |
    
    +--------------------+
    
    1 row in set (0.02 sec)
    
    mysql> SHOW PROC '/frontends'\G
    
    *************************** 1. row ***************************
    
    Name: 172.16.1.10_9010_1655892827597
    
    IP: 172.16.1.10
    
    EditLogPort: 9010
    
    HttpPort: 8030
    
    QueryPort: 9030
    
    RpcPort: 9020
    
    Role: FOLLOWER
    
    IsMaster: true
    
    ClusterId: 1837529251
    
    Join: true
    
    Alive: true
    
    ReplayedJournalId: 127
    
    LastHeartbeat: 2022-06-22 18:20:48
    
    IsHelper: true
    
    ErrMsg:
    
    StartTime: 2022-06-22 18:14:00
    
    Version: 2.2.1-147f178
    
    1 row in set (0.09 sec)
    

    二、部署 BE 节点

    创建目录:

    
    [root@mysql be]# mkdir -p storage
    
    [root@mysql be]# pwd
    
    /root/StarRocks-2.2.1/be
    

    添加 BE 节点。

    
    mysql> ALTER SYSTEM ADD BACKEND "172.16.1.10:9050";
    

    启动 BE 节点,进看进程

    
    [root@mysql bin]# ./start_be.sh --daemon
    
    [root@mysql bin]# ps -ef|grep starrocks_be
    
    root 14514 1 1 18:50 pts/4 00:00:00 /root/StarRocks-2.2.1/be/lib/starrocks_be
    
    root 14869 13680 0 18:50 pts/4 00:00:00 grep --color=auto starrocks_be
    
    查看 BE 节点情况
    
    mysql> SHOW PROC '/backends'\G
    
    *************************** 1. row ***************************
    
    BackendId: 10003
    
    Cluster: default_cluster
    
    IP: 172.16.1.10
    
    HeartbeatPort: 9050
    
    BePort: 9060
    
    HttpPort: 8040
    
    BrpcPort: 8060
    
    LastStartTime: 2022-06-22 18:50:09
    
    LastHeartbeat: 2022-06-22 18:50:44
    
    Alive: true
    
    SystemDecommissioned: false
    
    ClusterDecommissioned: false
    
    TabletNum: 10
    
    DataUsedCapacity: .000
    
    AvailCapacity: 11.109 GB
    
    TotalCapacity: 49.090 GB
    
    UsedPct: 77.37 %
    
    MaxDiskUsedPct: 77.37 %
    
    ErrMsg:
    
    Version: 2.2.1-147f178
    
    Status: {"lastSuccessReportTabletsTime":"2022-06-22 18:50:10"}
    
    DataTotalCapacity: 11.109 GB
    
    DataUsedPct: 0.00 %
    
    CpuCores: 2
    
    1 row in set (0.00 sec)
    

    导入测试数据,测试性能:

    https://docs.starrocks.com/zh-cn/main/benchmarking/TPC-H_Benchmark

  • 相关阅读:
    HashMap 使用小结
    linux下的文本处理命令sed&awk&grep
    HashMap和Hashtable的区别 .Properties
    Linux awk简简单单
    linux配置java环境变量(详细)
    linux后台运行程序及恢复
    为什么需要 单例设计模式(Singleton)?
    Linux文本处理命令
    使用Perf4J进行性能分析和监控
    sqlldr的用法总结
  • 原文地址:https://www.cnblogs.com/nanxiang/p/16419730.html
Copyright © 2020-2023  润新知