DatabaseDeploymentDetails

The details of a database deployment asset.

JSON representation 
{
  "generatedId": string,
  "manualUniqueId": string,
  "version": string,
  "edition": string,
  "topology": {
    object (DatabaseDeploymentTopology)
  },
  "aggregatedStats": {
    object (AggregatedStats)
  },

  // Union field engine_details can be only one of the following:
  "sqlServer": {
    object (SqlServerDatabaseDeployment)
  },
  "mysql": {
    object (MysqlDatabaseDeployment)
  },
  "postgresql": {
    object (PostgreSqlDatabaseDeployment)
  }
  // End of list of possible types for union field engine_details.
}
Fields
generatedId

string

The database deployment generated ID.
manualUniqueId

string

A manual unique ID set by the user.
version

string

The database deployment version.
edition

string

The database deployment edition.
topology

object (DatabaseDeploymentTopology)

Details of the database deployment topology.
aggregatedStats

object (AggregatedStats)

Output only. Aggregated stats for the database deployment.
Union field engine_details. Engine-specific details. engine_details can be only one of the following:
sqlServer

object (SqlServerDatabaseDeployment)

Details of a Microsoft SQL Server database deployment.
mysql

object (MysqlDatabaseDeployment)

Details of a MYSQL database deployment.
postgresql

object (PostgreSqlDatabaseDeployment)

Details of a PostgreSQL database deployment.

DatabaseDeploymentTopology

Details of database deployment's topology.

JSON representation 
{
  "coreCount": integer,
  "memoryBytes": string,
  "diskAllocatedBytes": string,
  "diskUsedBytes": string,
  "coreLimit": integer,
  "memoryLimitBytes": string,
  "instances": [
    {
      object (DatabaseInstance)
    }
  ]
}
Fields
coreCount

integer

Optional. Number of total cores.
memoryBytes

string (int64 format)

Optional. Total memory in bytes.
diskAllocatedBytes

string (int64 format)

Optional. Disk allocated in bytes.
diskUsedBytes

string (int64 format)

Optional. Disk used in bytes.
coreLimit

integer

Optional. Number of total cores limited by db deployment.
memoryLimitBytes

string (int64 format)

Optional. Total memory in bytes limited by db deployment.
instances[]

object (DatabaseInstance)

Optional. List of database instances.

DatabaseInstance

Details of a database instance.

JSON representation 
{
  "hosts": [
    {
      object (DatabaseInstanceHost)
    }
  ],
  "instanceName": string,
  "role": enum (Role)
}
Fields
hosts[]

object (DatabaseInstanceHost)

Optional. The instance's hosts.
instanceName

string

The instance's name.
role

enum (Role)

The instance role in the database engine.

DatabaseInstanceHost

Details of a host of a database instance.

JSON representation 
{
  "hostName": string
}
Fields
hostName

string

Optional. The host name of the host.

Role

Database instance roles.

Enums
ROLE_UNSPECIFIED Unspecified.
PRIMARY Primary.
SECONDARY Secondary.
ARBITER Arbiter.

SqlServerDatabaseDeployment

Specific details for a Microsoft SQL Server database deployment.

JSON representation 
{
  "features": [
    {
      object (SqlServerFeature)
    }
  ],
  "serverFlags": [
    {
      object (SqlServerServerFlag)
    }
  ],
  "traceFlags": [
    {
      object (SqlServerTraceFlag)
    }
  ]
}
Fields
features[]

object (SqlServerFeature)

Optional. List of SQL Server features.
serverFlags[]

object (SqlServerServerFlag)

Optional. List of SQL Server server flags.
traceFlags[]

object (SqlServerTraceFlag)

Optional. List of SQL Server trace flags.

SqlServerFeature

SQL Server feature details.

JSON representation 
{
  "featureName": string,
  "enabled": boolean
}
Fields
featureName

string

Required. The feature name.
enabled

boolean

Required. Field enabled is set when a feature is used on the source deployment.

SqlServerServerFlag

SQL Server server flag details.

JSON representation 
{
  "serverFlagName": string,
  "value": string,
  "valueInUse": string
}
Fields
serverFlagName

string

Required. The server flag name.
value

string

Required. The server flag value set by the user.
valueInUse

string

Required. The server flag actual value. If valueInUse is different from value it means that either the configuration change was not applied or it is an expected behavior. See SQL Server documentation for more details.

SqlServerTraceFlag

SQL Server trace flag details.

JSON representation 
{
  "traceFlagName": string,
  "scope": enum (Scope)
}
Fields
traceFlagName

string

Required. The trace flag name.
scope

enum (Scope)

Required. The trace flag scope.

Scope

The trace flag scope.

Enums
SCOPE_UNSPECIFIED Unspecified.
OFF Off.
GLOBAL Global.
SESSION Session.

MysqlDatabaseDeployment

Specific details for a Mysql database deployment.

JSON representation 
{
  "properties": [
    {
      object (MysqlProperty)
    }
  ],
  "plugins": [
    {
      object (MysqlPlugin)
    }
  ]
}
Fields
properties[]

object (MysqlProperty)

Optional. List of Mysql properties.
plugins[]

object (MysqlPlugin)

Optional. List of Mysql plugins.

MysqlProperty

Mysql property.

JSON representation 
{
  "property": string,

  // Union field value can be only one of the following:
  "enabled": boolean,
  "numericValue": string
  // End of list of possible types for union field value.
}
Fields
property

string

Required. The property name.

Union field value.

value can be only one of the following:
enabled

boolean

Required. The property is enabled.
numericValue

string (int64 format)

Required. The property numeric value.

MysqlPlugin

Mysql plugin.

JSON representation 
{
  "plugin": string,
  "version": string,
  "enabled": boolean
}
Fields
plugin

string

Required. The plugin name.
version

string

Required. The plugin version.
enabled

boolean

Required. The plugin is active.

PostgreSqlDatabaseDeployment

Specific details for a PostgreSQL database deployment.

JSON representation 
{
  "properties": [
    {
      object (PostgreSqlProperty)
    }
  ],
  "postgresqlExtensions": [
    {
      object (PostgreSqlExtension)
    }
  ]
}
Fields
properties[]

object (PostgreSqlProperty)

Optional. List of PostgreSql properties.
postgresqlExtensions[]

object (PostgreSqlExtension)

Optional. List of PostgreSql extensions.

PostgreSqlProperty

PostgreSql property.

JSON representation 
{
  "property": string,

  // Union field value can be only one of the following:
  "enabled": boolean,
  "numericValue": string
  // End of list of possible types for union field value.
}
Fields
property

string

Required. The property name.

Union field value.

value can be only one of the following:
enabled

boolean

Required. The property is enabled.
numericValue

string (int64 format)

Required. The property numeric value.

PostgreSqlExtension

PostgreSql extension.

JSON representation 
{
  "extension": string,
  "version": string
}
Fields
extension

string

Required. The extension name.
version

string

Required. The extension version.

AggregatedStats

Aggregated stats for the database deployment.

JSON representation 
{
  "databaseCount": integer
}
Fields
databaseCount

integer

Output only. The number of databases in the deployment.