Building zabbix monitoring system
Building Automation Service Platform--zabbix Monitoring Platform
Preparatory environment
Prepare a Linux host (CentOS 7 example)
LAMP platform has been installed
Close Firewall and SELinux
Setting IP Address
Setting up yum source
Individual symbols in linux instructions will conflict with the text editing language of the blog. I will use spac ...
Posted by chriskiely on Fri, 07 Jun 2019 16:56:09 -0700
Compiling MySQL from Source
Note: This compilation of MySQL-5.7.19 uses Linux (CentOS7) system Yum-y install make gcc-c + + bison-devel before compilation (Ubuntu and Debian install using apt-get)
make, a very important compilation tool under Linux, the most important and basic function is to describe the relationship between source programs through makefile files a ...
Posted by flash99 on Fri, 31 May 2019 17:32:34 -0700
MySQL Character Set Setting Details
1. Overview of Contents
During the use of MySQL, it is important to understand the concepts of character set, character order, and the impact of different settings on data storage and comparison.The problem of "random code" that many students encounter in their daily work is probably caused by the inadequate understanding of char ...
Posted by FarhanKhalaf on Fri, 17 May 2019 15:14:30 -0700
Install Zabbix 3.4 based on entOS 7
Zabbix is an enterprise-level distributed open source monitoring solution. It can monitor various network parameters as well as the health and integrity of servers. It supports flexible notification mechanism and provides excellent reporting and data visualization functions. Zabbix supports active polling and passive ca ...
Posted by desmond_ckl on Thu, 16 May 2019 17:15:18 -0700
Installation in mysql Linux
Linux version
Linux localhost.localdomain 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:43 EDT 2010 i686 i686 i386 GNU/Linux
From: http://www.cnblogs.com/xiaochaohuashengmi/archive/2011/10/18/2216087.html
Configuration of Mysql under Linux (rpm installation)
install
rmp -ivh MySQL-server-4.1.22-0.glibc23.i386.rpm --nodep ...
Posted by Hodo on Thu, 16 May 2019 02:10:16 -0700
centos7 Offline RMP Installation mysql-Pro Testing Effective
download
Download address of CentOS 7: https://dev.mysql.com/downloads/mysql/5.7.html#downloads
Don't choose the wrong version
I downloaded this: mysql-5.7.25-1.el7.x86_64.rpm-bundle.tar
===============================================================================================
The following installation process is ...
Posted by chaser7016 on Wed, 15 May 2019 12:09:58 -0700
Data type and integrity constraints for MySQL databases
Supplement:
select * from mysql.user #Show chaos
select * from mysql.user\G #Added\G The next line shows
Data Type: Store different types of data in different categories
The storage engine determines the type of table, and there are different types of data stored in the table. U.S. and Chinese data types have their own widths, but the ...
Posted by alecapone on Sat, 11 May 2019 18:36:36 -0700
Zabbix Implementation Monitoring | Zabbix Monitoring Example
I. overview
zabbix is an enterprise-level open source solution based on WEB interface to provide distributed system monitoring and network monitoring functions. zabbix can monitor all kinds of network parameters to ensure the safe operation of the server system, and provide flexible notification mechanism to enable system admi ...
Posted by carefree on Sat, 11 May 2019 12:49:35 -0700
Installation of mysql on linux
Installation of mysql on linux (yum source installation)
https://blog.csdn.net/huyangg/article/details/71308147
Installation of mysql on linux (binary installation)
Note: Install mysql-5.6.39-linux-glibc2.12-x86_64.tar.gz on centos7
1) Download the installation package for mysql
Official website download
Baidu Cloud Downl ...
Posted by zephyrstudios on Fri, 10 May 2019 14:16:34 -0700
MySQL Binary Log Format
MySQL Binary Log Format
Log classification
MySQL Storage Engine Layer Log
innodb
Redo log
Rollback Log
MySQL Service Layer Log
Binary logs
Slow check logs
General log
Introduction to Binary Logs
All modification events to the MySQL database, including DDL and DML operations, were recorded. The binlog only logs successful execution ...
Posted by attock on Thu, 11 Apr 2019 11:51:31 -0700