Amazon Relational Database Service

2024/12/16 - Amazon Relational Database Service - 4 updated api methods

Changes  This release adds support for the "MYSQL_CACHING_SHA2_PASSWORD" enum value for RDS Proxy ClientPasswordAuthType.

CreateDBProxy (updated) Link ¶
Changes (request, response)
Request
{'Auth': {'ClientPasswordAuthType': {'MYSQL_CACHING_SHA2_PASSWORD'}}}
Response
{'DBProxy': {'Auth': {'ClientPasswordAuthType': {'MYSQL_CACHING_SHA2_PASSWORD'}}}}

Creates a new DB proxy.

See also: AWS API Documentation

Request Syntax

client.create_db_proxy(
    DBProxyName='string',
    EngineFamily='MYSQL'|'POSTGRESQL'|'SQLSERVER',
    Auth=[
        {
            'Description': 'string',
            'UserName': 'string',
            'AuthScheme': 'SECRETS',
            'SecretArn': 'string',
            'IAMAuth': 'DISABLED'|'REQUIRED'|'ENABLED',
            'ClientPasswordAuthType': 'MYSQL_NATIVE_PASSWORD'|'MYSQL_CACHING_SHA2_PASSWORD'|'POSTGRES_SCRAM_SHA_256'|'POSTGRES_MD5'|'SQL_SERVER_AUTHENTICATION'
        },
    ],
    RoleArn='string',
    VpcSubnetIds=[
        'string',
    ],
    VpcSecurityGroupIds=[
        'string',
    ],
    RequireTLS=True|False,
    IdleClientTimeout=123,
    DebugLogging=True|False,
    Tags=[
        {
            'Key': 'string',
            'Value': 'string'
        },
    ]
)
type DBProxyName:

string

param DBProxyName:

[REQUIRED]

The identifier for the proxy. This name must be unique for all proxies owned by your Amazon Web Services account in the specified Amazon Web Services Region. An identifier must begin with a letter and must contain only ASCII letters, digits, and hyphens; it can't end with a hyphen or contain two consecutive hyphens.

type EngineFamily:

string

param EngineFamily:

[REQUIRED]

The kinds of databases that the proxy can connect to. This value determines which database network protocol the proxy recognizes when it interprets network traffic to and from the database. For Aurora MySQL, RDS for MariaDB, and RDS for MySQL databases, specify MYSQL. For Aurora PostgreSQL and RDS for PostgreSQL databases, specify POSTGRESQL. For RDS for Microsoft SQL Server, specify SQLSERVER.

type Auth:

list

param Auth:

[REQUIRED]

The authorization mechanism that the proxy uses.

  • (dict) --

    Specifies the details of authentication used by a proxy to log in as a specific database user.

    • Description (string) --

      A user-specified description about the authentication used by a proxy to log in as a specific database user.

    • UserName (string) --

      The name of the database user to which the proxy connects.

    • AuthScheme (string) --

      The type of authentication that the proxy uses for connections from the proxy to the underlying database.

    • SecretArn (string) --

      The Amazon Resource Name (ARN) representing the secret that the proxy uses to authenticate to the RDS DB instance or Aurora DB cluster. These secrets are stored within Amazon Secrets Manager.

    • IAMAuth (string) --

      A value that indicates whether to require or disallow Amazon Web Services Identity and Access Management (IAM) authentication for connections to the proxy. The ENABLED value is valid only for proxies with RDS for Microsoft SQL Server.

    • ClientPasswordAuthType (string) --

      The type of authentication the proxy uses for connections from clients.

type RoleArn:

string

param RoleArn:

[REQUIRED]

The Amazon Resource Name (ARN) of the IAM role that the proxy uses to access secrets in Amazon Web Services Secrets Manager.

type VpcSubnetIds:

list

param VpcSubnetIds:

[REQUIRED]

One or more VPC subnet IDs to associate with the new proxy.

  • (string) --

type VpcSecurityGroupIds:

list

param VpcSecurityGroupIds:

One or more VPC security group IDs to associate with the new proxy.

  • (string) --

type RequireTLS:

boolean

param RequireTLS:

Specifies whether Transport Layer Security (TLS) encryption is required for connections to the proxy. By enabling this setting, you can enforce encrypted TLS connections to the proxy.

type IdleClientTimeout:

integer

param IdleClientTimeout:

The number of seconds that a connection to the proxy can be inactive before the proxy disconnects it. You can set this value higher or lower than the connection timeout limit for the associated database.

type DebugLogging:

boolean

param DebugLogging:

Specifies whether the proxy includes detailed information about SQL statements in its logs. This information helps you to debug issues involving SQL behavior or the performance and scalability of the proxy connections. The debug information includes the text of SQL statements that you submit through the proxy. Thus, only enable this setting when needed for debugging, and only when you have security measures in place to safeguard any sensitive information that appears in the logs.

type Tags:

list

param Tags:

An optional set of key-value pairs to associate arbitrary data of your choosing with the proxy.

  • (dict) --

    Metadata assigned to an Amazon RDS resource consisting of a key-value pair.

    For more information, see Tagging Amazon RDS resources in the Amazon RDS User Guide or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora User Guide.

    • Key (string) --

      A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can't be prefixed with aws: or rds:. The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").

    • Value (string) --

      A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can't be prefixed with aws: or rds:. The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\p{L}\p{Z}\p{N}_.:/=+\-@]*)$").

rtype:

dict

returns:

Response Syntax

{
    'DBProxy': {
        'DBProxyName': 'string',
        'DBProxyArn': 'string',
        'Status': 'available'|'modifying'|'incompatible-network'|'insufficient-resource-limits'|'creating'|'deleting'|'suspended'|'suspending'|'reactivating',
        'EngineFamily': 'string',
        'VpcId': 'string',
        'VpcSecurityGroupIds': [
            'string',
        ],
        'VpcSubnetIds': [
            'string',
        ],
        'Auth': [
            {
                'Description': 'string',
                'UserName': 'string',
                'AuthScheme': 'SECRETS',
                'SecretArn': 'string',
                'IAMAuth': 'DISABLED'|'REQUIRED'|'ENABLED',
                'ClientPasswordAuthType': 'MYSQL_NATIVE_PASSWORD'|'MYSQL_CACHING_SHA2_PASSWORD'|'POSTGRES_SCRAM_SHA_256'|'POSTGRES_MD5'|'SQL_SERVER_AUTHENTICATION'
            },
        ],
        'RoleArn': 'string',
        'Endpoint': 'string',
        'RequireTLS': True|False,
        'IdleClientTimeout': 123,
        'DebugLogging': True|False,
        'CreatedDate': datetime(2015, 1, 1),
        'UpdatedDate': datetime(2015, 1, 1)
    }
}

Response Structure

  • (dict) --

    • DBProxy (dict) --

      The DBProxy structure corresponding to the new proxy.

      • DBProxyName (string) --

        The identifier for the proxy. This name must be unique for all proxies owned by your Amazon Web Services account in the specified Amazon Web Services Region.

      • DBProxyArn (string) --

        The Amazon Resource Name (ARN) for the proxy.

      • Status (string) --

        The current status of this proxy. A status of available means the proxy is ready to handle requests. Other values indicate that you must wait for the proxy to be ready, or take some action to resolve an issue.

      • EngineFamily (string) --

        The kinds of databases that the proxy can connect to. This value determines which database network protocol the proxy recognizes when it interprets network traffic to and from the database. MYSQL supports Aurora MySQL, RDS for MariaDB, and RDS for MySQL databases. POSTGRESQL supports Aurora PostgreSQL and RDS for PostgreSQL databases. SQLSERVER supports RDS for Microsoft SQL Server databases.

      • VpcId (string) --

        Provides the VPC ID of the DB proxy.

      • VpcSecurityGroupIds (list) --

        Provides a list of VPC security groups that the proxy belongs to.

        • (string) --

      • VpcSubnetIds (list) --

        The EC2 subnet IDs for the proxy.

        • (string) --

      • Auth (list) --

        One or more data structures specifying the authorization mechanism to connect to the associated RDS DB instance or Aurora DB cluster.

        • (dict) --

          Returns the details of authentication used by a proxy to log in as a specific database user.

          • Description (string) --

            A user-specified description about the authentication used by a proxy to log in as a specific database user.

          • UserName (string) --

            The name of the database user to which the proxy connects.

          • AuthScheme (string) --

            The type of authentication that the proxy uses for connections from the proxy to the underlying database.

          • SecretArn (string) --

            The Amazon Resource Name (ARN) representing the secret that the proxy uses to authenticate to the RDS DB instance or Aurora DB cluster. These secrets are stored within Amazon Secrets Manager.

          • IAMAuth (string) --

            Whether to require or disallow Amazon Web Services Identity and Access Management (IAM) authentication for connections to the proxy. The ENABLED value is valid only for proxies with RDS for Microsoft SQL Server.

          • ClientPasswordAuthType (string) --

            The type of authentication the proxy uses for connections from clients.

      • RoleArn (string) --

        The Amazon Resource Name (ARN) for the IAM role that the proxy uses to access Amazon Secrets Manager.

      • Endpoint (string) --

        The endpoint that you can use to connect to the DB proxy. You include the endpoint value in the connection string for a database client application.

      • RequireTLS (boolean) --

        Indicates whether Transport Layer Security (TLS) encryption is required for connections to the proxy.

      • IdleClientTimeout (integer) --

        The number of seconds a connection to the proxy can have no activity before the proxy drops the client connection. The proxy keeps the underlying database connection open and puts it back into the connection pool for reuse by later connection requests.

        Default: 1800 (30 minutes)

        Constraints: 1 to 28,800

      • DebugLogging (boolean) --

        Indicates whether the proxy includes detailed information about SQL statements in its logs. This information helps you to debug issues involving SQL behavior or the performance and scalability of the proxy connections. The debug information includes the text of SQL statements that you submit through the proxy. Thus, only enable this setting when needed for debugging, and only when you have security measures in place to safeguard any sensitive information that appears in the logs.

      • CreatedDate (datetime) --

        The date and time when the proxy was first created.

      • UpdatedDate (datetime) --

        The date and time when the proxy was last updated.

DeleteDBProxy (updated) Link ¶
Changes (response)
{'DBProxy': {'Auth': {'ClientPasswordAuthType': {'MYSQL_CACHING_SHA2_PASSWORD'}}}}

Deletes an existing DB proxy.

See also: AWS API Documentation

Request Syntax

client.delete_db_proxy(
    DBProxyName='string'
)
type DBProxyName:

string

param DBProxyName:

[REQUIRED]

The name of the DB proxy to delete.

rtype:

dict

returns:

Response Syntax

{
    'DBProxy': {
        'DBProxyName': 'string',
        'DBProxyArn': 'string',
        'Status': 'available'|'modifying'|'incompatible-network'|'insufficient-resource-limits'|'creating'|'deleting'|'suspended'|'suspending'|'reactivating',
        'EngineFamily': 'string',
        'VpcId': 'string',
        'VpcSecurityGroupIds': [
            'string',
        ],
        'VpcSubnetIds': [
            'string',
        ],
        'Auth': [
            {
                'Description': 'string',
                'UserName': 'string',
                'AuthScheme': 'SECRETS',
                'SecretArn': 'string',
                'IAMAuth': 'DISABLED'|'REQUIRED'|'ENABLED',
                'ClientPasswordAuthType': 'MYSQL_NATIVE_PASSWORD'|'MYSQL_CACHING_SHA2_PASSWORD'|'POSTGRES_SCRAM_SHA_256'|'POSTGRES_MD5'|'SQL_SERVER_AUTHENTICATION'
            },
        ],
        'RoleArn': 'string',
        'Endpoint': 'string',
        'RequireTLS': True|False,
        'IdleClientTimeout': 123,
        'DebugLogging': True|False,
        'CreatedDate': datetime(2015, 1, 1),
        'UpdatedDate': datetime(2015, 1, 1)
    }
}

Response Structure

  • (dict) --

    • DBProxy (dict) --

      The data structure representing the details of the DB proxy that you delete.

      • DBProxyName (string) --

        The identifier for the proxy. This name must be unique for all proxies owned by your Amazon Web Services account in the specified Amazon Web Services Region.

      • DBProxyArn (string) --

        The Amazon Resource Name (ARN) for the proxy.

      • Status (string) --

        The current status of this proxy. A status of available means the proxy is ready to handle requests. Other values indicate that you must wait for the proxy to be ready, or take some action to resolve an issue.

      • EngineFamily (string) --

        The kinds of databases that the proxy can connect to. This value determines which database network protocol the proxy recognizes when it interprets network traffic to and from the database. MYSQL supports Aurora MySQL, RDS for MariaDB, and RDS for MySQL databases. POSTGRESQL supports Aurora PostgreSQL and RDS for PostgreSQL databases. SQLSERVER supports RDS for Microsoft SQL Server databases.

      • VpcId (string) --

        Provides the VPC ID of the DB proxy.

      • VpcSecurityGroupIds (list) --

        Provides a list of VPC security groups that the proxy belongs to.

        • (string) --

      • VpcSubnetIds (list) --

        The EC2 subnet IDs for the proxy.

        • (string) --

      • Auth (list) --

        One or more data structures specifying the authorization mechanism to connect to the associated RDS DB instance or Aurora DB cluster.

        • (dict) --

          Returns the details of authentication used by a proxy to log in as a specific database user.

          • Description (string) --

            A user-specified description about the authentication used by a proxy to log in as a specific database user.

          • UserName (string) --

            The name of the database user to which the proxy connects.

          • AuthScheme (string) --

            The type of authentication that the proxy uses for connections from the proxy to the underlying database.

          • SecretArn (string) --

            The Amazon Resource Name (ARN) representing the secret that the proxy uses to authenticate to the RDS DB instance or Aurora DB cluster. These secrets are stored within Amazon Secrets Manager.

          • IAMAuth (string) --

            Whether to require or disallow Amazon Web Services Identity and Access Management (IAM) authentication for connections to the proxy. The ENABLED value is valid only for proxies with RDS for Microsoft SQL Server.

          • ClientPasswordAuthType (string) --

            The type of authentication the proxy uses for connections from clients.

      • RoleArn (string) --

        The Amazon Resource Name (ARN) for the IAM role that the proxy uses to access Amazon Secrets Manager.

      • Endpoint (string) --

        The endpoint that you can use to connect to the DB proxy. You include the endpoint value in the connection string for a database client application.

      • RequireTLS (boolean) --

        Indicates whether Transport Layer Security (TLS) encryption is required for connections to the proxy.

      • IdleClientTimeout (integer) --

        The number of seconds a connection to the proxy can have no activity before the proxy drops the client connection. The proxy keeps the underlying database connection open and puts it back into the connection pool for reuse by later connection requests.

        Default: 1800 (30 minutes)

        Constraints: 1 to 28,800

      • DebugLogging (boolean) --

        Indicates whether the proxy includes detailed information about SQL statements in its logs. This information helps you to debug issues involving SQL behavior or the performance and scalability of the proxy connections. The debug information includes the text of SQL statements that you submit through the proxy. Thus, only enable this setting when needed for debugging, and only when you have security measures in place to safeguard any sensitive information that appears in the logs.

      • CreatedDate (datetime) --

        The date and time when the proxy was first created.

      • UpdatedDate (datetime) --

        The date and time when the proxy was last updated.

DescribeDBProxies (updated) Link ¶
Changes (response)
{'DBProxies': {'Auth': {'ClientPasswordAuthType': {'MYSQL_CACHING_SHA2_PASSWORD'}}}}

Returns information about DB proxies.

See also: AWS API Documentation

Request Syntax

client.describe_db_proxies(
    DBProxyName='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    Marker='string',
    MaxRecords=123
)
type DBProxyName:

string

param DBProxyName:

The name of the DB proxy. If you omit this parameter, the output includes information about all DB proxies owned by your Amazon Web Services account ID.

type Filters:

list

param Filters:

This parameter is not currently supported.

  • (dict) --

    A filter name and value pair that is used to return a more specific list of results from a describe operation. Filters can be used to match a set of resources by specific criteria, such as IDs. The filters supported by a describe operation are documented with the describe operation.

    The following actions can be filtered:

    • DescribeDBClusterBacktracks

    • DescribeDBClusterEndpoints

    • DescribeDBClusters

    • DescribeDBInstances

    • DescribeDBRecommendations

    • DescribeDBShardGroups

    • DescribePendingMaintenanceActions

    • Name (string) -- [REQUIRED]

      The name of the filter. Filter names are case-sensitive.

    • Values (list) -- [REQUIRED]

      One or more filter values. Filter values are case-sensitive.

      • (string) --

type Marker:

string

param Marker:

An optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.

type MaxRecords:

integer

param MaxRecords:

The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, a pagination token called a marker is included in the response so that the remaining results can be retrieved.

Default: 100

Constraints: Minimum 20, maximum 100.

rtype:

dict

returns:

Response Syntax

{
    'DBProxies': [
        {
            'DBProxyName': 'string',
            'DBProxyArn': 'string',
            'Status': 'available'|'modifying'|'incompatible-network'|'insufficient-resource-limits'|'creating'|'deleting'|'suspended'|'suspending'|'reactivating',
            'EngineFamily': 'string',
            'VpcId': 'string',
            'VpcSecurityGroupIds': [
                'string',
            ],
            'VpcSubnetIds': [
                'string',
            ],
            'Auth': [
                {
                    'Description': 'string',
                    'UserName': 'string',
                    'AuthScheme': 'SECRETS',
                    'SecretArn': 'string',
                    'IAMAuth': 'DISABLED'|'REQUIRED'|'ENABLED',
                    'ClientPasswordAuthType': 'MYSQL_NATIVE_PASSWORD'|'MYSQL_CACHING_SHA2_PASSWORD'|'POSTGRES_SCRAM_SHA_256'|'POSTGRES_MD5'|'SQL_SERVER_AUTHENTICATION'
                },
            ],
            'RoleArn': 'string',
            'Endpoint': 'string',
            'RequireTLS': True|False,
            'IdleClientTimeout': 123,
            'DebugLogging': True|False,
            'CreatedDate': datetime(2015, 1, 1),
            'UpdatedDate': datetime(2015, 1, 1)
        },
    ],
    'Marker': 'string'
}

Response Structure

  • (dict) --

    • DBProxies (list) --

      A return value representing an arbitrary number of DBProxy data structures.

      • (dict) --

        The data structure representing a proxy managed by the RDS Proxy.

        This data type is used as a response element in the DescribeDBProxies action.

        • DBProxyName (string) --

          The identifier for the proxy. This name must be unique for all proxies owned by your Amazon Web Services account in the specified Amazon Web Services Region.

        • DBProxyArn (string) --

          The Amazon Resource Name (ARN) for the proxy.

        • Status (string) --

          The current status of this proxy. A status of available means the proxy is ready to handle requests. Other values indicate that you must wait for the proxy to be ready, or take some action to resolve an issue.

        • EngineFamily (string) --

          The kinds of databases that the proxy can connect to. This value determines which database network protocol the proxy recognizes when it interprets network traffic to and from the database. MYSQL supports Aurora MySQL, RDS for MariaDB, and RDS for MySQL databases. POSTGRESQL supports Aurora PostgreSQL and RDS for PostgreSQL databases. SQLSERVER supports RDS for Microsoft SQL Server databases.

        • VpcId (string) --

          Provides the VPC ID of the DB proxy.

        • VpcSecurityGroupIds (list) --

          Provides a list of VPC security groups that the proxy belongs to.

          • (string) --

        • VpcSubnetIds (list) --

          The EC2 subnet IDs for the proxy.

          • (string) --

        • Auth (list) --

          One or more data structures specifying the authorization mechanism to connect to the associated RDS DB instance or Aurora DB cluster.

          • (dict) --

            Returns the details of authentication used by a proxy to log in as a specific database user.

            • Description (string) --

              A user-specified description about the authentication used by a proxy to log in as a specific database user.

            • UserName (string) --

              The name of the database user to which the proxy connects.

            • AuthScheme (string) --

              The type of authentication that the proxy uses for connections from the proxy to the underlying database.

            • SecretArn (string) --

              The Amazon Resource Name (ARN) representing the secret that the proxy uses to authenticate to the RDS DB instance or Aurora DB cluster. These secrets are stored within Amazon Secrets Manager.

            • IAMAuth (string) --

              Whether to require or disallow Amazon Web Services Identity and Access Management (IAM) authentication for connections to the proxy. The ENABLED value is valid only for proxies with RDS for Microsoft SQL Server.

            • ClientPasswordAuthType (string) --

              The type of authentication the proxy uses for connections from clients.

        • RoleArn (string) --

          The Amazon Resource Name (ARN) for the IAM role that the proxy uses to access Amazon Secrets Manager.

        • Endpoint (string) --

          The endpoint that you can use to connect to the DB proxy. You include the endpoint value in the connection string for a database client application.

        • RequireTLS (boolean) --

          Indicates whether Transport Layer Security (TLS) encryption is required for connections to the proxy.

        • IdleClientTimeout (integer) --

          The number of seconds a connection to the proxy can have no activity before the proxy drops the client connection. The proxy keeps the underlying database connection open and puts it back into the connection pool for reuse by later connection requests.

          Default: 1800 (30 minutes)

          Constraints: 1 to 28,800

        • DebugLogging (boolean) --

          Indicates whether the proxy includes detailed information about SQL statements in its logs. This information helps you to debug issues involving SQL behavior or the performance and scalability of the proxy connections. The debug information includes the text of SQL statements that you submit through the proxy. Thus, only enable this setting when needed for debugging, and only when you have security measures in place to safeguard any sensitive information that appears in the logs.

        • CreatedDate (datetime) --

          The date and time when the proxy was first created.

        • UpdatedDate (datetime) --

          The date and time when the proxy was last updated.

    • Marker (string) --

      An optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.

ModifyDBProxy (updated) Link ¶
Changes (request, response)
Request
{'Auth': {'ClientPasswordAuthType': {'MYSQL_CACHING_SHA2_PASSWORD'}}}
Response
{'DBProxy': {'Auth': {'ClientPasswordAuthType': {'MYSQL_CACHING_SHA2_PASSWORD'}}}}

Changes the settings for an existing DB proxy.

See also: AWS API Documentation

Request Syntax

client.modify_db_proxy(
    DBProxyName='string',
    NewDBProxyName='string',
    Auth=[
        {
            'Description': 'string',
            'UserName': 'string',
            'AuthScheme': 'SECRETS',
            'SecretArn': 'string',
            'IAMAuth': 'DISABLED'|'REQUIRED'|'ENABLED',
            'ClientPasswordAuthType': 'MYSQL_NATIVE_PASSWORD'|'MYSQL_CACHING_SHA2_PASSWORD'|'POSTGRES_SCRAM_SHA_256'|'POSTGRES_MD5'|'SQL_SERVER_AUTHENTICATION'
        },
    ],
    RequireTLS=True|False,
    IdleClientTimeout=123,
    DebugLogging=True|False,
    RoleArn='string',
    SecurityGroups=[
        'string',
    ]
)
type DBProxyName:

string

param DBProxyName:

[REQUIRED]

The identifier for the DBProxy to modify.

type NewDBProxyName:

string

param NewDBProxyName:

The new identifier for the DBProxy. An identifier must begin with a letter and must contain only ASCII letters, digits, and hyphens; it can't end with a hyphen or contain two consecutive hyphens.

type Auth:

list

param Auth:

The new authentication settings for the DBProxy.

  • (dict) --

    Specifies the details of authentication used by a proxy to log in as a specific database user.

    • Description (string) --

      A user-specified description about the authentication used by a proxy to log in as a specific database user.

    • UserName (string) --

      The name of the database user to which the proxy connects.

    • AuthScheme (string) --

      The type of authentication that the proxy uses for connections from the proxy to the underlying database.

    • SecretArn (string) --

      The Amazon Resource Name (ARN) representing the secret that the proxy uses to authenticate to the RDS DB instance or Aurora DB cluster. These secrets are stored within Amazon Secrets Manager.

    • IAMAuth (string) --

      A value that indicates whether to require or disallow Amazon Web Services Identity and Access Management (IAM) authentication for connections to the proxy. The ENABLED value is valid only for proxies with RDS for Microsoft SQL Server.

    • ClientPasswordAuthType (string) --

      The type of authentication the proxy uses for connections from clients.

type RequireTLS:

boolean

param RequireTLS:

Whether Transport Layer Security (TLS) encryption is required for connections to the proxy. By enabling this setting, you can enforce encrypted TLS connections to the proxy, even if the associated database doesn't use TLS.

type IdleClientTimeout:

integer

param IdleClientTimeout:

The number of seconds that a connection to the proxy can be inactive before the proxy disconnects it. You can set this value higher or lower than the connection timeout limit for the associated database.

type DebugLogging:

boolean

param DebugLogging:

Whether the proxy includes detailed information about SQL statements in its logs. This information helps you to debug issues involving SQL behavior or the performance and scalability of the proxy connections. The debug information includes the text of SQL statements that you submit through the proxy. Thus, only enable this setting when needed for debugging, and only when you have security measures in place to safeguard any sensitive information that appears in the logs.

type RoleArn:

string

param RoleArn:

The Amazon Resource Name (ARN) of the IAM role that the proxy uses to access secrets in Amazon Web Services Secrets Manager.

type SecurityGroups:

list

param SecurityGroups:

The new list of security groups for the DBProxy.

  • (string) --

rtype:

dict

returns:

Response Syntax

{
    'DBProxy': {
        'DBProxyName': 'string',
        'DBProxyArn': 'string',
        'Status': 'available'|'modifying'|'incompatible-network'|'insufficient-resource-limits'|'creating'|'deleting'|'suspended'|'suspending'|'reactivating',
        'EngineFamily': 'string',
        'VpcId': 'string',
        'VpcSecurityGroupIds': [
            'string',
        ],
        'VpcSubnetIds': [
            'string',
        ],
        'Auth': [
            {
                'Description': 'string',
                'UserName': 'string',
                'AuthScheme': 'SECRETS',
                'SecretArn': 'string',
                'IAMAuth': 'DISABLED'|'REQUIRED'|'ENABLED',
                'ClientPasswordAuthType': 'MYSQL_NATIVE_PASSWORD'|'MYSQL_CACHING_SHA2_PASSWORD'|'POSTGRES_SCRAM_SHA_256'|'POSTGRES_MD5'|'SQL_SERVER_AUTHENTICATION'
            },
        ],
        'RoleArn': 'string',
        'Endpoint': 'string',
        'RequireTLS': True|False,
        'IdleClientTimeout': 123,
        'DebugLogging': True|False,
        'CreatedDate': datetime(2015, 1, 1),
        'UpdatedDate': datetime(2015, 1, 1)
    }
}

Response Structure

  • (dict) --

    • DBProxy (dict) --

      The DBProxy object representing the new settings for the proxy.

      • DBProxyName (string) --

        The identifier for the proxy. This name must be unique for all proxies owned by your Amazon Web Services account in the specified Amazon Web Services Region.

      • DBProxyArn (string) --

        The Amazon Resource Name (ARN) for the proxy.

      • Status (string) --

        The current status of this proxy. A status of available means the proxy is ready to handle requests. Other values indicate that you must wait for the proxy to be ready, or take some action to resolve an issue.

      • EngineFamily (string) --

        The kinds of databases that the proxy can connect to. This value determines which database network protocol the proxy recognizes when it interprets network traffic to and from the database. MYSQL supports Aurora MySQL, RDS for MariaDB, and RDS for MySQL databases. POSTGRESQL supports Aurora PostgreSQL and RDS for PostgreSQL databases. SQLSERVER supports RDS for Microsoft SQL Server databases.

      • VpcId (string) --

        Provides the VPC ID of the DB proxy.

      • VpcSecurityGroupIds (list) --

        Provides a list of VPC security groups that the proxy belongs to.

        • (string) --

      • VpcSubnetIds (list) --

        The EC2 subnet IDs for the proxy.

        • (string) --

      • Auth (list) --

        One or more data structures specifying the authorization mechanism to connect to the associated RDS DB instance or Aurora DB cluster.

        • (dict) --

          Returns the details of authentication used by a proxy to log in as a specific database user.

          • Description (string) --

            A user-specified description about the authentication used by a proxy to log in as a specific database user.

          • UserName (string) --

            The name of the database user to which the proxy connects.

          • AuthScheme (string) --

            The type of authentication that the proxy uses for connections from the proxy to the underlying database.

          • SecretArn (string) --

            The Amazon Resource Name (ARN) representing the secret that the proxy uses to authenticate to the RDS DB instance or Aurora DB cluster. These secrets are stored within Amazon Secrets Manager.

          • IAMAuth (string) --

            Whether to require or disallow Amazon Web Services Identity and Access Management (IAM) authentication for connections to the proxy. The ENABLED value is valid only for proxies with RDS for Microsoft SQL Server.

          • ClientPasswordAuthType (string) --

            The type of authentication the proxy uses for connections from clients.

      • RoleArn (string) --

        The Amazon Resource Name (ARN) for the IAM role that the proxy uses to access Amazon Secrets Manager.

      • Endpoint (string) --

        The endpoint that you can use to connect to the DB proxy. You include the endpoint value in the connection string for a database client application.

      • RequireTLS (boolean) --

        Indicates whether Transport Layer Security (TLS) encryption is required for connections to the proxy.

      • IdleClientTimeout (integer) --

        The number of seconds a connection to the proxy can have no activity before the proxy drops the client connection. The proxy keeps the underlying database connection open and puts it back into the connection pool for reuse by later connection requests.

        Default: 1800 (30 minutes)

        Constraints: 1 to 28,800

      • DebugLogging (boolean) --

        Indicates whether the proxy includes detailed information about SQL statements in its logs. This information helps you to debug issues involving SQL behavior or the performance and scalability of the proxy connections. The debug information includes the text of SQL statements that you submit through the proxy. Thus, only enable this setting when needed for debugging, and only when you have security measures in place to safeguard any sensitive information that appears in the logs.

      • CreatedDate (datetime) --

        The date and time when the proxy was first created.

      • UpdatedDate (datetime) --

        The date and time when the proxy was last updated.