ShardingJH

ShardingJH is a distributed database project that relies on Spring Boot, Hibernate and SQLite. It features P2P routing, gossip-based node discovery and sharding between multiple SQLite instances.

See the demo at ShardingJH Demo.

Requirements

• Java 8+
• SQLite
• Maven
• RabbitMQ

Build and Run

1. Ensure Java 8+ ,SQLite and RabbitMQ are available on your PATH.
2. Build the project using the Maven wrapper:

   ./mvnw clean package -DskipTests

3. Choose a server profile (server1, server2, server3 or server4) and run the application with the helper script:

   ./run-app.sh server1

   Profiles contain individual port and routing settings stored in the src/main/resources directory.

Manual Run

If you prefer to start the jar manually, run:

java -jar target/*.jar --spring.profiles.active=server1

Deployment to AWS

The project contains a GitHub Actions workflow (.github/workflows/github-actions-ec2.yml) that deploys the packaged jar to multiple EC2 servers. Each server corresponds to a different profile. The deployment script also inserts the RabbitMQ password into application.properties before running run-app.sh remotely.

Division of Work

Name	Responsibilities
JiDung	Encryption, P2P routing, Sharding strategy, MVCC and roll back, Static file replication, RabbitMQ product update sync, Frontend, AWS Deployment, Spring Boot framework, SQLite establishment
Haopeng	Gossip, HeartBeat messaging, Dynamic hash allocating

Demo video

Report and Presentation

• Report
• Presentation