Programmer Think

Pull mysql image docker pull mysql:5.7.36 Create container Create the following folders master slave1 slave2 Create master database docker run \ --name mysql-master \ -p 3307:3306 \ -v /usr/local/docker/mysql/data/master:/var/lib/mysql \ -e MYSQL_ROOT_PASSWORD=root \ -d mysql:5.7.36 Create slave database 1 docker run \ --name m ...

MySQL database Database overview Database related concepts DB Database: it is "a warehouse that organizes, stores and manages data according to data structure". Is a long-term storage in the computer, organized, shareable, unified management of a large number of data collection. It is essentially a file system, which exists on ...

2, MySQL introduction and installation 1 Introduction Mysql database is subordinate to MySQL AB company, headquartered in Sweden and later acquired by Oracle. Official website: https://www.mysql.com/ 2 advantages Low cost: open source, generally free to use. High performance: fast execution. Simple: easy to install and use. 3. MySQL ver ...

I am participating in the CSDN "new programmer" award-winning essay solicitation There are thousands of people in the vast sea. Thank you for seeing here this second. I hope my article will help you! May you keep your love and go to the mountains and seas in the future! 1. Basic knowledge of database 1.1 why learn database ...

1. Description of index caliber Retained on the next day: the number of users who use the product on the first day and still use it on the second day Multi day retention: the number of users who use the product on the first day and still use it after many days Number of people continuously active: how many people continuously use products 2 ...

1 example of many to many relationship 1. Table names and fields Student form: student (s_id, s_name, s_birth, s_gender) -- > student number, student name, date of birth, student gender Curriculum: Course (c_id, c_name) -- > course number, course name Teacher form: teacher (t_id, t_name) -- > teacher number, teacher name Transcrip ...

A constraint is actually a constraint on the data in a table. Function: the purpose of adding constraints is to ensure the integrity and validity of the records in the table, for example, the values of the column (mobile phone number) of the user table can not be empty, and the values of some columns (ID number) can not be repeated. Classific ...

MySQL InnoDB lock - For Update lock analysis: 1. InnoDB lock Brief introduction 2. Current read lock analysis: REPEATABLE-READ Repeatable reading,READ-COMMITTED Read committed 3. Lock mode description and 8.0 data_locks table 1, InnoDB lock 1. Global lock Global read lock, flush tables with read lock, the whole library is in read-only state. A ...

Use case Introducing maven dependency <dependency> <groupId>com.github.shyiko</groupId> <artifactId>mysql-binlog-connector-java</artifactId> <version>0.21.0</version> </dependency>   Implementation of monitoring binlog public class App { public static void main(String[] args) ...

1, ES Foundation Official documents: Elasticsearch: authoritative guide | Elastic 1. Noun comparison mysql ElasticSearchMySQLIndexIndexesDatabasedatabaseTypetypeTablesurfaceDocumentfileRowthat 's okFieldfieldColumncolumnMappingProcessing rulesSchemarelationship Indexes: indexes are the plural of indexes, which represent many indexes and a ...