Ubuntu Server 16.04 installation Percona server 5.7来 instead of MySQL or mariadb detailed tutorial

This article tags: Ubuntu MySQL ubuntuserver perconaserver MySQL database server performance optimization Internet Gossip
What is the goods?

Percona has improved mysql database server, with a significant increase in functionality and performance compared to MySQL. This version improves the performance of InnoDB under high load conditions, provides some very useful performance diagnostic tools for DBAs, and additional parameters and commands to control server behavior. Via

Through long-term practice and production environment testing, the performance and stability of Percona server is much better than native MySQL or MariaDB, at least not a variety of strange bugs, so all our new servers have been deployed uniformly Percona Server is used instead of MySQL or MariaDB

Second, installation steps

1. Follow the official tutorials to download the latest version of the. deb file

wget https://repo.percona.com/apt/percona-release_0.1-4.xenial_all.deb

2 dpkg . Install with command. Deb

dpkg -i percona-release_0.1-4.xenial_all.deb

3. Then use the Cat command to check if the official source of the Percona is properly joined

cat /etc/apt/sources.list.d/percona-release.list

4. Update the system

sudo apt-get update

5. Install Percona server 5.7 and Percona server Client 5.7

sudo apt-get install percona-server-server-5.7 percona-server-client-5.7

Third, other

The remaining installation steps are consistent with the MySQL installation method of the Ubuntu Server 16.04 installation lemp/lnmp Tutorial.

In general, the default configuration is sufficient for small and medium-sized websites, and if you have special needs, you can use the Percona configuration Wizard to customize your MySQL profile.

written at the end: for Freedom look outside the world, as well as it this line, not to go to Google data, finally, Amway a V--PN agent. a red apricot VPN, to Google to check the information is the absolute first choice, the connection speed, the use is also convenient. I bought is 99￥ a year, through this link (http://my.yizhihongxing.com/aff.php?aff=2509) registered after the Member center to lose the coupon code, split down, only 7 yuan per month, special benefits.

This article tags: Ubuntu MySQL ubuntuserver perconaserver MySQL database server performance optimization Internet Gossip

Turn from SUN's BLOG-focus on Internet knowledge, share the spirit of the Internet!

Original address: "Ubuntu server 16.04 install Percona server 5.7来 instead of MySQL or mariadb detailed tutorial "

Related reading: Aaron swartz– The internet genius of the life course: every moment asked himself, now the world what is the most important thing I can participate in doing? "
Related reading: " site environment Apache + PHP + mysql xampp, how to implement a server on the configuration of multiple sites?" "

Related reading: What is the engineer culture? Why are the engineers alive? Why do I need an engineer culture as an IT or internet company? "

Related reading: useful for programmers: 2017 latest in Google's Hosts file download and summary of the various hosts encountered the problem of the solution and configuration of the detailed

related reading: the Win10 perpetual activation tutorial and how can I see if the Windows system is permanently activated? 》

Related blog:SUN ' S blog -Focus on Internet knowledge and share the spirit of Internet! Go and see:www.whosmall.com

Original address: http://whosmall.com/?post=210

Ubuntu Server 16.04 installation Percona server 5.7来 instead of MySQL or mariadb detailed tutorial