debian安装percona-Server 记录

基本安装

基本安装步骤请参考官网指南
其中一个步骤是下载repository packages $(lsb_release -sc可以参考

https://repo.percona.com/apt/

对于依赖

sudo apt-get install lsb-release
sudo apt --fix-broken install

安装Mysql

启用软件源

sudo percona-release setup ps80
sudo apt-get install percona-server-server

安装完成以后，需要执行

        mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
        mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
        mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

安装后报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' 解决办法

sudo mkdir -p /var/run/mysqld
sudo chown mysql /var/run/mysqld/
sudo service mysql restart

安装postgresql

 sudo percona-release setup ppg-13
 sudo apt-get install percona-postgresql-13

添加llvm源

deb http://apt.llvm.org/buster/ llvm-toolchain-buster main
deb-src http://apt.llvm.org/buster/ llvm-toolchain-buster main
# 10 
deb http://apt.llvm.org/buster/ llvm-toolchain-buster-10 main
deb-src http://apt.llvm.org/buster/ llvm-toolchain-buster-10 main
# 11 
deb http://apt.llvm.org/buster/ llvm-toolchain-buster-11 main
deb-src http://apt.llvm.org/buster/ llvm-toolchain-buster-11 main

Note that this package will not install the components. To install these components use the appropriate packages:

$ # To install pg_repack
$ sudo apt-get install percona-postgresql-13-repack
$ # To Install pgaudit
$ sudo apt-get install percona-postgresql-13-pgaudit
$ # To install pgBackRest
$ sudo apt-get install percona-pgbackrest
$ # To install Patroni
$ sudo apt-get install percona-patroni
$ # To install pg_stat_monitor
$ sudo apt-get install percona-pg-stat-monitor13
$ # To install PostgreSQL contrib extensions
$ sudo apt-get install percona-postgresql-contrib

安装mongoDB

percona-release enable psmdb-44 release
sudo apt-get install percona-server-mongodb