Direct load

This topic describes how to enable and disable the direct load port in the OceanBase Cloud console.

Overview

OceanBase Database allows inserting data into the database through direct load. This feature bypasses the traditional SQL layer interface and writes data directly to the database files, thereby improving the efficiency of data import. For more information, see Direct load overview.

Prerequisites

When you use direct load, check the following conditions. You can enable the direct load port only when the following conditions are met.

• The instance is in the running state.

• The tenant is in the running state.

• The database version is V4.0.0 or later.

• The database proxy version is V4.3.0 or later.

  Note

  If the version does not meet the requirements, contact OceanBase Technical Support for assistance with the upgrade.

Enable direct load

1. Log in to the OceanBase Cloud console.

2. In the left-side navigation pane, click Instances.

3. On the Instances page, click the name of the target instance to go to the Overview page.

4. In the left-side navigation pane, click Database Proxy.

5. In the Database Proxy section, click Enable next to the Direct Import Port field to enable the direct load port.

After you enable direct load, you can use OceanBase Loader and Dumper to import data. For more information, see Direct load.

Disable direct load

In the Database Proxy section, click Disable next to the Direct Load Port field to disable the direct load port.