Skip to main content
Sumo Logic

Install the Aurora MySQL ULM App and view the Dashboards

This page provides instructions for installing the Sumo App for Aurora MySQL ULM, and descriptions of each of the app dashboards.

This page provides instructions for installing the Sumo App for Aurora MySQL ULM, as well as the descriptions of each of the app dashboards. Click a link to jump to a section:

Install the app 

Now that you have set up log and metric collection for Amazon Aurora MySQL, you can install the Sumo Logic App for Aurora MySQL ULM, and use its pre-configured searches and dashboards.

To  install the app, do the following:

Locate and install the app you need from the App Catalog. If you want to see a preview of the dashboards included with the app before installing, click Preview Dashboards.

  1. From the App Catalog, search for and select the app. 
  2. To install the app, click Add to Library and complete the following fields.
    1. App Name. You can retain the existing name, or enter a name of your choice for the app.

    2. Data Source. Select either of these options for the data source.

      • Choose Source Category, and select a source category from the list.

      • Choose Enter a Custom Data Filter, and enter a custom source category beginning with an underscore. Example: (_sourceCategory=MyCategory).

    3. Advanced. Select the Location in Library (the default is the Personal folder in the library), or click New Folder to add a new folder.
    4. Click Add to Library.

Once an app is installed, it will appear in your Personal folder, or other folder that you specified. From here, you can share it with your organization. See Welcome to the New Library for information on working with the library in the new UI.

Panels will start to fill automatically. It's important to note that each panel slowly fills with data matching the time range query and received since the panel was created. Results won't immediately be available, but with a bit of time, you'll see full graphs and maps. 

Dashboard filters

Each dashboard has a set of filters that you can apply to the entire dashboard, as shown in the following example. Click the funnel icon in the top dashboard menu bar to display a scrollable list of filters that narrow search results across the entire dashboard.

AuroraMySQL_Dashboard_Filter_iocn.png

Each panel has a set of filters that are applied to the results for that panel only, as shown in the following example. Click the funnel icon in the top panel menu bar to display a list of panel-specific filters.

AuroraMySQL_Panel_Fitler_icon.png

Logs - Overview Dashboard

Aurora MySQL ULM Logs - Overview Dashboard allows you to view high-level overview of the following log types: Error, Slow Query, Audit and General.

Use this dashboard to:

  • Identify Authentication Failures. You can drill down for granular data by clicking any of the first row panels  to display the “Error Log” analysis dashboard.
  • Identify the number of database connections. For more granular data, click the DB Connections panel to bring up the Audit Analysis dashboard .
  • Identify the number of slow queries and the users and client hosts that are responsible for them. For more granular data, click the Slow Queries and Top Users and IPs Firing Slow Queries panels to bring up the Slow Query Log dashboard.
  • Identify the breakdown of connection protocols. For more granular data, clicking the Connection Type Used panel to bring up the General Query Logs dashboard.

AuroraMySQL_Logs_Overview.png

Logs - Error Logs Analysis Dashboard

Aurora MySQL ULM Logs - Error Logs Analysis Dashboard allows you to view details for error logs, including failed authentications, error outliers, top and recent warnings, log levels, and aborted connections.

Use this dashboard to:

  • Track diagnostic messages, such as errors, warnings and notes to effectively troubleshoot a situation.
  • Identify outliers for diagnostic events to discover if there is anomaly.
  • Identify the reason for authentication failures for user, client, host, and client location being used to connect.
  • Identify connection abort events.
  • Monitor database instance start up, ready for connection events.

AuroraMySQL_Logs_ErrorLogsAnalysis.png

Logs - Slow Query Dashboard

Aurora MySQL ULM Logs - Slow Query Dashboard allows you to view log details on slow queries, including the number of slow queries, trends, execution times, time comparisons, command types, users, and IP addresses.

Use this dashboard to:

  • Identify queries that are taking longer to process than the time onfigured in DB Parameter Group.
  • Identify queries used to search non-indexed columns, thus impacting performance.
  • Identify candidate queries, for improvements based on frequency of execution, time it takes to execute, locking time, and other factors.
  • Identify users responsible for slow queries, from the client IP address and type of command.
  • Check if SQL SELECT type queries can be shifted to read replicas.
  • Monitor trends of slow queries, comparing history to analyze the cause and troubleshoot a solution.

AuroraMySQL_Logs_SlowQuery.png

Logs - Audit Log Analysis Dashboard

Aurora MySQL ULM Logs - Audit Log Analysis Dashboard allows you to view an analysis of events, including accessed resources, destination and source addresses,  timestamps, and user login information. These logs are specifically enabled to audit activities that are of interest from an audit and compliance perspective.

Use this dashboard to:

  • Identify successful and failed connections to the database with details about user, client IP address, location.
  • Identify whether multiple hosts are connecting to DB with same user.
  • Identify whether multiple users are connecting to DB from same host.
  • Identify the most active users, client hosts, and databases.
  • Get a high level overview of SQL statements and commands being executed.  
  • Identify user management related activities.

AuroraMySQL_Logs_AuditLogAnalysis.png

Logs - Audit Log SQL Statements Dashboard

Aurora MySQL Logs - Audit Log SQL Statements Dashboard allows you to view details for SQL statement events, including Top SQL commands and statements, trends, user management, and activity for various types of SQL statements.

These logs are specifically enabled to audit activities that are of interest from an audit and compliance perspective.

Use this dashboard to:

  • Identify top SQL statements, trends, and commands that are being executed.
  • Get details on SQL statements and commands (DML, DDL, DCL, TCL) that are eing executed.
  • Identify user management activities.
  • Identify objects that have been dropped.

AuroraMySQL_Logs_AuditLogSQLStatements.png

Logs - General Log Analysis Dashboard

Aurora MySQL ULM Logs - General Log Analysis Dashboard allows you to view event details for general logs, including command types and trends, user activity and management, host activity, connections, and SQL statements.

Use this dashboard to:

  • Identify attempts at client connection and disconnection.
  • Identify authentication failures, along with their reason, for user and client host being used to connect.
  • Monitor failed authentication attempts along with total attempts to track anomalies.
  • Monitor failures by checking the executables the clients sent to the server.
  • Monitor the types of SQL statements and queries (DML, DDL, DCL, TCL, and others) that are sent by a client.

AuroraMySQL_Logs_GeneralLogAnalysis.png

CloudTrail Event - Overview Dashboard

Aurora MySQL ULM CloudTrail Event - Overview Dashboard allows you to view details for event logs, including geographical locations, trends, successful and failed events, user activity, and error codes.

Use this dashboard to get an at-a-glance overview of following:

  • Locations of successful and failed activities to check whether they're within compliance.
  • Event trends to identify if there is something different compared to typical patterns.
  • Users and the type of authentication method used.
  • Keep watch on reasons of failed activities to take corrective actions as the need be.

AuroraMySQL_CloudTrailEvent_Overview.png

CloudTrail Event - Details Dashboard

Aurora MySQL ULM CloudTrail Event - Details Dashboard allows you to view details for events, including creating, modifying, and deleting database clusters and database instances.

Use this dashboard to keep track of your Aurora MySQL Clusters and Instances. This dashboard provides details about various cluster and instance related activities, such as creation, modification, deletion and reboot of instances. Improper configuration of clusters and instances may have an adverse impact on performance. This dashboard helps to identify these issues from the details of the Aurora MySQL-specific events, so you can effectively remedy the situation.

AuroraMySQL_CloudTrailEvent_Details.png

Metric - Overview Dashboard

Aurora MySQL ULM Metric - Overview Dashboard allows you to view high-level analysis of Aurora MySQL database CPU utilization, connections, login failures, IOPS, latency, and memory usage.

Use this dashboard to:

  • Monitor the number of connections any given time, how many queries are executed per second, and CPU utilization.
  • Monitor the Volume Read/Write IOPS to ensure the database is optimally interacting with disk.
  • Monitor replica lags, and select latency and free memory to ensure it can support heavy read loads with sustained performance.
  • Detect failed login and connection attempts.

AuroraMySQL_Metric_Overview.png

Metric - Generic Dashboard

Aurora MySQL ULM Metric - Generic Dashboard allows you to view a high-level analysis of database latency, throughput, uptime, memory and storage capacity.

Use this dashboard to:

  • Monitor replica lags for applications with heavy read activity loads. Aurora supports read replicas with extremely low replica lags.
  • Monitor network traffic load and usage. In general, RDS supports monitoring its Network throughput. 
  • Monitor cache hit ratio, to analyze free memory from a query performance perspective.
  • Identify deadlocks, volume used in bytes, to analyze free local storage and engine uptime.

AuroraMySQL_Metric_Generic_Dashboard.png

Metric - Latency, Throughput, and IOPS Monitoring Dashboard

Aurora MySQL ULM Metric - Latency, Throughput, and IOPS Monitoring Dashboard allows you to view granular details on database latency, throughput, and IOPS.

Use this dashboard to:

  • Monitor the performance of database queries.
  • Monitor latency and throughput for performance analysis. 
  • Monitor, select, insert, update, delete, commit, DML and DDL latency and throughput.

AuroraMySQL_Metric_LatencyThroughputIOPS.png

Metric - Resource Utilization Monitoring Dashboard

Aurora MySQL ULM Metric - Resource Utilization Monitoring Dashboard allows you to view analysis of resource utilization, including usage, latency, active and blocked transactions, and login failures.

Use this dashboard to:

  • Monitor CPU Credit Usage/Balance, as well as disk usage for bin logs,
  • Identify active and blocked transactions.
  • Monitor bin og replica lag.
  • Monitor Result Set Cache Hit Ratio from a performance perspective.

AuroraMySQL_Metric_ResourceUtilizationMonitoring.png