Database Properties

Property	Default Value	Description
db_owner	N/A	The database owner username
db_owner_password	N/A	The password of the database owner user
should_upgrade_db	true	Flag indicating whether the database upgrade should be performed. From version 8.0.3, the CMP deployment playbook supports the option to perform either: A clean database deployment when the database will be recreated and as a result of the deployment, existing data will be deleted. A database upgrade when the database structure and dictionary data will be upgraded to the new version, retaining existing data. Important: Do not change this property from the default value of `true` unless you fully understand the consequences of this action. Under NO circumstances should this be done in a production environment.
upgrade_db_from_version	N/A	The current version of the CMP database (e.g. 8.0.2) in case of the database upgrade. The version stored in the upgrade_db_from_version property must be less than the version of CMP that is being deployed. In addition, the version must be one that is supported for upgrade from for the release as indicated in the release notes.
db_data_population	Business_Configuration	The string identifying what data should be populated to the database at the time of the initial deployment. This property accepts the following values: Factory_Configuration Data configuration that is required for the basic operation of CMP and is maintained as part of future software upgrades. Business_Configuration Data configuration that is very infrequently changed in a CMP installation. Example data is provided that will likely form a good foundation for the configuration of CMP. This data will not be overwritten or updated as part of future software upgrades. Project_Configuration Data configuration that will always be specific to each CMP installation and will frequently change. Example data is provided that could be used as a foundation for the configuration of CMP but is more likely of use for demonstration and test purposes only. This data will not be overwritten or updated as part of future software upgrades. The data population options are hierarchical and build on each other. For example, if you select Factory_Configuration, Business and Project configuration are automatically and mandatorily populated too. This property can be omitted, in which case, the default value is used.

Two dictionary properties control database behaviour:

Group	Description
pg	PostgreSQL related properties
os	Operating system related properties

When CMP Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. is deployed for the first time, the PostgreSQL and OS Operating System. The software that supports a computer's basic functions, such as scheduling tasks and controlling peripherals. property settings for the database are automatically derived from the CPU and memory information supplied in the following database properties:

Property	Default Value	Description
db_system_cpu	4CPU	Number of CPUs on the system which hosts the database. This is used to determine how the Postgres database is configured.
db_system_mem	8GB Memory	The amount of memory on the system which hosts the database. This is used to determine how the Postgres database is configured.
db_system_dsk	SlowDisk	The type of disk installed on the system which hosts the database. This is used to determine how the Postgres database is configured.

When deploying CMP for the first time, if you need to alter these properties it is recommend that you configure them in the Installation Configuration tool in the page for the CMP Database host group In the Customer Manager Platform hierarchy, the highest level of the structure. The group level can be used to group corporates. Groups can hold financial information. under Advanced Properties.

Once CMP is installed, however, the system must be monitored and these settings adjusted as needed as the system matures, either manually or using automation tools.