Display information for a single, accessible Managed MySQL Database.
643 matches
100 actions
Linode
100 actions
- Account Settings ViewGETv1.0.0
- Account ViewGETv1.0.0
- Backup ViewGETv1.0.0
- Backups ListGETv1.0.0
- Configuration Profile ViewGETv1.0.0
- Configuration Profiles ListGETv1.0.0
- Disk ViewGETv1.0.0
- Disks ListGETv1.0.0
- Domain CreatePOSTv1.0.0
- Domain Record CreatePOSTv1.0.0
- Domain Record ViewGETv1.0.0
- Domain Records ListGETv1.0.0
- Domain ViewGETv1.0.0
- Domain Zone File ViewGETv1.0.0
- Domains ListGETv1.0.0
- Entity Transfer ViewGETv1.0.0
- Entity Transfers ListGETv1.0.0
- Event ViewGETv1.0.0
- Events ListGETv1.0.0
- Firewall Device ViewGETv1.0.0
- Firewall Devices ListGETv1.0.0
- Firewall Rules ListGETv1.0.0
- Firewall ViewGETv1.0.0
- Firewalls ListGETv1.0.0
- Firewalls ListGETv1.0.0
- Image ViewGETv1.0.0
- Images ListGETv1.0.0
- Invoice Items ListGETv1.0.0
- Invoice ViewGETv1.0.0
- Invoices ListGETv1.0.0
- IP Address ViewGETv1.0.0
- IP Address ViewGETv1.0.0
- IP Addresses ListGETv1.0.0
- IPv6 Pools ListGETv1.0.0
- IPv6 Range ViewGETv1.0.0
- IPv6 Ranges ListGETv1.0.0
- Kernel ViewGETv1.0.0
- Kernels ListGETv1.0.0
- Kubeconfig ViewGETv1.0.0
- Kubernetes API Endpoints ListGETv1.0.0
- Kubernetes Cluster Dashboard URL ViewGETv1.0.0
- Kubernetes Cluster ViewGETv1.0.0
- Kubernetes Clusters ListGETv1.0.0
- Linode NodeBalancers ViewGETv1.0.0
- Linode Statistics ViewGETv1.0.0
- Linode ViewGETv1.0.0
- Linode's Managed Settings ViewGETv1.0.0
- Linode's Volumes ListGETv1.0.0
- Linodes ListGETv1.0.0
- Login ViewGETv1.0.0
- Longview Client ViewGETv1.0.0
- Longview Clients ListGETv1.0.0
- Longview Plan ViewGETv1.0.0
- Longview Subscription ViewGETv1.0.0
- Longview Subscriptions ListGETv1.0.0
- Maintenance ListGETv1.0.0
- Managed Contact ViewGETv1.0.0
- Managed Contacts ListGETv1.0.0
- Managed Credential ViewGETv1.0.0
- Managed Credentials ListGETv1.0.0
- Managed Database Engine ViewGETv1.0.0
- Managed Database Engines ListGETv1.0.0
- Managed Database Type ViewGETv1.0.0
- Managed Database Types ListGETv1.0.0
- Managed Databases List AllGETv1.0.0
- Managed Issue ViewGETv1.0.0
- Managed Issues ListGETv1.0.0
- Managed Linode Settings ListGETv1.0.0
- Managed MongoDB Database Backup ViewGETv1.0.0
- Managed MongoDB Database Backups ListGETv1.0.0
- Managed MongoDB Database Credentials ViewGETv1.0.0
- Managed MongoDB Database SSL Certificate ViewGETv1.0.0
- Managed MongoDB Database ViewGETv1.0.0
- Managed MongoDB Databases ListGETv1.0.0
- Managed MySQL Database Backup ViewGETv1.0.0
- Managed MySQL Database Backups ListGETv1.0.0
- Managed MySQL Database Credentials ViewGETv1.0.0
- Managed MySQL Database SSL Certificate ViewGETv1.0.0
- Managed MySQL Database ViewGETv1.0.0
- Managed MySQL Databases ListGETv1.0.0
- Managed PostgreSQL Database Backup ViewGETv1.0.0
- Managed PostgreSQL Database Backups ListGETv1.0.0
- Managed PostgreSQL Database Credentials ViewGETv1.0.0
- Managed PostgreSQL Database SSL Certificate ViewGETv1.0.0
- Managed PostgreSQL Database ViewGETv1.0.0
- Managed PostgreSQL Databases ListGETv1.0.0
- Managed Service ViewGETv1.0.0
- Managed Services ListGETv1.0.0
- Network Transfer ViewGETv1.0.0
- Network Transfer View (year/month)GETv1.0.0
- Networking Information ListGETv1.0.0
- Node Pool ViewGETv1.0.0
- Node Pools ListGETv1.0.0
- Node ViewGETv1.0.0
- NodeBalancer Statistics ViewGETv1.0.0
- Statistics View (year/month)GETv1.0.0
- Trusted Devices ListGETv1.0.0
- Type ViewGETv1.0.0
- Types ListGETv1.0.0
- User Logins List AllGETv1.0.0
Infrastructure/Linode
Managed MySQL Database View
v1.0.0Output
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
{
"type": "object",
"description": "Managed MySQL Databases object.",
"properties": {
"allow_list": {
"type": "array",
"description": "A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format.\n\nBy default, this is an empty array (`[]`), which blocks all connections (both public and private) to the Managed Database.\n\nIf `0.0.0.0/0` is a value in this list, then all IP addresses can access the Managed Database.\n",
"items": {
"type": "string",
"format": "ipv4/prefix_length"
}
},
"cluster_size": {
"type": "integer",
"description": "The number of Linode Instance nodes deployed to the Managed Database.\n\nChoosing 3 nodes creates a high availability cluster consisting of 1 primary node and 2 replica nodes.\n",
"enum": [
1,
3
]
},
"created": {
"type": "string",
"format": "date-time",
"description": "When this Managed Database was created."
},
"encrypted": {
"type": "boolean",
"description": "Whether the Managed Databases is encrypted."
},
"engine": {
"type": "string",
"description": "The Managed Database engine type."
},
"hosts": {
"type": "object",
"description": "The primary and secondary hosts for the Managed Database. These are assigned after provisioning is complete.",
"properties": {
"primary": {
"type": "string",
"description": "The primary host for the Managed Database."
},
"secondary": {
"type": "string",
"description": "The secondary/private network host for the Managed Database.\n\nA private network host and a private IP can only be used to access a Database Cluster from Linodes in the same data center and will not incur transfer costs.\n\n**Note**: The secondary hostname is publicly viewable and accessible.\n"
}
}
},
"id": {
"type": "integer",
"description": "A unique ID that can be used to identify and reference the Managed Database."
},
"label": {
"type": "string",
"description": "A unique, user-defined string referring to the Managed Database."
},
"port": {
"type": "integer",
"description": "The access port for this Managed Database."
},
"region": {
"type": "string",
"description": "The [Region](/docs/api/regions/) ID for the Managed Database."
},
"replication_type": {
"type": "string",
"description": "The replication method used for the Managed Database.\n\nDefaults to `none` for a single cluster and `semi_synch` for a high availability cluster.\n\nMust be `none` for a single node cluster.\n\nMust be `asynch` or `semi_synch` for a high availability cluster.\n",
"enum": [
"none",
"asynch",
"semi_synch"
]
},
"ssl_connection": {
"type": "boolean",
"description": "Whether to require SSL credentials to establish a connection to the Managed Database.\n\nUse the **Managed MySQL Database Credentials View** ([GET /databases/mysql/instances/{instanceId}/credentials](/docs/api/databases/#managed-mysql-database-credentials-view)) command for access information.\n"
},
"status": {
"type": "string",
"description": "The operating status of the Managed Database.",
"enum": [
"provisioning",
"active",
"suspending",
"suspended",
"resuming",
"restoring",
"failed",
"degraded",
"updating",
"backing_up"
]
},
"type": {
"type": "string",
"description": "The Linode Instance type used by the Managed Database for its nodes."
},
"updated": {
"type": "string",
"format": "date-time",
"description": "When this Managed Database was last updated."
},
"updates": {
"type": "object",
"description": "Configuration settings for automated patch update maintenance for the Managed Database.",
"properties": {
"day_of_week": {
"type": "integer",
"description": "The day to perform maintenance. 1=Monday, 2=Tuesday, etc."
},
"duration": {
"type": "integer",
"description": "The maximum maintenance window time in hours."
},
"frequency": {
"type": "string",
"description": "Whether maintenance occurs on a weekly or monthly basis.",
"enum": [
"weekly",
"monthly"
]
},
"hour_of_day": {
"type": "integer",
"description": "The hour to begin maintenance based in UTC time."
},
"week_of_month": {
"type": "integer",
"description": "The week of the month to perform `monthly` frequency updates. Defaults to `null`.\n\n* Required for `monthly` frequency updates.\n\n* Must be `null` for `weekly` frequency updates.\n"
}
}
},
"version": {
"type": "string",
"description": "The Managed Database engine version."
}
}
}