在Docker中快速体验StarRocks 3.0.0环境
👉 本文共约257个字，系统预计阅读时间或需1分钟。
本页目录 隐藏
环境
1 2 3 4 5 6 7 8 | docker rm -f starrocks300 docker run -itd --name starrocks300 -h starrocks300 \ -p 9031:9030 -p 8031:8030 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/starrocks:3.0.0 \ /usr/sbin/init docker exec -it starrocks300 bash |
启动StarRocks
1 2 3 | /usr/local/starrocks/fe/bin/start_fe.sh --daemon /usr/local/starrocks/be/bin/start_be.sh --daemon /usr/local/starrocks/apache_hdfs_broker/bin/start_broker.sh --daemon |
使用
1 2 3 4 5 6 7 | mysql -h 127.0.0.1 -P9030 -uroot SHOW frontends \G show backends \G show broker; |
web界面：http://192.18.0.14:8030/ 用户名：root 密码为空
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 | [root@starrocks300 /]# mysql -h 127.0.0.1 -P9030 -uroot Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.0 StarRocks version 2.5.3 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [(none)]> SHOW frontends ; +------------------------------+-----------+-------------+----------+-----------+---------+--------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+ | Name | IP | EditLogPort | HttpPort | QueryPort | RpcPort | Role | ClusterId | Join | Alive | ReplayedJournalId | LastHeartbeat | IsHelper | ErrMsg | StartTime | Version | +------------------------------+-----------+-------------+----------+-----------+---------+--------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+ | 127.0.0.1_9010_1680064832570 | 127.0.0.1 | 9010 | 8030 | 9030 | 9020 | LEADER | 1723834094 | true | true | 2536 | 2023-03-29 15:15:47 | true | | 2023-03-29 15:13:57 | 2.5.3-46bf084 | +------------------------------+-----------+-------------+----------+-----------+---------+--------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+ 1 row in set (0.02 sec) MySQL [(none)]> show backends; +-----------+-----------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+ | BackendId | IP | HeartbeatPort | BePort | HttpPort | BrpcPort | LastStartTime | LastHeartbeat | Alive | SystemDecommissioned | ClusterDecommissioned | TabletNum | DataUsedCapacity | AvailCapacity | TotalCapacity | UsedPct | MaxDiskUsedPct | ErrMsg | Version | Status | DataTotalCapacity | DataUsedPct | CpuCores | NumRunningQueries | MemUsedPct | CpuUsedPct | +-----------+-----------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+ | 11001 | 127.0.0.1 | 9050 | 9060 | 8040 | 8060 | 2023-03-29 15:13:57 | 2023-03-29 15:15:52 | true | false | false | 79 | 27.525 KB | 519.123 GB | 1019.104 GB | 49.06 % | 49.06 % | | 2.5.3-46bf084 | {"lastSuccessReportTabletsTime":"2023-03-29 15:14:58"} | 519.123 GB | 0.00 % | 16 | 0 | 0.34 % | 0.0 % | +-----------+-----------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+ 1 row in set (0.01 sec) MySQL [(none)]> show broker; +-------------+-----------+------+-------+---------------------+---------------------+--------+ | Name | IP | Port | Alive | LastStartTime | LastUpdateTime | ErrMsg | +-------------+-----------+------+-------+---------------------+---------------------+--------+ | broker_name | 127.0.0.1 | 8000 | true | 2023-06-14 15:28:20 | 2023-06-14 15:40:31 | | +-------------+-----------+------+-------+---------------------+---------------------+--------+ 1 row in set (0.01 sec) MySQL [(none)]> mysql> show databases; +--------------------+ | Database | +--------------------+ | _statistics_ | | example_db | | information_schema | | lhrdb | | sbtest | +--------------------+ 5 rows in set (0.08 sec) |
您可以运行以下 SQL 确认 StarRocks 是否部署成功。
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
