如何通过源码包方式安装Percona server

这篇文章将为大家详细讲解有关如何通过源码包方式安装Percona server，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。https://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.29-76.2/source/tarball/percona-server-5.6.29-76.2.tar.gz下载cmake：https://cmake.org/download/]# tar -zxvf cmake-2.8.9.tar.gz]# cd cmake-2.8.9#查看帮助]# cat Readme.txt$ ./bootstrap; make; make install]# ./bootstrap]# make]# make install#basedir~]# mkdir -p /app/mysql#datadir~]# mkdir -p /data/percona/mysql/data~]# chown mysql:mysql /app/mysql/ -R~]# chown mysql:mysql /data/percona/mysql/ -R]# tar -zxvf percona-server-5.6.29-76.2.tar.gz]# cd percona-server-5.6.29-76.2]#cmake . -LH]#cmake . -DCMAKE_INSTALL_PREFIX=/app/mysql #设置程序安装路径-DMYSQL_DATADIR=/data/percona/mysql/data #设置数据存放路径-DSYSCONFDIR=/app/mysql #配置文件路径，由于当前有别的mysql实例运行,没有指定/etc-DWITH_MYISAM_STORAGE_ENGINE=1 #启用MYISAM存储引擎-DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/data/percona/mysql/mysqld.sock #设置套接字存放位置-DMYSQL_TCP_PORT=6603 #设置开放端口-DENABLED_LOCAL_INFILE=1 #设置读取本地文件-DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 #默认字符串-DDEFAULT_COLLATION=utf8_general_ci #默认检验规则附，如果cmake错误，需要重新cmake,需要清除之前的cmake信息：]# make clean]# rm –f CMakeCache.txt#-j后面是逻辑CPU的个数，可以根据实际情况来指定]#make -j `grep processor /proc/cpuinfo | wc -l`]#make install]# cat /app/mysql/my.cnf[mysqld]basedir=/app/mysqldatadir=/data/percona/mysql/datasocket=/data/percona/mysql/mysql.socklog-error=/data/percona/mysql/mysqld.loginnodb_buffer_pool_size = 128Mport=6603]# ./scripts/mysql_install_db –defaults-file=/app/mysql/my.cnf#注意，如果使用的root账户初始化db，生成的文件都是root拥有，而mysqld是以mysql用户运行的，对默认生成的文件没权限，可能无法正常start，如报错：26803 [Note] Plugin ‘FEDERATED’ is disabled./app/mysql/bin/mysqld: Can’t find file: ‘./mysql/plugin.frm’ (errno: 13 – Permission denied)2016-05-04 14:40:21 26803 [ERROR] InnoDB: ./ibdata1 can’t be opened in read-write mode2016-05-04 14:40:21 26803 [ERROR] InnoDB: The system tablespace must be writable!2016-05-04 14:40:21 26803 [ERROR] Plugin ‘InnoDB’ init function returned error.2016-05-04 14:40:21 26803 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.2016-05-04 14:40:21 26803 [ERROR] Unknown/unsupported storage engine: InnoDB2016-05-04 14:40:21 26803 [ERROR] Aborting#此时，修改basedir和datadir下的文件的所有者和所属组为mysql]# chown mysql:mysql /data/percona/mysql/ -R]# chown mysql:mysql /app/mysql/ -R#再启动mysql]# /data/percona/mysql/bin/mysqld_safe –defaults-file=/tmp/my.cnf &160504 10:37:02 mysqld_safe Adding ‘/data/percona/mysql/lib/mysql/libjemalloc.so.1’ t免费主机域名o LD_PRELOAD for mysqld160504 10:37:02 mysqld_safe Logging to ‘/data/percona/mysql/mysqld.log’.160504 10:37:02 mysqld_safe Starting mysqld daemon with databases from /data/percona/mysql/data]# netstat -antpl|grep mysqldtcp 0 0 :::6603 :::* LISTEN 27166/mysqld #percona mysqltcp 0 0 :::3306 :::* LISTEN 23233/mysqld #默认运行的mysql]# tail -f /data/percona/mysql/mysqld.log2016-05-04 14:42:02 27166 [Note] InnoDB: Waiting for purge to start2016-05-04 14:42:02 27166 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 16264262016-05-04 14:42:02 27166 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4eeaade7-11c3-11e6-86b0-782bcb6aa29a.2016-05-04 14:42:02 27166 [Note] Server hostname (bind-address): ‘*’; port: 66032016免费主机域名-05-04 14:42:02 27166 [Note] IPv6 is available.2016-05-04 14:42:02 27166 [Note] – ‘::’ resolves to ‘::’;2016-05-04 14:42:02 27166 [Note] Server socket created on IP: ‘::’.2016-05-04 14:42:02 27166 [Note] Event Scheduler: Loaded 0 events2016-05-04 14:42:02 27166 [Note] /app/mysql/bin/mysqld: ready for connections.Version: ‘5.6.29-76.2’ socket: ‘/data/percona/mysql/mysql.sock’ port: 6603 Source distributiona.Stop percona mysql serverb.rm –rf basedir && rm –rf datadir

关于“如何通过源码包方式安装Percona server”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，使各位可以学到更多知识，如果觉得文章不错，请把它分享出去让更多的人看到。

相关推荐: NBU异机还原oracle问题分析

这篇文章主要介绍“NBU异机还原oracle问题分析”，在日常操作中，相信很多人在NBU异机还原oracle问题分析问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”NBU异机还原oracle问题分析”的疑惑有所帮助！接下来，请跟着…