mysql transactions and indexes

5.mysql transactions and indexes **Business** Execute a group of sql statements in the same batch If an sql error occurs, all the sql in the batch will be cancelled mysql transaction processing only supports innoDB and BDB data table types ACID principle of transaction Atomic ity All operations in the whole transaction are either complet ...

Posted by rid243 on Mon, 02 May 2022 07:52:02 +0300

Transaction opening, commit and rollback of MySQL database

A transaction is a user-defined sequence of database operations. These operations are either done or not done at all, and are an inseparable unit of work. Based on the atomicity, consistency, isolation and persistence characteristics of transactions, related data operations can be defined into a transaction. If no exception occurs during the ...

Posted by wblati on Sat, 30 Apr 2022 23:02:23 +0300

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