What is Percona Server, How to Install in Ubuntu 14.04?
Percona Server is a tool used for relational database management. It is a fork of MySQL that comes with the Linux distribution and is developed independently. Percona Server, developed by InnoDB and MySQL experts, uses the same init scripts and command line as MySQL while promising more performance and scalability than MySQL.
* Licensed with General Public License (v2).
* Uses XtraDB instead of MySQL’s InnoDB storage engine.
* With this open-source product, you can get paid support and service if you wish.
It is not a problem that you have installed MySQL in your system. Percona Server makes the necessary changes and preserves both the data and /etc/mysql/my.cnf.
Package Manager Configuration for Installation
It is easy to install Percona Server for Ubuntu and Debian. Let’s open our /etc/apt/sources.list file and add our reflection to the end of the line.
$sudo vim /etc/apt/sources.list
deb http://repo.percona.com/apt quantal main
deb-src http://repo.percona.com/apt quantal main
Let’s mark Percona packages for not updating Ubuntu reflection.
$sudo vim /etc/apt/preferences.d/00percona.pref
Package: * Pin: release o=Percona Development Team Pin-Priority: 1001
Let’s update our local repository.
$ sudo apt-get update
Installing Percona Server
We can install Percona Server with the below command:
$ sudo apt-get install percona-server-server-5.5 percona-server-client-5.5
New password for the Percona Server “root” user:
Repeat password for the Percona Server “root” user:
We can check our version in MySQL console:
# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 42
Server version: 5.5.29–29.4 Percona Server (GPL), Release 29.4
Copyright © 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.
** You can check Percona Server Benchmark tests from Benchmark: MySQL 5.5 vs. Percona Server 5.5
** You can check here for a detailed comparison of database management systems.