Atom feed of this document
  
Juno -  Juno -  Juno -  Juno -  Juno -  Juno -  Juno -  Juno - 

 Configure the database

Use the options to configure the used databases:

Table 4.22. Description of database configuration options
Configuration option = Default value Description
[DEFAULT]
sql_connection = sqlite:///trove_test.sqlite (StrOpt) SQL Connection.
sql_idle_timeout = 3600 (IntOpt) Idle time (in seconds) after which the connection to the database is reestablished. Some databases will drop connections after a specific amount of idle time. Setting sql_idle_timeout to a lower value than this will ensure that a reconnect occurs before the database can drop the connection.
sql_query_log = False (BoolOpt) Write all SQL queries to a log.
sql_query_logging = False (BoolOpt) Allow insecure logging while executing queries through SQLAlchemy.

Table 4.23. Description of Cassandra database configuration options
Configuration option = Default value Description
[cassandra]
backup_incremental_strategy = {} (DictOpt) Incremental Backup Runner based on the default strategy. For strategies that do not implement an incremental, the runner will use the default full backup.
backup_namespace = None (StrOpt) Namespace to load backup strategies from.
backup_strategy = None (StrOpt) Default strategy to perform backups.
device_path = /dev/vdb (StrOpt) Device path for volume if volume support is enabled.
mount_point = /var/lib/cassandra (StrOpt) Filesystem path for mounting volumes if volume support is enabled.
replication_strategy = None (StrOpt) Default strategy for replication.
restore_namespace = None (StrOpt) Namespace to load restore strategies from.
tcp_ports = 7000, 7001, 9042, 9160 (ListOpt) List of TCP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
udp_ports = (ListOpt) List of UDP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
volume_support = True (BoolOpt) Whether to provision a Cinder volume for datadir.

Table 4.24. Description of Couchbase database configuration options
Configuration option = Default value Description
[couchbase]
backup_incremental_strategy = {} (DictOpt) Incremental Backup Runner based on the default strategy. For strategies that do not implement an incremental, the runner will use the default full backup.
backup_namespace = trove.guestagent.strategies.backup.couchbase_impl (StrOpt) Namespace to load backup strategies from.
backup_strategy = CbBackup (StrOpt) Default strategy to perform backups.
device_path = /dev/vdb (StrOpt) Device path for volume if volume support is enabled.
mount_point = /var/lib/couchbase (StrOpt) Filesystem path for mounting volumes if volume support is enabled.
replication_strategy = None (StrOpt) Default strategy for replication.
restore_namespace = trove.guestagent.strategies.restore.couchbase_impl (StrOpt) Namespace to load restore strategies from.
root_on_create = True (BoolOpt) Enable the automatic creation of the root user for the service during instance-create. The generated password for the root user is immediately returned in the response of instance-create as the 'password' field.
tcp_ports = 8091, 8092, 4369, 11209-11211, 21100-21199 (ListOpt) List of TCP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
udp_ports = (ListOpt) List of UDP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
volume_support = True (BoolOpt) Whether to provision a Cinder volume for datadir.

Table 4.25. Description of MongoDB database configuration options
Configuration option = Default value Description
[mongodb]
api_strategy = trove.common.strategies.mongodb.api.MongoDbAPIStrategy (StrOpt) Class that implements datastore-specific API logic.
backup_incremental_strategy = {} (DictOpt) Incremental Backup Runner based on the default strategy. For strategies that do not implement an incremental, the runner will use the default full backup.
backup_namespace = None (StrOpt) Namespace to load backup strategies from.
backup_strategy = None (StrOpt) Default strategy to perform backups.
cluster_support = True (BoolOpt) Enable clusters to be created and managed.
device_path = /dev/vdb (StrOpt) Device path for volume if volume support is enabled.
guestagent_strategy = trove.common.strategies.mongodb.guestagent.MongoDbGuestAgentStrategy (StrOpt) Class that implements datastore-specific Guest Agent API logic.
mount_point = /var/lib/mongodb (StrOpt) Filesystem path for mounting volumes if volume support is enabled.
num_config_servers_per_cluster = 3 (IntOpt) The number of config servers to create per cluster.
num_query_routers_per_cluster = 1 (IntOpt) The number of query routers (mongos) to create per cluster.
replication_strategy = None (StrOpt) Default strategy for replication.
restore_namespace = None (StrOpt) Namespace to load restore strategies from.
taskmanager_strategy = trove.common.strategies.mongodb.taskmanager.MongoDbTaskManagerStrategy (StrOpt) Class that implements datastore-specific task manager logic.
tcp_ports = 2500, 27017 (ListOpt) List of TCP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
udp_ports = (ListOpt) List of UPD ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
volume_support = True (BoolOpt) Whether to provision a Cinder volume for datadir.

Table 4.26. Description of MySQL database configuration options
Configuration option = Default value Description
[mysql]
backup_incremental_strategy = {'InnoBackupEx': 'InnoBackupExIncremental'} (DictOpt) Incremental Backup Runner based on the default strategy. For strategies that do not implement an incremental backup, the runner will use the default full backup.
backup_namespace = trove.guestagent.strategies.backup.mysql_impl (StrOpt) Namespace to load backup strategies from.
backup_strategy = InnoBackupEx (StrOpt) Default strategy to perform backups.
device_path = /dev/vdb (StrOpt) Device path for volume if volume support is enabled.
mount_point = /var/lib/mysql (StrOpt) Filesystem path for mounting volumes if volume support is enabled.
replication_namespace = trove.guestagent.strategies.replication.mysql_binlog (StrOpt) Namespace to load replication strategies from.
replication_strategy = MysqlBinlogReplication (StrOpt) Default strategy for replication.
restore_namespace = trove.guestagent.strategies.restore.mysql_impl (StrOpt) Namespace to load restore strategies from.
root_on_create = False (BoolOpt) Enable the automatic creation of the root user for the service during instance-create. The generated password for the root user is immediately returned in the response of instance-create as the 'password' field.
tcp_ports = 3306 (ListOpt) List of TCP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
udp_ports = (ListOpt) List of UDP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
usage_timeout = 400 (IntOpt) Maximum time (in seconds) to wait for a Guest to become active.
volume_support = True (BoolOpt) Whether to provision a Cinder volume for datadir.

Table 4.27. Description of Percona database configuration options
Configuration option = Default value Description
[percona]
backup_incremental_strategy = {'InnoBackupEx': 'InnoBackupExIncremental'} (DictOpt) Incremental Backup Runner based on the default strategy. For strategies that do not implement an incremental backup, the runner will use the default full backup.
backup_namespace = trove.guestagent.strategies.backup.mysql_impl (StrOpt) Namespace to load backup strategies from.
backup_strategy = InnoBackupEx (StrOpt) Default strategy to perform backups.
device_path = /dev/vdb (StrOpt) Device path for volume if volume support is enabled.
mount_point = /var/lib/mysql (StrOpt) Filesystem path for mounting volumes if volume support is enabled.
replication_namespace = trove.guestagent.strategies.replication.mysql_binlog (StrOpt) Namespace to load replication strategies from.
replication_password = NETOU7897NNLOU (StrOpt) Password for replication slave user.
replication_strategy = MysqlBinlogReplication (StrOpt) Default strategy for replication.
replication_user = slave_user (StrOpt) Userid for replication slave.
restore_namespace = trove.guestagent.strategies.restore.mysql_impl (StrOpt) Namespace to load restore strategies from.
root_on_create = False (BoolOpt) Enable the automatic creation of the root user for the service during instance-create. The generated password for the root user is immediately returned in the response of instance-create as the 'password' field.
tcp_ports = 3306 (ListOpt) List of TCP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
udp_ports = (ListOpt) List of UDP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
usage_timeout = 450 (IntOpt) Maximum time (in seconds) to wait for a Guest to become active.
volume_support = True (BoolOpt) Whether to provision a Cinder volume for datadir.

Table 4.28. Description of PostgreSQL database configuration options
Configuration option = Default value Description
[postgresql]
backup_incremental_strategy = {} (DictOpt) Incremental Backup Runner based on the default strategy. For strategies that do not implement an incremental, the runner will use the default full backup.
backup_namespace = trove.guestagent.strategies.backup.postgresql_impl (StrOpt) Namespace to load backup strategies from.
backup_strategy = PgDump (StrOpt) Default strategy to perform backups.
device_path = /dev/vdb (StrOpt) No help text available for this option.
ignore_dbs = postgres (ListOpt) No help text available for this option.
ignore_users = os_admin, postgres, root (ListOpt) No help text available for this option.
mount_point = /var/lib/postgresql (StrOpt) Filesystem path for mounting volumes if volume support is enabled.
restore_namespace = trove.guestagent.strategies.restore.postgresql_impl (StrOpt) Namespace to load restore strategies from.
root_on_create = False (BoolOpt) Enable the automatic creation of the root user for the service during instance-create. The generated password for the root user is immediately returned in the response of instance-create as the 'password' field.
tcp_ports = 5432 (ListOpt) List of TCP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
udp_ports = (ListOpt) List of UPD ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
volume_support = True (BoolOpt) Whether to provision a Cinder volume for datadir.

Table 4.29. Description of Redis database configuration options
Configuration option = Default value Description
[redis]
backup_incremental_strategy = {} (DictOpt) Incremental Backup Runner based on the default strategy. For strategies that do not implement an incremental, the runner will use the default full backup.
backup_namespace = None (StrOpt) Namespace to load backup strategies from.
backup_strategy = None (StrOpt) Default strategy to perform backups.
device_path = None (StrOpt) Device path for volume if volume support is enabled.
mount_point = /var/lib/redis (StrOpt) Filesystem path for mounting volumes if volume support is enabled.
replication_strategy = None (StrOpt) Default strategy for replication.
restore_namespace = None (StrOpt) Namespace to load restore strategies from.
tcp_ports = 6379 (ListOpt) List of TCP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
udp_ports = (ListOpt) List of UDP ports and/or port ranges to open in the security group (only applicable if trove_security_groups_support is True).
volume_support = False (BoolOpt) Whether to provision a Cinder volume for datadir.

Questions? Discuss on ask.openstack.org
Found an error? Report a bug against this page

loading table of contents...