Liberty -  Liberty -  Liberty -  Liberty -  Liberty -  Liberty -  Liberty -  Liberty - 

 Configure the database

Use the options to configure the used databases:

Table 6.22. Description of database configuration options
Configuration option = Default value Description
[DEFAULT]
sql_query_logging = False (BoolOpt) Allow insecure logging while executing queries through SQLAlchemy.
[database]
connection = sqlite:///trove_test.sqlite (StrOpt) SQL Connection.
idle_timeout = 3600 (IntOpt) No help text available for this option.
query_log = False (BoolOpt) No help text available for this option.

Table 6.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.
root_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for cassandra.
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 6.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.experimental.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.experimental.couchbase_impl (StrOpt) Namespace to load restore strategies from.
root_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for couchbase.
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.
[couchdb]
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/couchdb (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.
root_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for couchdb.
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 = 5984 (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 6.25. Description of DB2 database configuration options
Configuration option = Default value Description
[db2]
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.
ignore_users = PUBLIC, DB2INST1 (ListOpt) No help text available for this option.
mount_point = /home/db2inst1/db2inst1 (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.
root_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for db2.
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 = 50000 (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 6.26. Description of MariaDB database configuration options
Configuration option = Default value Description
[mariadb]
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_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for mysql.
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 6.27. Description of MongoDB database configuration options
Configuration option = Default value Description
[mongodb]
add_members_timeout = 300 (IntOpt) Maximum time to wait (in seconds) for a replica set initialization process to complete.
api_strategy = trove.common.strategies.cluster.experimental.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 = trove.guestagent.strategies.backup.experimental.mongo_impl (StrOpt) Namespace to load backup strategies from.
backup_strategy = MongoDump (StrOpt) Default strategy to perform backups.
cluster_support = True (BoolOpt) Enable clusters to be created and managed.
configsvr_port = 27019 (IntOpt) Port for instances running as config servers.
device_path = /dev/vdb (StrOpt) Device path for volume if volume support is enabled.
guestagent_strategy = trove.common.strategies.cluster.experimental.mongodb.guestagent.MongoDbGuestAgentStrategy (StrOpt) Class that implements datastore-specific Guest Agent API logic.
ignore_dbs = admin, local, config (ListOpt) Databases to exclude when listing databases.
ignore_users = admin.os_admin, admin.root (ListOpt) Users to exclude when listing users.
mongodb_port = 27017 (IntOpt) Port for mongod and mongos instances.
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 = trove.guestagent.strategies.restore.experimental.mongo_impl (StrOpt) Namespace to load restore strategies from.
root_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for mongodb.
taskmanager_strategy = trove.common.strategies.cluster.experimental.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 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 6.28. 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_gtid (StrOpt) Namespace to load replication strategies from.
replication_strategy = MysqlGTIDReplication (StrOpt) Default strategy for replication.
restore_namespace = trove.guestagent.strategies.restore.mysql_impl (StrOpt) Namespace to load restore strategies from.
root_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for mysql.
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 6.29. Description of Percona XtraDB Cluster database configuration options
Configuration option = Default value Description
[pxc]
api_strategy = trove.common.strategies.cluster.experimental.pxc.api.PXCAPIStrategy (StrOpt) Class that implements datastore-specific API logic.
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.
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.cluster.experimental.pxc.guestagent.PXCGuestAgentStrategy (StrOpt) Class that implements datastore-specific Guest Agent API logic.
ignore_users = os_admin, root, clusterrepuser (ListOpt) Users to exclude when listing users.
min_cluster_member_count = 3 (IntOpt) Minimum number of members in PXC cluster.
mount_point = /var/lib/mysql (StrOpt) Filesystem path for mounting volumes if volume support is enabled.
replication_namespace = trove.guestagent.strategies.replication.mysql_gtid (StrOpt) Namespace to load replication strategies from.
replication_strategy = MysqlGTIDReplication (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_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for pxc.
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.
taskmanager_strategy = trove.common.strategies.cluster.experimental.pxc.taskmanager.PXCTaskManagerStrategy (StrOpt) Class that implements datastore-specific task manager logic.
tcp_ports = 3306, 4444, 4567, 4568 (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 6.30. 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_gtid (StrOpt) Namespace to load replication strategies from.
replication_password = NETOU7897NNLOU (StrOpt) Password for replication slave user.
replication_strategy = MysqlGTIDReplication (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_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for percona.
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 6.31. 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.experimental.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.experimental.postgresql_impl (StrOpt) Namespace to load restore strategies from.
root_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for postgresql.
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 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 6.32. Description of Redis database configuration options
Configuration option = Default value Description
[redis]
api_strategy = trove.common.strategies.cluster.experimental.redis.api.RedisAPIStrategy (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 = trove.guestagent.strategies.backup.experimental.redis_impl (StrOpt) Namespace to load backup strategies from.
backup_strategy = RedisBackup (StrOpt) Default strategy to perform backups.
cluster_support = True (BoolOpt) Enable clusters to be created and managed.
device_path = None (StrOpt) Device path for volume if volume support is enabled.
guestagent_strategy = trove.common.strategies.cluster.experimental.redis.guestagent.RedisGuestAgentStrategy (StrOpt) Class that implements datastore-specific Guest Agent API logic.
mount_point = /var/lib/redis (StrOpt) Filesystem path for mounting volumes if volume support is enabled.
replication_namespace = trove.guestagent.strategies.replication.experimental.redis_sync (StrOpt) Namespace to load replication strategies from.
replication_strategy = RedisSyncReplication (StrOpt) Default strategy for replication.
restore_namespace = trove.guestagent.strategies.restore.experimental.redis_impl (StrOpt) Namespace to load restore strategies from.
root_controller = trove.extensions.common.service.DefaultRootController (StrOpt) Root controller implementation for redis.
taskmanager_strategy = trove.common.strategies.cluster.experimental.redis.taskmanager.RedisTaskManagerStrategy (StrOpt) Class that implements datastore-specific task manager logic.
tcp_ports = 6379, 16379 (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 6.33. Description of Vertica database configuration options
Configuration option = Default value Description
[vertica]
api_strategy = trove.common.strategies.cluster.experimental.vertica.api.VerticaAPIStrategy (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_member_count = 3 (IntOpt) Number of members in Vertica cluster.
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.cluster.experimental.vertica.guestagent.VerticaGuestAgentStrategy (StrOpt) Class that implements datastore-specific Guest Agent API logic.
mount_point = /var/lib/vertica (StrOpt) Filesystem path for mounting volumes if volume support is enabled.
readahead_size = 2048 (IntOpt) Size(MB) to be set as readahead_size for data volume
replication_strategy = None (StrOpt) Default strategy for replication.
restore_namespace = None (StrOpt) Namespace to load restore strategies from.
root_controller = trove.extensions.vertica.service.VerticaRootController (StrOpt) Root controller implementation for Vertica.
taskmanager_strategy = trove.common.strategies.cluster.experimental.vertica.taskmanager.VerticaTaskManagerStrategy (StrOpt) Class that implements datastore-specific task manager logic.
tcp_ports = 5433, 5434, 22, 5444, 5450, 4803 (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 = 5433, 4803, 4804, 6453 (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.

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

loading table of contents...