Programmer Group

This is a series of articles. If you haven't read the first episode, please jab here: Alibaba Nacos registration center of Spring Cloud series (I) This article introduces the construction of Nacos registry cluster environment. 　　 Construction of Nacos cluster environment 　　 The cluster mode is the same as our usual capacity expansion. It ca ...

In the process of performance test, we often encounter the performance bottleneck of Mysql. For the database, the so-called performance bottleneck is nothing more than slow SQL, high CPU, high IO, and high memory. The first three examples are used for performance analysis. Finally, the high memory is ...

Recently, we are introducing distributed transaction technology for the project. At present, Seata is a good choice. I plan to take a look at it. This article is purely a personal learning note, without any responsibility. In this article, nacos-1.2.0, SpringBoot-2.3.0, seata-1.2.0, mysql-5.7 are use ...

1. MySQL Read-Write Separation Concept The principle of MYSQL read-write separation is to let Master database handle transactional add, delete, modify, update operations (create, insert, update, delete) and Slave database handle query operations (select). MySQL read-write separation is based on MySQL master-slave replication, which can guarant ...

View mysql profile address mysql --help|grep 'my.cnf' ps aux|grep mysql|grep 'my.cnf' The configuration is divided into two parts, the master server part and the slave server part In this test, the master and slave of the two machines are synchronized, and the environment is windows (the same as Linux) Main server ip:192.168.1.199 Slave serve ...

2. Introduction to mobile rear end: E chat SDK provides a basic back-end community version source code. By compiling / modifying the back-end source code, you can achieve deeper business customization, such as file upload / download, online / offline monitoring, API permission function, cluster function, etc. The backend project uses springboot ...

Introduction to Canal 1. Application Scenarios In the previous statistical analysis function, we have taken a service call to obtain statistics, which is highly coupled and relatively inefficient. At present, I take another way to achieve this by synchronizing the database tables in real time. For e ...

Article catalog title Introduction and characteristics summary Working mechanism Installation and configuration Common command operations of Sqoop Import data from the database into HDFS Export data on HDFS to database Introduction and characteristics Sqoop is a Hadoop And data transfer tools ...

1 Preface One MySQL host in the production environment has a single point of failure, so we want to make sure that MySQL is highly available, that is, two MySQLsServer If one of the MySQL servers hangs up, the other can take over immediately. MySQL's highly available solutions are generally as follows: keepalived+dual master MHA PXC MMM Hear ...

1, Introduction to cursors 1. Introduction to cursors Cursor is a database query stored on MySQL server. It is not a select statement, but a result set retrieved by the statement. With the cursor, the result set can be processed row by row conveniently. The design of cursors is the idea of data buffer, which is used to store the results of S ...