Tag: percona

Percona MongoDB 4 builds a replica set

What is a replica set: Is a set of mongod processes that maintain the same data set Provides redundancy, automatic failover and high availability Provides read scalability The internal concepts are more or less similar to those of MySQL PRIMARY concept is roughly the same as MASTER in MySQL replication The SECONDARY concept is roughly […]

percona-xtrabackup-2.4-various versions

percona-xtrabackup-2.4.28-Linux-x86_64.glibc2.17-minimal.tar.gz 13.0 MB DOWNLOAD percona-xtrabackup-2.4.28-Linux-x86_64.glibc2.17.tar.gz 73.1 MB DOWNLOAD percona-xtrabackup-2.4.27-Linux-x86_64.glibc2.12-minimal.tar.gz 12.7 MB DOWNLOAD percona-xtrabackup-2.4.27-Linux-x86_64.glibc2.12.tar.gz 73.6 MB DOWNLOAD percona-xtrabackup-2.4.26-Linux-x86_64.glibc2.12-minimal.tar.gz 12.6 MB DOWNLOAD percona-xtrabackup-2.4.26-Linux-x86_64.glibc2.12-minimal.tar.gz.sha256sum 130 bytes DOWNLOAD percona-xtrabackup-2.4.26-Linux-x86_64.glibc2.12.tar.gz 73.0 MB DOWNLOAD percona-xtrabackup-2.4.26-Linux-x86_64.glibc2.12.tar.gz.sha256sum 122 bytes DOWNLOAD percona-xtrabackup-2.4.25-Linux-x86_64.glibc2.12-minimal.tar.gz 12.6 MB DOWNLOAD percona-xtrabackup-2.4.25-Linux-x86_64.glibc2.12-minimal.tar.gz.sha256sum 130 bytes DOWNLOAD percona-xtrabackup-2.4.25-Linux-x86_64.glibc2.12.tar.gz 73.0 MB DOWNLOAD percona-xtrabackup-2.4.25-Linux-x86_64.glibc2.12.tar.gz.sha256sum 122 bytes DOWNLOAD percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12-minimal.tar.gz 12.6 MB DOWNLOAD percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12-minimal.tar.gz.sha256sum 130 bytes […]

Build a Mysql derivative Percona database cluster through PXC

Build a Mysql derivative Percona database cluster through PXC 1. Install Percona database 1. Install Percona offline Enter the RPM installation file directory and execute the following script yum localinstall *.rpm Manage MySQL services systemctl start mysqld systemctl stop mysqld systemctl restart mysqld 2. Install Percona online Install using yum command yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm yum […]

bclinux 8.6 install percona-xtrabackup

1. Download Check the operating system version # cat /etc/os-release NAME=”BigCloud Enterprise Linux” VERSION=”8.6 (Core)” ID=”bclinux” ID_LIKE=”rhel fedora” VERSION_ID=”8.6″ PLATFORM_ID=”platform:an8″ PRETTY_NAME=”BigCloud Enterprise Linux 8.6 (Core)” ANSI_COLOR=”0;31″ CPE_NAME=”cpe:/o:bclinux:bclinux:8″ HOME_URL=”https://mirrors.bclinux.org/” BUG_REPORT_URL=”https://bugs.bclinux.org/” BCLINUX_BUGZILLA_PRODUCT=”BigCloud Enterprise Linux 8 (Core)” BCLINUX_BUGZILLA_PRODUCT_VERSION=8.6 BCLINUX_SUPPORT_PRODUCT=”BigCloud Enterprise Linux 8 (Core)” BCLINUX_SUPPORT_PRODUCT_VERSION=8.6 [root@hedun-zbmysql-01 ~]# Log in to the official website to download the corresponding version: Software […]

Percona XtraBackup full backup, additional backup

1. Fully prepared 1.1 Full database backup Create a backup directory mkdir -p /u01/mysql/backup/full fully equipped xtrabackup –backup –datadir=/u01/mysql/data/mysql3306/data/ \ –target-dir=/u01/mysql/backup/full/`date + ‘%Y%m%d’`/ … 2023-05-29T13:27:44.185420+08:00 0 [Note] [MY-011825] [Xtrabackup] All tables unlocked 2023-05-29T13:27:44.185449+08:00 0 [Note] [MY-011825] [Xtrabackup] Copying ib_buffer_pool to /u01/mysql/backup/full/20230529/ib_buffer_pool 2023-05-29T13:27:44.185496+08:00 0 [Note] [MY-011825] [Xtrabackup] Done: Copying ib_buffer_pool to /u01/mysql/backup/full/20230529/ib_buffer_pool 2023-05-29T13:27:44.190740 + 08:00 0 […]

percona-server-rocksdb-8.0.32 installation

MyRocks is a storage engine based on RocksDB for the relational database Mysql, an embeddable, persistent key-value store. Percona MyRocks is integrated with Percona Server for MySQL. RocksDB stores a log-structured merge tree (LSM tree). It is optimized for fast storage, with excellent space and write efficiency and acceptable read performance. Therefore, if your workload […]

“show engine innodb status” in Percona 8.0.30 leads to coredump troubleshooting and analysis

1. Abnormal crash In the beta test of GreatSQL merging Percona-Server 8.0.30, QA reported a crash bug: ########### bug list ########## When benchmarksql loads 1000 bins of data, a coredump occurs on the database instance. The core stack information is as follows: #0 0x00007f51315a39d1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000013258cd in handle_fatal_signal () at […]

upgrade percona mysql 8.0.18 to 8.0.32

Preface: This article describes upgrading mysql8.0.x to the latest version to fix the following vulnerabilities. According to this method to upgrade, the configuration file and database structure content still exist (to be safe, you still need to export my.cnf and database structure to prevent problems). Ideas: 1. Back up my.cnf and use mysqldump to export […]