The xPanel application provides an easy to use graphical interface to launch eXtremeDB tools and to simplify the configuration of xSQL configuration files.
The dashboard interface provides the following interactive graphical utility modules, and easy access Help to explain how to use each module:
- The xSQL Configuration Tool - facilitates creating new and modifying existing xSQL configuration files. eXtremeDB xSQL is a powerful and highly configurable database server that can manage local, remote and distributed eXtremeDB databases. The xSQL configuration file is a JSON formatted file that includes a variety of configuration parameters that determine xSQL and eXtremeDB behavior.
- The Web Service Connectors Tool - creates and configures connectors that enable xPanel to interact with the eXtremeDB Web Services tools such as the Performance Monitor, the SQL System Analyzer and the debug Tracer. Connectors establish binding relationships between SQL servers accessing eXtremeDB databases and the webserver that exposes RESTful Web Services associated with the xPanel tools. This binding is a "logical connection" that facilitates the RESTful communication between the tools' Web Services and the SQL server application. Connectors can be grouped for convenience when managing multiple (sometimes hundreds) of connections.
- The SQL System Analyzer - provides real-time eXtremeDB SQL engine information and allows monitoring the state of the SQL server without the need to attach a debugger to the server process. The SQL System Analyzer collects and visualizes SQL processing statistics, statement execution and transmission times, memory consumption while running statements, error status, result sets sizes and more. The Analyzer reads and displays various underlying operating system resource usage for the process running the statement. Information includes kernel-space and user-space times, the total swap size and the number of context switches during the statement execution as well as the number of bytes read and written to the persistent media.
- The Performance Monitor - provides a comprehensive, real-time view of various factors affecting performance of database applications. The Monitor easily connects to your database application or to the eXtremeDB xSQL server through Web Service Connectors. The Performance Monitor retrieves and displays the database application’s underlying CPU load, memory utilization and storage I/O, collects and analyzes various database runtime counters, metrics and statistics. The Monitor is a powerful performance turning tool that helps quickly locate bottlenecks and troubleshoot database performance problems.
- The SQL Query Console - provides the capability to execute ad hoc SQL statements against an eXtremeDB database and view the results of queries.
- The Tracer - displays the contents of a trace-log-file that tracks runtime activity of specific eXtremeDB modules. By specifying the individual modules to enable for tracing and the severity level in the xSQL configuration file, users control the debug output that gets written to the trace-log file. Then, a Web Service Connector can be assigned to Tracer which downloads the trace-log-file and periodically updates the output in the Tracer panel.