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
Posted by Wo0tHigh on Sat, 04 Apr 2020 21:41:32 -0700
Linux version: CentOS 6.5 64 bit
1. Download 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
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
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
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
Parameters of the mdadm command
Actual combat raid 0
Two new hard disks
Save configuration information
Create partition on raid 0
Format partition and mount
Set up auto mount after power on
Management software raid tool: mdad ...
Posted by fimbria on Thu, 27 Feb 2020 00:51:10 -0800
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
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.2 description of common parameters
4.3 best practices
4.4 troubleshooting of common problems
Posted by paran0id Dan on Sun, 23 Feb 2020 02:12:25 -0800
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
1. Confirm kernel version
CentOS7 kernel is generally 3.10, which meets the installation conditions (> = 3.8)
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
Changed to newer k ...
Posted by jameslloyd on Wed, 19 Feb 2020 06:38:38 -0800