Build a pure LAPM environment: CentOS 7.3 + Apache 2.4.29 + Php 5.6.35 + MySQL 5.6.24 (1-MySQL 5.6.24 installation)

The LAPM environment has been built many times in a year. Every time there are many pits, and then a little bit to solve them. Eventually, it was all over, but I was really tired and paralyzed. Tired, I think: Fortunately, it has been built, and I don't think it will be built in the future. So the whole process is not record ...

Posted on Tue, 25 Dec 2018 09:12:06 -0800 by darkwolf

MySQL Optimization -- NOT EXISTS and LEFT JOIN differences

In MySQL, we can convert NOT EXISTS statement to LEFT JOIN statement to optimize. Why is there performance improvement? Using NOT EXISTS mode, SQL is as follows: SELECT count(1) FROM t_monitor m WHERE NOT exists (SELECT 1 FROM t_alarm_realtime AS a WHERE a.resource_id=m.resource_id AND a.resource_type=m.resource_type AND a.monitor_na ...

Posted on Tue, 25 Dec 2018 00:36:07 -0800 by dxdolar

Deployment of MySQL Group Replication multiple master modes under Centos 6.8 (5.7 new features)

MySQL Group Replication (MGR) is a new high availability and high scalability solution launched by MySQL in December 2016. MySQL group replication provides high availability, high scalability and high reliability MySQL cluster services. 1. Introduction to MGR 1.1 features: Write More, Write Conflict Detection Excellent scalability, dyna ...

Posted on Mon, 24 Dec 2018 17:06:06 -0800 by Froolah

MySQL Access denied for user 'root'@'localhost'

#MySQL Access denied for user 'root'@'localhost' Causes of the problem: Execution of orders CREATE USER goodboy IDENTIFIED BY 'goodboy'; GRANT ALL privileges ON *.* TO 'goodboy'@'%' identified by 'goodboy' WITH GRANT OPTION; flush privileges; Errors occurred when granting all database privileges to goodboy users ERROR 1045 (28000): ...

Posted on Mon, 24 Dec 2018 14:09:07 -0800 by schwa97

How RDS for MySQL uses Percona Toolkit

Percona Toolkit contains a variety of tools for MySQL database management. Following is a description of the common use of pt-online-schema-change and pt-archiver with RDS MySQL. Note: Both pt-online-schema-change and pt-archiver tools must specify the no-version-check option to be used with RDS MySQL instances. This sample is tested using ve ...

Posted on Sun, 23 Dec 2018 23:33:06 -0800 by ThaboTheWuff

net.sz.framework framework framework easy to build services - - let you focus more on logical functions - - a preliminary study

Preface In previous articles, I have explained threadmodel, socket tcp, socket http, log, astart, scripts; All of them are explanations in fragments. From today on, we will take you a glimpse of the net.sz.framework framework. net.sz.framework framework is divided into java version and C net version, and the two language versions keep high cons ...

Posted on Sun, 23 Dec 2018 13:48:06 -0800 by snafudawn

EMQ Mega MQTT Message Service (TLS Docker Golang)

Enclosed: Meow a Mimi's blog: w-blog.cn EMQ official address: http://emqtt.com/ EMQ Chinese Documents: http://emqtt.com/docs/v2/guide.html 1.TLS Certificate Verification In order to ensure security, we often use HTTPS to ensure that requests are not tampered with, and TLS encryption as MQTT to ensure transmission security. The default TLS encr ...

Posted on Sun, 23 Dec 2018 02:24:06 -0800 by pythian

Database connection pool and com.mysql.jdbc.exceptions.jdbc4.Communications Exception exception

The abnormal information is as follows: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in mit/datamodel/ibatis/person.xml. --- The error occurred while executing query. --- Check the select * from person where pID = ?. --- Check the SQL Statement (preparation failed). --- Cause: com.mysql.jdbc.exception ...

Posted on Sat, 22 Dec 2018 11:06:06 -0800 by daanoz

[Drools rule engine] Drools 6.5.0 + eclipse 4.6.2 + Jdk1.7 + Tomcat 1.7 environment deployment

Preface A Demo runs very hard and the environment is not clear. It always encounters problems of one kind or another, such as the following: 1. value '1.8' is not a valid language level error 2. Unsupported major.minor version 51.0 Therefore, this article begins by explaining environmental dependence: Drools 6.5.0 http://www.drools.o ...

Posted on Fri, 21 Dec 2018 06:12:05 -0800 by joeywoodbury

centos 6.8 Install LNMP Environment (linux+nginx+mysql+php)

Nginx characteristicsNginx has the advantages of stable performance, rich functions, simple operation and maintenance, fast processing of static files and little system resource consumption.1. Compared with Apache, Nginx serves as a Web server: it uses fewer resources, supports more concurrent connections and is more efficient.2. As a load bala ...

Posted on Thu, 20 Dec 2018 22:03:06 -0800 by russian_god