All Products
Search
Document Center

Create a MySQL schema

Last Updated: Apr 25, 2019

Procedure

  1. Log on to the Data Lake Analytics console.

  2. In the left-side navigation pane, click Endpoint. In the endpoint list, locate the row that contains the target endpoint and click Log on in DMS in the Actions column. Run the following statement to create a MySQL schema in DLA:

    1. CREATE SCHEMA hello_mysql_vpc_rds WITH DBPROPERTIES (
    2. CATALOG = 'mysql',
    3. LOCATION = 'jdbc:mysql://rm-2zer0vg58mfofake.mysql.rds.aliyuncs.com:3306/rds_mysql_dbname',
    4. USER = 'rds_mysqldb_username',
    5. PASSWORD = 'rds_mysqldb_password',
    6. INSTANCE_ID = 'rds_mysql_instance_id',
    7. VPC_ID = 'rds_mysqldb_vpcid'
    8. );
    • VPC_ID: indicates the ID of the VPC where your MySQL instance is located, as shown in the following figure.

      1

    • INSTANCE_ID: indicates the ID of your MySQL instance. You can view the instance ID on the Instance Details page.

Next step

Create a MySQL table and read and write data from and to the table