Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1548

Shared connection

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Do
    • Affects Version/s: Icebox
    • Fix Version/s: N/A
    • Component/s: mariadbbackend
    • Labels:
      None

      Description

      In many environment, the latency between client and db is too high, to get better performance client need spawn more connections to cope with latency,but this may lead to contention problems.

      Put a proxy (mxs) between client and db, let proxy more closer to db(latency between proxy and db should be much more lower than latency between client and proxy), let multiple client connections share the same backend connection in order to reduce the contention;

      if can keep session state (session variables, temproary table, transaction ...) consistant will be better;

        Attachments

          Activity

            People

            Assignee:
            toddstoffel Todd Stoffel
            Reporter:
            dapeng dapeng huang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: