Select Your Language

Infrastructure and Management

Cloud Computing

Storage

Runtimes

Integration and Automation

  • Comments
  • multiple mysql instances in a cluster

    Posted on

    Can anyone tell me what the best approach to building a cluster ha with multiple instances of MySQL Or for having multiple servers accessing the same MySQL instance (diff databases of course)?

    I have two pairs of servers in an active-standby in a redhat cluster.

    App1/2 have Service A running that requires MySQL Database A access
    App3/4 have Service B running that requires MySQL Database B access

    Option1:
    One MySQL instance with both pairs having access to the MySQL service and databases A (app1/2) and database B (app3/4)

    Option2:
    MySQL service instance for App1/2 accessing database A and MySQL service instance for App3/4 accessing database B.

    I'm running RHEL 6.4 on all the servers and the databases will be on a shared SAN.

    Is there any performance differences with one option over the other?

    Thanks,
    Shane

    by

    points

    Responses

    Red Hat LinkedIn YouTube Facebook X, formerly Twitter

    Quick Links

    Help

    Site Info

    Related Sites

    © 2026 Red Hat