MySQL one click installation tutorial

Time:2021-11-9

It is said that MySQL users have reached tens of millions of levels, including enterprise users. It can be said that it is the most popular open source database management system software at present. No product can be omnipotent, nor can it be applicable to all application scenarios. So in what scenario does MySQL work and what scenario doesn’t?
1. Web site system
Web site is the largest customer base of MySQL and the most important supporting force in the development history of MySQL. This has been explained in the introduction to MySQL server at the beginning.
MySQL has become the most popular database management system for web site developers because the installation and configuration of MySQL database are very simple, the maintenance during use is not as complex as many large commercial database management systems, and the performance is excellent. Another very important reason is that MySQL is open source and can be used for free.
2. Logging system
Mysql database insertion and query performance are very efficient. If the design is good, when using MyISAM storage engine, they can not lock each other to achieve high concurrency performance. Therefore, MySQL is a very good choice for systems that need a lot of inserting and querying log records. For example, processing user login logs and operation logs are very suitable for application scenarios.
3. Data warehouse system
With the rapid growth of data warehouse, we need more and more storage space. With the continuous growth of data, the statistical analysis of data becomes more and more inefficient and difficult. What should I do? There are several main solutions. One is to use expensive high-performance hosts to improve computing performance and high-end storage devices to improve I / O performance. The effect is ideal, but the cost is very high; The second is to copy the data to multiple cheap PC servers using high-capacity hard disks to improve the overall computing performance and I / O capacity. The effect is acceptable, the storage space is limited and the cost is low; Third, by splitting the data horizontally, multiple cheap pcservers and local disks are used to store the data. There is only a part of all the data on each machine, which solves the problem of data volume. All pcservers calculate in parallel, and also solves the problem of computing power. The computing tasks of each machine are allocated through intermediate agents, It can not only solve the problem of computing performance, but also solve the problem of I / O performance, and the cost is also very low. In the above three schemes, MySQL has great advantages in the implementation of the second and third schemes. Through the simple replication function of MySQL, data can be copied from one host to another, not only in the LAN, but also in the WAN. Of course, many people may say that other databases can do the same, not only mysql. Indeed, many databases can do the same, but MySQL is free. Most other databases charge according to the number of hosts or CPUs. When we use a large number of pcservers, the license fee is quite amazing. The first scheme, basically all database systems can be implemented, but its high cost can not be borne by every company.
  4. Embedded system
The biggest limitation of embedded environment on software system is that hardware resources are very limited. The software system running in embedded environment must be lightweight and low consumption software.
MySQL has great scalability in the use of resources. It can run in an environment with abundant resources or in an environment with very few resources. It is a very suitable database system for embedded environment, and MySQL has a version specially for embedded environment.
Let’s learn how to simply and quickly install and deploy MySQL services
1. Find the MySQL installation service and click try.
MySQL one click installation tutorial
MySQL one click installation tutorial
2. Installation and deployment
Add node – select version – fill in parameters – deployment succeeded
MySQL one click installation tutorial
MySQL one click installation tutorial
The installation and deployment process is simple and fast. The detailed installation tutorials are as follows:
How to add nodes?
https://www.bilibili.com/vide…
How to deploy MySQL?
https://www.bilibili.com/vide…