Minn Fong
07/22/2026, 6:14 PMRocky
07/22/2026, 6:15 PM--helper flag.
1. Register the nodes (Run on Leader FE)
Connect to your Leader FE node (typically via port 9030) using a MySQL client and run the following commands. Replace <ip> with the AWS IP of the new node and 9010 with your configured edit_log_port (9010 is the default).
* To add a Follower:
sql
ALTER SYSTEM ADD FOLLOWER "<follower_ip>:9010";
* To add an Observer:
sql
ALTER SYSTEM ADD OBSERVER "<observer_ip>:9010";
2. Start the FE nodes (Run on the New Nodes)
On each of the new FE instances, you must start the process by pointing it to the existing Leader FE to synchronize metadata. This --helper flag is only required the first time you start the node.
bash
# Run this on the new node's terminal
./fe/bin/start_fe.sh --helper <leader_ip>:9010 --daemon
3. Verify the Status
After starting the nodes, you can check if they have successfully joined the cluster by running this SQL command on the Leader:
sql
SHOW PROC '/frontends'\G
Look for the Alive column (should be true) and the Role column (should match FOLLOWER or OBSERVER).
Important Notes:
* Security Groups: Ensure that the AWS Security Groups allow traffic between all FE nodes on the following ports: 9010 (Edit Log), 9020 (RPC), 9030 (Query), and 8030 (HTTP).
* Priority Networks: If your AWS instances have multiple network interfaces, ensure priority_networks is configured in fe.conf to match the CIDR of your AWS IPs.
* Quorum: For high availability, it is recommended to have exactly 3 Followers (1 Leader + 2 Followers). Observers do not participate in voting and do not affect the quorum.
References
• deployment/deploy_manually.md
• sql-reference/sql-statements/cluster-management/nodes_processes/ALTER_SYSTEM.md
• faq/operation_maintenance_faq.md
• administration/Meta_recovery.mdMinn Fong
07/22/2026, 6:16 PMRocky
07/22/2026, 6:16 PMLOAD jobs or CREATE TABLE).
3. When does FE become the bottleneck?
You will notice FE limitations in these specific scenarios:
* High QPS (Queries Per Second): If you are running thousands of small, sub-second queries per second, the FE's planning overhead becomes the primary bottleneck.
* Extremely Complex SQL: Queries with hundreds of joins or massive IN clauses can take hundreds of milliseconds just to plan before a single byte is read from the BE.
* External Catalogs: If you are querying large Hive/Iceberg tables, the FE spends significant time fetching partition metadata from the external metastore.
Summary
* Scale BEs when your queries are slow due to data volume or complex compute.
* Scale FEs (Followers) to ensure the cluster doesn't go offline if a node fails.
* Scale FEs (Observers) when you have hundreds of concurrent users or high QPS and want to offload the planning/connection overhead from the Leader.
References
• deployment/plan_cluster.md
• introduction/Architecture.md
• administration/management/resource_management/Load_balance.md
• knowledge/trouble_shooting/fe_deadlock_problems.md
References
• knowledge/trouble_shooting/fe_deadlock_problems.md