OceanBase Admin Toolkit (OAT) allows you to manage tools. You can use OAT to deploy and manage OceanBase Database tools in a centralized manner. The following table describes the tools supported by OAT.
| Tool | Description |
|---|---|
| OBLB | OBLB is an open-source load balancing service based on iptables. It can be used as a soft load balancer for OceanBase clusters when external load balancing equipment (such as F5) is not available and the traffic volume is low. |
| OBClient | OceanBase Client (OBClient) is a CLI tool dedicated to OceanBase Database. You can use OBClient to connect to MySQL and Oracle tenants of OceanBase Database. |
| OpsToolkit | OpsToolkit is a CLI-based O&M toolkit for customers and O&M engineers. It contains two tools: obcli and obtcl. obcli is used to debug SQL statements, and obtcl is used to manage and maintain clusters. |
| SQL Diagnoser | SQL Diagnoser is an agile SQL diagnostic tool that can directly analyze business clusters to detect general suspicious SQL statements and hidden performance issues. |
| obdiag | obdiag collects logs of OceanBase Database and reads Automatic Workload Repository (AWR) reports. It collects data required for frontend support engineers to troubleshoot issues and reduces the costs of information exchange between frontend and backend support engineers. |
| OB-Loader-Dumper | OB-Loader-Dumper is a client tool for importing and exporting data. It can import schemas or data to OceanBase Database, and export object schemas from OceanBase Database to an SQL or CSV file. |
| Sysbench | Sysbench is a multi-threaded benchmark tool that tests the performance of CPUs, memory, threads, I/O disks, and databases. It evaluates database workloads in different system parameter settings. Note: ob-sysbench is a version of Sysbench dedicated for OceanBase Database. |
| OBLENS | OBLENS (OceanBase Lens) is a multi-source performance analysis platform that offers flexible deployment. Currently, it primarily operates with server deployment and client-side data push. OAT provides the client-side installation feature through a tool management approach. |
To manage tools, perform the following steps:
- In the left-side navigation pane, choose Product Service > Tools.
- Find the tool that you want to install and click Install Now.
- After the configuration is complete, click OK. You can also click Cancel to cancel the configuration.
The following table describes the installation parameters.
| Parameter | Description |
|---|---|
| Packages | The installation package. Select the version of the package that you want to install from the drop-down list. |
| Tool Name | The name of the tool to be installed. |
| Server | The IP address of the server on which the tool is to be installed. |
| Service Port | The port number of the server. |
Manage packages
OAT allows you to manage the installation packages of OBClient, OpsToolkit, SQL Diagnoser, ODG, OB-Loader-Dumper, Sysbench, and OBLENS. OAT supports packages in the .rpm, .zip, or .tar format and allows you to scan local files to obtain the package list. For more information, see Manage packages.