This page outlines some frequently used utilities and tools available within ClustrixDB.
|Table of Contents|
ClustrixDB requires an external TCP load balancer to balance queries across a cluster. Clustrix recommends HAProxy as a load balancer. For more information, see Load Balancing ClustrixDB with HAProxy.
To access ClustrixDB from the command line, run MySQL from a command line prompt.
Because ClustrixDB is MySQL compatible, many third party tools such as MySQLWorkbench, TOAD, etc. will work seamlessly with ClustrixDB.
Depending on your specific needs, there are numerous options for loading data onto ClustrixDB:
See also Loading Data Onto ClustrixDB.
ClustrixDB includes ClustrixGUI Administration UI for cluster administration.
ClustrixDB’s server logs enable users and Customer Support to understand the queries and events that occur on a ClustrixDB cluster. All the logs created by ClustrixDB are placed, by default, in the /data/clustrix/log directory (this is configurable) and there are a separate set of logs for each node of your cluster. The logs used most frequently are query.log and clustrix.log.
The clustrix.log is a chronology of events that occur on your cluster. It includes alerts that are also logged to a separate log file - alert.log. Please see Database Alerts to establish the necessary alerts for your cluster.
ClustrixDB includes a general-purpose command line utility called clx for monitoring and managing a cluster. A single clx command is automatically processed in parallel on all nodes of a cluster. It is located in the /opt/clustrix/bin/ directory.
For a list of the processes that nanny monitors and controls, please refer to this Overview of Nanny.
Performance statistics are automatically collected by statd in the clustrix_statd database. The resulting statistics can be assessed by querying the tables directly or by viewing them with the ClustrixGUI administrative tool.
For a recap of the statistics gathered and some potential ways to analyze them, see Monitoring Your Cluster Using statd.
Clustrix regularly provides both major and minor releases to continuously improve its product's performance, functionality, scalability, and stability. Each release passes a thorough and rigorous quality assurance process before it is released to our customers.
For specifics on how to upgrade ClustrixDB, see Upgrading ClustrixDB.
Your application and database may experience fluctuating transaction volumes due to seasonal changes. The underlying design of ClustrixDB enables it to easily and uniquely adapt to those changes. To increase your cluster’s capacity, simply add more nodes. Conversely, if transaction volume subsequently declines, removing nodes to decrease costs is equally painless. See Flex Up and Flex Down for specifics.
ClustrixDB includes a fast parallel backup and restore feature. For backups, each ClustrixDB node sends its data directly to the backup target in parallel, allowing for concurrency and for backup performance to scale with cluster size. Similarly, the restore operation is initiated on one node and that node coordinates with all other nodes of the cluster to read from the backup file and restore data throughout the cluster in parallel.