Retrieve information regarding the database replicas. Read-only replicas are not supported for Redis clusters.
View Specific Information
Digital Ocean supports only DatabaseId and Name columns with "=" operator as filter criteria for this view.
Note: The DatabaseId columns is a required filter. The driver will fetch a list of all database clusters if this filter is not present as part of the criteria.
SELECT * FROM DatabaseReplicas WHERE DatabaseId='9cc10173-e9ea-4176-9dbc-a4cee4c4ff30' AND Name = 'DatabaseName'
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.
|Name [KEY]||String||A unique, human-readable name referring to a database cluster.|
|DatabaseId||String||A unique ID that can be used to identify and reference a database cluster.|
|ConnectionDatabase||String||The name of the default database.|
|ConnectionHost||String||The FQDN pointing to the database cluster's current primary node.|
|ConnectionPassword||String||The randomly generated password for the default user.|
|ConnectionPort||Integer||The port on which the database cluster is listening.|
|ConnectionSsl||Boolean||A boolean value indicating if the connection should be made over SSL.|
|ConnectionUri||String||A connection string in the format accepted by the psql command. This is provided as a convenience and should be able to be constructed by the other attributes.|
|ConnectionUser||String||The default user for the database.|
|PrivateConnectionDatabase||String||The name of the default database.|
|PrivateConnectionHost||String||The FQDN pointing to the database cluster's current primary node.|
|PrivateConnectionPassword||String||The randomly generated password for the default user.|
|PrivateConnectionPort||Integer||The port on which the database cluster is listening.|
|PrivateConnectionSsl||Boolean||A boolean value indicating if the connection should be made over SSL.|
|PrivateConnectionUri||String||A connection string in the format accepted by the psql command. This is provided as a convenience and should be able to be constructed by the other attributes.|
|PrivateConnectionUser||String||The default user for the database.|
|CreatedAt||Datetime||Represents when the database cluster was created.|
|Region||String||The slug identifier for the region where the database cluster is located.|
|Status||String||A string representing the current status of the database cluster. Possible values include creating, online, resizing, and migrating.|