在Docker中快速体验StarRocks 3.0.0环境

环境

1docker rm -f starrocks300
2docker run -itd --name starrocks300 -h starrocks300 \
3  -p 9031:9030 -p 8031:8030  \
4  -v /sys/fs/cgroup:/sys/fs/cgroup \
5  --privileged=true lhrbest/starrocks:3.0.0 \
6  /usr/sbin/init
7
8docker exec -it starrocks300 bash

启动StarRocks

1/usr/local/starrocks/fe/bin/start_fe.sh --daemon
2/usr/local/starrocks/be/bin/start_be.sh --daemon
3/usr/local/starrocks/apache_hdfs_broker/bin/start_broker.sh --daemon

使用

1mysql -h 127.0.0.1 -P9030 -uroot
2
3SHOW frontends \G
4
5show  backends \G
6
7show broker;

web界面：http://192.18.0.14:8030/  用户名：root  密码为空

 1[root@starrocks300 /]# mysql -h 127.0.0.1 -P9030 -uroot
 2Welcome to the MariaDB monitor.  Commands end with ; or \g.
 3Your MySQL connection id is 1
 4Server version: 5.1.0 StarRocks version 2.5.3
 5
 6Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
 7
 8Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 9
10MySQL [(none)]> SHOW frontends ;
11+------------------------------+-----------+-------------+----------+-----------+---------+--------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+
12| Name                         | IP        | EditLogPort | HttpPort | QueryPort | RpcPort | Role   | ClusterId  | Join | Alive | ReplayedJournalId | LastHeartbeat       | IsHelper | ErrMsg | StartTime           | Version       |
13+------------------------------+-----------+-------------+----------+-----------+---------+--------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+
14| 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 |
15+------------------------------+-----------+-------------+----------+-----------+---------+--------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+
161 row in set (0.02 sec)
17
18MySQL [(none)]> show  backends;
19+-----------+-----------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+
20| 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 |
21+-----------+-----------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+
22| 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 %      |
23+-----------+-----------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+
241 row in set (0.01 sec)
25
26MySQL [(none)]> show broker;
27+-------------+-----------+------+-------+---------------------+---------------------+--------+
28| Name        | IP        | Port | Alive | LastStartTime       | LastUpdateTime      | ErrMsg |
29+-------------+-----------+------+-------+---------------------+---------------------+--------+
30| broker_name | 127.0.0.1 | 8000 | true  | 2023-06-14 15:28:20 | 2023-06-14 15:40:31 |        |
31+-------------+-----------+------+-------+---------------------+---------------------+--------+
321 row in set (0.01 sec)
33
34MySQL [(none)]> 
35mysql> show databases;
36+--------------------+
37| Database           |
38+--------------------+
39| _statistics_       |
40| example_db         |
41| information_schema |
42| lhrdb              |
43| sbtest             |
44+--------------------+
455 rows in set (0.08 sec)

您可以运行以下 SQL 确认 StarRocks 是否部署成功。

 1CREATE DATABASE db1;
 2
 3USE db1;
 4
 5CREATE TABLE `sr_on_mac` (
 6 `c0` int(11) NULL COMMENT "",
 7 `c1` date NULL COMMENT "",
 8 `c2` datetime NULL COMMENT "",
 9 `c3` varchar(65533) NULL COMMENT ""
10) ENGINE=OLAP 
11DUPLICATE KEY(`c0`)
12PARTITION BY RANGE (c1) (
13  START ("2022-02-01") END ("2022-02-10") EVERY (INTERVAL 1 DAY)
14)
15DISTRIBUTED BY HASH(`c0`) BUCKETS 1 
16PROPERTIES (
17"replication_num" = "1",
18"in_memory" = "false",
19"storage_format" = "DEFAULT"
20);
21
22
23insert into sr_on_mac values (1, '2022-02-01', '2022-02-01 10:47:57', '111');
24insert into sr_on_mac values (2, '2022-02-02', '2022-02-02 10:47:57', '222');
25insert into sr_on_mac values (3, '2022-02-03', '2022-02-03 10:47:57', '333');
26
27
28select * from sr_on_mac where c1 >= '2022-02-02';

如果无错误返回，则表明您已成功在 Docker 环境中部署 StarRocks。

1mysql> select * from sr_on_mac where c1 >= '2022-02-02';
2+------+------------+---------------------+------+
3| c0   | c1         | c2                  | c3   |
4+------+------------+---------------------+------+
5|    3 | 2022-02-03 | 2022-02-03 10:47:57 | 333  |
6|    2 | 2022-02-02 | 2022-02-02 10:47:57 | 222  |
7+------+------------+---------------------+------+
82 rows in set (0.16 sec)