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
Posted by Frozen Kiwi on Tue, 20 Aug 2019 23:14:57 -0700
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.
MySQL Backup Strategy
MySQL Data Recovery
The premise ...
Posted by buildernaut1 on Mon, 19 Aug 2019 00:11:41 -0700
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 ...
Posted by UKlee on Sun, 18 Aug 2019 09:44:28 -0700
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
Posted by hasjem on Fri, 16 Aug 2019 20:16:53 -0700
Flume Log Collection System
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 ...
Posted by Magestic on Fri, 16 Aug 2019 06:53:44 -0700
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
Posted by seanpaulcail on Thu, 15 Aug 2019 05:37:27 -0700
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 ...
Posted by Beavis2084 on Thu, 15 Aug 2019 05:02:16 -0700
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.
Posted by ruthsimon on Thu, 15 Aug 2019 03:01:11 -0700
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 ...
Posted by Gast on Wed, 14 Aug 2019 22:04:55 -0700
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 ...
Posted by Saphod on Tue, 13 Aug 2019 01:33:00 -0700