This topic describes how to configure an independent ApsaraDB RDS for MySQL database as the metadatabase of a Hadoop cluster in the E-MapReduce (EMR) console.
Prerequisites
An ApsaraDB RDS for MySQL instance is purchased. For more information, see Create an ApsaraDB RDS for MySQL instance.
Note In this topic, an ApsaraDB RDS for MySQL instance that runs MySQL 5.7 is used.
Limits
When you create an ApsaraDB RDS for MySQL instance, you must set Database Engine to MySQL 5.7 and Edition to High-availability.
Procedure
Step 1: Prepare a metadatabase
Step 2: Create a cluster
In the Basic Settings step, configure the parameters described in the following table. For more information
about the configurations of other parameters, see Create a cluster.
Parameter | Description | |
---|---|---|
Cluster Name | The name of the cluster. The name must be 1 to 64 characters in length and can contain only letters, digits, hyphens (-), and underscores (_). | |
Type | Select Independent ApsaraDB RDS for MySQL. | |
Connection URL | Set Connection URL to a value in the format of jdbc:mysql://rm-xxxxxx.mysql.rds.aliyuncs.com/<Database name>?createDatabaseIfNotExist=true&characterEncoding=UTF-8.
|
|
Database Username | Set this parameter to the username of the account created in Step 1: Prepare a metadatabase. | |
Database Password | Set this parameter to the password of the account created in Step 1: Prepare a metadatabase. |
Step 3: Initialize the metastore service
Notice For a Hadoop cluster, perform the following steps to initialize the metastore service
based on the Hive version.