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