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
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
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
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
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
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`));
Posted by Crystal Dragon on Sat, 11 May 2019 22:26:21 +0200
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
This article includes the following contents
Group query: group by
Sort query: order by
Reduplication of query results: distinct
Limit query volume: limit
First, create two tables employee and department:
mysql> select * from employee;
Posted by abigail on Sat, 11 May 2019 10:55:36 +0200
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
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
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