Install the Aurora MySQL ULM App and view the 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
- Dashboard filters
- Logs - Overview Dashboard
- Logs - Error Logs Analysis Dashboard
- Logs - Slow Query Dashboard
- Logs - Audit Log Analysis Dashboard
- Logs - Audit Log SQL Statements Dashboard
- Logs - General Log Analysis Dashboard
- CloudTrail Event - Overview Dashboard
- CloudTrail Event - Details Dashboard
- Metric - Overview Dashboard
- Metric - Generic Dashboard
- Metric - Latency, Throughput, and IOPS Monitoring Dashboard
- Metric - Metric - Resource Utilization Monitoring Dashboard
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:
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.