Install Percona Server using a binary tar package
Install Percona Server using a binary tar package
InstallingPercona ServerFrom a Binary Tarball1. Download the binary tar package
Take version 5.6 as an example. Go to the official website https://www.percona.com/downloads/percona-server-5.6/latest/and you can see the following:
# Select a specific
Use the official binary installation directly.Https://www.percona.com/doc/percona-xtradb-cluster/5.6/installation.html#installationInnobackupex:This is actually a Perl script package for the following three tools, which can be backed up MyISAM, InnoDB, xtradb tables.Xtrabackup:A binary file compiled from C that can only back up InnoDB and xtradb data.Xbcrypt:The data used to encrypt or decrypt the backup.Xbstream:A compressed file used to decompress o
, wsrep_node_address=200.200.168.24 installation of each MySQL service, you need to modify their own IP
2, Wsrep_sst_method: When you just install, you need to set the slave node to rsync in order to sync successfully
MySQL services in each cluster are installed with the above steps
After the installation is complete, you can start MySQL.
The way to start MySQL, if it is the primary server, use/etc/init.d/mysql BOOTSTRAP-PXC, if it is a backup server,
Introduction of Percona-toolkit Tools
The Percona-toolkit, "PT Tool", is a collection of advanced command-line tools for performing various MySQL and system tasks that are complex and cumbersome to perform by hand, including:
Check the consistency of master and slave data
Effectively archive records
Look for Duplicate indexes
Summarizing Server information
Analyze queries from logs and tcpdump
Collect impor
Xtrabackup backup of large databases (full backup and Incremental Backup)
Xtrabackup
Xtrabackup is a free Database Hot Backup Software open source by percona. It can back up InnoDB databases and XtraDB storage engine databases in non-blocking ways (Table locks are also requi
Tags: record delete table Inno style rest Time Date Description poiuse third-party tools to back up MySQL-----perconaFirst, pre-preparation work:1, install the dependency package: Yum-y Install PERL-DIGEST-MD5 Perl-dbd-mysqlRPM-IVH libev-4.15-1.el6.rf.x86_64.rpm2. Installation Main package: percona-xtrabackup-24-2.4.7-1.el7.x86_64.rpm3. Contains two components:/usr/bin/xtrabackup: Supports InnoDB and XTRADB (incremental
After using Percona xtrabackup to do a full standby and two incremental backups, part of a table's data has been mistakenly deleted, how to recover mistakenly deleted data.
Thinking: will be fully prepared and incremental backup, the latest backup generated binary log all copied to the test environment, in the test environment after the deleted data recovery, wi
Install Percona Server using the source code package
Install Percona Server using the source code package
1. Download the source code tar package.
Https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.29-76.2/source/tarball/percona-server-5.6.29-76.2.tar.gz
Generally, it is not recommended to upgrade the database version. This script is dedicated to version control. To prevent compatibility issues between major versions, scripts by default only support upgrades between the same major version, such as MySQL-5.6.25 upgrade to MySQL-5.6.26, MySQL-5.5.44 upgrade to MySQL-5.5.45, MariaDB-10.0.20 upgrade to MariaDB-10.0.21; not across Branch versions and not across major versions, such as upgrading from MySQL-5.5.44 to PerconaL-5.5.44-37.3, MySQL-5.5.44
Need to use Percona-xtrabackup Backup to install this, it seems now this changed into a CMake installation, a little trouble.Why pick 2.3.4 version, because I heard that 2.3.3 unprepared for a deadlock.Functional requirements, using Innobackupex and xtrabackupInstall the dependency package first:Yum-y Install cmake gcc gcc-c++ libaio libaio-devel automake autoconf BZR bison libtool zlib-devel libgcrypt-deve
In CentOS 6.4 installation deployment Percona Xtrabackup, perform full backup script, backup unsuccessful, view log, error is as follows:11:15:51 innobackupex:connecting to MySQL server with DSN ' Dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_ Default_group=xtrabackup;mysql_socket=/data/lib/mysql/mysql.sock ' as ' dump ' (using Password:yes).Innobacku
invisible to mysql5.1.
So how can we support this software? First, we have set it to the default installation and use my. CNF, our world-class best practice, for configuration. Secondly, we have updated the monitoring system and can use the new 5.5 and special percona extension functions. Once again, we integrate the tips, graphics, and practical experience recommended by the company, and apply these to our management to better serve our customers.
mysql/mariadb/Percona Database Upgrade script intercepts upgrade_db.sh in Oneinstack, it is generally not recommended to upgrade the database version, this script is specifically provided to you version control. To prevent compatibility issues between large versions, scripts only support upgrades between the same large version by default, such as: MySQL-5.6.25 upgrade to MySQL-5.6.26, MySQL-5.5.44 upgrade to MySQL-5.5.45, MariaDB-10.0.20 upgrade to Ma
For data security, sometimes the database needs to delay backup, here are two ways to delay backup.First, the use of tools.Implementing the Environment:192.168.189.143 (MySQL Main library)192.168.189.144 (MySQL standby, 3 minutes delay)Steps:1: Install MySQL on the server and configure master-slave replication. Omitted2: View 144 copy status from the library, confirm that synchronization is OK, or write data tests on the main library.3: Download the
should be able to connect from remote)mysql_password=123456If there is no other way to copy the specific method on the Internet search (and also have mysqlchk this file. All two files must have execute permission)Vi/etc/services finally add:Mysqlchk 9200/tcp # MysqlchkStart xinetd (if Apt-get install xinetd is not installed)Service xinetd RestartStart HaproxyServices Haproxy StartOrHaproxy-f/etc/haproxy/haproxy.cfg-p/var/run/haproxy.pid-d-V (this is for debug start, error will print out)
System Maintenance engineer Li ChaoWe have introduced the Distributed Monitoring System zabbix-automatic discovery-add MySQL multi-instance monitoring, but did not provide the key that can be used directly, too shabby, the monitoring effect is poor. To monitor MySQL more carefully, the industry will choose to use Percona monitoring plugins to monitor MySQL. Percona has more detailed templates and scripts fo
MySQL Server Version:Server version: 5.7.10-log MySQL Community Server (GPL)Percona xtrabackup Version:Innobackupex version 2.4.2 Linux (x86_64) (revision id:8e86a84)Description[Master]: Represents a statement executed on the master library [slave]: Represents a statement executed on the slave library--Perform a master library full-ready[Master]innobackupex--parallel=4/data/backup/full--no-timestamp--Attach
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.