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
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://188.8.131.52/jd ...
Posted by deejay on Mon, 10 Feb 2020 05:59:16 -0800
MySQL comes with four databases, which are:
This article introduces the performance ﹣ schema library.
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 theory + operation-02 (zabbix deployment + email alarm)
Monitoring end: 192.168.136.168Monitored end: 192.168.136.185
yum install -y \
mariadb-server mariadb \
vim /etc/httpd/conf/httpd. ...
Posted by DeathfireD on Mon, 10 Feb 2020 03:12:52 -0800
Refer to official information
1. This version of mysql needs to rely on libaio library. If not, you can download it using yum
shell> yum search libaio
Posted by djkanebo on Tue, 28 Jan 2020 07:19:35 -0800
Basic environment configuration:
yum remove firewalld -y
Turn off selinux
sudo vim /etc/selinux/config
Modify the following:
Install iptables services and ...
Posted by versatilewt on Wed, 22 Jan 2020 01:00:27 -0800
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
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
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. Add a global read lock to the backup library: fl ...
Posted by djopie on Thu, 16 Jan 2020 09:39:26 -0800
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