docker run -d -p 9030:9030 -p 8030:8030 -p 8040:8040 --name ss30 --hostname mgr1 --restart=always -v /data/file:/data/file -v /etc/localtime:/etc/localtime:ro -v /data/starrocks:/data/starrocks:rw --network mgr --ip 172.18.0.30 --privileged=true --link mariadb starrocks/allin1-ubuntu
docker exec -it ss30 /bin/bash
/data/deploy/starrocks/fe/conf/fe.conf
LOG_DIR = ${STARROCKS_HOME}/log
DATE = "$(date +%Y%m%d-%H%M%S)"
JAVA_OPTS="-Dlog4j2.formatMsgNoLookups=true -Xmx8192m -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:${LOG_DIR}/fe.gc.log.$DATE -XX:+PrintConcurrentLocks"
# For jdk 11+, this JAVA_OPTS will be used as default JVM options
JAVA_OPTS_FOR_JDK_11="-Dlog4j2.formatMsgNoLookups=true -Xmx8192m -XX:+UseG1GC -Xlog:gc*:${LOG_DIR}/fe.gc.log.$DATE:time"
##
## the lowercase properties are read by main program.
##
# DEBUG, INFO, WARN, ERROR, FATAL
sys_log_level = INFO
http_port = 8030
rpc_port = 9020
query_port = 9030
edit_log_port = 9010
mysql_service_nio_enabled = true
# Configs to speed up broker load
async_load_task_pool_size=20
# Config to expire dangling tablets more aggresivelly so SRs can reclaim storage space faster.
catalog_trash_expire_second=3600
# For CREATE TABLE AS SELECT that does not specify the bucketing config, create this many
# buckets by default (the default was 10).
default_bucket_num=48
# Enable udf.
enable_udf = true
default_replication_num = 1
meta_dir = /data/starrocks/fe
priority_networks = 172.18.0.30/32/data/deploy/starrocks/be/conf/be.conf
# INFO, WARNING, ERROR, FATAL
sys_log_level = INFO
# ports for admin, web, heartbeat service
be_port = 9060
be_http_port = 8040
heartbeat_service_port = 9050
brpc_port = 8060
# Configs to speed up broker load
flush_thread_num_per_store=8
load_process_max_memory_limit_percent=50
brpc_socket_max_unwritten_bytes=10737418240
# Config to allow streaming load large files
streaming_load_max_mb=204800
priority_networks = 127.0.0.1/32
/data/deploy/starrocks/fe/conf/cn.conf
# INFO, WARNING, ERROR, FATAL
sys_log_level = INFO
# ports for admin, web, heartbeat service
thrift_port = 9060
be_http_port = 8040
heartbeat_service_port = 9050
brpc_port = 8060
-连接 StarRocks
成功部署后,您可以通过 MySQL 客户端连接该 StarRocks 集群。
通过 MySQL 客户端连接任意一个 FE 节点的 query_port(默认为 9030)以连接 StarRocks。StarRocks 内置 root 用户,密码默认为空
mysql -P9030 -h127.0.0.1 -uroot --prompt="StarRocks > "
-查看 FE 节点的状态:
SHOW PROC '/frontends'\G
StarRocks > SHOW PROC '/frontends'\G
*************************** 1. row ***************************
Name: 8962368f9208_9010_1681370634632
IP: 8962368f9208
EditLogPort: 9010
HttpPort: 8030
QueryPort: 9030
RpcPort: 9020
Role: LEADER
ClusterId: 555505802
Join: true
Alive: true
ReplayedJournalId: 99
LastHeartbeat: 2023-04-13 07:28:50
IsHelper: true
ErrMsg:
StartTime: 2023-04-13 07:24:11
Version: BRANCH-3.0-0afb97bbf
1 row in set (0.02 sec)
如果 Alive 字段为 true,则该 FE 节点正常启动并加入集群。
如果字段 Role 为 FOLLOWER,则该 FE 节点有资格被选举为 Leader FE 节点。
如果字段 Role 为 LEADER,则该 FE 节点为 Leader FE 节点。
-SQL 查看 BE 节点的状态:
SHOW PROC '/backends'\G
StarRocks > SHOW PROC '/backends'\G
*************************** 1. row ***************************
BackendId: 10004
IP: 8962368f9208
HeartbeatPort: 9050
BePort: 9060
HttpPort: 8040
BrpcPort: 8060
LastStartTime: 2023-04-13 07:24:25
LastHeartbeat: 2023-04-13 07:29:05
Alive: true
SystemDecommissioned: false
ClusterDecommissioned: false
TabletNum: 30
DataUsedCapacity: 0.000
AvailCapacity: 527.437 GB
TotalCapacity: 1.968 TB
UsedPct: 73.83 %
MaxDiskUsedPct: 73.83 %
ErrMsg:
Version: BRANCH-3.0-0afb97bbf
Status: {"lastSuccessReportTabletsTime":"2023-04-13 07:28:26"}
DataTotalCapacity: 527.437 GB
DataUsedPct: 0.00 %
CpuCores: 16
NumRunningQueries: 0
MemUsedPct: 0.02 %
CpuUsedPct: 0.1 %
1 row in set (0.00 sec)如果 Alive 字段为 true,则该 BE 节点正常启动并加入集群。