DDBMS

Distributed Database Management System Project for THUACP2023

Install Requirements

pip install -r requirements.txt

Set Up

1. Database Setup

MySQL is used for database. Run the following sql statment to create the two databases

CREATE DATABASE DBMS1;
CREATE DATABASE DBMS2;

Then create tables and populate them with data in their respective database using sql statements provided in this project. They are located in different folders and already fragmented according to the requirements in the project. The sql statements are named with their respective dbms for example article_dbms1.sql in article folder for article data in DMBS1

• When running a large script in mysql workbence, to bulk load the data into database, set maximum allowed

 SET GLOBAL max_allowed_packet=1000000

2. MinIO Setup

MinIO cluster is build on docker compose. Therefore docker must be installed first. To built the container on docker, change current directory to minio folder, where docker-compose.ymal is located, then run the following command.

$ cd minio
$ docker-compose up -d

This will build docker container containing four images, minio1, minio2, minio3 and ngnix.
After successful build, make sure the container is up and running and visit localhost:9005 to access minio console interface. Login using the credentials set in docker-compose.yaml Then create a bucket and upload the article data.

3. Run Flask APP

Make sure the MySQL database and MinIO servers are up and running before running the App. Also configure the ports (connection to the mysql database and minio cluster) in news.py file incase there's problem which usually arises if those ports are being used by other application on your machine.
Then run the the following command to start the APP.

cd web
flask --app newsapp --debug run

This should start the app, then visit http://127.0.0.1:5000(The local link on which the flask app is running) to access the app.