Installing binary mariadb

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

Full backup and restore of mysql database using mysql dump

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

CentOS7 installation configuration mysql5.7 tar installation free version

I. The system of CentOS7.4 comes with mariadb # View the Mariadb of the system [root@localhost~]# rpm -qa|grep mariadb mariadb-libs-5.5.44-2.el7.centos.x86_64 # 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

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

LNMP+Redis Architecture Deployment

Working mechanism 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

Detailed description of Nginx static and dynamic separation in Linux system

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

Primary primary replication, semi synchronous replication

MYSQL primary primary replication: mutual primary and secondary Easy problem: inconsistent data Host IP Master1 192.168.37.7 Master2 192.168.37.17 Master1 settings [root@Centos7 ~]#vim /etc/my.cnf [mysqld] log_bin server_id=7 auto_increment_offset=1 auto_increment_increment=2 Create a replication account MariaDB [(none)]> grant ...

Posted on Wed, 13 Nov 2019 11:45:41 -0500 by orange08

MySQL 5.7.28 binary installation under CentOS 7.4

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

[CentOS 7LNMP architecture 19], LNMP introduction and mysql installation in LNMP#

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 Install mysql Delete mysql [root@localhost ~]# ps aux | grep mysql root 3059 0.0 0.0 ...

Posted on Sat, 02 Nov 2019 15:31:52 -0400 by expertis

Data cleaning of zabbix database

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" FROM information_schema.TABLES WHERE table_schema = 'zabbi ...

Posted on Sat, 02 Nov 2019 12:35:39 -0400 by vince81