Basic database architecture and log functions, database architecture logs
1. Why mysql?
MySQL features a plug-in storage engine to facilitate read/write splitting
It is open-source and free
2. How database software runs in the Early Stage: data is written together with applications, and data operations must be performed by programmers themselves.
Later: the database management system (DBMS) was born.
Mysql, SQLServer, SQLite, etc... 3. Analyze the execution status through a basic schematic diagram of the database:
We can see that there will be operations on logs before the operation data, and the system will regularly back up the logs. Because the logs record the specific steps of the operation, the database system can follow the log, wait until the final data (the introduction is clear)
Here we will mention that master-slave replication will be used later. It is achieved through the interaction between the master database and slave database through binary logs, and the effect is very good.