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
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.
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.
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 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.
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.