mysql Communication Protocol -- Create Connections

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

Delete the database without running away - Explain MySQL data recovery in detail

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 ...

Posted by buildernaut1 on Mon, 19 Aug 2019 00:11:41 -0700

PHP-RPM Installation Guide (Useful for hands-on testing)

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

Implicit conversion of scala

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 ...

Posted by hasjem on Fri, 16 Aug 2019 20:16:53 -0700

Big data - - Flume

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 ...

Posted by Magestic on Fri, 16 Aug 2019 06:53:44 -0700

Ali doesn't let MySQL multi-table Join? I want it!

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

Automation operation and maintenance tool saltstack - Grains, pillar, job cache, jinja template details and nginx, keepalived service configuration

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

Use of Saltstack Function Modules in Linux (salt-ssh, salt-syndic and salt-api)

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

MYSQL Asynchronous Replication

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

MySQL Realizes Recursive Query

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 ...

Posted by Saphod on Tue, 13 Aug 2019 01:33:00 -0700