Programmer Think

I. Achieving Requirements 1. The responsibility of the data access layer is to add, delete and modify the database, so it can be very single. It only needs one inteface to do it. 2. Automated ORM is not conducive to the optimization of SQL and the customization of SQL, so TeaFrameWork ORM is ready to be implemented in a semi-automatic way. De ...

1. Install elastic search The first time to use apt-get installation method, should be the software source is not set to the latest, the result of the installation version of 1.7x, decisive deletion. For the second time, download and install the zip package of elastic search directly. wget https://artifacts.elastic.co/downloads/elasticsearch/ ...

Database Architecture: One Primary and Two Subordinate master: 192.168.0.11 slave1: 192.168.0.201 slave2: 192.168.0.202 MHA software: Download address mha4mysql-manager-0.57.tar.gz mha4mysql-node-0.57.tar.gz The Manager Toolkit mainly includes the following tools: Masha_check_ssh Checks the SSH configuration of MHA Masha_check_repl che ...

Abstract:        Hand-in-hand teaches you how to build a vsftpd server, which implements virtual user authentication based on db files and MySQL database files. Of course, this article also includes the problem checking in the process of building, haha.        In ad ...

client initiates a connection request, shakes hands three times and exchanges validation information. How does mysql complete the validation work during this period? Process (three handshakes) How information is encrypted client: hash_stage1 = sha1(password) hash_stage2 = sha1(hash_stage1) reply = sha1(scramble, hash_stage2) ^ hash_stage1 ...

Preface Memory resources are managed by the operating system, and allocation and recovery operations may perform system calls (for example, malloc algorithm, the larger memory space allocation interface is mmap, and the smaller space is not returned to the operating system after free). Frequent system calls will inevitably reduce system perform ...

In MySQL replication environments, we usually judge SLAVE latency only based on the value of Seconds_Behind_Master. This is acceptable in most cases, but not accurate enough, and more factors should be taken into account. First, let's look at the state of SLAVE: > show slave status\G *************************** 1. row *************** ...

In the docker project, jenkins built by a single organization use gitlab web hook to integrate the project continuously. Note that this project is php project without build and test part. As for the test part, we will only carry out a submission and deployment function in the next section. This session will not talk about how to use docker to d ...

1. Common Notes 1.1 @Configuration @Configuration public class MainConfig { } @ The Configuration annotation indicates that this class is a configuration class that should contain details on how to create bean s in the context of Spring applications. 1.2 @ComponentScan @Configuration @ComponentScan("per.ym") public class MainConfig { } @ Comp ...

Background Recently, at 05:00 a.m., I always get warnings from the SQL firewall: group_name id user host db command time info state BASE 1059712468 xx xx.xx.xx.xx aea Query 34 UPDATE approve SET operator = 0', operator_name ='system', comment ='departure', status ='1'WHERE (id = 48311') updating When I first saw this data, the first react ...