𝟳 𝗠𝘂𝘀𝘁-𝗸𝗻𝗼𝘄 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗲𝘀 𝘁𝗼 𝗦𝗰𝗮𝗹𝗲 𝘆𝗼𝘂𝗿 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 by ByteByteGo

𝟭 - 𝗜𝗻𝗱𝗲𝘅𝗶𝗻𝗴:

Check the query patterns of your application and create the right indexes.

𝟮 - 𝗠𝗮𝘁𝗲𝗿𝗶𝗮𝗹𝗶𝘇𝗲𝗱 𝗩𝗶𝗲𝘄𝘀:

Pre-compute complex query results and store them for faster access.

𝟯 - 𝗗𝗲𝗻𝗼𝗿𝗺𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻:

Reduce complex joins to improve query performance.

𝟰 - 𝗩𝗲𝗿𝘁𝗶𝗰𝗮𝗹 𝗦𝗰𝗮𝗹𝗶𝗻𝗴

Boost your database server by adding more CPU, RAM, or storage.

𝟱 - 𝗖𝗮𝗰𝗵𝗶𝗻𝗴

Store frequently accessed data in a faster storage layer to reduce database load.

𝟲 - 𝗥𝗲𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻

Create replicas of your primary database on different servers for scaling the reads.

𝟳 - 𝗦𝗵𝗮𝗿𝗱𝗶𝗻𝗴

Split your database tables into smaller pieces and spread them across servers. Used for scaling the writes as well as the reads.