ApsaraDB for OceanBase:Lindorm data source

Background

When you create a Lindorm instance, the root and columnar_internal_user users are created by default. They have all permissions, including read, write, admin, trash, and system. When you use the data transmission service to migrate data from a Lindorm instance to OBKV, you can create a user and grant required permissions to the user as needed.

You need to enter the username in the Username field when you create a Lindorm data source.

Create a user for a Lindorm instance

1. Log on to the Lindorm console.

2. On the Instances page, click the ID of the target instance.

   

3. On the Instance Details page, click Access Control in the left-side navigation pane to add your client IP address to the allowlist.

   1. Run the ifconfig command to obtain the client IP address.

   2. On the Whitelists tab of the Access Control page, click Modify Group in the Actions column of the target allowlist.

      

      To add an allowlist, click Create Whitelist and complete related settings. For more information, see Configure an allowlist.

   3. Click OK.

4. Log on to the Lindorm Insight page.

   1. On the Instance Details page, click Wide Table Engine in the left-side navigation pane.

   2. On the right side of the Wide Table Engine page, click ClusterManagerInternet in the Cluster Management section.

      Important

      If you log on to the Lindorm Insight page for the first time, click Reset Ul Access Password in the Cluster Management section on the right side of the Wide Table Engine page, change the logon password, and then click ClusterManagerInternet.

      

   3. After you confirm that the client IP address has been added to the allowlist and the logon password has been changed upon initial logon, click OK in the dialog box that appears.

   4. In the Log On dialog box, specify Username and Password.

   5. Click Log On.

5. Create a user.

   1. On the Lindorm Insight page, choose Data Manager > User Manager in the left-side navigation pane.

   2. On the User Manager page, click Add user in the upper-right corner.

      

   3. In the Add User dialog box, specify Username and Password.

   4. Click OK.

      You can view this user on the User Manager page.

      

Grant permissions to a user of a source Lindorm instance

1. On the User Manager page, click More in the row of the target user and select Grant global permission.

   

   You can also grant permissions on namespaces or tables to the user. For more information, see Manage users.

2. In the Grant global permission dialog box, select READ and WRITE.

   When the Lindorm instance serves as the source, the user created for the Lindorm instance must have the READ permission for schema migration, full data migration, and full verification, and the WRITE permission for reverse incremental migration. Default permissions are sufficient for the user to perform incremental synchronization.

   

3. Click OK.