MiCloud只有在SmartOS中有預載Percona的服務,用戶可參考以下的步驟,在Linux環境下安裝。用户可参考以下的步骤,在Linux环境下安装。
Table of Contents |
---|
在CentOS中安裝Percona
...
1.將Percona的套件安裝至主機的套件庫中将Percona的套件安装至主机的套件库中
#rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm |
---|
...
2.請搜尋Percona的套件,並安裝下方框起來的二個套件请搜寻Percona的套件,并安装下方框起来的二个套件
#yum search percona |
---|
...
3.安裝Percona
# yum install Percona-Server-client-55.x86_64 |
---|
...
# yum install Percona-Server-server-55.x86_64 |
---|
...
4.請至etc下建立一個檔案,且命名為my请至etc下建立一个档案,且命名为my.cnf,並加入下方列出的幾個設定cnf,并加入下方列出的几个设定
#vi /etc/my.cnf |
---|
...
[mysqld]
plugin-load=handlersocket.so
loose_handlersocket_port = 9998
# the port number to bind to (for read requests)
loose_handlersocket_port_wr = 9999
# the port number to bind to (for write requests)
loose_handlersocket_threads = 16
# the number of worker threads (for read requests)
loose_handlersocket_threads_wr = 1
# the number of worker threads (for write requests)
open_files_limit = 65535
# to allow handlersocket accept many concurrent
# connections, make open_files_limit as large as
# possible. |
---|
...
5.啟動服務启动服务
#service mysql start |
---|
...
6.設定root密碼设定root密码
# mysqladmin -u root password 1qaz |
---|
...
7.登入mysql
#mysql -uroot -p |
---|
...
...
在Ubuntu、Debian安裝Percona
...
1.下載Percona套件至套件套中並安裝下载Percona套件至套件套中并安装
#gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
#gpg -a --export CD2EFD2A | sudo apt-key add - |
---|
...
2.依照不同OS及OS版本,加入不同的設定至依照不同OS及OS版本,加入不同的设定至/etc/apt/sources.list中。
#vi /etc/apt/sources.list |
---|
...
2-1 Ubuntu
a. Ubuntu10
deb http://repo.percona.com/apt lucid main
deb-src http://repo.percona.com/apt lucid main |
---|
...
b. Ubuntu12
deb http://repo.percona.com/apt precise main
deb-src http://repo.percona.com/apt precise main |
---|
...
2-2 Debian
deb http://repo.percona.com/apt squeeze main
deb-src http://repo.percona.com/apt squeeze main |
---|
...
3.更新套件庫更新套件库
#apt-get update |
---|
...
4.安裝Percona
#apt-get install percona-server-server-5.5 percona-server-client-5.5 |
---|
...
5.設定root密碼设定root密码
# mysqladmin -u root password 1qaz |
---|
...
6.登入mysql
#mysql -uroot -p |
---|
...