Dynamic load balancing middle-ware for heterogenous database partitions case study: MYSQL databases

Abstract

In the recent past we have seen people and organizations appreciate the use of Information and Communication Technology (ICT), as this happens massive data has been generated, replicated and stored for future use. These dataset has grown to unimaginable size the I.T experts 10 years ago couldn’t have predicted. We have seen institutions like bank and telecommunications industry acquire millions of customers whose detailed information need to be stored in database system and retrieved and manipulated at will. In the banks for example the customers will want to access their account any time of the day regardless of whether there is no power or not, or if there are so many customers that the customer connected to the servers and each have to wait for their turn in the queue. Due to these demands computer scientist and expert from various industries have put their heads together to try and find a solution to make sure that as the information dataset continues to grow the daily operation of any computer system continues to give the same expected output or better. Hence these experts have seen the need to continually create the best strategies to ensure total availability of information in an information system. One of these efforts has been noticed in the area of distributed database management systems which has initiated the need to have mechanisms like load-balancing to ensure high availability, fail-over, increased response and much more. This has lead to a more efficient way of making sure that life move smoothly for those people using information and communication technology services.