Background and preparations

Preparations

Before you use DLA to read data from and write data to a PolarDB database, perform the following operations to prepare test data in the database:

1. Purchase a pay-as-you-go cluster.
   Notice

   • DLA and PolarDB must be deployed in the same region.
   • DLA connects to the PolarDB database over a virtual private cloud (VPC). We recommend that you select VPC as the network type when you create a PolarDB cluster.
2. Configure a whitelist for a cluster.
3. Connect to a PolarDB for MySQL cluster.
4. Write test data to a table in the PolarDB database.
   In this topic, the person table is created in the PolarDB database and test data is written to this table.

   ​CREATE TABLE person (
     id int(11) NOT NULL,
     name varchar(1023) NOT NULL,
     age int(11) NOT NULL,
     PRIMARY KEY (id)
   )
   insert into person 
     values (1, 'james', 10), 
            (2, 'bond', 20), 
            (3, 'jack', 30), 
            (4, 'lucy', 40);​

Usage notes

Before you connect DLA to a PolarDB database, you must add the Classless Inter-Domain Routing (CIDR) block 100.104.0.0/16 to a whitelist of the PolarDB cluster. For more information, see Configure a whitelist for a cluster.

Your PolarDB cluster resides in a VPC. By default, DLA cannot access resources in the VPC. To enable DLA to access your PolarDB database, you must use the reverse access technique of the VPC. You must add the CIDR block 100.104.0.0/16 to a whitelist of your PolarDB cluster.