Database

A reading note of《System Design Interview》, in which discuss how to design a system that can scale from zero to millions of users. Single server Everything is running on one server: web, app, database, cache, etc. Besides, DNS(Domain Server System) is paid service provided by 3rd parties With the growth of user base, one server is not enough. Separating Database and Server Separating web/mobile traffic(web tier) and database(data tier) servers allows them to be scaled independently...

Essential Knowledge of MySQL Database How is a query processed? Connector: Long connection, Short connection, Reset Connection, etc. Cache: Optional for the query. However, the cache is not useful because the data might be updated frequently. It is now not supported in MySQL8.0 Analyzer: lexical analysis. Syntax analysis. Including checking whether a querying column exists or not. Optimizer: Decide using which index. Start by reading which table while executing join....