Log Data Directory Not Set for A MySQL Auto-Discovered Instance

Article ID: MSQL0018 A MySQL auto-discovered instance does not have a value set for the log data directory.

Symptom

A MySQL auto-discovered instance does not have a value set for the log data directory.

Cause

No value is set for the log data directory because the --log-bin parameter and the datadir parameter are not set for the command line or the configuration file.

Resolution

To resolve this problem, you can use one of the following procedures:

  • In the auto-discovered instance, update the value for the log data directory.
  • If binary logging is enabled, complete the following steps:
    1. Do one of the following:
      • Add the value to the log-bin parameter in the config file.
      • Start the MySQL server with --log-bin = <log_file_name> parameter.
    2. Delete the incomplete instance that was created, and then discover the instance again.
  • If binary logging is disabled, complete the following step:
    1. Do one of the following:
      • Add the data directory value to the datadir parameter in the config file.
      • Start the MySQL server with the --datadir = parameter.
    2. Delete the incomplete instance that was created, and then discover the instance again.