So keepalived has been around for quite a while now
.... however it is still a mystery to many.
So this is a very simple example of how keepalived can work
with MySQL. Hopefully, this can help those with questions.
We will have a Simple master to slave set up. Meaning.. we write
to one unless we have failover to the second for some
event.
1st - install keepalived
# yum search keepalived keepalived.x86_64 : Load balancer
and high availability service
Name and summary matches only, use "search all" for
everything. # yum -y install keepalived
You should now have an config file
# ls -ltr /etc/keepalived/keepalived.conf
Keep the original as you always backup .. right.... # cp
/etc/keepalived/keepalived.conf
/etc/keepalived/keepalived.conf.orig
So you need to figure out an ipaddress you can use for your
virtual …
Usually application don’t connect directly to Percona XtraDB Cluster, but go through a proxy – ProxySQL, for instance. However, if only one proxy node is used it becomes a single point of failure. Not long ago Marco Tusa wrote about how to configure two ProxySQL nodes in front of XtraDB cluster. If deployed on EC2 instances, it […]
The post Setup High Availability For ProxySQL via KeepAlived In AWS appeared first on TwinDB.
In this blog post, we’ll look at how to set up ProxySQL for high availability.
During the last few months, we’ve had a lot of opportunities to present and discuss a very powerful tool that will become more and more used in the architectures supporting MySQL: ProxySQL.
ProxySQL is becoming more flexible, solid, performant and used every day (http://www.proxysql.com/ and recent http://www.proxysql.com/compare). You can use ProxySQL for high availability.
The tool is a winner when compared to similar ones, and we should all have a clear(er) idea of how to integrate it in our architectures in order to achieve the best results.
The first thing to keep in mind is that ProxySQL doesn’t natively support any high availability solution. We can setup a cluster of …
[Read more]January 30, 2015 By Severalnines
| In this joint webinar series with our friends from the HAProxy team, we covered the concepts around the popular open-source HAProxy load balancer, and demonstrated how to use it with SQL-based database clusters. We also discussed HA strategies for HAProxy with Keepalived and Virtual IP. |
|
Thanks to everyone who participated in these two sessions this week! Please see below for details on next week’s follow up session 'Performance Tuning for HAProxy & MySQL'.
The topics covered this week included:
- What is HAProxy?
- SQL Load balancing for MySQL
- Failure detection using MySQL health checks
- High Availability with Keepalived and Virtual IP
- Use cases: MySQL/MariaDB Galera Cluster, MySQL NDB …
September 11, 2014 By Severalnines
Thanks to everyone who attended and participated in this week’s webinar on ‘Performance Tuning of HAProxy for Database Load Balancing’. And special thanks to our guest speaker, Baptiste Assmann of HAProxy Technologies.
If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.
Watch the replay of this webinar to learn about what HAProxy can tell you about your application and database instances. And understand the difference between short-lived connections and persistent connections, and how they affect the performance and availability of your applications.
Watch the replay Performance …
[Read more]June 17, 2014 By Severalnines
We continuously see great interest in MySQL load balancing and HAProxy, so we thought it was about time we organised a live webinar on the topic!
As most of your will know, database clusters and load balancing go hand in hand.
Once your data is distributed and replicated across multiple database nodes, a load balancing mechanism helps distribute database requests, and gives applications a single database endpoint to connect to.
Instance failures or maintenance operations like node additions/removals, reconfigurations or version upgrades can be masked behind a load balancer. This provides an efficient way of isolating changes in the database layer from the rest of the …
[Read more]This is a followup to Jay Janssen’s October post, “Using keepalived for HA on top of Percona XtraDB Cluster.” We got a request recently where the customer has 2 VIPs (Virtual IP addresses), one for reader and one for a writer for a cluster of 3 nodes. They wanted to keep it simple, with low latency and does not require an external node resource like HaProxy would.
keepalived is a simple load balancer with HA capabilities, which means it can proxy TCP services behind it and at the same time, keep itself highly available using VRRP as failover mechanism. This post is about taking advantage of the …
[Read more]Percona XtraDB Cluster (PXC) itself manages quorum and node failure. Minorities of nodes in a network partition situation will move themselves into a Non-primary state and not allow any DB activity. Nodes in such a state will be easily detectable via SHOW GLOBAL STATUS variables.
It’s common to use HAproxy with PXC for load balancing purposes, but what if you are planning to just send …
[Read more]April 26, 2013 By Severalnines
This post shows you how to move from a single instance Drupal/MySQL to a multi-server environment. A well designed multi-server deployment not only allows Drupal to scale, but will also enhance redundancy by removing single points of failure. Components used are Apache, PHP, csync2, lsyncd, Keepalived, HAproxy, MySQL Galera Cluster and ClusterControl.