OceanBase Admin Toolkit (OAT) allows you to deploy and manage OceanBase Database tools in a unified manner. The following table describes the tools supported by OAT.
| Tool | Description |
|---|---|
| OBClient | OceanBase Client (OBClient) is a CLI tool dedicated to OceanBase Database. You can use it 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 for debugging SQL statements, and obtcl is used for managing and maintaining clusters. |
| SQL Diagnoser | SQL Diagnoser is an agile SQL diagnostic tool that can directly analyze business clusters to find 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 troubleshooting by frontend support engineers 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, disks, and databases. It evaluates the database workload in different system parameter settings. Notice: Sysbench in OAT is ob-sysbench, a reconstructed version for OceanBase Database. |
To manage tools, perform the following steps:
- In the left-side navigation pane, choose Product Service > Tool.
- Find the target tool 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 | 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 where the tool is to be installed. |
| Service Port | The port number of the server. |
Package management
OAT allows you to manage the installation packages of OBClient, OpsToolkit, SQL Diagnoser, ODG, OB-Loader-Dumper, and Sysbench. OAT supports packages in .rpm, .zip, and .tar formats, and it allows you to scan local files to obtain the package list. For more information, see Package management.