MySQL Forums
Forum List  »  Utilities

Re: Load Balancing vs MySQL Fabric
Posted by: Rick James
Date: March 05, 2016 12:28AM

"Caching a connection" is at odds with "reconnecting after a server goes away".

In Fabric's case, the Fabric connector + Fabric node will (as I understand it) find the new place to connect to. Unfortunately, the Fabric node becomes the single-point-of-failure. So the question becomes one of hardening the Fabric node vs hardening the Master.

Even simple DNS A-records (and AAAA-records) is an approach to load balancing. It suffers from the tradeoff between short TTL versus pounding on the DNS server. But it has the SPOF pretty much solved -- you have a short list of hard-coded IP addresses of DNS servers.

Options: ReplyQuote


Subject
Views
Written By
Posted
1703
February 17, 2016 04:43PM
645
February 20, 2016 03:40PM
640
February 22, 2016 03:18AM
627
February 22, 2016 10:42AM
629
February 22, 2016 11:14AM
650
February 22, 2016 06:23PM
627
February 29, 2016 10:55AM
Re: Load Balancing vs MySQL Fabric
590
March 05, 2016 12:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.