Today, I talked to an architect about some issues. I accidentally said one thing. I was interested in it and recorded it as follows:
1: We all know the InnoDB and MyISAM engines in MySQL. InnoDB has transaction management. Therefore, InnoDB operations and MyISAM operations are simple in terms of database insertion. inndodb is reliable, and MyISAM is faster in terms of queries.
2: Based on the above features and the master-slave mechanism of mysqljuyou, we can establish two databases. One is that database engine a is InnoDB, the other is database B, and the engine is MyISAM. For database A, configure it as the master server, and B as the slave server (there are many specific configurations on the Internet, which are not important here ).
3: For a whole web application, if update operations are performed on a and query operations are performed on B, the performance improvement will naturally be improved.