servers

Creates, updates, deletes, gets or lists a servers resource.

Overview

Name	servers
Type	Resource
Id	azure.maria_db.servers

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Properties of the server.
sku	object	Billing information related properties of a server.
tags	object	Resource tags.

list_by_resource_group

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Properties of the server.
sku	object	Billing information related properties of a server.
tags	object	Resource tags.

list

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Properties of the server.
sku	object	Billing information related properties of a server.
tags	object	Resource tags.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, serverName		Gets information about a server.
list_by_resource_group	select	subscriptionId, resourceGroupName		List all the servers in a given resource group.
list	select	subscriptionId		List all the servers in a given subscription.
create	insert	subscriptionId, resourceGroupName, serverName, data__properties, data__location		Creates a new server or updates an existing server. The update action will overwrite the existing server.
update	update	subscriptionId, resourceGroupName, serverName		Updates an existing server. The request body can contain one to many of the properties present in the normal server definition.
delete	delete	subscriptionId, resourceGroupName, serverName		Deletes a server.
start	exec	subscriptionId, resourceGroupName, serverName		Starts a stopped server.
stop	exec	subscriptionId, resourceGroupName, serverName		Stops a running server.
restart	exec	subscriptionId, resourceGroupName, serverName		Restarts a server.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
resourceGroupName	string	The name of the resource group. The name is case insensitive.
serverName	string	The name of the server.
subscriptionId	string	The ID of the target subscription.

SELECT examples

get

Gets information about a server.

SELECT
location,
properties,
sku,
tags
FROM azure.maria_db.servers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND serverName = '{{ serverName }}' -- required
;

list_by_resource_group

List all the servers in a given resource group.

SELECT
location,
properties,
sku,
tags
FROM azure.maria_db.servers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
;

list

List all the servers in a given subscription.

SELECT
location,
properties,
sku,
tags
FROM azure.maria_db.servers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

create

Creates a new server or updates an existing server. The update action will overwrite the existing server.

INSERT INTO azure.maria_db.servers (
data__sku,
data__properties,
data__location,
data__tags,
subscriptionId,
resourceGroupName,
serverName
)
SELECT 
'{{ sku }}',
'{{ properties }}' /* required */,
'{{ location }}' /* required */,
'{{ tags }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ serverName }}'
RETURNING
location,
properties,
sku,
tags
;

Manifest

# Description fields are for documentation purposes
- name: servers
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the servers resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the servers resource.
    - name: serverName
      value: string
      description: Required parameter for the servers resource.
    - name: sku
      value: object
      description: |
        Billing information related properties of a server.
    - name: properties
      value: object
      description: |
        Properties of the server.
    - name: location
      value: string
      description: |
        The location the resource resides in.
    - name: tags
      value: object
      description: |
        Application-specific metadata in the form of key-value pairs.

UPDATE examples

update

Updates an existing server. The request body can contain one to many of the properties present in the normal server definition.

UPDATE azure.maria_db.servers
SET 
data__sku = '{{ sku }}',
data__properties = '{{ properties }}',
data__tags = '{{ tags }}'
WHERE 
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND serverName = '{{ serverName }}' --required
RETURNING
location,
properties,
sku,
tags;

DELETE examples

delete

Deletes a server.

DELETE FROM azure.maria_db.servers
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND serverName = '{{ serverName }}' --required
;

Lifecycle Methods

start

Starts a stopped server.

EXEC azure.maria_db.servers.start 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@serverName='{{ serverName }}' --required
;

stop

Stops a running server.

EXEC azure.maria_db.servers.stop 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@serverName='{{ serverName }}' --required
;

restart

Restarts a server.

EXEC azure.maria_db.servers.restart 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@serverName='{{ serverName }}' --required
;