Read our blog for the latest insights on sales and marketing Take Me There
Webinar: Use Sugar Data to Easily Generate Complex Documents Register
Webinar: Advanced Calendar Solution for Sugar Register
Amazon RDS Performance Insights supports SQL-level metrics on Amazon Aurora with MySQL-compatibility, a relational database built for the cloud. With RDS Performance Insights SQL-level metrics, you can identify high-frequency, long-running, and stuck SQL queries in seconds.
Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time.
RDS Performance Insights allows non-experts and experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights also collects SQL-level metrics such as average latency, calls per second, and rows returned per call. You can determine if a SQL query takes too long to complete or if a particular SQL query is called at a different rate than you expect and then make improvements to your application such as optimizing a slow SQL query, adding an index to your database, and scaling your database.
Amazon RDS Performance Insights is a database performance tuning and monitoring feature of RDS that allows you to visually assess the load on your database and determine when and where to take action. With one click in the Amazon RDS Management Console, you can add a fully managed performance monitoring solution to your Amazon RDS database. RDS Performance Insights is included with supported Amazon Aurora clusters and Amazon RDS instances and stores seven days of performance history in a rolling window at no additional cost. If you need longer-term retention, you can choose to pay for up to two years of performance history retention.
Amazon Aurora Multi-Master is a single database that allows you to create multiple read-write instances of your Aurora database across multiple Availability Zones, which enables uptime-sensitive applications to achieve continuous write availability through instance failure. With today’s launch, the feature is available for the MySQL-compatible edition of Aurora in 8 AWS regions. Check out this blog to find out how to build highly available MySQL applications using Aurora Multi-Master.
The feature is now available in US East (N. Virginia), US East (Ohio), US West (Oregon), Asia Pacific (Mumbai), Asia Pacific (Seoul), Asia Pacific (Tokyo), EU (Frankfurt), and EU (Ireland).
Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better performance than the typical MySQL database, together with increased scalability, durability, and security.
Earlier this year, AWS launched support for Aurora PostgreSQL user authentication with Kerberos and Microsoft Active Directory. In the original release, this support was based on AWS Directory Service for Microsoft Active Directory. AWS has now added support for user authentication using external Kerberos and Microsoft Active Directories, including those running on premises.
Aurora PostgreSQL support for Kerberos and Microsoft Active Directory provides the benefits of single sign-on and centralized authentication of Aurora PostgreSQL database users. Keeping all of your user credentials in the same Active Directory will save you time and effort, as you will now have a centralized place for storing and managing them for multiple DB instances.
In addition to password-based authentication and authentication with AWS Identity and Access Management (IAM), you can authenticate using AWS Managed Microsoft AD Service or your self-managed or on-premises Microsoft Active Directory. You can enable your database users to authenticate against Aurora PostgreSQL using the credentials stored in the AWS Directory Service for Microsoft Active Directory.
To reduce the number of Active Directories that you need to manage, you can use a single one for different Amazon Virtual Private Clouds (VPCs) within the same AWS region. You can also join Aurora PostgreSQL instances to shared Active Directory domains owned by different accounts.
Active Directory integration is supported with Aurora PostgreSQL versions 10.11 and newer, and 11.6 and newer. Read the documentation for details.
Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better performance than the typical MySQL database and three times the performance of the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product page.