Global Database Concurrency and Recovery Web Application Simulation

This is a web application whos main goal is to simulate database concurrency, replication, and recovery scenarios. The application uses NodeJS and Express, while the Database uses MySQL.

---

1. Copy and Paste these Commands in the IDE Terminal

npm init
npm i express express-handlebars body-parser mysql hbs dotenv method-override
node app.js

2. Open any Web-browser and Type "http://localhost:3000"

3. Set Preferred Isolation Level

The buttons automatically set the preferred global transaction isolation level among all the nodes in the web-application
SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED
SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ
SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE

4. Select A Node

The web application and the database simulated multi-master replication. This means that any changes set to central node also reflects in luzon/vismin node and vice versa.

5. READ a User

To select a user, just copy paste the preferred apptid and paste in the searchbar and click the search button.

6. EDIT or DELETE a User

7. Reflected Changes