Recommended articles about growing from small to big

Assuming that a website (discuz) has a small number of visits from the beginning to tens of millions of daily PVs, let's speculate on the evolution of its mysql server architecture. In the first stage, the daily pv level of website visits is less than 10,000. When running web and db on a single machine, there is no need for architecture layer tuning (for example, there is no need to add memcached cache). At this time, data is often cold backed up daily, but sometimes if data security is considered, a mysql master-slave will be set up. In the second stage, the daily number of website visits reached tens of thousands. At this time, the single machine is already somewhat loaded, so we need to separate the web and db, and build a memcached service as a cache. In other words, at this stage, we can also use a single machine to run mysql to undertake the data storage and query of the entire website. If you do MySQL master-slave, the purpose is also for data security. In the third stage, the daily number of website visits reached hundreds of thousands. Although a single machine can support it, the machine configuration required is much better than the previous machine. If funds allow, you can purchase a machine with high configuration to run the mysql service. However, it does not mean that doubling the configuration will double the performance. At a certain stage, the configuration will increase

1. MySQL Details of the evolution of the architecture from small to large

##Introduction: Suppose a website (discuz) starts from the most Start the number of visits very small to make PV ten million. Let's speculate that the evolution of its MySQL server architecture.

2. [php]mysql global ID generation scheme, phpmysql global id_PHP tutorial

Introduction: [php] mysql global ID generation scheme, phpmysql global ID. [php] mysql global ID generation scheme, phpmysql global id production system will always go through a process of business volume from small to large as the business grows. Scalability is to consider the high availability of the database system

3. [php]mysql global ID generation scheme, phpmysql global id

Introduction: [php]mysql global ID generation scheme, phpmysql global id. [php] mysql global ID generation scheme, phpmysql global id production system will always go through a process of business volume from small to large as the business grows. Scalability is to consider the high availability of the database system

[Related Q&A recommendations]:

javascript - The drop-down background image changes from blurry to clear, and the size changes from small to large.

javascript - About a special effect on the 36kr homepage

The above is the detailed content of Recommended articles about growing from small to big. For more information, please follow other related articles on the PHP Chinese website!