Learn fundamental concepts about Firebolt Engines.
TYPE
, NODES
, and CLUSTERS
attributes that define a Firebolt engine’s configuration and scaling options.information_schema
to optimize resource allocation.SHOW ENGINES
to check the status of all engines, including running, resizing, and stopped states.TYPE
of engine defines the compute node size used as a building block for an engine. They are available in Small, Medium, Large, and X-Large sizes. Change the node type to vertically scale up or down. Small and medium engines are available for use right away. If you want to use a large or extra-large engine, reach out to support@firebolt.io.
Family TYPE
and NODES
attributes. A given Firebolt engine can contain one or more clusters. The maximum number of clusters is specified by the max_clusters attribute. Only homogeneous cluster configurations (clusters with the same number of Nodes and Type) are supported within a single engine. Users can leverage the MIN_CLUSTERS
and MAX_CLUSTERS
attributes to support query concurrency scaling.
Examples:
TYPE
, NODES
, MIN_CLUSTERS
and MAX_CLUSTERS
form the configuration of an engine.
To create an engine, use the CREATE ENGINE command, specifying the node type to be used for the engine, number of clusters and number of nodes per cluster.
The following code example creates two clusters, each containing four nodes of type M
, from the compute-optimized family:
Scaling Type | Action | Example SQL Command |
---|---|---|
Vertical Scaling | Change the node type and family | ALTER ENGINE MyEngine SET TYPE = L FAMILY = SO; |
Horizontal Scaling | Change the number of nodes | ALTER ENGINE MyEngine SET NODES = 3; |
Concurrency Scaling | Change the number of clusters | ALTER ENGINE MyEngine SET MIN_CLUSTERS = 2 MAX_CLUSTERS = 2; |
ALTER ENGINE
to horizontally scale an engine from two to three nodes:
<account-name>.<org-name>.region.firebolt.io
The combined length of account-name
and org-name
must not exceed 62 characters.
information_schema
to track engine performance and usage.
View | Description |
---|---|
engine_metrics_history | Captures CPU and RAM usage every 30 seconds and retains data for 30 days. |
engine_running_queries | Lists active queries and queries waiting to be processed. |
MyEngine
:
MyEngine
:
SHOW ENGINES and UI | Description |
---|---|
STARTING | The engine is provisioning resources, and will be ready to use soon. |
RUNNING | The engine is running queries or available to run queries. The engine can be modified while it is running. |
RESIZING | The engine is currently being resized after an ALTER ENGINE command. The engine will be in this state when the user has issued a request to change the engine TYPE , number of NODES or number of CLUSTERS . |
DRAINING | The engine is completing running queries before shutting down. |
STOPPING | The engine is shutting down and cannot accept new queries. |
STOPPED | The engine is fully stopped and not available to run queries. |