(四)、mysql部署

中小型规模网站集群架构:mysql部署

: Ago linux运维群:93324526


前言

1.数据库需要授权三个用户
create database wordpress;
grant all on wordpress.* to 'wordpress'@'172.16.1.%' identified by "wordpress";
create database dedecms;
grant all on dedecms.* to 'dedecms'@'172.16.1.%' identified by "dedecms";
create database discuz;
grant all on discuz.* to 'discuz'@'172.16.1.%' identified by "discuz";
2.数据库rpm包制作的脚本
#!/bin/sh
ln -s /application/mysql-5.6.34/ /application/mysql
useradd  mysql  -M -s /sbin/nologin -u 899
chown -R mysql.mysql /application/mysql*
cd /application/mysql
./scripts/mysql_install_db --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data/
\cp support-files/mysql.server /etc/init.d/mysqld
sed -i 's#/usr/local/mysql#/application/mysql#g' /etc/init.d/mysqld
sed -i 's#/usr/local/mysql#/application/mysql#g' /application/mysql/bin/mysqld_safe
ln -s /application/mysql/bin/mysql /usr/local/bin/mysql
\cp /application/mysql/my.cnf /etc/my.cnf
/etc/init.d/mysqld start
制作rpm包
fpm -s dir -t rpm -n mysql -v 5.6.34  --post-install /server/scripts/mysql_rpm.sh -f /application/mysql-5.6.34/

一、ansible部署

base.yml请狂点

---
- hosts: 172.16.1.51
  tasks:
  - name: base
    include: /server/files/base.yml
  - name: "install mysql"
    yum: 
      name: mysql
      state: installed

转载于:https://www.cnblogs.com/can-H/articles/6660342.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值