安裝 Percona MySQL on Ubuntu－flyfox

建議使用 Percona MySQL 官方提供的 Repo。
若 /etc/apt/sources.list.d/ 下沒有 percona.list，且 /etc/apt/sources.list 中也無相關設定，
代表沒有設定 Percona MySQL 專用 repo。

安裝 Percona MySQL repo key
# sudo apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

# sudo vi /etc/apt/sources.list.d/percona.list
deb http://repo.percona.com/apt precise main
deb-src http://repo.percona.com/apt precise main

若 Ubuntu 版本非 12.04 (precise)，請將 precise 換成以下指令產生的代號
# lsb_release -cs
lucid (Ubuntu 10.04)

更新套件資料庫
# sudo apt-get update

安裝指定版本
# sudo apt-get install percona-server-server-5.1

移除指定版本
# sudo apt-get remove percona-server-server-5.1

自動升級
# sudo apt-get install percona-server-server

無法以 sudo apt-get remove 移除的軟體
# dpkg --get-selections |grep deinstall
libaio1 deinstall
libmysqlclient16 deinstall
libmysqlclient18 deinstall
percona-server-client-5.1 deinstall
percona-server-client-5.5 deinstall
percona-server-server-5.1 deinstall
percona-server-server-5.5 deinstall

手動移除無法以 sudo apt-get remove 移除的軟體
# sudo apt-get purge percona-server-client-5.1

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 59
Server version: 5.6.13-rc60.5 Percona Server (GPL), Release 60.5

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.

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.02 sec)