​
Roles

A user must be assigned the admin application role to execute any of the examples described on this page.

​
Manage Services

The Winning Variant services can be managed by an admin using the following stored procedures:

ProcedureDescription
management.suspend_services()Suspends all services.
management.resume_services()Resumes all services.
management.get_service_status()Gets the status of all services.
management.get_service_endpoints()Shows ingress URLs for all services.

Examples

USE <application_name>;

-- Suspend all services
CALL management.suspend_services();

-- Check status of services
CALL management.get_service_status();

​
Configuration Properties

While certain components of the app are configurable directly (i.e., scaling a compute pool), other components may be configured indirectly.

​
Properties

PropertyDescription
VARIANTAPI:CONFIG_REFRESH_SECONDSHow often (in seconds) to refresh the configuration in the Variant API. This includes picking up new/updated experiment configuration. The Variant API must be restarted for this to take effect.

​
Set configuration property

To set a property, execute the following procedure:

CALL management.set_config_property('<property>', '<value>')

Example

-- Set the Variant API to refresh configuration every 5 minutes
CALL management.set_config_property('VARIANTAPI:CONFIG_REFRESH_SECONDS', '300')

All values are stored as strings. So even a number, such as 100 should be stored as '100'.

​
Get configuration properties

To see the current configuration properties, perform a SELECT from management.config_properties.

Example

-- See all configuration properties
SELECT * FROM management.config_properties;