CentosLinux

How to Install Percona 8 in CentOS 7

1 Mins read

How to Install Percona 8 in Centos 7 – Percona Server for MySQL® is a free, fully compatible, enhanced and open source drop-in replacement for any MySQL database. It provides superior performance, scalability and instrumentation.

Percona Server for MySQL is trusted by thousands of enterprises to provide better performance and concurrency for their most demanding workloads, and delivers greater value to MySQL server users with optimized performance, greater performance scalability and availability, enhanced backups and increased visibility.

So essentially, yes. It is MySQL with some (very interesting) tweaks. You should use it when it solves a particular problem that you’re having. The list of differences are available at the product documentation page (linked above), but here’s a short list of what I believe are among the most compelling features:

– Improved Buffer Pool Scalability
– HandlerSocket included by default
– InnoDB Data Dictionary Size Limit
– Dynamic Row Format Memory Tables
– Extra slow query log statistics and configuration options

Follow these steps to Install Percona 8 in CentOS 7

yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

Enable percona server 8.0 repo

percona-release setup ps80

Install percona server

sudo yum install percona-server-server

Start mysql Server

service mysql start

Find the temporary password and login to mysql

sudo grep "temporary password" /var/log/mysqld.log

Run mysql_secure_installation

/usr/bin/mysql_secure_installation

Change the password, answer “yes” every question

Those are the article How to Install Percona 8 in CentOS 7, Keep going..

Related posts
Linux

Vim Keyboard Shortcut (or Vi) You Should Memorize

3 Mins read
Vim Keyboard Shortcut – The Vim editor is a command-line based tool that’s an enhanced version of the venerable vi editor. Despite…
CentosLinux

Semanage : Command Not Found in CentOS 7

1 Mins read
Semanage is an SELinux (Security-Enhanced Linux) management tool that is used to configure specific elements without making any adjustments to or reassembling…
CentosLinux

Install Nextcloud on CentOS 7 + Setting Let’s Encrypt SSL

3 Mins read
Install Nextcloud on CentOS 7 – This guide will walk you through the installation of Nextcloud on CentOS 7 with PHP 7.3,…

Leave a Reply

Your email address will not be published. Required fields are marked *