Programming VIP

In my blog website, Nacos is used as the configuration and registration center and associated with the database. Since the data, data and website settings are stored in the database, I always want to make a backup. So I found a relatively simple scheduled backup mode. Of course, it is based on linux. Method: use the timer in linux system to ...

From the library, you can view the database you just created: In this database, query the data in the user table: 3, MyCat master slave read / write separation 1. Read write separation principle Read write separation is simply to separate the read and write operations of the database to correspond to different database servers. The mast ...

preface The database table design I mentioned here involves how to organize your business table, how to design, how to redundant fields, etc., but these are my personal views. You are welcome to discuss different views with me in the message area 1, Database table? According to my understanding, database tables are generally divided ...

5, Experimental steps Experiment 1: transplant embedded database sqlite 1 ~ 5: install sqlite database 6: Use of database Method 1: command to manipulate the database Mode 2: program to manipulate the database Outside the experiment (you can see if you are interested) Experiment 2: embedded Qt experiment 1, QT installation ...

In daily development, there are many similar operations to reduce inventory, such as goods inventory in e-commerce system, prize inventory in lottery system, etc. 1 Solution Using the mysql database, use a field to store the inventory, each time the inventory is deducted to update the field.Use the database, but store multiple copies of t ...

Introduction: This blog is mainly used to record some bits related to learning and life. This blog is relatively simple and will not be very difficult to build. The technologies involved mainly include springboot, mybatis plus, springMVC, redis, JWT,mySql, etc. Although this blog is relatively simple, there are still holes in it!, Maybe you ...

①. How to develop based on the official website ①. Enter the Chinese official website of redis and click document ②. Select distributed lock to open the page ③. Click Wiki ④. In the follow-up, you can refer to the documents about distributed locks ⑤. The concept of flying in the sky (RedLock) must be realized by landing (Redisson) ⑥. ...

1. Replicate one more database locally (ignored if you have multiple servers conditionally) 1) Find the mysql instance folder and data folder (usually under C:\Program Files and C:\ProgramData) Directly copy a copy from the library 2) Modify slave library configuration my ini [client] port=3307 [mysqld] port=3307 basedir="C:/Program Files/M ...

Connection pool When JDBC executes an SQL statement, most of the time is wasted on creating and closing connections, and the user experience is very poor Connection pooling can be used to manage connections, so connection pooling is a buffering technology used to manage connections. Working process of connection pool The role of connection ...

The so-called ORM framework, object relational mapping, is used to make a mapping between relational databases and objects. In this way, when we operate the database, we don't need to deal with complex SQL statements, but just operate it as usual. 4, Project case demonstration ================================================================= ...