Programmer Think

1, Background introduction When the number of MySQL database instances of the group reaches 2000 + and the scale of MHA cluster reaches hundreds, the timely and efficient management of MHA is a challenge that DBA s must face. MHA cluster node information and operation status are the basis of management. This section mainly introduces how to col ...

catalogue preface 1, LAMP overview 1. LAMP platform overview 2. Build LAMP platform sequence 3. Advantages of compilation and installation 4. Main functions of each component 2, Compile and install Apache httpd service   1. Close the firewall and transfer the software packages required to install Apache to the / opt directory 2. I ...

Install Docker Install Docker Compose (this is required for the operation of a complete project) This document mainly records the process of learning to deploy Docker. The article is followed by the deployment of open source projects based on Docker and Docker Compose. It's never too old to learn, keep an empty cup mentality, learn knowledg ...

explain analysis execution plan You can use the EXPLAIN or DESC command to obtain information about how MySQL executes the SELECT statement, including how tables are connected and the order of connection during the execution of the SELECT statement. Execution plan of query SQL statement: explain select * from tb_item where id = 1;   ...

mysql transaction In MySQL, transaction is actually the smallest and indivisible unit of work. Transactions can ensure the integrity of a business. Such as bank transfer a-> -100 update user set money = money-100 where name'a'; b-> +100 updata user set money=money +100 where name='b'; In the actual program. If only one ...

3. Menu management list data presentation 3.1 data architecture analysis After loading the menu list page, start the asynchronous loading operation of menu data. This menu list page should present the menu and superior menu information. During data query, the data encapsulation and transmission process is shown in figure-8. Figure-8 Note: Th ...

1. Description The description of each component is shown in the table below: assemblyeditionThe serverInstallation tutorialeffectcanal1.1.5canal1, canal2, canal3canal HA installation + mysql multi node automatic switchingzookeeper3.6.3canal1, canal2, canal3zookeeper fully distributed installationmysql8.0.25canal1, canal2MySQL master mast ...

In September, datawhale teamed up to learn task05 advanced SQL operations 1, Window function 1. Concept, basic usage Window function (OLAP function) Online AnalyticalProcessingReal time analysis and processing of database Window function allows us to selectively summarize, calculate and sort some data Conventional SELECT statemen ...

preface Teach you how to use sharding JDBC to realize the database sub database and sub table. 1, Concept Sub database and sub table Database and table splitting is a reasonable splitting of databases and tables when the amount of data is large to a certain extent. Take MySQL as an example: it is recommended that the maximum amount ...

part 1 ORM framework ORM (Object-Relational Mapping) The emergence of ORM framework is essentially to simplify the coding of database operations in the programming process. Now this ORM framework can be basically divided into two categories. First, the representative of fully automatic ORM framework is -- > hibernate claims that you don't n ...