Java project: warehouse management system (java+SpringBoot+LayUI+HTML+Thymeleaf+mysql + training report)
Source code acquisition: download from "resources" on the blog home page!
Project introduction
The warehouse management system is divided into three modules: basic management, warehouse management and system management. There are sub modules under each module. functional module
1, Basic management
1. Customer management Custome ...
Posted by tsigo on Sat, 30 Apr 2022 21:52:16 +0300
Basic syntax of MySQL database
Basic operation of MySQL database
1. Creation of database
1.1 create database
Create database
create database <Database name> -- stay sql Statements are not case sensitive
Use database
use <Database name>
Delete database
drop database <Database name>
view the database
show databases <Database name>
1.2 crea ...
Posted by IG88 on Sat, 30 Apr 2022 18:54:06 +0300
MySQL high availability solution - dual master
There are many high availability schemes for MySQL, such as dual master, MHA, MMM, etc. here is just the simplest dual master high availability scheme.
1, Configure MySQL as master-slave
1.1 environmental preparation
OS
IP
hostname
service
Centos 7.5
192.168.1.1
db01
MySQL+Keepalived
Centos 7.5
192.168.1.2
db02
MySQL+Keepalived
This ...
Posted by srikanth03565 on Sat, 30 Apr 2022 12:56:05 +0300
Naming Specification for MySQL
1. Naming Specification
1.1 Specification for Library Construction
Databases, tables, fields, indexes are all lowercase letters, and English words are underlined () Separate.
1.2 Table Field Specification
The column design specification uses tinyint/int/bigint according to business area, which takes up 1/4/8 bytes, respectively.
Use tinyint ...
Posted by Bramme on Sat, 30 Apr 2022 03:48:57 +0300
MySQL data backup and recovery
MySQL backup generally adopts the method of full database backup and log backup. According to the needs of the business, a full backup can be performed every Sunday at 1 am and an incremental backup every hour, so that full backup and log backup can be used after MySQL failure. Recover the most complete data possible.
1. binlog log recovery
The ...
Posted by possiblyB9 on Fri, 29 Apr 2022 17:12:08 +0300
MySQL advanced SQL statement parsing
Tip: after the article is written, the directory can be generated automatically. Please refer to the help document on the right for how to generate it
preface
Learning and understanding the SQL statements configured by MySQL is conducive to laying a solid foundation for the flexible mastery and application of MySQL.
A SQL statement
...
Posted by ScottRiley on Fri, 29 Apr 2022 12:06:11 +0300
Mybatis complex query (many-to-many, one-to-many, many-to-one)
We know that it is very easy to complete single-table query in Mybatis, and multi-table query is a difficult point in the Mybatis framework, which needs to be mastered.
1. Many-to-many query
There is a many-to-many relationship between users and groups, and the requirement is: find all group information by user id
The database design ...
Posted by nonexistentera on Fri, 29 Apr 2022 03:20:50 +0300
MySQL master-slave replication and read-write separation
1, Deployment reasons
reason:
Ensure that the data of the master database and the slave database are always, and prevent single point of failure and data lossIn enterprise applications, mature businesses usually have a large amount of dataA single MySQL cannot meet the actual needs in terms of security, high availability and high concurre ...
Posted by bbristow on Thu, 28 Apr 2022 20:50:46 +0300
Shardingsphere JDBC chapter of Amazon Aurora's reading and writing ability expansion
Source: Amazon AWS official blog
Sun Jinhua, senior solution architect of Amazon cloud technology, is responsible for helping customers design and consult the cloud architecture. Before joining AWS, I started my own business and was responsible for the construction of e-commerce platform and the overall architecture design of auto enterprise ...
Posted by JukEboX on Thu, 28 Apr 2022 19:43:38 +0300
Fault analysis | who stole my IO
Author: Sun Qiao
As a member of aikesheng DBA team, he is mainly responsible for the daily maintenance of MySQL and DMP platform, and has a strong interest in database automatic operation and maintenance.
Source: original contribution
*It is produced by aikesheng open source community. The original content cannot be used without authoriza ...
Posted by wiredweb on Wed, 27 Apr 2022 13:54:49 +0300