Programmer Think

Welcome to the MySQL technical articles shared by the great SQL community. If you have any questions or want to learn, you can leave a message in the comment area below. After seeing it, you will answer itproblemThe original question is as follows:If you add a shared lock to a row of a table in a MySQL transaction, in theory, the table itself w ...

1. Database installation The first method: apt installation sudo apt update //Update source sudo apt install -y mysql-server   The first method: deb package installation reach MySQL :: Download MySQL Community Server 2. Initialize configuration sudo mysql_secure_installation   Configure whether to verify password strength, y ...

catalogue 1, Introduction 2, MHA services working principle Actual operation Initialize environment Modify the hostname of Master, Slave1 and Slave2 nodes Master slave synchronization Install MHA 1, Introduction MHA (Master HA) is an open source MySQL high availability program. It provides the automatic master failover function for M ...

Some time ago, I encountered the emergency treatment after the mysql table ibd file was deleted. Deleting the table file directly is strictly prohibited. Here we test the emergency recovery process in several cases. 1. The ibd file has been emptied or deleted by mistake 1) Create table sbtest1 and insert data CREATE TABLE `sbtest1` ( `id` ...

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 ...