Technology sharing and using binlog Event to find problems

Author: Gao Peng (eight monsters) At the end of the article, there is his book "in-depth understanding of MySQL master-slave principle 32", in-depth understanding of MySQL master-slave, GTID related technical knowledge. With the previous understanding of events, we can use these events to complete some work. After learning these com ...

Posted on Thu, 12 Dec 2019 01:53:02 -0500 by MoFish

TiKV Source Parsing Series Articles TiKV Coprocessor Executor Source Parsing

Author: Dun Liming In the first two articles TiKV Source Parsing Series (14) Overview of Coprocessor,TiKV Source Parsing Series Articles (15) Expression Calculation Framework TiDB tries to push down Selection and Aggregation operators to TiKV nodes in order to maximize the distributed computing power, and how the pushed down expressions are com ...

Posted on Wed, 11 Dec 2019 22:12:06 -0500 by sahel

Spring Security & oauth2 implementation of SMS verification code to obtain AccessToken

The native OAuth2 dependency provided by Spring has several commonly used authorization methods built in: password, authorization code, client_credentials, refresh_token, implicit, etc. Although it can meet our daily needs, it is still helpless to meet some special needs, such as wechat login, SMS login, etc. for this point, ApiBoot is modified ...

Posted on Wed, 11 Dec 2019 02:26:58 -0500 by kannu

ubuntu mysql master-slave replication

1. The main service starts log bin # vim /etc/mysql/my.cnf .... server-id = 55 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M ... Restart mysql after modifying mysql configuration # service mysql restart Authorize slave permission mysql > grant repli ...

Posted on Wed, 11 Dec 2019 01:13:28 -0500 by CMC

Introduction to LAMP architecture and MySQL binary package installation

Introduction to LAMP architecture Linux + Apache(httpd) + MySQL + PHP PHP website (Google, Taobao, Baidu) Three roles can be in one machine or separated (httpd and PHP need to be together) httpd, PHP, MySQL working diagram It is a "dynamic" request process for PHP to read data from MySQL. MySQL/Mariadb introduction MySQL is a rela ...

Posted on Tue, 10 Dec 2019 17:37:35 -0500 by medusa1414

[hadoop] hive installation practice

1. Download Hive installation package: Download on official website: http://hive.apache.org/downloads.html 2. Upload Hive's tar package and extract it:Suggestions and hadoop directory at the first level, convenient for subsequent use; Unzip: tar -zxvf apache-hive-1.2.1-bin.tar.gz -C /home/hadoop/hive Modify the name of the extracted file: mv a ...

Posted on Tue, 10 Dec 2019 16:49:08 -0500 by knsito

java+js recursive loop tree to realize infinite pull-down menu

At present, article management is needed in the project. Each article needs to choose article classification, which is hierarchical and has no hierarchical limit. Therefore, there may be infinite drop-down menu when selecting classification My idea is to make the same as the above figure. If there is a next level of mouse ho ...

Posted on Tue, 10 Dec 2019 10:24:00 -0500 by pmzq

koa,express,node general method to connect MySQL

No matter node, express or koa, this tutorial can be connected by the following methods. Here, KOA is used as a reference New file directory, this is how I am Many tutorials do not involve the version, so let many beginners, copy his code, there are errorsMy version: "dependencies": { "koa": "^2.6.2", "mysql": "^2.16.0" } 1. Set con ...

Posted on Tue, 10 Dec 2019 09:27:13 -0500 by Dimensional

CentOS 7 steps to install Zabbix Server (MariaDB)

First, make sure that the computer can be connected to the Internet. Turn off SELinux, open 10050 and 10051 ports or turn off the firewall. Turn off SELinux reference Tutorial links. #Installation preparation rpm -Uvh https://repo.zabbix.com/zabbix/4.0/rhel/7/x86_64/zabbix-release-4.0-1.el7.noarch.rpm yum clean all #Install prerequisite ...

Posted on Tue, 10 Dec 2019 05:09:45 -0500 by FadeOut79

MySQL command window Chinese scrambling or inserting Chinese data failed

When using the command window to operate MySQL database on windows, if the character code of the command window is inconsistent with that of the database, there will be Chinese scrambling For example, Chinese characters may appear in query, or the error "ERROR 1366 (HY000): Incorrect string value: '\xD5\xC5\xC8\xFD' for column 'name' at r ...

Posted on Tue, 10 Dec 2019 03:26:42 -0500 by feyd