Database Administration

database administration

Database Administration is Easy with ClustrixDB

ClustrixDB Database Administration

Database administration has many moving parts: performance monitoring, database or mysql administration, tracking transactions per second, optimizing query performance and much more.  

ClustrixDB’s browser-based web UI makes database administration easier. The ClustrixDB database administration UI provides a user-friendly view into current demands on the database, delivering easily-accessible performance monitoring metrics on current transactions per second, CPU utilization, latency, and query performance. The Clustrix database administration UI  provides all sorts of new capabilities for database performance monitoring, like identifying and remedying potential hiccups and slowdowns, all accessible via five main sections on the dashboard.

Key Capabilities for Database Performance Monitoring

ui database administration


View all important cluster attributes

The 'Health' dashboard is designed to give a quick high-level overview of database cluster health and activity. There are graphs of each of the five main cluster attributes: transactions per second, CPU utilization, in-memory table utilization, storage, and read and write latencies. All data is updated every 5 seconds.

queries database administration


View into query performance

The 'Queries' tab has two distinct views that show the query performance for current and recent queries. The views display all currently executing queries and queries that have recently completed, along with metrics such as the number of times the query was executed, the amount of rows read by the associated query, the database on which the query executed, and more.

graphs database administration


Monitor performance of clusters over time

The 'Graphs' tab displays important database attributes over a user-specified interval. The default interval is 24 hours, but can be range from 15 minutes to 7 days.

There are multiple categories of graphs for performance monitoring, including performance, diagnostic, queries and rows, locks, sessions and transactions, replication, and disk.

compare database administration


Compare cluster performance attributes  

The 'Compare' tab allows users to compare two sets of database performance attributes at two different points in time. The default attributes are CPU min/max/average, and query latency. Values displayed for viewing include the queried database, the query statement, and the amount of rows read by a query.

flex database administration


Add or remove nodes for elastic scale

The 'Flex' tab displays all the nodes and node statuses of the current cluster and allows the cluster to be expanded and reduced in size. The Clustrix UI includes an option to quickly and easily drop a node, which simply marks the node as softfailed. You can also easily add a node to your cluster, or flex out, to expand capacity for ease of database administration.

Elastic Scale: For the Ultimate in Database Performance Management

In addition, the UI also includes database administration tools that allow for more control and visibility for easily increasing and decreasing database resources in response to changes in demand (flex out/flex in).  It also provides detailed information on Clustrix’s utilization of in-memory resources – letting the administrator know well in advance of potential issues with capacity and performance.

In addition, the UI can be displayed with a light or dark background, depending on preference.

ClustrixDB provides a visual summary of your database cluster. Quickly review key database performance metrics including transactions per seconds, CPU utilization, and both read and write latency.

Quickly diagnose and resolve most database performance issues with detailed information about key metrics and easy comparisons to spot anomalies and outliers.

Need more information?

Check out our resources page to view white papers, case studies, and more or get in touch with our experts.