Installing Zabbix 3.4 from deployment packages

Installation from deployment packages Installation from Zabbix's official source library Zabbix SIA provides official RPM and DEB deployment packages for Red Hat Enterprise Linux, Debian and Ubuntu LTS systems. Deployment package files can be downloaded through repo.zabbix.com. The server provides both yum and apt source lib ...

Posted by kodlcan on Wed, 15 May 2019 01:11:52 +0200

Centos 7.2 Compile and Install Mysql 5.7.18 Configuration and Details

I. Main features of MySQL 5.7 (1) Native Support Systemd (2) Better performance: for multi-core CPU, solid-state hard disk, lock has better optimization (3) Better InnoDB storage engine (4) More robust replication: replication brings a solution that data is not lost at all. Traditional financial customers can also use mysql database. (5) A ...

Posted by mcubedma on Tue, 14 May 2019 23:09:50 +0200

Master-slave synchronization of mysql database to achieve read-write separation

In order to understand a large number of concurrent visits in large websites, it is far from enough to achieve distributed load balancing in websites. To the data business layer and data access layer, if the traditional data structure is still used, or only one server is used to handle so many database connection operations, th ...

Posted by Mr. Tech on Sun, 12 May 2019 04:31:44 +0200

2. MySQL server multi-instance and test experiment

Multiple instances In production, with the updating of database version or other requirements, it may be necessary to install multiple databases of different versions (or the same version) on one host. (The database here refers to an entire database separated by the database port number, rather than referring to the database in a database, pay ...

Posted by deejay on Sun, 12 May 2019 04:28:22 +0200

linux Installation mysql8.x

MySQL MySQL introduction MySQL was originally an open source relational database management system developed by Swedish company MySQL AB, which was acquired by Sun Microsystems in 2008. In 2009, Oracle acquired Sunrise Microsystems, and MySQL became Oracle's product. MySQL has become the most popular open source database in the past because of ...

Posted by sweetstuff2003 on Sat, 11 May 2019 22:52:05 +0200

Some characteristics of mariadb (<=10.4)

Recently, I read MariaDB's official website to introduce MariaDB's functions and characteristics, and outlined a few places that I feel it necessary to understand: Supporting column-level compression CREATE TABLE `cmp2` ( `id` bigint(20) NOT NULL, `name` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`)); https://mariadb.com/kb/en/library/storag ...

Posted by Crystal Dragon on Sat, 11 May 2019 22:26:21 +0200

Proxy SQL (11) of MySQL Middleware: Chain Rules (flagIN and flagOUT)

Return Proxy SQL Series: http://www.cnblogs.com/f-ck-need-u/p/7586194.html   1. Understanding Chain Rules In the mysql_query_rules table, there are two special fields, "flagIN" and "flagOUT", which are used to define the entry and exit of the rules respectively, so as to realize the chains of rules. The implementation of ch ...

Posted by pob123 on Sat, 11 May 2019 15:33:54 +0200

MySQL Queries (1)

This article includes the following contents Simple query Conditional query: Group query: group by Sort query: order by Reduplication of query results: distinct Limit query volume: limit 0 preparation First, create two tables employee and department: mysql> select * from employee; +----+----------+--------+--------+-- ...

Posted by abigail on Sat, 11 May 2019 10:55:36 +0200

Detailed description of the shell with python to automatically install zabbix monitor

Script environment 1.linux centos 7 system2. The CD-ROM image file has been mounted3. The system can connect to the external network.4. Font links: https://pan.baidu.com/s/1m9WJys5aGuUi-WgBG-zrxw Extraction code: qq6r Experimental steps 1. Upload font files and zabbix scripts to the Linux system / root directory Method 1: Mount Method 2: U ...

Posted by sicKo on Sat, 11 May 2019 10:00:42 +0200

Building wnmp under Windows

The running environment is windows server 2008 64-bit system. Installation directory D:/wnmp Mysql 5.7 Download Address: https://dev.mysql.com/downloads/mysql/5.7.html#downloads (This article chooses 5.7.25 | Microsoft Windows | All | Windows (x86, 64-bit), ZIP Archive) php7.2 Download Address: https://windows.php.net/downloads/releases/php-7. ...

Posted by cyberlew15 on Sat, 11 May 2019 09:05:31 +0200