V2版本,结构较比V1版本有很大的改动 全部转化成 controller、dao、service 模式,更加符合企业开发
由于整合上传oss和上传到本地,需要在 conf 中进行配置 UploadModel 字段,上传到 oss 则配置 oss,上传本地则配置 local
基于 gin+gorm+redis+mysql 读写分离的电商网站(高并发秒杀系统),包括 JWT 鉴权,CORS跨域,AES 对称加密,引入ELK体系,使用docker容器化部署
Docker 安装 MySQL
➜ ~ docker search mysql
NAME DESCRIPTION STARS OFFICIAL AUTOMATED
mysql MySQL is a widely used, open-source relation… 13234 [OK]
➜ ~ docker pull mysql:latest
latest: Pulling from library/mysql
Digest: sha256:e9027fe4d91c0153429607251656806cc784e914937271037f7738bd5b8e7709
Status: Image is up to date for mysql:latest
docker.io/library/mysql:latest
➜ ~ docker run -itd --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=密码 mysql
8d227cb57844817048571ee06efe21bc206c9399ddddc1ac741be0026f38603c
➜ ~ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
8d227cb57844 mysql "docker-entrypoint.s…" 45 seconds ago Up 42 seconds 0.0.0.0:3306->3306/tcp, 33060/tcp mysql
➜ ~ docker exec -it mysql bash
root@8e6ae0287092:/# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 8.0.27 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
use mysql;
ALTER USER 'root'@'%' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mall_db |
| mall_db_test |
| mysql |
| performance_schema |
| sys |
| todolist |
+--------------------+
7 rows in set (0.22 sec)
mysql> use mall_db;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+-------------------+
| Tables_in_mall_db |
+-------------------+
| address |
| admin |
| carousel |
| cart |
| category |
| favorite |
| notice |
| order |
| product |
| product_img |
| relation |
| skill_product |
| skill_product2_mq |
| user |
+-------------------+
14 rows in set (0.00 sec)
mysql> select * from user;
+----+---------------------+---------------------+------------+-----------+-------+--------------------------------------------------------------+-----------+--------+-----------------------------------------------------+--------------------------+
| id | created_at | updated_at | deleted_at | user_name | email | password_digest | nick_name | status | avatar | money |
+----+---------------------+---------------------+------------+-----------+-------+--------------------------------------------------------------+-----------+--------+-----------------------------------------------------+--------------------------+
| 1 | 2023-06-19 07:12:55 | 2023-06-19 07:12:55 | NULL | xi | | $2a$12$bSkd66FwPau0vEP0141ZruOh9p9rkjMIjgZ2ncCp21er7ZmSe./vC | ?? | active | http://127.0.0.1:3000/static/imgs/avatar/avatar.png | Zt3uB50jiObAwOoJ/kLpaQ== |
| 2 | 2023-07-20 03:21:01 | 2023-07-20 03:21:01 | NULL | x | | $2a$12$3a76sUYwl8TbdILrCd8sku22567S8D6.J2/.Xo5prf39GVrLp58.i | ?? | active | http://127.0.0.1:3000/static/imgs/avatar/avatar.png | Zt3uB50jiObAwOoJ/kLpaQ== |
| 3 | 2023-07-20 09:11:23 | 2023-07-20 09:11:23 | NULL | test | | $2a$12$u9CYbv7rYD4BnDjdc7bRKeBVui21quziudVGlTUTL5soMvn9rXMc. | ?? | active | http://127.0.0.1:3000/static/imgs/avatar/avatar.png | Zt3uB50jiObAwOoJ/kLpaQ== |
| 4 | 2023-07-28 07:04:48 | 2023-07-28 07:04:48 | NULL | ?? | | $2a$12$IeLjHH1sQ1D5kDBHE6622uHLXKbfXSdX4Pro3BKHqJ7PG8m/lddFm | ?? | active | avatar.JPG | wVlreio71PEArDlotVjrJw== |
| 5 | 2023-08-13 07:10:05 | 2023-08-13 07:10:05 | NULL | test1 | | $2a$12$NrV9rB1BwdeskRx0GFyLN..3s86GTzVeCchxXaREwQBBxUclPKWuq | ?? | active | avatar.JPG | wVlreio71PEArDlotVjrJw== |
+----+---------------------+---------------------+------------+-----------+-------+--------------------------------------------------------------+-----------+--------+-----------------------------------------------------+--------------------------+
5 rows in set (0.01 sec)