Programmer Group

The content of this article is collated and validated according to the content of mysql official documents (all pictures are taken from the official website) The main contents of mysql communication co-connection stage include: Exchange information between client and server If the client has set up SSL, set up the SSL communication channel ...

In our daily work, there will always be some erroneous deletion of database tables and data caused by hand shaking, wrong writing conditions, wrong table names, wrong connection with production database. Then, if the data can not be recovered, what DBA is needed. Related articles MySQL Backup Strategy MySQL Data Recovery 1 Preface The premise ...

Note: This tutorial may have a lot of detours, but it is sure that the installation was successful. One problem is that the initial installation of the compiled instructions seems to be wrong, but it was corrected later, but this tutorial has encountered more than 10 problems and solved them, which has some reference and (django) It starts with ...

1. Implicit Conversion 1 Basic Introduction Implicit conversion functions are functions declared with a single parameter using the implicit keyword.This function is automatically applied to convert values from one type to another (2) Examples obj ...

Flume Log Collection System Summary operating mechanism Architecture of Flume Acquisition System Flume installation deployment A Simple Case of Flume Flume custom MySQL Source Custom Source Description Custom MySQL Source Composition Customize My ...

Links to the original text: https://mp.weixin.qq.com/s?__biz=MzUzMTA2NTU2Ng==&mid=2247487444&idx=1&sn=5325b3e29504162cd9c882c2c7f0e1d7&chksm=fa497065cd3ef973e229966f3c9c612cca8526d7201790e773ede29b9a855d27eb6d86449776&mpshare=1&scene=23&srcid=&sharer_sharetime=1565145500644&sharer_s ...

1. Configuration Management (continued) Now, on the basis of the previous blog post, I will continue to talk about configuration management. To supplement the knowledge of sls files: The core of Salt state system is SLS, or SaLt State file. _SLS r ...

Introduction of Saltstack Function Module 1. Introduction to salt-ssh Sal-ssh can run independently without minion, and use sshpass to interact with passwords, but it works in serial mode, resulting in a significant performance degradation. ...

Replication, replication is a highly available foundation, and the underlying layers of middleware such as MHA, mycat all rely on replication principles Master master master instance slave Slave slave Classification: default asynchronous replication, semi-synchronous replication after version 5.5, new GTID replication at version 5.6, multi-sour ...

Summary A few days ago, a client consulted about MySQL recursive query method. At that time, he had a simple understanding and felt that recursive query logic level is a special query method. However, it was later found that this is a very common query requirement, such as folding display of some comment floors, various flow charts and other re ...