OpenStack部署:安装MySQL数据库

来自CloudWiki
119.162.4.114讨论2018年9月8日 (六) 12:41的版本 (创建页面,内容为“==安装Mysql数据库服务== ===controller节点=== # yum install mysql mysql-server MySQL-python 修改 /etc/my.cnf文件[mysqld]中添加 <nowiki>max_conne…”)
(差异) ←上一版本 | 最后版本 (差异) | 下一版本→ (差异)
跳转至: 导航搜索

安装Mysql数据库服务

controller节点

  1. yum install mysql mysql-server MySQL-python

修改 /etc/my.cnf文件[mysqld]中添加

max_connections=10000
default-storage-engine = innodb
innodb_file_per_table
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8

启动服务

#systemctl enable mariadb.service
#systemctl start mariadb.service

配置Mysql

#mysql_secure_installation

按enter确认后设置数据库root密码

Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] n
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y

修改/usr/lib/systemd/system/mariadb.service

[Service]新添加两行如下参数:

LimitNOFILE=10000
LimitNPROC=10000

重新加载系统服务,并重启mariadb服务

# systemctl daemon-reload
# service mariadb restart

compute节点

  1. yum -y install MySQL-python

安装Mongo数据库服务

controller:

#yum install -y mongodb-server mongodb

编辑 /etc/mongod.conf文件

删除bind_ip行
修改 smallfiles = true
  1. systemctl enable mongod.service
  1. systemctl start mongod.service


安装RabbitMQ服务

controller:

  1. yum install -y rabbitmq-server

systemctl enable rabbitmq-server.service

systemctl restart rabbitmq-server.service

rabbitmqctl add_user openstack 000000

rabbitmqctl set_permissions openstack ".*" ".*" ".*"


安装memcahce

controller:

  1. yum install memcached python-memcached

systemctl enable memcached.service

systemctl restart memcached.service