puppet连载10：linux安装percona57/56/55、sysbench、tpcc模块 ...

最新推荐文章于 2022-07-12 00:23:32 发布
最新推荐文章于 2022-07-12 00:23:32 发布
阅读量136 收藏
点赞数
文章标签： 运维 数据库 java
原文链接：https://yq.aliyun.com/articles/682401
版权

在服务端/puppet/soft下建my.cnf，内容为https://www.jianshu.com/p/c63fc6c71279

在服务端/puppet/soft下建changemysql57pass.sh，内容为：

!/bin/bash

mysqld --initialize
mysqld --skip-grant-tables &
sleep 3
mysql -Dmysql -uroot -e "update mysql.user set authentication_string=password('xmrbi3967968@') where user='root';"
mysql -Dmysql -uroot -e "flush privileges;"
pkill mysqld
service mysqld start
chkconfig mysqld on

保存，退出，chmod +x /puppet/soft/changemysql57pass.sh

安装Percona-XtraDB-Cluster57/56/55、Percona-Server-57/56/55、sysbench、sysbench-tpcc、percona-toolkit、percona-xtrabackup、tpcc-mysql、设置配置文件/etc/my.cnf、更改默认root密码、mysql的安装方式包括yum和rpm

mkdir -p /etc/puppet/modules/linuxpercona/{manifests,templates,files}
vi /etc/puppet/modules/linuxpercona/manifests/init.pp
class linuxpercona::perconayum {
exec {"yum install https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/percona-release-0.1-7.noarch.rpm -y":
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => 'ls /etc/yum.repos.d/percona-release.repo',
}
exec {'ensure data':
command => 'mkdir /data',
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => 'ls /data',
}
}
class linuxpercona::perconaxtradbcluster57rpm {
exec {"client57":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/Percona-XtraDB-Cluster-client-57-5.7.23-31.31.2.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep Percona-XtraDB-Cluster-client-57",
}
exec {"qpress11":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/qpress-11-1.el7.x86_64.rpm",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep qpress-11",
}
exec {"socat":
command => "yum install -y socat perl* libev",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "whereis socat",
}
exec {"xtrabackup24":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/percona-xtrabackup-24-2.4.12-1.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep percona-xtrabackup-24",
}
exec {"sharedcompat57":
command => "rpm -Uvh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/Percona-XtraDB-Cluster-shared-compat-57-5.7.23-31.31.2.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep Percona-XtraDB-Cluster-shared-compat-57",
}
exec {"shared57":
command => "rpm -Uvh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/Percona-XtraDB-Cluster-shared-57-5.7.23-31.31.2.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep Percona-XtraDB-Cluster-shared-57",
}
exec {"server57":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/Percona-XtraDB-Cluster-server-57-5.7.23-31.31.2.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep Percona-XtraDB-Cluster-server-57",
}
exec {"sysbench":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/sysbench-1.0.9-1.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep sysbench-1.0.9",
}
exec {"tpcc":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/sysbench-tpcc-1.0.15-2.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep sysbench-tpcc-1.0.15",
}
exec {"toolkit":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/percona-toolkit-3.0.9-1.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep percona-toolkit-3.0.9",
}
package {"unzip":
ensure => installed,
before => Exec["mysqltpcc"],
}
exec {"datamysql":
command => "mkdir /data",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "ls /data",
before => Exec["mysqltpcc"],
}
exec {"mysqltpcc":
command => "cd /data&& wget https://github.com/Percona-Lab/tpcc-mysql/archive/master.zip -O tpcc-mysql.zip&&unzip tpcc-mysql.zip",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "ls /data/tpcc-mysql-master",
}
file {"/etc/my.cnf":
ensure => present,
source => "puppet:///soft/my.cnf",
require => Exec["server57"],
}
file {"/data/changemysql57pass.sh":
ensure => present,
source => "puppet:///soft/changemysql57pass.sh",
require => File["/etc/my.cnf"],
notify => Exec["changepass"],
}
exec {"changepass":
command => "sh /data/changemysql57pass.sh",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
require => File["/data/changemysql57pass.sh"],
refreshonly => true,
}
}

class linuxpercona::perconaserver57rpm {
exec { "sharedcompat57":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/Percona-Server-shared-compat-57-5.7.23-25.1.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep Percona-Server-shared-compat-57",
}
exec { "shared57":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/Percona-Server-shared-57-5.7.23-25.1.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep Percona-Server-shared-57",
}
exec { "client57":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/Percona-Server-client-57-5.7.23-25.1.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep Percona-Server-client-57",
}
exec {"qpress11":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/qpress-11-1.el7.x86_64.rpm",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep qpress-11",
}
exec {"socat":
command => "yum install -y socat perl* libev",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "whereis socat",
}
exec { "server57":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/Percona-Server-server-57-5.7.23-25.1.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep Percona-Server-server-57",
}
exec {"sysbench":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/sysbench-1.0.9-1.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep sysbench-1.0.9",
}
exec {"tpcc":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/sysbench-tpcc-1.0.15-2.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep sysbench-tpcc-1.0.15",
}
exec {"toolkit":
command => "rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/percona/yum/release/centos/7Server/RPMS/x86_64/percona-toolkit-3.0.9-1.el7.x86_64.rpm --force --nodeps",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "rpm -qa|grep percona-toolkit-3.0.9",
}
package {"unzip":
ensure => installed,
before => Exec["mysqltpcc"],
}
exec {"datamysql":
command => "mkdir /data",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "ls /data",
before => Exec["mysqltpcc"],
}
exec {"mysqltpcc":
command => "cd /data&& wget https://github.com/Percona-Lab/tpcc-mysql/archive/master.zip -O tpcc-mysql.zip&&unzip tpcc-mysql.zip",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
unless => "ls /data/tpcc-mysql-master",
}
file {"/etc/my.cnf":
ensure => present,
source => "puppet:///soft/my.cnf",
require => Exec["server57"],
}
file {"/data/changemysql57pass.sh":
ensure => present,
source => "puppet:///soft/changemysql57pass.sh",
require => File["/etc/my.cnf"],
notify => Exec["changepass"],
}
exec {"changepass":
command => "sh /data/changemysql57pass.sh",
path => ["/usr/bin","/usr/sbin","/bin","/sbin"],
require => File["/data/changemysql57pass.sh"],
refreshonly => true,
}
}

class linuxpercona::perconaxtradbcluster57 {
require linuxpercona::perconayum
package {"Percona-XtraDB-Cluster-57":
ensure => installed,
}
}
class linuxpercona::perconaxtradbcluster56 {
require linuxpercona::perconayum
package {"Percona-XtraDB-Cluster-56":
ensure => installed,
}
}
class linuxpercona::perconaxtradbcluster55 {
require linuxpercona::perconayum
package {"Percona-XtraDB-Cluster-55":
ensure => installed,
}
}
class linuxpercona::perconaserver57 {
require linuxpercona::perconayum
package {"Percona-Server-server-57":
ensure => installed,
}
}
class linuxpercona::perconaserver56 {
require linuxpercona::perconayum
package {"Percona-Server-server-56":
ensure => installed,
}
}
class linuxpercona::perconaserverserver55 {
require linuxpercona::perconayum
package {"Percona-Server-server-55":
ensure => installed,
}
}
class linuxpercona::sysbench {
require linuxpercona::perconayum
package {"sysbench":
ensure => installed,
}
}
class linuxpercona::sysbenchtpcc {
require linuxpercona::perconayum
package {"sysbench-tpcc":
ensure => installed,
}
}
class linuxpercona::perconatoolkit {
require linuxpercona::perconayum
package {"percona-toolkit":
ensure => installed,
}
}
class linuxpercona::perconaxtrabackup {
require linuxpercona::perconayum
package {"percona-xtrabackup":
ensure => installed,
}
}

修改

vi /etc/puppet/manifests/nodes/huangat-test.pp
node 'huangat-test' {
include test
include linuxbaseinstall
include linuxoptimize
include linuxjdktomcat::tomcat8036
include linuxclean::yumclean,linuxclean:puppetclean
}

provider => rpm,
source => "/tmp/rhel5/postfix-2.5.17-1.rhel5.x86_64.rpm",

weixin_34191734
关注
puppet-hazelcast:www.hazelcast.com 的木偶模块
07-03
内存数据网格的 Puppet 模块。 此模块仅用于开发目的 - 请勿在生产中使用。 它目前将管理中心部署到 tomcat7，可在http://yourHost:8080/mancenter 用法 最小 include 'hazelcast' 自定义配置 { "hazelcast": ...
[centos] 安装Percona
突围
11-03 4334
[root@localhost TT]# ps -ef|grep mysql root      7265     1  0 Oct23 pts/4    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var --pid-file=/usr/local/mysql/var/localhos
CentOS7.6下安装Percona-Server5.6
qq_41931905的博客
04-21 385
1.1MySQL数据库安装 1.1.1准备数据库安装包 提前准备好Percona-Server安装包 1.1.2上传安装包到Linux目录 1.创建好Mysql的安装目录 2.上传下载好的数据库文件到云服务器（这里使用的是WinSCP实现文件上传） 3.解压安装包 tar -xvf Percona-Server-5.6.24-72.2-r8d0f85b-el...
Percona（MySQL）安装
醉糊涂仙的博客
05-02 3601
简介：Percona是MySQL的分支版本，性能超越标准的MySQL。另外MySQL关键技术被Oracle收购以后，Percona是唯一免费的版本。 1，下载percona，链接： https://pan.baidu.com/s/1fVyTdO0IqJM5sUihUs1Y3A 提取码：h181 2，首先安装 cmake，gcc-c++,openssl openssl-devel。 ...
mysql percona yum_CentOS6.6 yum安装percona mysql5.6
weixin_35931397的博客
02-17 209
0.安装percona-release-0.1-3.noarch.rpmyum -y install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm1.安装Percona-Server-client-56 Percona-Server-server-56yu...
在Centos7上安装Percona 5.7
热门推荐
吴业亮的专栏
05-06 1万+
作者：【吴业亮】云计算开发工程师 博客：http://blog.csdn.net/wylfengyujiancheng 在openstack集群非常大的情况下mysql5.5的最大连接数就成了问题（1040，Too many connections），dashboard界面操作经常因为连接不 上数据库报各种错误。经过试验将最大连接数改为2000，超时时间改为300s，问题还依旧。 针对这种问
puppet-islandora:用于管理 Islandora 7.x 的 Puppet 模块
06-30
**Islandora 7.x Puppet 模块详解** 在 IT 管理领域，Puppet 是一款强大的自动化配置管理工具，它允许系统管理员通过声明式语言来定义和管理 IT 基础设施的状态。Islandora 是一个开源的数字资产管理系统，基于 ...
puppet安装配置.pdf
最新发布
10-30
在本文中，我们将深入探讨如何在Red Hat Enterprise Linux 5.3 (64位)系统上安装和配置Puppet，包括服务端和客户端的设置。 首先，Puppet的安装需要Ruby作为前置条件。在RHEL 5.3上，可以通过添加EPEL仓库并使用`...
puppet-resolver:用于管理etcresolv.conf的人偶模块
05-17
该模块需要Example42 Puppi模块提供的功能（即使您不使用和安装Puppi，也需要它） 有关Example42模块的逻辑和使用模式的详细信息，请查看Example42主模块集上的DOCS目录。 用法-基本管理 使用自定义dns服
puppet-nodejs:用于管理Node.js和NPM的Puppet模块
05-06
up节点 该模块允许您安装和 。 该模块作为在Puppet Forge上。公告内容最新版本是 。 关于master开发正在发生2.2 。 旧版仍保持不变，但不会获得任何新功能。 有关更多信息，请参阅“一章。安装该模块取决于以下常用...
安装percona 5.7
架构师的成长之路的博客
12-19 1837
环境搭建二安装数据库mysql percona 5.7安装percona 5.7首先，你需要设置Percona的Yum库:yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm接下来安装Percona:yum install Percona-...
Percona 5.6.43 遇到的一个bug
weixin_34150224的博客
04-06 120
最近搭建的一个灾备库，是percona5.6+tokudb的引擎。从官网下载了最新的包 Percona-Server-server-56-5.6.43-rel84.3.el7.x86_64.rpm ，安装后发现errlog里面打了一大堆的TRACE日志。类似如下：TRACE:<INTERPOSE>read()intercepted,fd=110 TRA...
mysql 升级percona_MySQL Study之--Percona Server 5.5升级5.6
weixin_42356844的博客
02-07 255
系统环境：操作系统：CentOS_6.5(64)MySQL: Percona server 5.5(5.6)一、升级的目的为什么MySQL升级是必须的? 原因有很多,比如：为了使用新增的特性,基于性能方面的考量, 修复的bug. 但是在没有充分的测试以前就应用到你的应用中是非常危险的, 因为升级可以能会让你的应用不能正常运作- 也可能引起性能的问题. 此外, 我建议你关注MySQL的发布信息和...
Percona Server 5.7有哪些性能提升？
老叶茶馆
10-27 2721
导读 Percona Server 5.7有哪些性能提升？ 翻译团队：知数堂藏经阁项目 - 天一阁 团队成员：天一阁-冷锋、 天一阁-JACK 、天一阁-神谕 译文校稿：叶师傅 原文出处：《Percona Server 5.7 performance improvements》 https://www.percona.com/blog/2016/03/17/percona-
mysql-Percona Server详细安装步骤
1392252267@qq.com
10-17 2754
之前安装过mysql的mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz，是需要自己手动进行配置的， Linux-CentOS6.5-MySQL安装 以下是Percona-Server-5.6.24-72.2-r8d0f85b-el6-x86_64-bundle.tar的安装，请读者自行借鉴。 关于此软件建议读者自行网上查找。PS：是本人太懒，不想再去找了 ...
linux安装percona冲突,linux下安装percona
weixin_39793434的博客
05-26 152
下载地址上传Percona-Server-5.6.27-76.0-r5498987-el6-x86_64-bundle.tar解压tar -xfPercona-Server-5.6.27-76.0-r5498987-el6-x86_64-bundle.tar依次安装Percona-Server-shared-56-5.6.27-rel76.0.el6.x86_64.rpmPercona-Serv...
部署percona_mysql5.7
daemon_agent的博客
07-12 651
例如：第一章 Python 机器学习入门之pandas的使用https://www.percona.com/由于网络原因无法下载，私信留言 2.编辑配置文件 3.初始化percona5.7 4.启动数据库 /app/percona57/percona/bin/mysqld_safe --defaults-file=/app/percona57/percona/etc/my.cnf &可在mysqld底下增加参数，跳过密码认证 skip-grant-tables...............
linux学习第六篇：安装Percona Server-Mysql
邢宇超的博客
08-07 2791
安装衍生版Percona Server5 个 MySQL 数据库的衍生版 http://www.oschina.net/news/32144/5-mysql-derivative安装包：Percona-Server-5.6.21-70.0-r688-el6-x86_64-bundle.tar首先安装第三方组件cmake yum -y install cmakemkdir /usr/local/s
linux下安装percona
ckqq46580的博客
03-01 175
下载地址 https://www.percona.com/downloads/ 上传Percona-Server-5.6.27-76.0-r5498987-el6-x86_64-bundle.tar 解压tar -xfP...
Puppet 2.6配置详解：集中管理Linux/Unix平台资源
Puppet 2.6配置手册是一份详细的指南，介绍了如何在Linux和Unix平台环境中部署和管理集中配置管理系统。该手册分为多个部分，深入讲解了Puppet的基本概念、安装步骤、配置方法以及高级应用。 首先，1.1节定义了...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值