Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6798

Porting wsrep_reject_queries from Percona XtraDB Cluster

        Details

          Description

          Hello,

          this is a feature request to port the following commit to MGC:
          http://bazaar.launchpad.net/~raghavendra-prabhu/percona-xtradb-cluster/pxc-1179805/revision/442

          https://launchpad.net/bugs/1179805
          Bug1179805: wsrep variable to reject queries

          This commit adds a variable wsrep_reject_queries which can take 3 values:

          a) NONE - default - nothing is rejected.

          b) ALL - all queries are rejected with 'Error 1047: Unknown command'.

          c) ALL_KILL - all queries are rejected and existing ones are also
          aborted without waiting.

          Thanks in advance.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

                Hi Guillaume Lefranc!

                What are the possible use cases of this option? I see that once
                its set (ALL), mysqldump cannot be used on the node.

                Show
                nirbhay_c Nirbhay Choubey added a comment - Hi Guillaume Lefranc ! What are the possible use cases of this option? I see that once its set (ALL), mysqldump cannot be used on the node.
                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

                http://lists.askmonty.org/pipermail/commits/2014-October/006819.html

                Show
                nirbhay_c Nirbhay Choubey added a comment - http://lists.askmonty.org/pipermail/commits/2014-October/006819.html
                Hide
                Permalink
                erkules erkan yanar added a comment -

                So this is good for the connected session only?
                So afaik it is useless. At least when you want to work inside the database.

                Show
                erkules erkan yanar added a comment - So this is good for the connected session only? So afaik it is useless. At least when you want to work inside the database.
                Hide
                Permalink
                tanj Guillaume Lefranc added a comment -

                Nirbhay, unfortunately I don't remember the original use case for this feature. If mysqldump cannot be used, indeed, it sounds like a useless idea.

                Show
                tanj Guillaume Lefranc added a comment - Nirbhay, unfortunately I don't remember the original use case for this feature. If mysqldump cannot be used, indeed, it sounds like a useless idea.
                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

                Asked a question : https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1179805/comments/8

                Show
                nirbhay_c Nirbhay Choubey added a comment - Asked a question : https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1179805/comments/8
                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

                No use case for this FR could be found.

                Show
                nirbhay_c Nirbhay Choubey added a comment - No use case for this FR could be found.

                  People

                  • Assignee:
                    nirbhay_c Nirbhay Choubey
                    Reporter:
                    tanj Guillaume Lefranc
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: