建議使用 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
Copyright (c) 2009-2013 Percona LLC and/or its affiliates
Copyright (c) 2000, 2013, 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.
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)
Linux (4)