• MapReduce Service

mrs
  1. Help Center
  2. MapReduce Service
  3. User Guide
  4. Using MRS
  5. Using Loader
  6. Preparing a Driver for MySQL Database Link

Preparing a Driver for MySQL Database Link

Scenario

As a component for batch data export, Loader can import and export data using a relational database.

Prerequisites

You have prepared service data.

Procedure

  1. Download the mysql-connector-java-5.1.21.jar MySQL JDBC driver from the MySQL official website.
  2. Upload mysql-connector-java-5.1.21.jar to the /opt/Bigdata/FusionInsight/FusionInsight-Sqoop-1.99.7/FusionInsight-Sqoop-1.99.7/server/jdbc Loader installation directory on active and standby MRS master nodes.
  3. Change the owner of mysql-connector-java-5.1.21.jar to omm:wheel.
  4. Modify the jdbc.properties configuration file.

    Change the key-value of MYSQL to mysql-connector-java-5.1.21.jar, for example, MYSQL=mysql-connector-java-5.1.21.jar.

  5. Restart Loader.