New answers tagged

0

If you hover your mouse over underscored number in Sessions->Total and you will see something like this:


0

I have the same issues. Check for 'slow queries'. That is priority 1. Don't think there are none, there is always something to find. use SSD disks Here are my settings (Most imporant once) [galera] innodb_autoinc_lock_mode=2 wsrep_provider_options=gcache.size=512M;gcache.recover=yes wsrep_causal_reads=ON wsrep_slave_threads=24 ...


1

If you are using metalb, I think you don't need to have an external vm with haproxy, you could install an ingress controller in kubernetes and change the service type of the ingress controller to LoadBalancer. Now You will have an external ip in your lan to access your local service through the ingress controller ip. (Internet) -> (Router) -> Nat -> ...


1

After adding below line under frontend section, logs are now generating in log file. log 127.0.0.1:514 local0 debug


0

Solution The open files limit can be increased. … the per-process hard limit is set to 1048576 by default, but it can be changed using the "fs.nr_open" sysctl. From: HAProxy Management Guide | 5. File-descriptor limitations I've stumbled upon a useful resource on how to increase fs.nr_open. This is what I ended up doing (on my host machine): # 0. ...


-1

How could we configure in a load balancer like HA Proxy to split read operation from writes and send to node 2 and 3 only read operations? Not at all. There is no way that a load balancer would know what happens in a SQL Server connection and understand logically what can and what can not be considered a read only or a write only or a mixed (which is a ...


1

I found the solution by editing my wild card as below. acl k8s_domain hdr(host) -m reg -i ^(?!auth)[^\.]+\.web\.simoncarr\.co\.uk$


2

Workaround that hides haproxy stats.cfg password is using environment variable value instead of password in a configuration file. This way stats.cfg may look like: listen stats bind *:1936 mode http stats auth admin:"$PASS" ... PASS environment variable holds the password. The password could be populated via ...


Top 50 recent answers are included