mirror of
https://github.com/apache/cloudstack.git
synced 2025-10-26 08:42:29 +01:00
d949302d0f
* DB : Add support for MySQL 8
- Splits commands to create user and grant access on database, the old
statement is no longer supported by MySQL 8.x
- `NO_AUTO_CREATE_USER` is no longer supported by MySQL 8.x so remove
that from db.properties conn parameters
For mysql-server 8.x setup the following changes were added/tested to
make it work with CloudStack in /etc/mysql/mysql.conf.d/mysqld.cnf and
then restart the mysql-server process:
server_id = 1
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION"
innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
max_connections=1000
log-bin=mysql-bin
binlog-format = 'ROW'
default-authentication-plugin=mysql_native_password
Notice the last line above, this is to reset the old password based
authentication used by MySQL 5.x.
Developers can set empty password as follows:
> sudo mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED BY '';
In libvirt repository, there are two related commits
2019-08-23 13:13 Daniel P. Berrangé ● rpm: don't enable socket activation in upgrade if --listen present
2019-08-22 14:52 Daniel P. Berrangé ● remote: forbid the --listen arg when systemd socket activation
In libvirt.spec.in
/bin/systemctl mask libvirtd.socket >/dev/null 2>&1 || :
/bin/systemctl mask libvirtd-ro.socket >/dev/null 2>&1 || :
/bin/systemctl mask libvirtd-admin.socket >/dev/null 2>&1 || :
/bin/systemctl mask libvirtd-tls.socket >/dev/null 2>&1 || :
/bin/systemctl mask libvirtd-tcp.socket >/dev/null 2>&1 || :
Co-authored-by: Wei Zhou <w.zhou@global.leaseweb.com>
Co-authored-by: Abhishek Kumar <abhishek.mrt22@gmail.com>
Co-authored-by: Rohit Yadav <rohit.yadav@shapeblue.com>
77 lines
2.6 KiB
Properties
77 lines
2.6 KiB
Properties
#
|
|
# Licensed to the Apache Software Foundation (ASF) under one
|
|
# or more contributor license agreements. See the NOTICE file
|
|
# distributed with this work for additional information
|
|
# regarding copyright ownership. The ASF licenses this file
|
|
# to you under the Apache License, Version 2.0 (the
|
|
# "License"); you may not use this file except in compliance
|
|
# with the License. You may obtain a copy of the License at
|
|
#
|
|
# http://www.apache.org/licenses/LICENSE-2.0
|
|
#
|
|
# Unless required by applicable law or agreed to in writing,
|
|
# software distributed under the License is distributed on an
|
|
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
|
|
# KIND, either express or implied. See the License for the
|
|
# specific language governing permissions and limitations
|
|
# under the License.
|
|
#
|
|
|
|
|
|
# management server clustering parameters, change cluster.node.IP to the machine IP address
|
|
# in which the management server is running
|
|
cluster.node.IP=127.0.0.1
|
|
cluster.servlet.port=9090
|
|
region.id=1
|
|
|
|
# CloudStack database settings
|
|
db.cloud.username=cloud
|
|
db.cloud.password=cloud
|
|
db.root.password=
|
|
db.cloud.host=localhost
|
|
db.cloud.driver=jdbc:mysql
|
|
db.cloud.port=3306
|
|
db.cloud.name=cloud
|
|
|
|
# CloudStack database tuning parameters
|
|
db.cloud.maxActive=250
|
|
db.cloud.maxIdle=30
|
|
db.cloud.maxWait=10000
|
|
db.cloud.autoReconnect=true
|
|
db.cloud.validationQuery=SELECT 1
|
|
db.cloud.testOnBorrow=true
|
|
db.cloud.testWhileIdle=true
|
|
db.cloud.timeBetweenEvictionRunsMillis=40000
|
|
db.cloud.minEvictableIdleTimeMillis=240000
|
|
db.cloud.poolPreparedStatements=false
|
|
db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&prepStmtCacheSqlLimit=4096&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC
|
|
|
|
# usage database settings
|
|
db.usage.username=cloud
|
|
db.usage.password=cloud
|
|
db.usage.host=localhost
|
|
# It's not guaranteed that using a different DB provider than the one from the regular cloud DB will work
|
|
db.usage.driver=jdbc:mysql
|
|
db.usage.port=3306
|
|
db.usage.name=cloud_usage
|
|
|
|
# usage database tuning parameters
|
|
db.usage.maxActive=100
|
|
db.usage.maxIdle=30
|
|
db.usage.maxWait=10000
|
|
db.usage.autoReconnect=true
|
|
db.usage.url.params=serverTimezone=UTC
|
|
|
|
# Simulator database settings
|
|
db.simulator.username=cloud
|
|
db.simulator.password=cloud
|
|
db.simulator.host=localhost
|
|
# It's not guaranteed that using a different DB provider than the one from the regular cloud DB will work
|
|
db.simulator.driver=jdbc:mysql
|
|
db.simulator.port=3306
|
|
db.simulator.name=simulator
|
|
db.simulator.maxActive=250
|
|
db.simulator.maxIdle=30
|
|
db.simulator.maxWait=10000
|
|
db.simulator.autoReconnect=true
|