SSIS Components for DigitalOcean

Build 20.0.7587

LoadBalancers

Retrieve Load Balancers in DigitalOcean.

View Specific Information

Select

Digital Ocean supports only Id column with "=" operator as filter criteria for this view.

SELECT * FROM Loadbalancers WHERE Id='ae120e99-bb8a-4879-a6cd-10612ba7ae82'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type References Description
Id [KEY] String A unique ID that can be used to identify and reference a Load Balancer.
Name String A human-readable name for a Load Balancer instance.
Ip String An attribute containing the public-facing IP address of the Load Balancer.
Algorithm String The load balancing algorithm used to determine which backend Droplet will be selected by a client. It must be either 'round_robin' or 'least_connections'.
Status String A status string indicating the current state of the Load Balancer. This can be 'new', 'active', or 'errored'.
RegionSlug String

Regions.Slug

The region slug where the Load Balancer instance is located.
CreatedAt Datetime The date and time value that represents when the Load Balancer was created.
HealthCheckProtocol String The protocol used for health checks sent to the backend Droplets. The possible values are 'http' or 'tcp'.
HealthCheckPort Integer An integer representing the port on the backend Droplets on which the health check will attempt a connection.
HealthCheckPath String The path on the backend Droplets to which the Load Balancer instance will send a request.
HealthCheckIntervalSeconds Integer The number of seconds between two consecutive health checks.
HealthCheckResponseTimeoutSeconds Integer The number of seconds between two consecutive health checks.
HealthCheckUnhealthyThreshold Integer The number of times a health check must fail for a backend Droplet to be marked 'unhealthy' and be removed from the pool.
HealthCheckHealthyThreshold Integer The number of times a health check must pass for a backend Droplet to be marked 'healthy' and be re-added to the pool.
StickySessionsType String An attribute indicating how and if requests from a client will be persistently served by the same backend Droplet. The possible values are 'cookies' or 'none'.
StickySessionsCookieName String The name of the cookie sent to the client. This attribute is only returned when using 'cookies' for the sticky session's type.
StickySessionsCookieTtlSeconds String The number of seconds until the cookie set by the Load Balancer expires. This attribute is only returned when using 'cookies' for the sticky session's type.
Tag String The name of a Droplet tag corresponding to Droplets assigned to the Load Balancer.
DropletIds String An array containing the IDs of the Droplets assigned to the Load Balancer.
RedirectHttpToHttps Boolean A boolean value indicating whether HTTP requests to the Load Balancer on port 80 will be redirected to HTTPS on port 443.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587