Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Loader/ Uploading the MySQL Database Connection Driver
Updated on 2024-10-09 GMT+08:00

Uploading the MySQL Database Connection Driver

Scenario

As a component for batch data export, Loader can import and export data using a relational database. Before connecting to a relational database, you need to manually upload the driver.

Procedure

Modify the permission on the JAR package of the relational database driver.

  1. Log in to the active and standby management nodes of the Loader service, obtain the driver JAR package of the relational database, and save it to the following directory on the active and standby Loader nodes: ${BIGDATA_HOME}/FusionInsight_Porter_xxx/install/FusionInsight-Sqoop-1.99.3/FusionInsight-Sqoop-1.99.3/server/webapps/loader/WEB-INF/ext-lib
  2. Run the following commands as user root on the active and standby nodes of the Loader service to change the permission:

    cd ${BIGDATA_HOME}/FusionInsight_Porter_xxx/install/FusionInsight-Sqoop-1.99.3/FusionInsight-Sqoop-1.99.3/server/webapps/loader/WEB-INF/ext-lib

    chown omm:wheel JAR package name

    chmod 600 JARpackage name

  3. Log in to FusionInsight Manager. Choose Cluster and click the target cluster name. In the navigation pane on the left, choose Services > Loader. In the upper right corner, choose More, select Restart Service, and enter the password of the administrator to restart the Loader service.