DLM Installation and Upgrade
Also available as:
PDF

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'@'%' IDENTIFIED BY 'password';
  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