Turning on the Standard mode of Database Insights for Amazon RDS
To turn on the Standard mode of Database Insights for Amazon RDS, use the following procedures.
Turning on the Standard mode of Database Insights when creating a DB instance or Multi-AZ DB cluster
Turn on the Standard mode of Database Insights when creating a database for Amazon RDS.
- Console
-
In the console, you can turn on the Standard mode of Database Insights when you create a DB instance or Multi-AZ DB cluster.
To turn on the Standard mode of Database Insights when creating a DB instance or Multi-AZ DB cluster using the console
Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/
. -
Choose Databases.
-
Choose Create database.
-
In the Database Insights section, select Standard mode. Then, choose from the following options to turn Performance Insights on or off:
To turn off Performance Insights, deselect Enable Performance Insights.
To turn on Performance Insights, select Enable Performance Insights. To configure Performance Insights, specify the following options:
-
Retention – The amount of time to retain Performance Insights data. The retention period must be at least 7 days.
-
Amazon KMS key – Specify your KMS key. Performance Insights encrypts all potentially sensitive data using your KMS key. Data is encrypted in flight and at rest. For more information, see Encrypting Amazon RDS resources.
-
-
Choose Create database.
- Amazon CLI
-
To turn on the Standard mode of Database Insights when creating a DB instance or Multi-AZ DB cluster, call the create-db-instance or create-db-cluster Amazon CLI command and supply the following values:
--database-insights-mode standardto turn on the Standard mode of Database Insights.--engine– The database engine for the DB instance.-
--db-instance-identifier– The identifier for the DB instance or--db-cluster-identifier– The identifier for the Multi-AZ DB cluster. -
--enable-performance-insightsor--no-enable-performance-insightsto turn Performance Insights on or off. If you specify--enable-performance-insights, you must also specify the--performance-insights-retention-period– The retention period for data for your DB instance. The retention period must be at least 7 days.
The following example enables the Standard mode of Database Insights and Performance Insights when creating a DB instance.
For Linux, macOS, or Unix:
aws rds create-db-instance \ --database-insights-mode standard \ --engine postgresql \ --db-instance-identifier sample-db-identifier \ --enable-performance-insights \ --performance-insights-retention-period 7For Windows:
aws rds create-db-instance ^ --database-insights-mode standard ^ --engine postgresql ^ --db-instance-identifier sample-db-identifier ^ --enable-performance-insights ^ --performance-insights-retention-period 7The following example enables the Standard mode of Database Insights and disables Performance Insights when creating a DB instance.
For Linux, macOS, or Unix:
aws rds create-db-instance \ --database-insights-mode standard \ --engine postgresql \ --db-instance-identifier sample-db-identifier \ --no-enable-performance-insightsFor Windows:
aws rds create-db-instance ^ --database-insights-mode standard ^ --engine postgresql ^ --db-instance-identifier sample-db-identifier ^ --no-enable-performance-insights - RDS API
-
To turn on the Standard mode of Database Insights when you create a DB instance or Multi-AZ DB cluster, specify the following parameters for your CreateDBInstance or CreateDBCluster Amazon RDS API operation.
DatabaseInsightsModetostandardEnablePerformanceInsightstoTrueorFalse. If you setEnablePerformanceInsightstoTrue, you must setPerformanceInsightsRetentionPeriodto at least 7 days.
Turning on the Standard mode of Database Insights when modifying a DB instance or Multi-AZ DB cluster
Turn on Standard mode of Database Insights when modifying a database for Amazon RDS.
Note
To enable Database Insights, each DB instance in a Multi-AZ DB cluster must have the same Performance Insights and Enhanced Monitoring settings.
- Console
-
In the console, you can turn on the Standard mode of Database Insights when you modify a DB instance or Multi-AZ DB cluster.
To turn on the Standard mode of Database Insights when modifying a DB instance or Multi-AZ DB cluster using the console
Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/
. -
Choose Databases.
-
Choose a DB instance or Multi-AZ DB cluster, and choose Modify.
-
In the Database Insights section, select Standard mode. Then, choose from the following options:
To turn off Performance Insights, deselect Enable Performance Insights.
To turn on Performance Insights, select Enable Performance Insights. To configure Performance Insights, specify the following options:
-
Retention – The amount of time to retain Performance Insights data. The retention period must be at least 7 days.
-
Amazon KMS key – Specify your KMS key. Performance Insights encrypts all potentially sensitive data using your KMS key. Data is encrypted in flight and at rest. For more information, see Encrypting Amazon RDS resources.
-
-
Choose Continue.
-
For Scheduling of Modifications, choose Apply immediately. If you choose Apply during the next scheduled maintenance window, your database ignores this setting and turns on the Standard mode of Database Insights immediately.
-
Choose Modify instance.
- Amazon CLI
-
To turn on the Standard mode of Database Insights when modifying a DB instance or Multi-AZ DB cluster, call the modify-db-instance or modify-db-cluster Amazon CLI command and supply the following values:
--database-insights-mode standardto turn on the Standard mode of Database Insights.-
--db-instance-identifier– The identifier for the DB instance or--db-cluster-identifier– The identifier for the Multi-AZ DB cluster. -
--enable-performance-insightsor--no-enable-performance-insightsto turn Performance Insights on or off. If you specify--enable-performance-insights, you must also specify the--performance-insights-retention-period– The retention period for data for your DB instance or Multi-AZ DB cluster. The retention period must be at least 7 days.
The following example enables the Standard mode of Database Insights and enables Performance Insights when modifying a DB instance.
For Linux, macOS, or Unix:
aws rds modify-db-instance \ --database-insights-mode standard \ --db-instance-identifier sample-db-identifier \ --enable-performance-insights \ --performance-insights-retention-period 7For Windows:
aws rds modify-db-instance ^ --database-insights-mode standard ^ --db-instance-identifier sample-db-identifier ^ --enable-performance-insights ^ --performance-insights-retention-period 7The following example enables the Standard mode of Database Insights and disables Performance Insights when modifying a DB instance.
For Linux, macOS, or Unix:
aws rds modify-db-instance \ --database-insights-mode standard \ --db-instance-identifier sample-db-identifier \ --no-enable-performance-insightsFor Windows:
aws rds modify-db-instance ^ --database-insights-mode standard ^ --db-instance-identifier sample-db-identifier ^ --no-enable-performance-insights - RDS API
-
To turn on the Standard mode of Database Insights when you modify a DB instance or Multi-AZ DB cluster, specify the following parameters for your ModifyDBInstance or ModifyDBCluster Amazon RDS API operation.
DatabaseInsightsModetostandardEnablePerformanceInsightstoTrueorFalse. If you setEnablePerformanceInsightstoTrue, you must setPerformanceInsightsRetentionPeriodto at least 7 days.