“OpenStack部署:安装MySQL数据库”的版本间的差异

来自CloudWiki
跳转至: 导航搜索
(创建页面,内容为“==安装Mysql数据库服务== ===controller节点=== # yum install mysql mysql-server MySQL-python 修改 /etc/my.cnf文件[mysqld]中添加 <nowiki>max_conne…”)
 
 
(未显示另一用户的1个中间版本)
第1行: 第1行:
 
==安装Mysql数据库服务==
 
==安装Mysql数据库服务==
 
===controller节点===
 
===controller节点===
# yum install  mysql  mysql-server  MySQL-python
+
yum install  mysql  mysql-server  MySQL-python
  
 
修改 /etc/my.cnf文件[mysqld]中添加
 
修改 /etc/my.cnf文件[mysqld]中添加
第14行: 第14行:
 
启动服务
 
启动服务
  
#systemctl enable mariadb.service
+
systemctl enable mariadb.service
#systemctl start mariadb.service
+
 
 +
systemctl start mariadb.service
  
 
配置Mysql
 
配置Mysql
  
#mysql_secure_installation
+
mysql_secure_installation
  
 
按enter确认后设置数据库root密码
 
按enter确认后设置数据库root密码
第37行: 第38行:
 
重新加载系统服务,并重启mariadb服务
 
重新加载系统服务,并重启mariadb服务
  
# systemctl daemon-reload
+
systemctl daemon-reload
# service mariadb restart
+
 
 +
service mariadb restart
  
 
===compute节点===
 
===compute节点===
  
#yum -y install  MySQL-python
+
yum -y install  MySQL-python
  
 
== 安装Mongo数据库服务 ==
 
== 安装Mongo数据库服务 ==
第48行: 第50行:
 
controller:
 
controller:
  
#yum install -y mongodb-server mongodb
+
yum install -y mongodb-server mongodb
  
 
编辑 /etc/mongod.conf文件
 
编辑 /etc/mongod.conf文件
第55行: 第57行:
 
  修改 smallfiles = true
 
  修改 smallfiles = true
  
#systemctl enable mongod.service
+
systemctl enable mongod.service
  
#systemctl start mongod.service
+
systemctl start mongod.service
  
  
第64行: 第66行:
 
controller:
 
controller:
  
# yum install -y rabbitmq-server
+
yum install -y rabbitmq-server
  
 
systemctl enable rabbitmq-server.service
 
systemctl enable rabbitmq-server.service
第73行: 第75行:
  
 
rabbitmqctl set_permissions openstack ".*" ".*" ".*"
 
rabbitmqctl set_permissions openstack ".*" ".*" ".*"
 
  
 
== 安装memcahce ==
 
== 安装memcahce ==
第79行: 第80行:
 
controller:
 
controller:
  
#yum install memcached python-memcached
+
yum install memcached python-memcached
  
 
systemctl enable memcached.service
 
systemctl enable memcached.service
  
 
systemctl restart memcached.service
 
systemctl restart memcached.service

2018年9月8日 (六) 12:44的最新版本

安装Mysql数据库服务

controller节点

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节点

yum -y install MySQL-python

安装Mongo数据库服务

controller:

yum install -y mongodb-server mongodb

编辑 /etc/mongod.conf文件

删除bind_ip行
修改 smallfiles = true

systemctl enable mongod.service

systemctl start mongod.service


安装RabbitMQ服务

controller:

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:

yum install memcached python-memcached

systemctl enable memcached.service

systemctl restart memcached.service