A Scalable Online Shopping System

The repo includes my study notes and re-implementation details from online bootcamp courses.

The project built a simple web based online shopping application based on Java(1.8) and Spring Boot(1.5.8.RELEASE). And introducing Redis(3.2) and RabbitMQ(3.7.7) to improve qps from 1306 to 2114 (with 5000 Threads and 10 Loop Count).

Feature implemented so far:

• user register and log in
• view item list
• view item detail
• create order

How to start on local host

The notes below shows how I started my instance on windows 10 machine. Please feel free to choose any tool you like!

pom.xml

• git clone this repo
• Open IntelliJ and import project from existing source (choose the directory of pom.xml)

MY SQL

• Use MySQL Workbench and create miaosha schema
• Run the SQL query in tablesDDL.sql. After running DDL, you can see:

Changed your connection setting in src\main\resources\application.properties, here are mine:

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/miaosha?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false

Redis

Install Redis and changed your connection setting in src\main\resources\application.properties, here are mine:

#redis
redis.host=127.0.0.1
redis.port=6379

RabbitMQ

Install Erlang(20.3) and RabbitMQ(3.7.7). Changed your connection setting in src\main\resources\application.properties, here are mine:

#rabbitmq
spring.rabbitmq.host=127.0.0.1
spring.rabbitmq.port=5672
spring.rabbitmq.username=guest
spring.rabbitmq.password=guest

If everything goes well, visit http://localhost:15672/ and log in with username: guest and password: guest

Add miaosha.queue and miaoshatest manually:

Notes about Redis and RabbitMQ

Installation of these two could be error-prone. Please refer official documentation. After starting the services, we can test Redis and RabbitMQ connection on windows PowerShell:

Run Application

Go to src\main\java\com\imooc\miaosha\MainApplication.java and run as java application.

A Simple Project Demo

• user register and log in

• view item list

• view item detail

• create order

TODO

• Nginx for reverse proxy
• JMeter for stress testing. We mainly focused on the qps before and after introducing Redis and RabbitMQ.