Serverless Metrics Integration Module for Cloud Databases
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Cloud hosted relational databases typically only send default metrics to monitoring services, limiting users' ability to send custom or user-defined metrics, which are essential for business-specific monitoring and alerting.
Innovation Solution
A platform, language, cloud, and database agnostic user-defined metrics integration module that uses a serverless function to fetch and send user-defined metrics from cloud hosted relational databases to cloud monitoring services, allowing deployment on any cloud provider and reducing dependency on cloud provider metrics monitoring.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If cloud hosted databases use default provider-defined metrics, then monitoring service integration is simple, but users cannot send custom or business-specific metrics to monitoring services
Solution Approach 1:
The patent introduces a metrics integration service as an intermediary component between the cloud database and monitoring services. This service receives custom metrics from the database, processes them, and forwards them to appropriate monitoring services, thereby enabling custom metrics transmission without requiring direct complex integration between the database and monitoring services.
Solution Approach 2:
The metrics integration service is configured with subscription information and automatically subscribes to relevant database metrics based on predefined rules. This self-service mechanism eliminates the need for manual subscription management and reduces integration complexity while enabling custom metrics to be sent to monitoring services.
2Adaptability or versatility
If users rely on cloud provider-defined metrics, then monitoring setup is straightforward, but business-specific monitoring needs cannot be met
Solution Approach 1:
The metrics integration service acts as an intermediary that captures custom business metrics from the database that would otherwise not be available to monitoring services. It selectively subscribes to and forwards specific custom metrics based on configuration, preventing loss of business-critical information while maintaining straightforward monitoring setup.
3Reliability
If custom metrics integration is implemented, then monitoring capabilities are enhanced, but integration costs and complexity increase
Solution Approach 1:
The metrics integration service automatically manages subscriptions to database metrics based on configured subscription information. It self-configures to subscribe to relevant metrics and manages the integration lifecycle, reducing the architectural complexity that would otherwise be required to achieve reliable custom metrics monitoring.
Solution Approach 2:
The metrics integration service is designed as a universal component that can work with multiple database types and monitoring services. It handles various metric types and formats through a unified interface, reducing the need for separate integration solutions for different scenarios and thereby lowering overall integration complexity while maintaining monitoring reliability.
Data Source
AI summary
Various methods, apparatuses/systems, and media for integration of user defined metrics of cloud hosted relational databases with cloud monitoring services are disclosed. A processor receives via a serverless function implemented within the processor a configuration file containing configuration of collection of database connection string and respective metrics query. The serverless function connects to the secrets provider to fetch a password or authorization token to connect with a plurality of different types of cloud hosted relational databases. The processor returns, in response to receiving the respective metrics query, a table with two columns where one column includes a user defined metric name and the other column includes the metric query to fetch a user defined metric value for the given user defined metric name from the databases; and automatically integrates the fetched user defined metric value of the databases with the cloud monitoring service.