azure-postgresql-flexible-server
intel/azure-postgresql-flexible-server/intel
Intel Cloud Optimization Module - Azure PostgreSQL Flexible Server
Intel Optimized Cloud Modules for Terraform © Copyright 2024, Intel Corporation Azure PostgreSQL Flexible Server Module This module can be used to deploy an Intel optimized Azure PostgreSQL Flexible Server instance. Instance selection and PostgreSQL optimization are included by default in the code. The PostgreSQL Optimizations were based off Intel Xeon Tuning guides Performance Data Boost Azure PostgreSQL performance by up to 1.42x with 3rd Generation Intel® Xeon® Scalable Processor (Ice Lake) Process up to 1.24x more Azure PostgreSQL transactions with 3rd Generation Intel® Xeon® Scalable Processor (Ice Lake) Up to 1.23x more Azure PostgreSQL OLTP transactions per minute with 3rd Generation Intel® Xeon® Scalable Processor (Ice Lake) Usage See examples folder for complete examples. By defau
| Name | Type | Description | Default |
|---|---|---|---|
| resource_group_name | string | Existing Resource Group where resource will be created. | required |
| db_password | string | Password for the master database user. | required |
| db_server_name | string | Name of the server that will be created. | required |
| db_ha_standby_zone | string | Specifies the Availability Zone in which the standby Flexible Server should be l | "1" |
| db_engine_version | string | Database engine version for the Azure database instance. | "14" |
| db_charset | string | Specifies the Charset for the database. | "UTF8" |
| db_name | string | Name of the database that will be created on the flexible instance. If this is s | null |
| db_server_sku | string | Instance SKU, see comments above for guidance | "MO_Standard_E8ds_v4" |
| db_username | string | Username for the master database user. | "pgadmin" |
| db_ha_mode | string | The high availability mode for the Flexible Server. Possibles values are ZoneRed | "ZoneRedundant" |
| db_private_dns_zone_id | string | The ID of the private DNS zone to create the Flexible Server. | null |
| db_parameters | object({ postgres = option | Intel Cloud optimizations for Xeon processors | {
"postgres": {
"autovacuum": {},
|
| db_allocated_storage | number | The max storage allowed for the PostgreSQL Flexible Server. Possible values (MB) | 2097152 |
| db_restore_time | string | When create_mode is PointInTimeRestore, specifies the point in time to restore f | null |
| db_geo_backup_enabled | bool | Turn Geo-redundant server backups on/off. This allows you to choose between loca | false |
| db_create_source_id | string | For creation modes other than Default, the source server ID to use. | null |
| db_collation | string | Specifies the Collation for the Database. | "en_US.UTF8" |
| db_engine | string | Database engine for Azure database instance. | "postgres" |
| db_maintenance_hour | string | The start hour for maintenance window. | null |
| db_firewall_rules | list(object({ name | Map of IP ranges that (if specified) will create firewall rules for the server t | [] |
| db_backup_retention_period | number | The days to retain backups for. Must be between 1 and 35. | 7 |
| db_create_mode | string | The creation mode which can be used to restore or replicate existing servers. | "Default" |
| db_delegated_subnet_id | string | The ID of the virtual network subnet to create the Flexible Server. | null |
db_server_sku — Instance SKU in use for the database instance that was created.db_resource_group_name — Resource Group where the database instance resides.db_collation — The Collation configured on the database.db_private_dns_zone_id — The ID of the private DNS zone that the instance will use.db_maintenance_window_hour — Maintainence window for the database instance.db_allocated_storage — Storage allocated to the database instance.db_name — Name of the database that has been provisioned on the database instance.db_restore_time — Specifies the point in time to restore from creation_source_server_id.db_server_name — Database instance hostname.db_location — Database instance location.db_zone — Zone where the database instance was deployed.db_create_mode — The creation mode that was configured on the instance. db_maintenance_window_day — Maintainence window for the database instance.db_maintenance_window_minute — Maintainence window for the database instance.db_username — Database instance master username.db_password — Database instance master password.db_id — Database instance ID.db_hostname — Database instance fully qualified domain name.db_engine_version_actual — Running engine version of the database (full version number)db_ha_standby_zone — Specifies the Availability Zone in which the standby Flexible Server should be located.db_create_source_id — For creation modes other than Default, the source server ID to use.db_charset — The Charset configured on the database.db_backup_retention — Number of configured backups to keep for the database instance.db_delegated_subnet_id — The ID of the virtual network subnet to create the MySQL Flexible Server.db_ha_mode — The high availability mode for the MySQL Flexible Server.db_firewall_rules — Database Firewall Rules.