doris-standalone

[dyrnq]

mysql -uroot -P9030 -h127.0.0.1 -e "ALTER SYSTEM ADD BACKEND '127.0.0.1:9050'"

[dyrnq]

root@standalone:/opt/apache-doris# mysql -uroot -P9030 -h127.0.0.1 -e "show frontends;show backends;"
+-----------------------------------------+------------+-------------+----------+-----------+---------+--------------------+----------+----------+-----------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
| Name                                    | Host       | EditLogPort | HttpPort | QueryPort | RpcPort | ArrowFlightSqlPort | Role     | IsMaster | ClusterId | Join | Alive | ReplayedJournalId | LastStartTime       | LastHeartbeat       | IsHelper | ErrMsg | Version                     | CurrentConnected |
+-----------------------------------------+------------+-------------+----------+-----------+---------+--------------------+----------+----------+-----------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
| fe_223fe569_da82_4e57_8e05_bc203d1f05a7 | standalone | 9010        | 8030     | 9030      | 9020    | 10030              | FOLLOWER | true     | 290094702 | true | true  | 115               | 2024-11-15 06:50:58 | 2024-11-15 06:58:58 | true     |        | doris-2.1.7-rc03-443e87e203 | Yes              |
+-----------------------------------------+------------+-------------+----------+-----------+---------+--------------------+----------+----------+-----------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
+-----------+------------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+
| BackendId | Host       | HeartbeatPort | BePort | HttpPort | BrpcPort | ArrowFlightSqlPort | LastStartTime       | LastHeartbeat       | Alive | SystemDecommissioned | TabletNum | DataUsedCapacity | TrashUsedCapacity | AvailCapacity | TotalCapacity | UsedPct | MaxDiskUsedPct | RemoteUsedCapacity | Tag                      | ErrMsg | Version                     | Status                                                                                                                        | HeartbeatFailureCounter | NodeRole |
+-----------+------------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+
| 10002     | standalone | 9050          | 9060   | 8040     | 8060     | 10040              | 2024-11-15 06:51:04 | 2024-11-15 06:58:58 | true  | false                | 22        | 0.000            | 0.000             | 288.916 GB    | 548.951 GB    | 47.37 % | 47.37 %        | 0.000              | {"location" : "default"} |        | doris-2.1.7-rc03-443e87e203 | {"lastSuccessReportTabletsTime":"2024-11-15 06:58:30","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false} | 0                       | mix      |
+-----------+------------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+

[dyrnq]

root@standalone:/opt/apache-doris# hostname
standalone
root@standalone:/opt/apache-doris# cat /etc/hosts 
127.0.0.1       localhost
::1     localhost ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
172.17.0.5      standalone

[dyrnq]

docker exec -it fe-01 bash -c "mysql -uroot -P9030 -hfe-01 -e \"show frontends;\""
+-----------------------------------------+-------+-------------+----------+-----------+---------+--------------------+----------+----------+------------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
| Name                                    | Host  | EditLogPort | HttpPort | QueryPort | RpcPort | ArrowFlightSqlPort | Role     | IsMaster | ClusterId  | Join | Alive | ReplayedJournalId | LastStartTime       | LastHeartbeat       | IsHelper | ErrMsg | Version                     | CurrentConnected |
+-----------------------------------------+-------+-------------+----------+-----------+---------+--------------------+----------+----------+------------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
| fe_978e35b9_c16c_471b_b04f_b25e4ded51d8 | fe-02 | 9010        | 8030     | 9030      | 9020    | 10030              | FOLLOWER | false    | 1940727622 | true | true  | 263               | 2024-11-15 16:08:40 | 2024-11-15 16:21:09 | true     |        | doris-2.1.7-rc03-443e87e203 | No               |
| fe_462a4bdd_f094_48b5_81ea_1ebadec23d9e | fe-01 | 9010        | 8030     | 9030      | 9020    | 10030              | FOLLOWER | true     | 1940727622 | true | true  | 265               | 2024-11-15 15:59:58 | 2024-11-15 16:21:09 | true     |        | doris-2.1.7-rc03-443e87e203 | Yes              |
| fe_cb68f485_ce02_4d8a_a7d8_a105fdbc96e5 | fe-03 | 9010        | 8030     | 9030      | 9020    | 10030              | FOLLOWER | false    | 1940727622 | true | true  | 263               | 2024-11-15 16:08:40 | 2024-11-15 16:21:09 | true     |        | doris-2.1.7-rc03-443e87e203 | No               |
+-----------------------------------------+-------+-------------+----------+-----------+---------+--------------------+----------+----------+------------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+

[dyrnq]

docker exec -it fe-01 bash -c "mysql -uroot -P9030 -h127.0.0.1 -e 'show frontends;show backends;' "
+-----------------------------------------+-------+-------------+----------+-----------+---------+--------------------+----------+----------+------------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
| Name                                    | Host  | EditLogPort | HttpPort | QueryPort | RpcPort | ArrowFlightSqlPort | Role     | IsMaster | ClusterId  | Join | Alive | ReplayedJournalId | LastStartTime       | LastHeartbeat       | IsHelper | ErrMsg | Version                     | CurrentConnected |
+-----------------------------------------+-------+-------------+----------+-----------+---------+--------------------+----------+----------+------------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
| fe_8171c8ea_4815_409f_9d32_7ba9a8f2e614 | fe-01 | 9010        | 8030     | 9030      | 9020    | 10030              | FOLLOWER | true     | 1692375324 | true | true  | 95                | 2024-11-15 20:01:41 | 2024-11-15 20:03:22 | true     |        | doris-2.1.7-rc03-443e87e203 | Yes              |
| fe_a9cb6d65_911e_46fc_b3bf_e19a361ea9f1 | fe-02 | 9010        | 8030     | 9030      | 9020    | 10030              | FOLLOWER | false    | 1692375324 | true | true  | 93                | 2024-11-15 20:01:48 | 2024-11-15 20:03:22 | true     |        | doris-2.1.7-rc03-443e87e203 | No               |
| fe_b9dc260d_6629_423f_aee1_59d7222ac025 | fe-03 | 9010        | 8030     | 9030      | 9020    | 10030              | FOLLOWER | false    | 1692375324 | true | true  | 93                | 2024-11-15 20:01:49 | 2024-11-15 20:03:22 | true     |        | doris-2.1.7-rc03-443e87e203 | No               |
+-----------------------------------------+-------+-------------+----------+-----------+---------+--------------------+----------+----------+------------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
+-----------+-------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+
| BackendId | Host  | HeartbeatPort | BePort | HttpPort | BrpcPort | ArrowFlightSqlPort | LastStartTime       | LastHeartbeat       | Alive | SystemDecommissioned | TabletNum | DataUsedCapacity | TrashUsedCapacity | AvailCapacity | TotalCapacity | UsedPct | MaxDiskUsedPct | RemoteUsedCapacity | Tag                      | ErrMsg | Version                     | Status                                                                                                                        | HeartbeatFailureCounter | NodeRole |
+-----------+-------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+
| 10002     | be-02 | 9050          | 9060   | 8040     | 8060     | 10040              | 2024-11-15 20:02:02 | 2024-11-15 20:03:22 | true  | false                | 22        | 0.000            | 0.000             | 1.459 TB      | 2.882 TB      | 49.39 % | 49.39 %        | 0.000              | {"location" : "default"} |        | doris-2.1.7-rc03-443e87e203 | {"lastSuccessReportTabletsTime":"2024-11-15 20:03:16","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false} | 0                       | mix      |
| 10003     | be-01 | 9050          | 9060   | 8040     | 8060     | 10040              | 2024-11-15 20:02:02 | 2024-11-15 20:03:22 | true  | false                | 22        | 0.000            | 0.000             | 1.459 TB      | 2.882 TB      | 49.39 % | 49.39 %        | 0.000              | {"location" : "default"} |        | doris-2.1.7-rc03-443e87e203 | {"lastSuccessReportTabletsTime":"2024-11-15 20:03:16","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false} | 0                       | mix      |
| 10040     | be-03 | 9050          | 9060   | 8040     | 8060     | 10040              | 2024-11-15 20:02:11 | 2024-11-15 20:03:22 | true  | false                | 22        | 0.000            | 0.000             | 1.459 TB      | 2.882 TB      | 49.39 % | 49.39 %        | 0.000              | {"location" : "default"} |        | doris-2.1.7-rc03-443e87e203 | {"lastSuccessReportTabletsTime":"2024-11-15 20:03:16","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false} | 0                       | mix      |
+-----------+-------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+