Is there a way to configure HAProxy to stop sending queries to one of the nodes in a percona xtradb cluster if that node is running a very slow query i.e, bypassing the node processing the extremely slow query and send only to the other nodes until the node processing the extremely slow query becomes free?
HAProxy load balancing
167 Views Asked by The Georgia At
1
There are 1 best solutions below
Related Questions in CLUSTER-COMPUTING
- How to Socket.IO Multithreading on a Raspberry Pi?
- Snakemake remote rules re-read config file?
- Why can CPU memory be specified and allocated during instance creation but not GPU memory on the cloud?
- Make a Cluster without using MongoDB Atlas
- Why don't run at multiple thread?
- Imports failing with workaround in Google Dataproc Cluster Notebooks
- Galera Cluster: 3 Node Cluster, One Node does not reconnect after rebooting
- How to install gromacs on gcp HPC
- Slurm - How to run a list of jobs n by n?
- Setup Slurm partition for only interactive jobs
- makeCluster fails with remote server Ubuntu
- Creating a cluster with two laptops (mac)
- How to configure express-fileupload with cluster?
- problem in configuring dataproc cluster from GCP Console since Friday (1 february 2024)
- Kubernetes cluster refused to connect google cloud
Related Questions in HAPROXY
- HTTP 3 - How to resolve this error
- HAProxy frontend not serving html page
- Strange behaviour of Laravel application behind HAPROXY load balancer
- Set acl in haproxy based on client ip using map_ip
- ProxySQL as a backend for Wordpress results in login out user from wordpress
- Troubleshooting HAProxy Access Issue in Docker-Compose Setup
- redisClient error Error: Socket closed unexpectedly
- How to match only one specific path in haproxy and redirect the request to a backend service
- Replacing a part of the path by another URL on haproxy
- Sending HTTP request using TCP healthcheck
- How much backend does HAProxy can easily support?
- HAProxy SNI Based
- How to ignore signalr from balancing in HAProxy?
- Haproxy backend with SSL unable to talk to Istio Mesh
- Why can't HAProxy connect to my local server when my browser can?
Related Questions in PERCONA
- mysqlcheck or check mysql table without marking the table as corrupted
- Error during installation Prestashop using Percona 5.7
- How to isolate duplicate subvalues of a group by SQL statement
- Waiting for restore metadata - Percona Operator for MongoDb
- Percona Pmm helm upgrade failed: error converting YAML to JSON: yaml: line 14: did not find expected key
- pt-show-grant and root password protection
- Percona xtrabackup bypass xbcloud locally
- Percona XtraDB Cluster: Automatic Failover Between Nodes in Java Spring Boot Application
- Can ProxySQL auto failover in a Galera cluster?
- Mongodb ConnectionPoolExpired between it’s replica members
- MySQL errno: 24 - Too many open files
- MongoDB query execution time metric in prometheus
- MySQL 8 ALGORITHM=INSTANT taking a long time
- MySQL - The password hash doesn't have the expected format
- Is it possible to pass AWS VPC endpoints to overwrite the default ones in Percona
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You would have to modify the HAProxy monitoring script to consider long running queries in it's decision making process. This is not something that can be done via any built-in means; it would be completely custom written.