Basic operation of MySQL database
1. Creation of database
1.1 create database
create database <Database name> -- stay sql Statements are not case sensitive
use <Database name>
drop database <Database name>
view the database
show databases <Database name>
1.2 crea ...
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
Posted by srikanth03565 on Sat, 30 Apr 2022 12:56:05 +0300
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 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
Posted by possiblyB9 on Fri, 29 Apr 2022 17:12:08 +0300
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
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
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
1, Deployment reasons
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
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
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