Install mysql in RPM mode

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

Posted by Wo0tHigh on Sat, 04 Apr 2020 21:41:32 -0700

rpm installs mysql and modifies mysql login password

Reprint https://blog.csdn.net/yejiyueshang/article/details/78745664 Linux version: CentOS 6.5 64 bit 1. Download MySQL wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-1.el6.x86_64.rpm-bundle.tar 1 2. decompression mkdir mysql cd mysql [root@localhost mysql]# tar -xvf mysql-5.7.20-1.el6.x86_64.rpm-bundle. ...

Posted by soianyc on Thu, 02 Apr 2020 21:20:22 -0700

Installing mysql environment under linux

1. When installing apache, it has been checked that there is no mysql native to centos installed locally. If there is any, it must be uninstalled, or the port may be occupied 2. Prepare mysql installation package (note that when compiling, the compilation of mysql 5.5 and above is different from that of mysql 5.5 and below. 5.5 needs to be comp ...

Posted by Honor on Mon, 30 Mar 2020 11:37:11 -0700

MySQL data backup and recovery -- xtrabackup tool

The previous article introduced the logical backup tool mysqldump. This article will demonstrate the second part of data backup and recovery by using xtrabackup, a more popular physical backup tool. 1. Installation of xtrabackup tool 1.1 installation dependency package /* xtrabackup You need to install the related dependency package to use th ...

Posted by blear on Wed, 25 Mar 2020 05:45:51 -0700

MySQL high availability - PXC cluster

Blog Outline: 1, PXC introduction 2, Deploy PXC cluster 1, PXC introduction Reference resources: Official Percona PXC is an open source MySQL high availability solution, which integrates Percona Server and Xtrabackup with Galera library to realize synchronous multi master replication. High availability solutions based on Galera mainly incl ...

Posted by nic9 on Thu, 27 Feb 2020 03:17:08 -0800

Day06 RAID management tool - mdadm-raid0 management

Article directory mdadm introduction Parameters of the mdadm command Actual combat raid 0 Two new hard disks Create raid0 Save configuration information Create partition on raid 0 Format partition and mount Set up auto mount after power on mdadm introduction Management software raid tool: mdad ...

Posted by fimbria on Thu, 27 Feb 2020 00:51:10 -0800

Rabbitmq introduction and deployment cluster

Blog Outline:1, MQ introduction2, What is RabbitMQ?3, Installing RabbitMQ4, Deploy Rabbitmq cluster1) Deployment environment2) Install rabbitmq service3) Configure the host file and add the above two nodes to the cluster4) rabbitmq01 configure the cluster and add rabbitmq02 and 03 to the 01 cluster5) Accessing the web interface6) Add vhost to ...

Posted by brij_theinvader on Tue, 25 Feb 2020 22:24:35 -0800

MySQL master slave -- data verification

Article directory 4. PT table checksum to verify master-slave data 4.0 references and installation 4.1. Pt table checksum verification principle 4.2 notes and common parameters 4.2.1 precautions 4.2.2 description of common parameters 4.3 best practices 4.4 troubleshooting of common problems 4.4.1, ...

Posted by paran0id Dan on Sun, 23 Feb 2020 02:12:25 -0800

Ganglia of Flume monitoring

About Ganglia Ganglia is an open source cluster monitoring visualization tool initiated by UC Berkeley, which is designed to measure thousands of nodes. Ganglia's core includes gmond, gmetad and a Web front end. It is mainly used to monitor the system performance, such as: cpu, mem, hard disk utilizat ...

Posted by mackevin on Wed, 19 Feb 2020 23:19:50 -0800

CentOS7 installation and operation Docker

1. Confirm kernel version CentOS7 kernel is generally 3.10, which meets the installation conditions (> = 3.8) uname -r //perhaps uname -a 2. update pack yum unpdate -y This process may be a little slow. If there is a higher version of kernel, it will update back to 3.10 View the current default kernel grub2-editenv list Changed to newer k ...

Posted by jameslloyd on Wed, 19 Feb 2020 06:38:38 -0800