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
Replace CentOS yum source under RedHat6.9
Catalog
Check and delete the original yum source
Download the yum source for CentOS
Install RPM package
yum configuration
Modify yum configuration
Clean up and rebuild cache
Because red hat's Yum needs to be charged and registered before it can be used. So I want to update the yum source to ...
Posted by Bizzle on Wed, 19 Feb 2020 05:44:06 -0800