Programmer Group

System environment Centos-7 mysql version mysql-5.7.17 1. Download and unzip rpm package [root@VM_42_245_centos ~]# tar xf mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar [root@VM_42_245_centos ~]# ls mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar mysql-community-client-5.7.17-1.el7.x86_64.rpm mysql-community-common-5.7.17-1.el7.x86_64.rpm ...

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 ...

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 ...

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 ...

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. ...

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 ...

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 ...

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 ...

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 ------------------------- ...

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 ...