red hat Linux builds LAMP platform

Linux system, Apache, Mysql, PHP Ensure the existing development environment package before installing the configuration [root@localhost ~]# yum -y install pcre-devel zlib-devel links Turn off selinux and iptables [root@localhost ~]# vi /etc/selinux/config # Modify the configuration file and turn ...

Posted by falcon1 on Mon, 17 Feb 2020 22:51:48 -0800

tomcat multi instance jpress

Made by two couples 1. Basic environment preparation Step 1: download the installation package # wget -P /app/tools/ https://mirrors.tuna.tsinghua.edu.cn/apache/tomcat/tomcat-8/v8.5.50/bin/apache-tomcat-8.5.50.tar.gz # wget -P /app/tools/ http://47.111.238.157/jd ...

Posted by deejay on Mon, 10 Feb 2020 05:59:16 -0800

[MySQL] performance ﹣ schema Library of MySQL

MySQL comes with four databases, which are: information_schema performance_schema mysql test This article introduces the performance ﹣ schema library. Sketch Performance schema library is a new storage engine in MySQL 5.5. It is mainly used to collect database server performance parameters, monitor ...

Posted by tanju on Mon, 10 Feb 2020 03:27:39 -0800

zabbix 4.0 theory + operation - 02 (zabbix deployment + email alarm)

zabbix theory + operation-02 (zabbix deployment + email alarm) Experimental environment Monitoring end: 192.168.136.168Monitored end: 192.168.136.185 Install LAMP yum install -y \ httpd \ mariadb-server mariadb \ php \ php-mysql \ php-gd \ libjpeg* \ php-ldap \ php-odbc \ php-pear \ php-xml \ php-xmlrpc \ php-mhash vim /etc/httpd/conf/httpd. ...

Posted by DeathfireD on Mon, 10 Feb 2020 03:12:52 -0800

Installing mysql under linux

Download mysql https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz Refer to official information https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html 1. This version of mysql needs to rely on libaio library. If not, you can download it using yum shell> yum search libaio shel ...

Posted by djkanebo on Tue, 28 Jan 2020 07:19:35 -0800

Implementation of mariadb galera cluster based on docker

Environment configuration: Node name IP address node01 192.168.10.207 node02 192.168.10.167 Basic environment configuration: Remove firewalld yum remove firewalld -y Turn off selinux sudo vim /etc/selinux/config Modify the following: SELINUX=disabled Install iptables services and ...

Posted by versatilewt on Wed, 22 Jan 2020 01:00:27 -0800

Role application of Ansible automatic operation and maintenance playbook (deploying apache and zabbix)

I. Preface About roles Roles can be automatically installed in variable files, tasks, handlers, etc. according to the hierarchical structure. To use roles, you only need to use the include instruction in the playbook. In short, roles is a mechanism that can easily include variables, files, tasks, t ...

Posted by qistoph on Sun, 19 Jan 2020 03:24:48 -0800

centos7 mounts the new hard disk and modifies the storage path of mariadb

Environment CentOS7.4 mariadb 5.5 In principle, all mariadb installed from yum can be used Because the paths of / var/lib/mysql and / etc/my.cnf are the same The reason for this operation is that zabbix's history problem log has filled the disk, so you can only add a new hard disk and change the mysql storage path ------------------------- ...

Posted by br on Fri, 17 Jan 2020 23:53:23 -0800

Backup database using cp command

cp command backup is a warm, full backup, the backup process needs to maintain a global read lock, this lock is more lethal to the database, it is likely to make the database hang in production environment, so it is not recommended to use in production environment. 1. Backup 1. Add a global read lock to the backup library: fl ...

Posted by djopie on Thu, 16 Jan 2020 09:39:26 -0800

18 MySQL middleware proxysql realizes mysql read-write separation

1. The way of separating read from write in MySQL There are several ways for mysql to achieve read-write separation: The program modifies mysql operation, communicates with database directly, realizes load balance in a simple and quick way with separation of reading and writing and random way, and di ...

Posted by palace on Tue, 14 Jan 2020 21:33:23 -0800