This topic describes the features of Database Autonomy Service (DAS).
- SQL review and optimization
- Analysis of slow SQL queries
- Storage analysis
- Performance trends
- Session management
- Full SQL statistics
- Diagnostic reports
- 24/7 anomaly detection
- Automatic SQL throttling
- Automatic SQL optimization
- Automatic SQL review and optimization
- Capacity assessment and specification recommendations
- Auto scaling
Monitoring and alerting
DAS allows you to centrally manage and monitor your on-premises databases and cloud databases. This reduces your management costs by more than 50%. The operational faults can also be significantly reduced.
- DAS allows you to monitor databases on a unified platform. You can monitor the performance
trends and real-time performance of all the database instances in different clusters
- Cost-effectiveness: DAS helps you monitor databases and spares you from hiring engineers to develop and deploy programs for data collection, computing, and storage.
- Various metrics: DAS collects, computes, and then displays a variety of key monitoring metrics that are related to database performance.
- Fine-grained monitoring: You can configure fine-grained monitoring to detect anomalies based on your business needs. The finest granularity is seconds.
- DAS allows you to configure alerting on a unified platform. You can create custom
alert rules for on-premises databases and cloud databases and configure alert notification
- Default alert template: You can use a variety of default alert templates for different types of database engines. These default templates are developed based on the experience in database O&M.
- Custom configuration: DAS supports custom alert templates. You can configure alert rules, alert contacts, and contact groups based on your business needs. This way, you can create alert templates for different users in your enterprise.
- Alert notification: DAS automatically checks whether alert notification is configured for all the database instances to which DAS is connected. If you do not configure alert notification for one of these database instances, DAS sends a notification message to you. This protects your business against damage.
Autonomy service for intelligent diagnosis and optimization
DAS provides 24/7 anomaly detection based on machine learning and fine-grained data monitoring. You can enable a variety of features, such as automatic SQL throttling, anomaly snapshots, automatic SQL review and optimization, automatic storage expansion, and auto scaling of computing resources. These features support a closed-loop diagnosis process. This helps you detect anomalies, analyze root causes, mitigate loss or optimize performance, track effects, and roll back operations or add knowledge to the knowledge base. The effect of performance optimization can also be quantified. This way, DAS ensures the service continuity of databases.
DAS supports autonomous scenarios without manual intervention. DAS can also continuously develop self-learning capabilities, such as automatic annotation of anomalies, case system setups, anomaly simulation, and quantitative feedback and assessment. DAS accumulates a large number of cases based on various online business scenarios. These cases continuously accelerate DAS development. This makes the autonomy service increasingly effective. DAS provides six core autonomous features based on the preceding concepts: 24/7 real-time anomaly detection, fault self-repair, automatic optimization, automatic parameter tuning, auto scaling, and intelligent stress testing.
- Data-driving capability: DAS collects large amounts of real-time data, such as performance metrics, SQL query logs, and logs of O&M changes. The detection capabilities are developed based on the collected data. You can detect real-time security threats and anomalies in runtime environments.
- Automatic decision-making capability: The deep integration of machine learning and database expert experience allows DAS to automatically make decisions in different business scenarios.
- Automatic execution capability: Tasks are automatically orchestrated and implemented based on decisions that are made by Autonomy Center.
- Closed-loop management: A closed-loop process is provided to coordinate operations and manage data in DAS. For example, after an anomaly is detected, DAS makes a global decision based on root cause analysis. DAS diagnoses the anomaly and optimizes performance based on the global decision. Then, DAS tracks and evaluates the effects of optimization and provides feedback. DAS also allows you to roll back the operations.
Enterprise-grade database management
DAS supports various monitoring scenarios based on years of database O&M and management experience of the Alibaba Cloud database team. The database instances that DAS monitors may be deployed across clusters and environments. DAS provides multi-module dashboards for you to view performance data of all database instances.
- Database management across environments or clusters
DAS allows you to monitor database instances across environments or clusters. You can perform aggregation and drill-down on monitoring metrics for a specific cluster or environment. DAS meets the requirements for enterprise-grade database management.
- Inspection and scoring
DAS inspects all the database instances to which DAS is connected. The inspection items include basic items, SQL statements, storage, performance, and security. Then, DAS generates a score for each database instance based on the inspection results. The score indicates the health status of a database instance.
DAS enables a wide range of features. For example, DAS identifies the following items for security: high-risk SQL queries, SQL injections, new access sources, and access to sensitive data. DAS also monitors databases in real time, audits full data, and detects suspicious access to databases and data breaches. This ensures data security.
DAS provides the following features for security audit:
- Identify SQL injections
- Identify high-risk SQL queries
- Identify new access sources