Percona Server:修订间差异
跳到导航
跳到搜索
此页面具有访问限制。如果您看见此消息,则说明您没有权限访问此页面。
(→設定) |
(→快速安裝) |
||
(未显示同一用户的18个中间版本) | |||
第1行: | 第1行: | ||
'''Percona Server'''是一套資料庫軟體,源自[[MySQL]]。 | '''Percona Server'''是一套 由[[Percona]]維護的 資料庫軟體,源自[[MySQL]]。 | ||
== 安裝 == | == 安裝 == | ||
第5行: | 第5行: | ||
[[MySQL]]系的資料庫在使用[[jemalloc]]時效能都會提昇不少,所以在不少衍生版本都有支援jemalloc。其中Percona Server在偵測到系統內有jemalloc時會自動啟用<ref>{{Cite web |url=https://www.percona.com/blog/2017/01/03/enabling-and-disabling-jemalloc-on-percona-server/ |title=Enabling and Disabling Jemalloc on Percona Server |accessdate=2018-04-23 |date=2017-01-03}}</ref>,減少了設定所需的手續。 | [[MySQL]]系的資料庫在使用[[jemalloc]]時效能都會提昇不少,所以在不少衍生版本都有支援jemalloc。其中Percona Server在偵測到系統內有jemalloc時會自動啟用<ref>{{Cite web |url=https://www.percona.com/blog/2017/01/03/enabling-and-disabling-jemalloc-on-percona-server/ |title=Enabling and Disabling Jemalloc on Percona Server |accessdate=2018-04-23 |date=2017-01-03}}</ref>,減少了設定所需的手續。 | ||
在[[Ubuntu]]上 | 在[[Ubuntu]]上 先 安裝<code>gnupg2</code>,等下會用到: | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
sudo apt install -y gnupg2 | sudo apt install -y gnupg2; sudo apt clean | ||
</syntaxhighlight> | </syntaxhighlight> | ||
第17行: | 第17行: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
裝完後可以更新系統並且安裝Percona Server 5.7: | 裝完後可以更新系統並且安裝Percona Server 5.7 與<code>libjemalloc1</code> : | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
sudo apt update; sudo apt install -y percona-server-server-5.7 | sudo apt update; sudo apt install -y libjemalloc1 percona-server-server-5.7; sudo apt clean | ||
</syntaxhighlight> | </syntaxhighlight> | ||
第26行: | 第26行: | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
sudo percona-release setup ps80; sudo apt install -y percona-server-server | sudo percona-release setup ps80; sudo apt install -y libjemalloc2 percona-server-server; sudo apt clean | ||
</syntaxhighlight> | |||
另外可以加裝mycli: | |||
<syntaxhighlight lang="bash"> | |||
sudo apt install -y mycli; sudo apt clean | |||
</syntaxhighlight> | </syntaxhighlight> | ||
第35行: | 第41行: | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
sudo service mysql stop | sudo service mysql stop | ||
</syntaxhighlight> | </syntaxhighlight> | ||
第49行: | 第49行: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Percona Server 8.0版本的則是: | Percona Server 8.0版本的則是 ,可以參考[https://github.com/gslin/mysql-template/blob/master/mysql-8.0.cnf mysql-8.0.cnf]這邊的設定檔 : | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
第72行: | 第72行: | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
sudo apt install -y gnupg2 | sudo apt install -y gnupg2; cd /tmp; wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb; sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb; sudo apt update; sudo apt install -y libjemalloc1 mycli percona-server-server-5.7; sudo apt clean; sudo service mysql stop; cd /etc/mysql/percona-server.conf.d/; sudo mv mysqld.cnf mysqld.cnf.bak; sudo wget -O mysqld.cnf https://raw.githubusercontent.com/gslin/mysql-template/master/mysql-5.7.cnf; sudo mkdir /srv/tmp; sudo chmod 1777 /srv/tmp; sudo service mysql start | ||
</syntaxhighlight> | |||
Percona Server 8.0版本的則是: | |||
<syntaxhighlight lang="bash"> | |||
sudo apt install -y gnupg2; cd /tmp; wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb; sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb; sudo percona-release setup ps80; sudo apt install -y libjemalloc2 mycli percona-server-server; sudo apt clean; sudo service mysql stop; cd /etc/mysql/mysql.conf.d/; sudo mv mysqld.cnf mysqld.cnf.bak; sudo wget -O mysqld.cnf https://raw.githubusercontent.com/gslin/mysql-template/master/mysql-8.0.cnf; sudo mkdir /srv/tmp; sudo chmod 1777 /srv/tmp; sudo service mysql start | |||
</syntaxhighlight> | </syntaxhighlight> | ||
2023年7月26日 (三) 22:17的最新版本
Percona Server是一套由Percona维护的数据库软件,源自MySQL。
安装
MySQL系的数据库在使用jemalloc时效能都会提升不少,所以在不少衍生版本都有支援jemalloc。其中Percona Server在侦测到系统内有jemalloc时会自动启用[1],减少了设定所需的手续。
在Ubuntu上先安装gnupg2
,等下会用到:
sudo apt install -y gnupg2; sudo apt clean
首先安装Percona的APT设定,以及对应所需的Key:
cd /tmp; wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb; sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
装完后可以更新系统并且安装Percona Server 5.7与libjemalloc1
:
sudo apt update; sudo apt install -y libjemalloc1 percona-server-server-5.7; sudo apt clean
或是Percona Server 8.0:
sudo percona-release setup ps80; sudo apt install -y libjemalloc2 percona-server-server; sudo apt clean
另外可以加装mycli:
sudo apt install -y mycli; sudo apt clean
设定
在第一次设定前先停掉Percona Server:
sudo service mysql stop
接着到/etc/mysql/percona-server.conf.d/
下将本来的设定档改名,然后可以参考mysql-5.7.cnf这边的设定档:
cd /etc/mysql/percona-server.conf.d/; sudo mv mysqld.cnf mysqld.cnf.bak; sudo wget -O mysqld.cnf https://raw.githubusercontent.com/gslin/mysql-template/master/mysql-5.7.cnf; sudo mkdir /srv/tmp; sudo chmod 1777 /srv/tmp
Percona Server 8.0版本的则是,可以参考mysql-8.0.cnf这边的设定档:
cd /etc/mysql/mysql.conf.d/; sudo mv mysqld.cnf mysqld.cnf.bak; sudo wget -O mysqld.cnf https://raw.githubusercontent.com/gslin/mysql-template/master/mysql-8.0.cnf; sudo mkdir /srv/tmp; sudo chmod 1777 /srv/tmp
其中最主要的值是innodb_buffer_pool_size
,表示InnoDB在内存内占用的空间(这边设定值不包括overhead,所以实际使用的量通常会超过所设定的值)。当整台机器都是专门给Percona Server使用时,会设定整台服务器内存的60%到75%。如果不是专门使用时可以看资料量与特性决定:
innodb_buffer_pool_size = 64M
设完后就可以启动:
sudo service mysql start
快速安装
把上面提到的指令一次跑完:
sudo apt install -y gnupg2; cd /tmp; wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb; sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb; sudo apt update; sudo apt install -y libjemalloc1 mycli percona-server-server-5.7; sudo apt clean; sudo service mysql stop; cd /etc/mysql/percona-server.conf.d/; sudo mv mysqld.cnf mysqld.cnf.bak; sudo wget -O mysqld.cnf https://raw.githubusercontent.com/gslin/mysql-template/master/mysql-5.7.cnf; sudo mkdir /srv/tmp; sudo chmod 1777 /srv/tmp; sudo service mysql start
Percona Server 8.0版本的则是:
sudo apt install -y gnupg2; cd /tmp; wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb; sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb; sudo percona-release setup ps80; sudo apt install -y libjemalloc2 mycli percona-server-server; sudo apt clean; sudo service mysql stop; cd /etc/mysql/mysql.conf.d/; sudo mv mysqld.cnf mysqld.cnf.bak; sudo wget -O mysqld.cnf https://raw.githubusercontent.com/gslin/mysql-template/master/mysql-8.0.cnf; sudo mkdir /srv/tmp; sudo chmod 1777 /srv/tmp; sudo service mysql start
相关连结
参考资料
- ↑ Enabling and Disabling Jemalloc on Percona Server. 2017-01-03 [2018-04-23].
外部链接
- 官方网站 (英文)