Installation and description of mysql report monitoring tool

mysql report displays mysql status changes in a friendly way. In fact, it reports almost all the states. Unlike show status, which only shows more than 100 state values, mysql report interprets and formats these state values in a humane way, greatly increasing their readability. The advantage of MySQL report is that it can quickly view variou ...

Posted by jackthebookie on Sun, 23 Jun 2019 15:28:10 -0700

Basic commands of Mysql database

1. When you need to install mysql database through yumFirst you need to update the yum source[root@server ~]# rpm  -Uvh  http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm [root@server ~]# yum install mysql-community-server mysql-community-devel2. Source Package InstallationReference resources   http://douer ...

Posted by Ganlek on Sat, 22 Jun 2019 16:59:20 -0700

CentOS 7 installs mysql to change data storage location

Recently, I changed my computer system to centos. Everyday development tools need to be reconfigured. Here I record the configuration of mysql, which is different from the ubuntu series. Reference resources: http://www.centoscn.com/mysql/2016/0315/6844.html 1. MySQL relies on libaio, so first install libaio yum search libaio # Retrieval ...

Posted by Willburt on Sat, 22 Jun 2019 14:29:33 -0700

6. Use read to define variables

To illustrate the example below, we first install the Apache server and then start Apache. [root@localhost ~]# yum install httpd [root@localhost ~]# systemctl start httpd [root@localhost ~]# ps aux | grep http root 3716 0.5 0.0 221936 5000 ? Ss 13:49 0:00 /usr/sbin/httpd -DFOREGROUND apache 3717 0.0 0.0 224020 3088 ...

Posted by Gokul on Fri, 21 Jun 2019 13:55:33 -0700

LVS Dual-machine Load Balancing Deployment Scheme Based on Centos 7.3.10-514

LVS Dual-machine Load Balancing Deployment Scheme Based on Centos 7.3.10-514 Host: 192.168.1.51 Standby: 192.168.1.52 LVS VIP: 192.168.1.50 0. Production system local CD-ROM yum source Note: Use CentOS-7-x86_64-DVD-1611.iso file to upload to the system for completing the following installation steps without access to the public netwo ...

Posted by rake on Thu, 20 Jun 2019 17:06:20 -0700

CentOS 6.5 configures the LNPM environment (PHP 7.0)

CentOS 6.5 configures the LNPM environment (PHP 7.0) After installing virtual machine on window s platform, install LNPM (PHP 7.0) environment in CentOS 6.5: The following parts are reproduced separately from (thanks to the relevant authors, I only make merger adjustments for your reference): http://blog.csdn.net/boolbo/article/details/52353 ...

Posted by Jessup on Wed, 19 Jun 2019 12:03:34 -0700

CentOS6 Disc Merge

Introduction: Systems before CentOS6 and CentOS6 will store the system on two discs, DVD1 and DVD2. DVD1 can be used to install the operating system. System installation package files are stored in DVD1 and DVD2 respectively. When installing software using local yum sources, if you only use the package files on one disc, the installation ...

Posted by DJ Judas on Wed, 19 Jun 2019 09:55:58 -0700

Nginx configures multiple HTTPS domain names

This article is synchronized with the personal Github blog: https://github.com/johnnian/Blog/issues/8 Welcome to leave a message. Recently, I've been playing the Wechat app. I have the following programs on hand: A Cloud Server: CentOS 7 Multiple primary domain names During the development and testing process, for some reasons, we want to mak ...

Posted by @sh on Mon, 17 Jun 2019 11:41:39 -0700

pt-table-checksum checks master-slave database data

pt-table-checksum and pt-table-sync, the former is mainly used to verify the consistency of master and slave, and the latter is mainly used to repair data. The combination of the two can repair the problem of data inconsistency. 1. pt-table-checksum installation The latest address for downloading the toolkit is as follows: https://www.percona. ...

Posted by maxpagels on Sat, 15 Jun 2019 17:11:35 -0700

Tengine 2.2.0 Compilation, Installation, Boot-up, Reverse Agent Configuration and Health Check

Tengine 2.2.0 Compilation, Installation, Boot-up, Reverse Agent Configuration and Health Check tengine is an open source project based on nginx initiated by taobao. nginx throughput is relatively high, fast and stable, and reverse proxy and load balancing using nginx is the most common. This article describes how to compile and install under ...

Posted by LoganK on Thu, 13 Jun 2019 13:42:14 -0700