- Total activity 126
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 2
- Subscriptions 61
PostsRecent activity by Severalnines Support Sort by recent activity
Integration with ClusterControl
Once installed, the HAProxy instance is integrated within ClusterControl, so it is possible to view its status from the ClusterControl GUI, as seen in the below diagram. Clicking on the link bring...
Setting up HAProxy
Severalnines has created deployment scripts for HAProxy. These are available on GitHub.The scripts work with any Galera or MySQL Cluster setup that has been deployed using the Severalnines Configur...
Redundancy of HAProxy
Since all applications will be depending on HAProxy to connect to an available database node, one can have multiple HAProxy instances to avoid a single point of failure.One possible setup is to ins...
What happens when a database node fails?
When a database node fails, the database connections that have been opened on that node will also fail. It is important that HAProxy does not redirect new connection requests to the failed node. I...
What are the benefits of using HAProxy?
This setup simplifies a number of things: All applications access the cluster via one single IP. The topology of the database cluster is masked behind HAProxy. MySQL Connections are load-balanced ...
Failure Detection – how does it work?
There are several user definable parameters that determine how fast HAProxy will be able to detect that a server is not available.As default, the interval between health checks for a server that is...
Health Checks for MySQL
HAProxy determines if a server is available for request routing by performing so called health checks. By default, a health check consists of trying to establish a TCP connection to the server.This...
What is HAProxy?
HAProxy stands for High Availability Proxy, and is a great TCP/HTTP load balancer. It distributes a workload across a set of servers to maximize performance and optimize resource usage.A front-end ...
Limitations in Galera Cluster for MySQL
In MySQL-5.5.x/wsrep-23.x, Galera Replication has some limitations, these are documented in readme-wsrep. Galera replication originally only worked with InnoDB storage engine, but it now also supp...
Error: Cannot connect to Master
When adding a new slave, one would first have to add a new host using the ‘Host Management’ tab. This allows ClusterControl™ to provision the new host with a management agent. A Slave can be then a...