Lepus Monitoring Database

This post is a reference Lepus Official Documentation The official documentation was detailed, but some download links failed (maintainers of this open source product are busy, so updates are not timely) and the use of lepus was documented for their own writing style, so this post appeared. The Lepus system features are as follows: Remote mo ...

Posted by thelinx on Sat, 29 Feb 2020 08:17:26 -0800

Asynchronous write to MySQL database

Note: Both commit() and execute() of database pymysql submit data synchronously to the database when submitting data. Because of the resolution of scrapy framework data and the asynchronous multi-threaded, scrapy's data resolution speed is much higher than the speed at which data is written to the database.If the data is writte ...

Posted by Savahn on Fri, 28 Feb 2020 08:49:37 -0800

Ansible automatic operation and maintenance learning III: yaml syntax and playbook writing

Note: part of the code of the article case will be misaligned. Please pay attention to the format alignment when using!! Chapter 3 yaml syntax and playbook writing Ansible's playbook adopts yaml syntax, so before learning ansible playbook, it is necessary to understand and master the grammar format of yaml. Only by practicing and mastering the ...

Posted by JDcrack on Fri, 28 Feb 2020 02:22:44 -0800

Translation of official documents of Alertmanager

original text Abridged slightly Alarm overview Prometheus alarms are divided into two parts. Alarm rules in Prometheus server send alarms to alert manager, which processes these alarms, including silence, inhibition, aggregation, and sending notifications through email, online notification system and ...

Posted by senatedc on Thu, 27 Feb 2020 18:28:46 -0800

Mysql:MySQL Data Management

Foreign Key Management Foreign key concept If a public key is the primary key in a relationship, it is called the foreign key in another relationship.Thus, the foreign key represents the correlation between the two relationships.Tables whose primary key is a foreign key to another relationship are called primary tables, and tables with foreign ...

Posted by ph0ngwh0ng on Thu, 27 Feb 2020 11:47:50 -0800

MySQL high availability - PXC cluster

Blog Outline: 1, PXC introduction 2, Deploy PXC cluster 1, PXC introduction Reference resources: Official Percona PXC is an open source MySQL high availability solution, which integrates Percona Server and Xtrabackup with Galera library to realize synchronous multi master replication. High availability solutions based on Galera mainly incl ...

Posted by nic9 on Thu, 27 Feb 2020 03:17:08 -0800

hive installation (incomplete)

1. Three installation methods of hive Three installation methods of Hive are introduced on Hive official website, corresponding to different application scenarios. In the final analysis, the storage location of metadata is different. Embedded mode (metadata is saved in the embedded derby database, al ...

Posted by akreation on Thu, 27 Feb 2020 02:23:22 -0800

The use of database transaction in Spring BootSpring Boot

Hello, welcome to the program workplace, where you need to improve technology, career planning, personal growth, sideline development and other articles. Learn and improve with more small partners. This is the twelfth article in the Spring Boot series. Understanding the previous articles will hel ...

Posted by tinkertron on Wed, 26 Feb 2020 05:15:24 -0800

8, jOOQ series tutorial - Spring Boot and jOOQ integration

Complete tutorial: https://jooq.diamondfsd.com/ In the current situation of the prevalence of micro services, the micro service system based on Spring Boot or Spring Cloud is the mainstream, and it is also the new selection direction in the current business scenario Compared with using Spring directly, using Spring Boot to integrate jOOQ is rel ...

Posted by Hagaroo on Wed, 26 Feb 2020 02:47:19 -0800

Business logic implementation of SMS verification code

Mobile phone verification code is a function that we use in our daily life So let's assume that we can make this function work There are many ways to achieve this. Some of them are in slow storage Here I simply record the implementation process of the latter! First, make a button to submit the u ...

Posted by tsilenzio on Tue, 25 Feb 2020 19:56:11 -0800