Programmer Think

preface: The article was first published in https://sleepymonster.cn This is a question for the finals of the 2021 Jinan University freshman competition. At that time, I was gambling. If I did it, I would win the second prize Unfortunately, the network is not powerful enough to suck out second times without changing the script. But I'v ...

17, Three paradigms of database design 1. What is the database design paradigm? The design basis of database table teaches you how to design database table. 2. What are the common database design paradigms? Three. The first paradigm: it is required that any table must have a primary key, and no field is atomic and can no longer be divided. The ...

1, Index 1.1 what is an index How to find the target quickly when the number of databases is huge? The index is used. If a book wants to quickly find the knowledge points it wants, it will first look at the directory, and the index is equivalent to the directory of the book, which is convenient for query. 1.2 characteristics of index Similar ...

One section after another, thousands of branches save thousands of leaves. I don't blossom. I don't have to flirt with bees and butterflies. Haoshou is still greedy for learning, modest and virtuous. When the hidden spirit has no me, I understand things without saying. preface I open source it. But I hope you can learn the idea of datab ...

catalogue 1, Master slave replication architecture and principle 1. Principle of mysql master-slave replication 2. Principle of read-write separation 2, Configure master-slave replication and read-write separation 1. Environment configuration 2. Initial environmental preparation 3. Set up mysql master-slave replication 3. Build Amoeba t ...

1. Relationship between tables one-on-one Monogamy One to many One person can own more than one car Create person table CREATE TABLE person(id int PRIMARY KEY auto_increment,name VARCHAR(50)); Create car table CREATE TABLE car ( cid INT PRIMARY KEY , cname VARCHAR ( 50 ), color VARCHAR(25), pid INT, CONSTRAINT c_p_fk FOREIGN key(pid) ...

catalogue 1, Mycat application scenario 2, Mycat summary 3, Specific operation 1.master server: 192.168.68.200 2.slave server: 192.168.68.30 3.mycat server: 192.168.68.40 4. Client: 192.168.68.195 five   mycat server: 192.168.68.40 6.master server: 192.168.68.200 7. Client: 192.168.68.195 8. Verification On the master-slave ser ...

Getting started with Mybatis 1. Use of mybatis Write SQL into xml file to reduce the coupling between SQL and program The biggest change: before writing the UserDao interface, write the implementation class UserDaoImp, and now write the UserMapper.xml configuration file 1. Create Maven project and add dependency mybatis In the example, (the d ...

Summary of Myqsl knowledge points 1, Database related concepts DB: a database that holds a set of organized data containersDBMS: database management system, also known as database software (product), is used to manage data in DBsql structured query language is a language used to communicate with DBS 2, mysql common commands 1. View all curr ...

Note: the article comes from   Write-Ahead Log , the author works at Thoughtworks   Martin Fowler . This paper mainly writes "pre write log", a common technology in modern distributed database. Pre write log The persistence guarantee is provided by persisting each state change to the log in the form of command without ref ...