Help Center > > User Guide> MRS Cluster Component Operation Guide> Using Loader> Preparing a Driver for MySQL Database Link

Preparing a Driver for MySQL Database Link

Updated at: Dec 31, 2019 GMT+08:00

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/MRS_XXX/install/FusionInsight-Sqoop-1.99.7/FusionInsight-Sqoop-1.99.7/server/jdbc Loader installation directory on active and standby MRS master nodes. In which xxx indicates the MRS version.
  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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel