Shulou(Shulou.com)05/31 Report--

This article shows you how to install TokuDB, which is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

One: the reason

Compared with ordinary business data, the data generated by the monitoring system has the characteristics of absolute majority of writing requirements and relatively few reads.

The previously used PMM monitoring system, its docker version of the solution, not only does not build its own percona branch database, but also uses the older 5.5official branch version. After monitoring the libraries and hosts of 6 instances. Three weeks later, it took up 9GB space.

Thankfully, taking this into account, Percona will automatically delete backup historical data on a regular basis according to the available capacity of the PMM server's hard disk.

For a DBA, you need to pay attention to the historical load of a library to facilitate hardware expansion planning compared with the same period last year. At least two years of complete data.

Second: solutions

The highly compressed TokuDB engine is used to compress and store historical data.

TokuDB is a highly scalable, zero-maintenance downtime MySQL storage engine that delivers indexing-based query acceleration, improved replication performance, unparalleled compression, and live schema modification. The TokuDB storage engine is a scalable, ACID and MVCC compliant storage engine that provides indexing-based query improvements, offers online schema modifications, and reduces slave lag for both hard disk drives and flash memory.

This storage engine is specifically designed for high performance on write-intensive workloads which is achieved with Fractal Tree indexing.

Three: installation steps

Tokudb can be enabled either on the official community version of MySQL or on the percona partition. Considering that the percona branch version supports more monitoring features than the official version, the percona-mysql-server version is used this time.

Pre-installation preparation

# systemctlstop firewalld # stop the system Firewall # systemctl mask firewalld # shielded Firewall self-boot # setenforce 0 # close SELinux#sed-I's Universe EnforcingAccord Performing percona GO / etc/selinux/config # permanently close SELinux# to create percona software source # cat > / etc/yum.repos.d/percona-release.repo

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.