Table: linode_node_balancer - Query Linode NodeBalancers using SQL

Linode NodeBalancers distribute incoming traffic across multiple Linode instances to ensure high availability and reliability. They are essential for managing and balancing the load on your Linode instances, allowing you to scale applications and services efficiently.

Table Usage Guide

The linode_node_balancer table provides insights into each NodeBalancer within the Linode platform. As a system administrator or DevOps engineer, you can explore NodeBalancer-specific details through this table, including configurations, tags, and traffic metrics. Utilize it to gather information about each NodeBalancer, such as its current configuration, traffic handling, and region.

Examples

Basic info

Retrieve a list of all NodeBalancers in your Linode account to get an overview of your load balancing resources.

select
  id,
  created,
  updated,
  label,
  hostname
from
  linode_node_balancer;

select
  id,
  created,
  updated,
  label,
  hostname
from
  linode_node_balancer;

NodeBalancers by region

Explore which regions have the most NodeBalancers to better allocate resources and manage load distribution.

select
  region,
  count(*)
from
  linode_node_balancer
group by
  region;

select
  region,
  count(*)
from
  linode_node_balancer
group by
  region;

NodeBalancers created in the last 30 days

List all NodeBalancers that were created in the last 30 days to monitor new infrastructure additions.

select
  label,
  created,
  region
from
  linode_node_balancer
where
  created >= current_date - interval '30 days';

select
  label,
  created,
  region
from
  linode_node_balancer
where
  created >= date('now', '-30 days');

NodeBalancers by transfer usage

Identify NodeBalancers based on their transfer usage to manage bandwidth and optimize costs.

select
  label,
  transfer ->> 'in' as transfer_in,
  transfer ->> 'out' as transfer_out
from
  linode_node_balancer
order by
  (transfer ->> 'in') :: bigint + (transfer ->> 'out') :: bigint desc;

select
  label,
  json_extract(transfer, '$.in') as transfer_in,
  json_extract(transfer, '$.out') as transfer_out
from
  linode_node_balancer
order by
  (json_extract(transfer, '$.in')) + (json_extract(transfer, '$.out')) desc;

Schema for linode_node_balancer

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
client_conn_throttle	bigint		Throttle connections per second (0-20). Set to 0 (zero) to disable throttling.
configurations	jsonb		The NodeBalancer configurations.
created	timestamp with time zone		When the NodeBalancer was created.
euuid	text		An external unique identifier for this account.
hostname	text		The NodeBalancer's hostname, ending with .nodebalancer.linode.com.
id	bigint		The unique ID of this NodeBalancer.
ipv4	inet		The NodeBalancer's public IPv4 address.
ipv6	inet		The NodeBalancer's public IPv6 address.
label	text		The NodeBalancer's label. These must be unique on your Account.
region	text		The Region where this NodeBalancer is located. NodeBalancers only support backends in the same Region.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		An array of tags applied to this object. Tags are for organizational purposes only.
transfer	jsonb		Information about the amount of transfer this NodeBalancer has had so far this month.
updated	timestamp with time zone		When the NodeBalancer was updated.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- linode

You can pass the configuration to the command with the --config argument:

steampipe_export_linode --config '<your_config>' linode_node_balancer