Discovery > Discovery Modules > Database > MySQL Replication Between Databases Discovery > Troubleshooting and Limitations – MySQL Replication Between Databases Discovery

Troubleshooting and Limitations – MySQL Replication Between Databases Discovery

This section describes troubleshooting and limitations for MySQL Replication Between Databases discovery.

  • There are two main approaches to running several active MySQL instances on one host:

    • Two MySQL instances are each run on a different port, for example, one on 134.44.1.1:3306 and the second on 134.44.1.1:3307.

    • A host has several IPs, and each MySQL process is bound to its own IP, for example, 134.44.1.1:3306 and 134.44.1.2:3306.

    In the second case, as the key identifier that differentiates one MySQL CI from another is a port number (without an IP), the job cannot differentiate between the two MySQL instances and merges them into one CI.