Let's download the required binaries from the official website belowhttps://downloads.mariadb.org/mariadb/10.2.3/#bits=64After downloading, we can also check md5 to ensure that the package is not damaged during transmission and there will be no strange problems during installation
1 Prepare users and groups
groupadd -r -g 336 mysql
useradd -r ...
Posted on Sun, 17 Nov 2019 11:11:13 -0500 by Kevmaster
1 > start database binary log
Check whether SQL log bin is enabled
MariaDB [(none)]> show variables like 'sql_log_bin';
| Variable_name | Value |
| sql_log_bin | ON |
1 row in set (0.00 sec)
Use set SQL log bin = on; turn on binary log
Modify profileSpecif ...
Posted on Sat, 16 Nov 2019 17:17:58 -0500 by creatives
I. The system of CentOS7.4 comes with mariadb
# View the Mariadb of the system
[root@localhost~]# rpm -qa|grep mariadb
# Uninstalling Mariadb from the system
[root@localhost ~]# rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64
# Delete my.cnf in etc directory
[root@localhost ~]# rm /etc/my.c ...
Posted on Fri, 15 Nov 2019 12:14:31 -0500 by nincha
Apache and LNMP architecture do dynamic and static separation
nginx has strong static processing ability and insufficient dynamic processing ability, so we need to give the dynamic page to Apache to realize dynamic and static separation.
Install apache service first
[root@localhost ~]# yum install httpd httpd-devel -y ##Installing the Apach ...
Posted on Thu, 14 Nov 2019 15:07:31 -0500 by karnegyhall
The L (Linux) N (Nginx) M (Mysql) P (PHP) architecture must be known to all that the main purpose of the LNMP architecture is to connect front-end services to back-end storage and one of the back-end services to achieve dynamic requests for PHP programs.
Today we add a Redis program to the LNMP architecture, which plays a da ...
Posted on Thu, 14 Nov 2019 02:45:16 -0500 by Clinger
Introduction of Nginx Dynamic and Static Separation
Nginx has a strong static processing capability but insufficient dynamic processing capability. Therefore, dynamic and static separation technology is commonly used in enterprises.
Dynamic and Static Separation for PHP
Give static pages to Nginx
Dynamic pages are handled by PHP-FPM modules ...
Posted on Thu, 14 Nov 2019 02:31:38 -0500 by ureck
MYSQL primary primary replication: mutual primary and secondary
Easy problem: inconsistent data
[root@Centos7 ~]#vim /etc/my.cnf
Create a replication account
MariaDB [(none)]> grant ...
Posted on Wed, 13 Nov 2019 11:45:41 -0500 by orange08
Linux system version: CentOS 7.4MySQL version: 5.7.28In Linux platform, there are RPM package, binary package and source package. This article mainly takes RPM package as an example to introduce how to install MySQL on Linux platform.Download address:https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
The spec ...
Posted on Mon, 04 Nov 2019 16:47:07 -0500 by smti
shallow A kind of ove
LNMP architecture introduction
Unlike LAMP, Nginx provides web Services
And php exists as an independent service, which is called php FPM.
Nginx processes static requests directly, and dynamic requests are forwarded to PHP FPM
[root@localhost ~]# ps aux | grep mysql
root 3059 0.0 0.0 ...
Posted on Sat, 02 Nov 2019 15:31:52 -0400 by expertis
backgroundBecause the historical data of zabbix is too large, it takes up too much disk space, so it needs to clean up the data and free up space.
1. Check the space occupied by the table
SELECT table_name AS "Tables",
round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
WHERE table_schema = 'zabbi ...
Posted on Sat, 02 Nov 2019 12:35:39 -0400 by vince81