Based On The Parallel Mpi And Mysql Database System

With the hardware technology approaching its physical limitation, building a parallel DBMS that can run on a cluster becomes the only way to increase the performance of database at present. Now, cluster has been applied in many areas such as weather forecasting, oil industry, CAE, CFD, Web, etc. And there are many successful cases prove that cluster can increase the performance of database. This thesis proposed a middle-ware structure based on MPI and MySQL, which can help us use a parallel database without knowing how to use MPI or MySQL. And this thesis also try to builda Beowulf cluster with a good tools package, which is called "OSCAR". The major contributions in this thesis are detailed as follows.Firstly, this thesis tries to use a useful package called "OSCAR"to build a Beowulf cluster.Secondly, this thesis builds a platform on which we can perform our research and development.Thirdly, this thesis try to build a parallel DBMS named M2 using MPIand MySQL, with focus on special application, and not for general situation.Fourthly, this thesis implements some important modules including parallel sort, parallel-join, parallel-projection and parallel-select, which prove that the idea building a parallel database with MPI and MySQL is feasible.Fifthly, this thesis implements some important modules, which canimprove the system's usability. These modules include database conversing module, output module and connection module.Sixthly, this thesis performs many tests on M2 on different platform,and gives many analysises in detail. As the result, this thesis get the emphases on increasing the performance of the Parallel Database System.