Configure MySQL External Database

Follow these steps to configure MySQL external database.

  1. Create the database and user for DLM Engine. Replace the username, password, and the dbname.
    
    CREATE USER beacon IDENTIFIED BY 'beacon';
    CREATE DATABASE beacondb;
    GRANT ALL PRIVILEGES ON beacondb.* TO beacon@'%';
    flush privileges;
    
  2. Setup the mysql connector in Ambari.
    If Ambari is not already setup with mysql connector, follow these steps:
    1. Download mysql connector.
    2. Setup the connector in Ambari.
      ambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/mysql-connector-java.jar