CentOS7怎么安装Percona Server+Mysql
这篇文章给大家分享的是有关CentOS7怎么安装Percona Server+Mysql的内容。小编觉得挺实用的,因此分享给大家做个参考,一起跟随小编过来看看吧。
一、环境说明
(1)CentOS-7-x86_64,内核版本
uname-r3.10.0-693.el7.x86_64
(2)Mysql版本
percona-server-5.6.29
(3)文件存放路径
/home/soft
二、安装前准备
(1)配置权限
groupaddmysqluseradd-r-gmysqlmysql
(2)创建安装目录
mkdir/usr/local/mysql#mysql安装目录chown-Rmysql:mysql/usr/local/mysqlmkdir/usr/local/mysql/dataconf#数据库配置存放目录chown-Rmysql:mysql/usr/local/mysql/dataconfmkdir/usr/local/mysql/sock#运行mysql时mysql.sock存放目录chown-Rmysql:mysql/usr/local/mysql/sockmkdir/var/log/mysql#创建日志存放目录touch/var/log/mysql/mysql.logchown-Rmysql:mysql/var/log/mysql/mysql.logtouch/usr/local/mysql/my.cnf#创建mysql配置文件
三、安装编译环境
yuminstallreadline-develgitgccgcc-c++makecmakebisonbison-develncurses-devellibaio-develperlzlib1g-devautoconf
四、编译安装percona
cd/home/soft/tarzxvfpercona-server-5.6.29-76.2.tar.gzcdpercona-server-5.6.29-76.2cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql#需要使用cmake进行安装,这里表示的是文件安装目录-DSYSCONFDIR=/usr/local/mysql#存放配置文件的目录-DMYSQL_DATADIR=/usr/local/mysql/dataconf#存放数据库的目录-DMYSQL_UNIX_ADDR=/usr/local/mysql/sock/mysqld.sock#存放mysql.sock文件的目录-DMYSQL_TCP_PORT=3306-DWITH_MYISAM_STORAGE_ENGINE=1#配置端口-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DEXTRA_CHARSETS=all-DDEFAULT_CHARSET=utf8#配置默认的字符编码格式-DDEFAULT_COLLATION=utf8_general_ci-DENABLED_LOCAL_INFILE=1-DWITH_EDITLINE=bundled-DCMAKE_BUILD_TYPE=RelWithDebInfo-DBUILD_CONFIG=mysql_release-DFEATURE_SET=community-DWITH_EMBEDDED_SERVER=OFF
之后,继续编译安装。
make-j8#大概需要30-40分钟左右。如果报错,请使用makeclean,rm-rfCMakeCache.txtmakeinstall
五、配置Percona参数
cat/usr/local/mysql/my.cnf[mysqld]#Disablingsymbolic-linksisrecommendedtopreventassortedsecurityriskssymbolic-links=0explicit_defaults_for_timestamp=truefederated#Settingsuserandgroupareignoredwhensystemdisused.#Ifyouneedtorunmysqldunderadifferentuserorgroup,#customizeyoursystemdunitfileformariadbaccordingtothe#instructionsinhttp://fedoraproject.org/wiki/Systemdbasedir=/usr/local/mysqldatadir=/usr/local/mysql/dataconfport=3306socket=/usr/local/mysql/sock/mysql.socksymbolic-links=0character_set_server=utf8pid-file=/usr/local/mysql/mysql.pidskip-grant-tables[mysqld_safe]log-error=/var/log/mysql/mysql.logpid-file=/usr/local/mysql/mysql.pidsocket=/usr/local/mysql/sock/mysql.sock[client]socket=/usr/local/mysql/mysql.sock[mysql.server]user=mysqlbasedir=/usr/local/mysqlsocket=/usr/local/mysql/sock/mysql.sock[mysql]socket=/usr/local/mysql/sock/mysql.sock
六、配置Mysql访问权限
chown-Rmysql:mysql/usr/local/mysql/binchown-Rmysql:mysql/usr/local/mysql/mysql.pid
七、初始化Mysql服务器
/usr/local/mysql/scripts/mysql_install_db--defaults-file=/usr/local/mysql/my.cnf--basedir=/usr/local/mysql--datadir=/usr/local/mysql/dataconf--user=mysql
八、配置环境变量
为了能直接调用mysql命令,需要配置环境变量vi/etc/profile在/etc/profile文件末尾添加exportPATH=/usr/local/mysql/bin:$PATH使环境变量立即生效source/etc/profile
九、配置启动脚本
cp/home/soft/percona-server-5.6.29-76.2/support-files/mysql.server/etc/init.d/mysqlchmod+x/etc/init.d/mysqlchkconfigmysqlonservicemysqlstart/stop
十、后言
此方法我也不知道为什么在CentOS7里面安装之后可以用,在Debian服务器里面无法进行编译安装使用。另外在使用的过程中,有时候可能也需要Percona-Server-client的支持。针对这个问题,可以使用以下方法解决:将文件上传到/home/soft/目录下,然后进行安装。安装方法如下:
rpm-ivhPercona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64.rpmrpm-ivhPercona-Server-shared-55-5.5.35-rel33.0.611.rhel6.x86_64.rpmrpm-ivhPercona-Server-devel-55-5.5.35-rel33.0.611.rhel6.x86_64.rpmrpm-ivhPercona-Server-client-55-5.5.35-rel33.0.611.rhel6.x86_64.rpm
或者使用rpm -ivh * 即可安装
感谢各位的阅读!关于“CentOS7怎么安装Percona Server+Mysql”这篇文章就分享到这里了,希望以上内容可以对大家有一定的帮助,让大家可以学到更多知识,如果觉得文章不错,可以把它分享出去让更多的人看到吧!
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。