DBmarlin 4.8.0 Introduces RBAC, ServiceNow Integration & Additional Features
In the DBmarlin latest version 4.8.0 supports Role-based access control (RBAC), alerting to ServiceNow, additional contention information for CockroachDB and more.
Role-Based Access Control (RBAC)
Role-Based Access Control (RBAC) in DBmarlin is an essential feature that provides granular control over user access, allowing administrators to define permissions tailored to each user’s needs. This functionality is particularly beneficial for enterprises that manage extensive database environments, where multiple team members may need access to various resources but at different permission levels. RBAC ensures that sensitive data is accessible only to authorized personnel, reducing security risks and enforcing accountability across teams.
DBmarlin offers two primary roles: Administrator and Regular user. Administrators hold full control and can access all databases within DBmarlin, making them responsible for managing configurations, monitoring system health, and troubleshooting. Regular users, on the other hand, are limited to specific database instances, which are assigned to them by an Administrator. The access for Regular users is managed through instance tags, providing flexibility in assigning permissions based on criteria relevant to the organization. For example, administrators could grant users access only to instances tagged as “App=retail” or “Region=Hyderabad” Such configurations enable tailored access control, ensuring users only see the databases necessary for their roles.
ServiceNow Integration
DBmarlin has recently introduced support for ServiceNow integration, allowing for seamless alert management within this widely used IT service management platform. ServiceNow enables IT teams to automate workflows, manage incidents, and streamline operations. With this integration, DBmarlin users can configure database alerts to automatically generate incident tickets in ServiceNow, facilitating faster responses to database issues. This feature enhances cross-team collaboration by integrating database monitoring within the broader IT ecosystem, ensuring that database-related incidents are documented and tracked alongside other IT infrastructure issues.
CockroachDB Transaction Contention Monitoring
DBmarlin 4.7 has expanded its capabilities with a transaction contention monitoring feature for CockroachDB. The new screen includes a real-time chart that visually displays contention patterns, offering insights into transaction delays and bottlenecks. This feature is complemented by a detailed tabular view, listing blocked and waiting transactions and their associated SQL statements. With these tools, database administrators can more effectively identify and resolve contention issues, minimizing delays and improving database performance.
Azure SQL CPU and Memory Metrics Monitoring
As part of the DBmarlin 4.8 update, users now have access to CPU and memory metrics for Microsoft Azure SQL databases. Unlike on-premises databases, Azure SQL operates within a managed environment where the underlying operating system is maintained by Azure. DBmarlin addresses this limitation by collecting metrics directly from SQL Server queries, bypassing the need for host sensors. This enhancement allows users to monitor database resource consumption, helping them identify potential performance issues and optimize resource allocation within their Azure SQL instances
