Convert to mysql horizontal scaling and Vertical Scaling

Scale

Scale-up and Scale-out explain the scalability of the system, Scale-up and Scale-out) it is two common terms. For Beginners, it is easy to confuse these two concepts. Here we summarize some clear explanations of these concepts. First, refer to Wikipedia

Explanations of Scale-up and Scale-out

Speaking of system scalability, Scale-up and Scale-out are two common terms. For Beginners, it is easy to confuse these two concepts, here we summarize some clear explanations of concepts.

First, let's talk about Wikipedia.

Scale vertically (scale up)

To scale vertically (or scale up) means to add resources to a single node in a system, typically involving the addition of CPUs or memory to a single computer. such vertical scaling of existing systems also enables them to leverage Virtualization technology more than tively, as it provides more resources for the hosted set of Operating system and Application modules to share.

Taking advantage of such resources can also be called "scaling up", such as expanding the number of Apache daemon processes currently running.

Scale horizontally (scale out)

To scale horizontally (or scale out) means to add more nodes to a system, such as adding a new computer to a distributed software application. an example might be scaling out from one web server system to three.

As computer prices drop and performance continues to increase, low cost "commodity" systems can be used for high performance computing applications such as seismic analysis and biotechnology workloads that cocould in the past only be handled by supercomputers. hundreds of small computers may be configured in a cluster to obtain aggregate computing power which often exceeds that of single traditional RISC processor based scientific computers. this model has further been fueled by the availability of high performance interconnects such as Myrinet and InfiniBand technologies. it has also led to demand for features such as remote maintenance and batch processing management previously not available for "commodity" systems.

The scale-out model has created an increased demand for shared data storage with very high I/O performance, especially where processing of large amounts of data is required, such as in seismic analysis. this has fueled the development of new storage technologies such as object storage devices.

Scale vertically (scale up)

To scale vertically (or scale up) means to add resources to a single node in a system, typically involving the addition of CPUs or memory to a single computer. such vertical scaling of existing systems also enables them to leverage Virtualization technology more than tively, as it provides more resources for the hosted set of Operating system and Application modules to share.

Taking advantage of such resources can also be called "scaling up", such as expanding the number of Apache daemon processes currently running.

Scale horizontally (scale out)

To scale horizontally (or scale out) means to add more nodes to a system, such as adding a new computer to a distributed software application. an example might be scaling out from one web server system to three.

As computer prices drop and performance continues to increase, low cost "commodity" systems can be used for high performance computing applications such as seismic analysis and biotechnology workloads that cocould in the past only be handled by supercomputers. hundreds of small computers may be configured in a cluster to obtain aggregate computing power which often exceeds that of single traditional RISC processor based scientific computers. this model has further been fueled by the availability of high performance interconnects such as Myrinet and InfiniBand technologies. it has also led to demand for features such as remote maintenance and batch processing management previously not available for "commodity" systems.

The scale-out model has created an increased demand for shared data storage with very high I/O performance, especially where processing of large amounts of data is required, such as in seismic analysis. this has fueled the development of new storage technologies such as object storage devices.

---------------------------- Gorgeous split line ---------------------------------------

Poor English? It doesn't matter. I have prepared a Chinese text for you. From here, he uses fish farming as an image metaphor.

When you only have six or seven fish, a small fish tank is enough. However, after a while, more than thirty fish are generated. This small tank is obviously not big enough.

If you use the Scale-up solution, you need to buy a large cylinder and take out all the sand, water plants, sets, heating rods, and thermometers from the small cylinder, re-arrange to the big cylinder. This project is not simple. It may not be fixed in ten minutes or eight minutes, especially when it comes to water plants. It is difficult to separate it when it comes to correction. (However, it is more complicated than the data migration project, ).

Now let's change your mind. With the Scale-out solution, you are connected to the same small cylinder next to this small cylinder, and the two cylinder are connected. The fish can be automatically dispersed into two tanks, and you will save the above-mentioned series of troubles such as sand migration, water plants, and scenery.