The design of database under high concurrency

Now what age, still holding SQL Server MySQL Oracle read the data, well you have the problem I came to you to answer

In high concurrency, talk about how data is synchronized (written, read) between the database and Redis, which can guarantee the integrity of the business and improve performance.

Mode 1: Database saves data, Redis does not persist
After Redis boots, load data from the database
Read requests that do not require strong, consistent real-time, are processed by Redis
Requires strong, consistent, real-time read requests, processed by the database
Write requests are handled in 2 ways, handled by the database
-the application writes the database first and then updates the Redis
-the application writes the database first and then synchronizes the other daemon to Redis
Pros: Redis boot does not handle REDIS data and database inconsistencies
Cons: Redis starts a large reading pressure on the database

Mode 2: The database and Redis handle different data types separately
Database processing requires strongly consistent real-time data, such as financial data, transaction data
Redis processing data that does not require strong, consistent real-time, such as the Web site's hottest sticker leaderboard

The design of database under high concurrency