[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] DB Failover Load Balancer
- Subject: [ale] DB Failover Load Balancer
- From: DJPfulio at jdpfu.com (DJ-Pfulio)
- Date: Mon, 20 Jul 2015 16:18:16 -0400
- In-reply-to: <CAOXayVsM=eL4NsKHmjTE+zs898gdmOLza91j=2+x2ZKsZNDQwQ@mail.gmail.com>
- References: <CAOXayVsM=eL4NsKHmjTE+zs898gdmOLza91j=2+x2ZKsZNDQwQ@mail.gmail.com>
On 07/20/2015 03:32 PM, Robert L. Harris wrote:
> Guys,
> I'm setting up an HAProxy to balance between some web servers. Working
> great with a least-used mode.
>
> The next step is to balance between 2 databases but I don't want them in
> a round robin or even 'normal' balancing. The DBA's are setting up
> one-way data replication only ( long argument they are refusing to explain
> ). So I need to have 2 hosts in a 'cluster' with HostA as the
> single/primary and if it goes down, fail over to HostB. If HostA comes
> back up, do NOT fail back to HostA until manually told to do so ( data
> re-sync, etc ).
>
> Any thoughts? I don't see an option to configure HAproxy in this type of
> config.
Load balancing web front-ends is VERY different from doing an HA solution for a
DBMS. HA-proxy fits for web, but not for DBs.