| # 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=@DBUSER@ |
| db.cloud.password=@DBPW@ |
| db.cloud.host=@DBHOST@ |
| db.cloud.driver=@DBDRIVER@ |
| db.cloud.port=3306 |
| db.cloud.name=cloud |
| |
| # Connection URI to the database "cloud". When this property is set, only the following properties will be used along with it: db.cloud.maxActive, db.cloud.maxIdle, db.cloud.maxWait, db.cloud.username, db.cloud.password, db.cloud.driver, db.cloud.validationQuery, db.cloud.isolation.level. Other properties will be ignored. |
| db.cloud.uri= |
| |
| |
| # CloudStack database tuning parameters |
| db.cloud.maxActive=250 |
| db.cloud.maxIdle=30 |
| db.cloud.maxWait=10000 |
| 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&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'&serverTimezone=UTC |
| |
| # CloudStack database SSL settings |
| db.cloud.useSSL=false |
| db.cloud.keyStore= |
| db.cloud.keyStorePassword= |
| db.cloud.trustStore= |
| db.cloud.trustStorePassword= |
| |
| # Encryption Settings |
| db.cloud.encryption.type=none |
| db.cloud.encrypt.secret= |
| db.cloud.encryptor.version= |
| |
| # usage database settings |
| db.usage.username=@DBUSER@ |
| db.usage.password=@DBPW@ |
| db.usage.host=@DBHOST@ |
| db.usage.driver=@DBDRIVER@ |
| db.usage.port=3306 |
| db.usage.name=cloud_usage |
| |
| # Connection URI to the database "usage". When this property is set, only the following properties will be used along with it: db.usage.maxActive, db.cloud.maxIdle, db.cloud.maxWait, db.usage.username, db.usage.password, db.usage.driver, db.usage.validationQuery, db.usage.isolation.level. Other properties will be ignored. |
| db.usage.uri= |
| |
| |
| # usage database tuning parameters |
| db.usage.maxActive=100 |
| db.usage.maxIdle=30 |
| db.usage.maxWait=10000 |
| db.usage.url.params=serverTimezone=UTC |
| |
| # Simulator database settings |
| db.simulator.username=@DBUSER@ |
| db.simulator.password=@DBPW@ |
| db.simulator.host=@DBHOST@ |
| db.simulator.driver=@DBDRIVER@ |
| db.simulator.port=3306 |
| db.simulator.name=simulator |
| db.simulator.maxActive=250 |
| db.simulator.maxIdle=30 |
| db.simulator.maxWait=10000 |
| db.simulator.autoReconnect=true |
| |
| # Connection URI to the database "simulator". When this property is set, only the following properties will be used along with it: db.simulator.host, db.simulator.port, db.simulator.name, db.simulator.autoReconnect. Other properties will be ignored. |
| db.simulator.uri= |
| |
| |
| # High Availability And Cluster Properties |
| db.ha.enabled=false |
| db.ha.loadBalanceStrategy=com.cloud.utils.db.StaticStrategy |
| # cloud stack Database |
| db.cloud.replicas=localhost,localhost |
| db.cloud.autoReconnect=true |
| db.cloud.failOverReadOnly=false |
| db.cloud.reconnectAtTxEnd=true |
| db.cloud.autoReconnectForPools=true |
| db.cloud.secondsBeforeRetrySource=3600 |
| db.cloud.queriesBeforeRetrySource=5000 |
| db.cloud.initialTimeout=3600 |
| |
| #usage Database |
| db.usage.replicas=localhost,localhost |
| db.usage.autoReconnect=true |
| db.usage.failOverReadOnly=false |
| db.usage.reconnectAtTxEnd=true |
| db.usage.autoReconnectForPools=true |
| db.usage.secondsBeforeRetrySource=3600 |
| db.usage.queriesBeforeRetrySource=5000 |
| db.usage.initialTimeout=3600 |