MySQL instance for those features alone ala:
http://flavio.tordini.org/a-more-stable-mysql-with-haproxy
If you are looking to load balance multiple database servers, I think haproxy
is a good choice for doing that.
It will work great as long as everything is functioning normally, but you
Hello everyone,
I'm looking for documentation to make a load balancer for mysql.
I found this article :
https://www.digitalocean.com/community/articles/how-to-use-haproxy-to-set-up-mysql-load-balancing--3
What do you think?
We also perform a test with LVS load balancing for mysql.
Have you
In the past I've used a ludicrously high setting on the primary for
rise, the number of health checks it has to pass before it's
considered to be up again.
It's definitely a hack, though that's not to say I haven't used it in
production ;-)
Jonathan
--
Jonathan Matthews
Oxford, London, UK
How about handling it on the backend. Setup your health checks on a different
port and forward that port with iptables to the actual health check. When you
fail over to the slave have some automation that detects that and shuts down
iptables on the master. When your ready to receive traffic
Hi,
We are using HAProxy to check for MySQL availability and failing over to a
slave. Is it possible to stop HAProxy going back to the master once it is up?
We want that to happen after manual intervention.
Regards,
Jayadevan
DISCLAIMER: The information in this e-mail and any attachment is
❦ 12 décembre 2012 14:45 CET, Baptiste bed...@gmail.com :
Maybe some of you already experimented source port exhaustion.
Here is a blog post giving some information about it:
http://blog.exceliance.fr/2012/12/12/haproxy-high-mysql-request-rate-and-tcp-source-port-exhaustion/
Great post
there, not in the
frontend nor a listen section!). It will cause RSTs to be sent to the
server when closing the connection. If this helps, it means there are
TCP sessions stuck somewhere in the chain.
Other servers get their ACK, and work as expected.
haproxy and mysql have iptables/firewall rules.
haproxy as std
the haproxy
access:
insert into user (Host,User) values ('192.168.1.3','haproxy'); (The
users table has the ndbcluster engine, for that the permissions are
replicated inmediatly)
Then I modify my haproxy.conf like this:
listen MySQL_Node 192.168.1.3:3306
mode tcp
option mysql
are
replicated inmediatly)
Then I modify my haproxy.conf like this:
listen MySQL_Node 192.168.1.3:3306
mode tcp
option mysql-check user haproxy
option tcplog
balance roundrobin
server mysqlnode1 192.168.1.1 check port 3306 weight 50
server mysqlnode2
server mysqlnode2 192.168.1.2 check weight 50
The problem comes when I try to make a request to the haproxy:
mysql -uuser -ppass -h 192.168.1.3 test -e select * from test1;
It works well but if I reboot the service (haproxy) the request
doesn't work; I obtain the next error:
Host is blocked because
server mysqlnode1 192.168.1.1 check weight 50
server mysqlnode2 192.168.1.2 check weight 50
The problem comes when I try to make a request to the haproxy:
mysql -uuser -ppass -h 192.168.1.3 test -e select * from test1;
It works well but if I reboot the service (haproxy) the request
Hi Manoj,
On Sun, Aug 14, 2011 at 09:28:33PM +, Manoj Kumar wrote:
Hi,
Is there any way to forward mysql client ip address to backend mysql. We have
Mysql servers frontend by haproxy but when we check the processlist on mysql
servers it is showing IP address of the haproxy. We can
I want to use HAPROXY between a slow mysql clients and a mysql server to
minimize database interaction time. The large network latency between the
client and database is currently a performance bottleneck. The database is
often occupied serving result-data to the slow client.
In my new setup the
the client has acked the data and closed its side. For that, maybe
a mysql proxy might be better (never tried though).
If so, where can I find examples how to configure HAPROXY?
There is a very good article by Alex Williams about haproxy + mysql,
I'm sure you can find useful info there :
http
Dnia 2010-02-09, wto o godzinie 19:37 +0100, Berco Beute pisze:
I want to use HAPROXY between a slow mysql clients and a mysql server
to minimize database interaction time. The large network latency
between the client and database is currently a performance bottleneck.
The database is often
Hi, I'm trying to use HAProxy as round robin load balancer for 2 MySQL
servers. I'm using mysqlslap for benchmarking.
At the moment I figured that load balanced connection is slowest in times.
I need explanation from HAProxy experts why ?
There is my config:
cat /etc/haproxy/haproxy.cfg
global
To: haproxy@formilux.org
Subject: HAProxy and MySQL
Hi, I'm trying to use HAProxy as round robin load balancer for 2 MySQL servers.
I'm using mysqlslap for benchmarking.
At the moment I figured that load balanced connection is slowest in times. I
need explanation from HAProxy experts why
Hello,
I am considering using haproxy with mysql. Basically one server, and one
backup server. Has anyone used haproxy with mysql? What were your
experiences (good and bad)? What values do you use for timeouts, etc.?
Thank you.
18 matches
Mail list logo