June 19, 2013

Comment: Percona XtraDB Cluster reference architecture with HaProxy

… Zoltan, That might cause an issue if there is a failover during that time, and the application doesn’t handle that… having the connection made, until it’s necessary. In this haproxy configuration, the timeout on the client and on the server…, or timeout values in the TCP stack for the database, haproxy and the application also.

Comment: Lighttpd as reverse proxy

… “HAproxy” in front for reverse proxy and load balancing. It’s VERY fast to parse HTTP requests and it handle failover. It… a lot of traffic, you should look at this :) http://haproxy.1wt.eu/

Comment: How to start a Percona XtraDB Cluster

… if node1 goes down and node2 receives writes (e.g failover in haproxy to write to node2 instead of node1)… when node1…

Comment: Percona XtraDB Cluster reference architecture with HaProxy

Hello Peter, Can you please provide an example how would I need to set up the haproxy for separating the traffic via mysql read for roundrobin and the mysql write failover configuration. It would help me alot. Thanks

Comment: Migrating to XtraDB Cluster Webinar follow up questions

… use this in master-slave mode, and it brings back failover and slave promotion issues like you have with MySQL replication… must not use master-master load balancing!) Q: In the haproxy example, how do you specify with xtradb cluster the different…

Comment: How Does Semisynchronous MySQL Replication Work?

… problems with combining it to master/master circular replication and haproxy load balancing queries in front of mysql servers) and others… and allows to have data integrity, high availability and easy failover with MySQL ? Would be happy to have your thoughts/comments…