Programming VIP

1. Prometheus monitoring server 1.1 problems This case requires the deployment of prometheus monitoring server to complete the following tasks: Install monitoring serverModify profileWrite service files and manage servicesView monitoring data 1.2 scheme Two virtual machines are required for the experiment, and the host information is ...

redis sentinel cluster Redis sentinel is different from redis master-slave; redis master-slave; The master hangs up and will never replace the master redis sentinel master and slave will replace the master MHA 1, Overview of Redis sentinel; summary; Sentinel: sentinel mode is a distributed system. This process is used to monitor the workin ...

📚 preface What is SQL? Official explanation: SQL (Structured Query Language) is used to manage relational database management system (RDBMS). What can SQL be used for? Generally speaking, it allows you to access and process the database, including data insertion, query, update and deletion. SQL is almost a necessary skill for ...

As a memory based cache system, Redis has always been known for its high performance. Without context switching and lock free operation, even in the case of single thread processing, the read speed can reach 110000 times / s and the write speed can reach 81000 times / s. However, the single thread design also brings some problems to Redis: On ...

#Advanced 6: link query /* Meaning: it is also called multi table query. When the query fields come from multiple tables, the join query will be used Cartesian product phenomenon: Table 1 has m rows, table 2 has n rows, and the result is mn rows Cause: there is no valid continuous condition How to avoid: adding valid connection conditions Class ...

Centos7 installation mysql8 (two installation methods) super detailed 1, Command installation 1. Configure Mysql 8.0 installation source: rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm [root@localhost home]# rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm obtain https://dev.mysql. ...

Insert – map insert statements.Update – map update statements.Delete – map delete statements.select – map query statementsql – repeatable sentence blocks that can be referenced by other statementsresultMap – describes how to load objects from the database result set. It is the most complex and powerful elemen ...

1. Summary One of the hardest things for many beginners learning MySQL before learning SQL Server is that there are subtle differences in their grammar, such as the absence of keywords such as modify and change in SQL Server, or every statement in MySQL. At the end, SQL Server uses the go keyword to indicate the end of a batch statement, a ...

background When the business party migrates, the total data size is only more than 300 M, but the MySQL server prompts that the packet exceeds max_allowed_packet, but there is no problem with 10G pressure test data during test migration? The final solution to the problem is very simple, adjust the appropriate max_ allowed_ The size of ...

Environmental preparation (1) Two virtual machines are required, and the memory is better than 2G. DM8 is installed on each virtual machine, and initialization is not required after installation.(2) In this paper, the machine is named. The first one is called node 1 and the second one is called node 2, which is convenient to call. Because it i ...