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

A question about maxscale weights mechanism

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Trivial
    • Resolution: Won't Do
    • Affects Version/s: 2.1.17
    • Fix Version/s: N/A
    • Component/s: readwritesplit, Router
    • Labels:
      None
    • Environment:
      centos 6

      Description

      Sup, team! I have just a question about priority of servers with weight. For ex. i have config:

      # servers
      [ss_1]
      type=server
      address=mysql-ss-1.fr.local
      port=3306
      protocol=MySQLBackend
      s_weight=0
       
      [ss_2]
      type=server
      address=mysql-ss-2.fr.local
      port=3306
      protocol=MySQLBackend
      s_weight=0
       
      [ss_3]
      type=server
      address=mysql-ss-3.fr.local
      port=3306
      protocol=MySQLBackend
      s_weight=0
       
      [ss_4]
      type=server
      address=mysql-ss-4.fr.local
      port=3306
      protocol=MySQLBackend
      s_weight=0
       
      [ss_5]
      type=server
      address=mysql-ss-1.ms.local
      port=3306
      protocol=MySQLBackend
      s_weight=1
       
      [ss_6]
      type=server
      address=mysql-ss-2.ms.local
      port=3306
      protocol=MySQLBackend
      s_weight=1
       
      [ss_7]
      type=server
      address=mysql-ss-1.al.local
      port=3306
      protocol=MySQLBackend
      s_weight=110
      

      where ~99% of connections will be routed to mysql-ss-1.al.local and ~1% to mysql-ss-1.ms.local and mysql-ss-2.ms.local . When mysql-ss-1.al.local will be down, all of connections will be routed to mysql-ss-1.ms.local and mysql-ss-2.ms.local , and when they will be down too, all connections will be routed to other servers with weight 0. But what i should set to s_weight param, if i want to route 100% of connections to mysql-ss-1.al.local , then if it will be down, i want to route 100% of connections to mysql-ss-1.ms.local and mysql-ss-2.ms.local , and then if they will be down too, route 100% of connections to other servers ?

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            iglov Igor V. Lovalev
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration