Learn more: www.calebcurry.com/blogs/database-clustering/intro-to-database-clustering Get ClusterControl: bit.ly/ClusterControl A load balancer is like another addition to your database that adds a layer of magic. The load balancer is a piece of software that will automatically balance how much each node is being hit to protect from overworking a particular node and slowing down the entire database cluster. If you did not have a load balancer, and you were writing a software application, you would manually decide what nodes to read and write from. This is not always good because you might not know ahead of time how well a particular node is going to keep up with your demands. With a load balancer, you make every piece of code talk to the load balancer, and then the load balancer will distribute the demands across the nodes. The load balancer of choice is ProxySQL! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! www.patreon.com/calebcurry Subscribe to my newsletter: eepurl.com/-8qtH Donate!: bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: CalebCurry.com Facebook: www.facebook.com/CalebTheVideoMaker Google+: plus.google.com/+CalebTheVideoMaker2 Twitter: twitter.com/calebCurry Amazing Web Hosting - www.dreamhost.com/r.cgi?1487063 (The best web hosting for a cheap price!)

Be the first to comment