MySQL load balancing

frankenstine

Junior member
  • Oct 13, 2012
    177
    13
    18
    මචංලා ලොකු උදව්වක් ඕනේ ......මගේ final year research එකට කෙල වෙලා බන් ඉන්නේ. MySQL load balancing කරන්න දන්නා එකෙක් ඉන්නවද ? database optimization පැත්ත දන්න කෙනෙක් ඉන්නවා නම් support එකක් දීපං ......ලොකු උදව්වක් මචංලා ..........
     

    imhotep

    Well-known member
  • Mar 29, 2017
    14,825
    8
    35,335
    113
    This is a vast topic. Load balancers in general are available in hardware and software based solutions. Now there are even cloud based Load Balancing as a Services .
    You can use clustering or even SQL replication to provide load balancing. Again there are methods and algorithms used for load balancing.

    Load balancers are generally grouped into two categories: Layer 4 and Layer 7. Layer 4 load balancers act upon data found in network and transport layer protocols (IP, TCP, FTP, UDP). Layer 7 load balancers distribute requests based upon data found in application layer protocols such as HTTP.

    Typical software solutions can be HAProxy, ProxySQL or even by using the MySQL's Connector/j

    How you implement is based on the circumstances and probably you are looking for a general paper on SQL load balancing. If I can locate a brief one will send a link.
     

    Upasakaya

    Well-known member
  • Oct 10, 2017
    1,276
    164
    63
    This is a vast topic. Load balancers in general are available in hardware and software based solutions. Now there are even cloud based Load Balancing as a Services .
    You can use clustering or even SQL replication to provide load balancing. Again there are methods and algorithms used for load balancing.

    Load balancers are generally grouped into two categories: Layer 4 and Layer 7. Layer 4 load balancers act upon data found in network and transport layer protocols (IP, TCP, FTP, UDP). Layer 7 load balancers distribute requests based upon data found in application layer protocols such as HTTP.

    Typical software solutions can be HAProxy, ProxySQL or even by using the MySQL's Connector/j

    How you implement is based on the circumstances and probably you are looking for a general paper on SQL load balancing. If I can locate a brief one will send a link.
    ++
     
    • Like
    Reactions: imhotep