Core article
Data storage
Considerations for MySQL Index usage
Talk about anti-pattern design.
Talking about the design of sub-library and table
Distributed dilemma and countermeasures brought by sub-database and sub-table
Talk about the path of SQL optimization
The deadlock problem encountered by MySQL
Lnnodb and MyISAM of the storage engine
Principles of database indexing
Why do you use B-tree
The difference between a clustered index and a nonclustered index
Limit 20000 loading is slow how to solve
Choosing the right Distributed primary key scheme
ObjectId rules
Talk about MongoDB usage scenarios
Inverted index
Talk about Elasticsearch usage scenarios
Cache usage
What types of Redis are there?
REDIS internal structure
Talk about Redis usage scenarios
Redis persistence mechanism
How Redis achieves persistence
Redis Cluster scheme and implementation
Why Redis is a single thread
Cache Rush
Cache demotion
The rationality of using caching
Message Queuing
Usage scenarios for Message Queuing
The important compensation of the message to solve the idea
The idea of power-equal solution of message
The idea of accumulating messages
How to implement Message Queuing yourself
How to ensure the order of messages
Java Technology Brochure (core article)