Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search
Copy Page
You are not logged in. Any changes you make will be marked as
anonymous
. You may want to
Log In
if you already have an account. You can also
Sign Up
for a new account.
This page is being edited by
.
image-effects
image-attributes
search
attachments
weblink
advanced
Paragraph
Paragraph
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Preformatted
Quote
Bold
Italic
Underline
Colour picker
More colours
Formatting
Strikethrough
Subscript
Superscript
Monospace
Clear Formatting
Bullet list
Numbered list
Task list
Outdent
Indent
Align left
Align center
Align right
Link
Table
Insert
Insert Content
Image
Link
Attachment
Symbol
Emoticon
Wiki Markup
Horizontal rule
Task List
Insert Macro
User Mention
Info
JIRA Issue
Gliffy Diagram
Status
Gallery
Table of Contents
Other Macros
Page Layout
No Layout
Two column (simple)
Two column (simple, left sidebar)
Two column (simple, right sidebar)
Three column (simple)
Two column
Two column (left sidebar)
Two column (right sidebar)
Three column
Three column (left and right sidebars)
Undo
Redo
Find/Replace
Keyboard Shortcuts Help
Hide the toolbars
Launch editor full screen
<p>用户可参考以下的步骤,在Linux环境下安装。</p><p><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3RvY30&locale=en_GB&version=2" data-macro-name="toc"></p><h4>在CentOS中安裝Percona</h4><p>1.将Percona的套件安装至主机的套件库中</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/c1.png?version=1&modificationDate=1715138669308&api=v2" data-image-src="/download/attachments/3245514/c1.png?version=1&modificationDate=1715138669308&api=v2" data-linked-resource-id="3219408" data-linked-resource-type="attachment" data-linked-resource-default-alias="c1.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > c1.png" data-location="null > c1.png"></p><p>2.请搜寻Percona的套件,并安装下方框起来的二个套件</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#yum search percona</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/c2.png?version=1&modificationDate=1715138669309&api=v2" data-image-src="/download/attachments/3245514/c2.png?version=1&modificationDate=1715138669309&api=v2" data-linked-resource-id="3219409" data-linked-resource-type="attachment" data-linked-resource-default-alias="c2.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > c2.png" data-location="null > c2.png"></p><p>3.安裝Percona</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># yum install Percona-Server-client-55.x86_64</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/c3.png?version=1&modificationDate=1715138669311&api=v2" data-image-src="/download/attachments/3245514/c3.png?version=1&modificationDate=1715138669311&api=v2" data-linked-resource-id="3219410" data-linked-resource-type="attachment" data-linked-resource-default-alias="c3.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > c3.png" data-location="null > c3.png"></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># yum install Percona-Server-server-55.x86_64</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/c4.png?version=1&modificationDate=1715138669312&api=v2" data-image-src="/download/attachments/3245514/c4.png?version=1&modificationDate=1715138669312&api=v2" data-linked-resource-id="3219411" data-linked-resource-type="attachment" data-linked-resource-default-alias="c4.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > c4.png" data-location="null > c4.png"></p><p>4.请至etc下建立一个档案,且命名为my.cnf,并加入下方列出的几个设定</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#vi /etc/my.cnf</pre></th></tr></tbody></table><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>[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.</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/c5.png?version=1&modificationDate=1715138669313&api=v2" data-image-src="/download/attachments/3245514/c5.png?version=1&modificationDate=1715138669313&api=v2" data-linked-resource-id="3219412" data-linked-resource-type="attachment" data-linked-resource-default-alias="c5.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > c5.png" data-location="null > c5.png"></p><p>5.启动服务</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#service mysql start</pre></th></tr></tbody></table><p><span style="line-height: 1.4285715;"><img class="confluence-embedded-image" src="/download/attachments/3245514/c6.png?version=1&modificationDate=1715138669314&api=v2" data-image-src="/download/attachments/3245514/c6.png?version=1&modificationDate=1715138669314&api=v2" data-linked-resource-id="3219413" data-linked-resource-type="attachment" data-linked-resource-default-alias="c6.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > c6.png" data-location="null > c6.png"><br />6.设定root密码<br /></span></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># mysqladmin -u root password 1qaz</pre></th></tr></tbody></table><p>7.登入mysql</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#mysql -uroot -p</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/c7.png?version=1&modificationDate=1715138669307&api=v2" data-image-src="/download/attachments/3245514/c7.png?version=1&modificationDate=1715138669307&api=v2" data-linked-resource-id="3219407" data-linked-resource-type="attachment" data-linked-resource-default-alias="c7.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > c7.png" data-location="null > c7.png"></p><pre> </pre><p> </p><hr style="line-height: 1.4285715;" /><h4>在Ubuntu、Debian安裝Percona</h4><p>1.下载Percona套件至套件套中并安装</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A #gpg -a --export CD2EFD2A | sudo apt-key add -</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/u1.png?version=1&modificationDate=1715138669305&api=v2" data-image-src="/download/attachments/3245514/u1.png?version=1&modificationDate=1715138669305&api=v2" data-linked-resource-id="3219405" data-linked-resource-type="attachment" data-linked-resource-default-alias="u1.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > u1.png" data-location="null > u1.png"></p><p><span style="line-height: 1.4285715;">2.依照不同OS及OS版本,加入不同的设定至/etc/apt/sources.list中。</span></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#vi /etc/apt/sources.list</pre></th></tr></tbody></table><p><span style="color: rgb(0,0,0);">2-1 Ubuntu</span><br /><span style="color: rgb(0,0,0);">a. Ubuntu10</span></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>deb http://repo.percona.com/apt lucid main deb-src http://repo.percona.com/apt lucid main</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/u2.png?version=1&modificationDate=1715138669306&api=v2" data-image-src="/download/attachments/3245514/u2.png?version=1&modificationDate=1715138669306&api=v2" data-linked-resource-id="3219406" data-linked-resource-type="attachment" data-linked-resource-default-alias="u2.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > u2.png" data-location="null > u2.png"></p><p><span style="line-height: 1.4285715;">b. Ubuntu12</span></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>deb http://repo.percona.com/apt precise main deb-src http://repo.percona.com/apt precise main</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/u3.png?version=1&modificationDate=1715138669301&api=v2" data-image-src="/download/attachments/3245514/u3.png?version=1&modificationDate=1715138669301&api=v2" data-linked-resource-id="3219402" data-linked-resource-type="attachment" data-linked-resource-default-alias="u3.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > u3.png" data-location="null > u3.png"></p><p><span style="line-height: 1.4285715;"><br />2-2 Debian</span></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>deb http://repo.percona.com/apt squeeze main deb-src http://repo.percona.com/apt squeeze main</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/d1.png?version=1&modificationDate=1715138669299&api=v2" data-image-src="/download/attachments/3245514/d1.png?version=1&modificationDate=1715138669299&api=v2" data-linked-resource-id="3219401" data-linked-resource-type="attachment" data-linked-resource-default-alias="d1.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > d1.png" data-location="null > d1.png"></p><p><span style="line-height: 1.4285715;"><br />3.更新套件库</span></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#apt-get update</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/u4.png?version=1&modificationDate=1715138669302&api=v2" data-image-src="/download/attachments/3245514/u4.png?version=1&modificationDate=1715138669302&api=v2" data-linked-resource-id="3219403" data-linked-resource-type="attachment" data-linked-resource-default-alias="u4.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > u4.png" data-location="null > u4.png"></p><p><span style="line-height: 1.4285715;"><br />4.安裝Percona</span></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#apt-get install percona-server-server-5.5 percona-server-client-5.5</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/u5.png?version=1&modificationDate=1715138669304&api=v2" data-image-src="/download/attachments/3245514/u5.png?version=1&modificationDate=1715138669304&api=v2" data-linked-resource-id="3219404" data-linked-resource-type="attachment" data-linked-resource-default-alias="u5.png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > u5.png" data-location="null > u5.png"></p><p><span style="line-height: 1.4285715;"><br />5.设定root密码</span></p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre># mysqladmin -u root password 1qaz</pre></th></tr></tbody></table><p>6.登入mysql</p><table class="confluenceTable"><tbody><tr><th class="confluenceTh"><pre>#mysql -uroot -p</pre></th></tr></tbody></table><p><img class="confluence-embedded-image" src="/download/attachments/3245514/c7%20%281%29.png?version=1&modificationDate=1715138669315&api=v2" data-image-src="/download/attachments/3245514/c7%20%281%29.png?version=1&modificationDate=1715138669315&api=v2" data-linked-resource-id="3219414" data-linked-resource-type="attachment" data-linked-resource-default-alias="c7 (1).png" data-base-url="http://wiki.fengqi.asia" data-linked-resource-container-id="3245514" title="null > c7 (1).png" data-location="null > c7 (1).png"></p><p> </p><p> </p>
Attachments
Labels
Location
Edit
Preview
Save
Cancel
Next hint