Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Image Removed

Image Added

3.安裝Percona

# yum install Percona-Server-client-55.x86_64

...

Image Removed

Image Added

# yum install Percona-Server-server-55.x86_64

...

Image Removed

Image Added

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.

...

Image Removed

Image Added

5.啟動服務启动服务

#service mysql start

...

Image Removed

Image Added
6.
設定root密碼设定root密码

# mysqladmin -u root password 1qaz

...

7.登入mysql

#mysql -uroot -p

...

Image Removed

Image Added

 

 

...

在Ubuntu、Debian安裝Percona

...

1.下載Percona套件至套件套中並安裝下载Percona套件至套件套中并安装

#gpg --keyserver  hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
#gpg -a --export CD2EFD2A | sudo apt-key add -

...

Image Removed

Image Added

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

...

Image Removed

Image Added

b. Ubuntu12

deb http://repo.percona.com/apt precise main
deb-src http://repo.percona.com/apt precise main

...

Image Removed

Image Added


2-2 Debian

deb http://repo.percona.com/apt squeeze main
deb-src http://repo.percona.com/apt squeeze main

...

Image Removed

Image Added


3.
更新套件庫更新套件库

#apt-get update

...

Image Removed

Image Added


4.安裝Percona

#apt-get install percona-server-server-5.5 percona-server-client-5.5

...

Image Removed

Image Added


5.
設定root密碼设定root密码

# mysqladmin -u root password 1qaz

...

6.登入mysql

#mysql -uroot -p

...

Image Removed

Image Added