Project Proposal: MySQL Replication

In a business environment, loss of data in databases must be minimized. The causes of losses can be due to disk failure, server failure and or data corruption to name a few. In other cases, environment can play a role in data loss as it was the case during Hurricane Ike. There are many technologies today that are used to guarantee data is available in case of server or storage failure. Database replication, the saving of data in another disk system, is a solution that has gained in importance.

Our team will demonstrate data replication of databases simulating storage devices located in different locations. We will use two servers running Ubuntu with MySQL databases installed. One will be the master and the other a redundant slave. MySQL database replication will be used to keep a copy of the database that is manipulated on the master server. Further expansion on this project can be made to utilize more than just one slave server. We plan to implement some sort of web access to allow database queries and database manipulation. If time permits for the web portal expansion, additional research can be done on existing open source scripts to see if there is one that could be implemented with this project.

Student:
Chris Cooper
Clark Calvin
Joel Mundt

Lab Instructor:
Sergio Chacon