1 Reply Latest reply on Jul 23, 2004 3:03 PM by Steve Lewis

    Different connections for queries and updates

    posselt Newbie

      Hi there,

      Is it possible to specify a datasource with different nodes for updates and queries?

      I have access to a MySQL cluster with one write master and several read slaves.
      All write accesses have to go to the write master. Hence, with my current
      deployment, all read accesses also have to go to the write master instead of
      spreading them all over the read slaves.

      I could also deploy two different datasources, one beeing read only, however, I
      would have to tell the CMP to use them both and AFAIK this is not possible.