[MDEV-6798] Porting wsrep_reject_queries from Percona XtraDB Cluster Created: 2014-09-26  Updated: 2014-11-03  Resolved: 2014-11-03

Status: Closed
Project: MariaDB Server
Component/s: Galera
Fix Version/s: 5.5.41-galera, 10.0.15-galera

Type: Task Priority: Trivial
Reporter: Guillaume Lefranc Assignee: Nirbhay Choubey (Inactive)
Resolution: Won't Fix Votes: 0
Labels: galera


 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.

 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2014-10-21 ]

Hi guillaumelefranc!

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

Comment by Nirbhay Choubey (Inactive) [ 2014-10-21 ]

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

Comment by erkan yanar [ 2014-10-22 ]

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

Comment by Guillaume Lefranc [ 2014-10-22 ]

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.

Comment by Nirbhay Choubey (Inactive) [ 2014-10-22 ]

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

Comment by Nirbhay Choubey (Inactive) [ 2014-11-03 ]

No use case for this FR could be found.

Generated at Thu Feb 08 07:14:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.