Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the acf domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php on line 6131

Deprecated: Creation of dynamic property ACF::$fields is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/fields.php on line 138

Deprecated: Creation of dynamic property acf_loop::$loops is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/loop.php on line 28

Deprecated: Creation of dynamic property ACF::$loop is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/loop.php on line 269

Deprecated: Creation of dynamic property ACF::$revisions is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/revisions.php on line 397

Deprecated: Creation of dynamic property acf_validation::$errors is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/validation.php on line 28

Deprecated: Creation of dynamic property ACF::$validation is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/validation.php on line 214

Deprecated: Creation of dynamic property acf_form_customizer::$preview_values is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/forms/form-customizer.php on line 28

Deprecated: Creation of dynamic property acf_form_customizer::$preview_fields is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/forms/form-customizer.php on line 29

Deprecated: Creation of dynamic property acf_form_customizer::$preview_errors is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/forms/form-customizer.php on line 30

Deprecated: Creation of dynamic property ACF::$form_front is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/forms/form-front.php on line 598

Deprecated: Creation of dynamic property acf_form_widget::$preview_values is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/forms/form-widget.php on line 34

Deprecated: Creation of dynamic property acf_form_widget::$preview_reference is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/forms/form-widget.php on line 35

Deprecated: Creation of dynamic property acf_form_widget::$preview_errors is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/forms/form-widget.php on line 36

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the all-in-one-wp-migration domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php on line 6131

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php:6131) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/wp_plugin/wp_plugin.php on line 23

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/wp-super-cache/wp-cache-phase2.php on line 54

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php:6131) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/wp-super-cache/wp-cache-phase2.php on line 1539

Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/wp-super-cache/wp-cache-phase2.php on line 828

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the rocket domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php on line 6131

Deprecated: Creation of dynamic property acf_field_oembed::$width is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/fields/class-acf-field-oembed.php on line 31

Deprecated: Creation of dynamic property acf_field_oembed::$height is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/fields/class-acf-field-oembed.php on line 32

Deprecated: Creation of dynamic property acf_field_google_map::$default_values is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/fields/class-acf-field-google-map.php on line 33

Deprecated: Creation of dynamic property acf_field__group::$have_rows is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/includes/fields/class-acf-field-group.php on line 31

Deprecated: Creation of dynamic property acf_field_clone::$cloning is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/pro/fields/class-acf-field-clone.php on line 34

Deprecated: Creation of dynamic property acf_field_clone::$have_rows is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-pro/pro/fields/class-acf-field-clone.php on line 35

Deprecated: Creation of dynamic property jh_acf_field_table::$settings is deprecated in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-content/plugins/advanced-custom-fields-table-field/class-jh-acf-field-table.php on line 23

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php:6131) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php:6131) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php:6131) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php:6131) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php:6131) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php:6131) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php:6131) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/rest-api/class-wp-rest-server.php on line 1902

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/functions.php:6131) in /var/www/vhosts/studiogo.tech/httpdocs/upcloudold/wp-includes/rest-api/class-wp-rest-server.php on line 1902
{"id":2272,"date":"2022-04-22T14:32:07","date_gmt":"2022-04-22T11:32:07","guid":{"rendered":"https:\/\/upcloud.com\/?post_type=documentation&p=2272"},"modified":"2023-09-06T04:48:20","modified_gmt":"2023-09-06T04:48:20","slug":"managed-databases","status":"publish","type":"documentation","link":"https:\/\/studiogo.tech\/upcloudold\/documentation\/managed-databases\/","title":{"rendered":"Managed Databases"},"content":{"rendered":"\r\n

UpCloud Managed Database<\/a> is a database-as-a-service offering a carefree option for running well-known open-source databases in the cloud. It is deployable via the users’ UpCloud Control Panel with configuration options including the choice of database management systems, clustered or single-node systems, and a number of resource plans. Managed Databases are available in every UpCloud data centre location.<\/p>\r\n\r\n\r\n\r\n

Available databases<\/h2>\r\n\r\n\r\n\r\n

Currently, available database systems include the following.<\/p>\r\n\r\n\r\n\r\n

MySQL<\/h3>\r\n\r\n\r\n\r\n

MySQL is the world\u2019s most popular enterprise-grade open-source relational database management system. Managed Databases utilise MySQL Community Edition<\/a>, supported by a huge and active community of open-source developers.<\/p>\r\n\r\n\r\n\r\n

Customisable database properties<\/strong><\/p>\r\n\r\n\r\n\r\n

The following MySQL database properties can be set by the user via the UpCloud API<\/a>.<\/p>\r\n\r\n\r\n\r\n

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
admin_password<\/td>\r\ninnodb_lock_wait_timeout<\/td>\r\nnet_read_timeout<\/td>\r\n<\/tr>\r\n
admin_username<\/td>\r\ninnodb_log_buffer_size<\/td>\r\nnet_write_timeout<\/td>\r\n<\/tr>\r\n
automatic_utility_network_ip_filter<\/td>\r\ninnodb_online_alter_log_max_size<\/td>\r\npublic_access<\/td>\r\n<\/tr>\r\n
backup_hour<\/td>\r\ninnodb_print_all_deadlocks<\/td>\r\nslow_query_log<\/td>\r\n<\/tr>\r\n
backup_minute<\/td>\r\ninnodb_rollback_on_timeout<\/td>\r\nsort_buffer_size<\/td>\r\n<\/tr>\r\n
binlog_retention_period<\/td>\r\ninteractive_timeout<\/td>\r\nsql_mode<\/td>\r\n<\/tr>\r\n
connect_timeout<\/td>\r\ninternal_tmp_mem_storage_engine<\/td>\r\nsql_require_primary_key<\/td>\r\n<\/tr>\r\n
default_time_zone<\/td>\r\nip_filter<\/td>\r\ntmp_table_size<\/td>\r\n<\/tr>\r\n
group_concat_max_len<\/td>\r\nlong_query_time<\/td>\r\nversion<\/td>\r\n<\/tr>\r\n
information_schema_stats_expiry<\/td>\r\nmax_allowed_packet<\/td>\r\nwait_timeout<\/td>\r\n<\/tr>\r\n
innodb_ft_min_token_size<\/td>\r\nmax_heap_table_size<\/td>\r\n\u00a0<\/td>\r\n<\/tr>\r\n
innodb_ft_server_stopword_table<\/td>\r\nmigration<\/td>\r\n\u00a0<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

PostgreSQL<\/h3>\r\n\r\n\r\n\r\n

PostgreSQL<\/a>, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.<\/p>\r\n\r\n\r\n\r\n

Customisable database properties<\/strong><\/p>\r\n\r\n\r\n\r\n

The following PostgreSQL database properties can be set by the user via the UpCloud API<\/a>.<\/p>\r\n\r\n\r\n\r\n

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
admin_password<\/td>\r\nip_filter<\/td>\r\npg_partman_bgw.role<\/td>\r\n<\/tr>\r\n
admin_username<\/td>\r\njit<\/td>\r\npg_read_replica<\/td>\r\n<\/tr>\r\n
automatic_utility_network_ip_filter<\/td>\r\nlog_autovacuum_min_duration<\/td>\r\npg_service_to_fork_from<\/td>\r\n<\/tr>\r\n
autovacuum_analyze_scale_factor<\/td>\r\nlog_error_verbosity<\/td>\r\npg_stat_statements.track<\/td>\r\n<\/tr>\r\n
autovacuum_analyze_threshold<\/td>\r\nlog_line_prefix<\/td>\r\npgbouncer<\/td>\r\n<\/tr>\r\n
autovacuum_freeze_max_age<\/td>\r\nlog_min_duration_statement<\/td>\r\npglookout<\/td>\r\n<\/tr>\r\n
autovacuum_max_workers<\/td>\r\nmax_files_per_process<\/td>\r\npublic_access<\/td>\r\n<\/tr>\r\n
autovacuum_naptime<\/td>\r\nmax_locks_per_transaction<\/td>\r\nshared_buffers_percentage<\/td>\r\n<\/tr>\r\n
autovacuum_vacuum_cost_delay<\/td>\r\nmax_logical_replication_workers<\/td>\r\nsynchronous_replication<\/td>\r\n<\/tr>\r\n
autovacuum_vacuum_cost_limit<\/td>\r\nmax_parallel_workers<\/td>\r\ntemp_file_limit<\/td>\r\n<\/tr>\r\n
autovacuum_vacuum_scale_factor<\/td>\r\nmax_parallel_workers_per_gather<\/td>\r\ntimescaledb<\/td>\r\n<\/tr>\r\n
autovacuum_vacuum_threshold<\/td>\r\nmax_pred_locks_per_transaction<\/td>\r\ntimezone<\/td>\r\n<\/tr>\r\n
backup_hour<\/td>\r\nmax_prepared_transactions<\/td>\r\ntrack_activity_query_size<\/td>\r\n<\/tr>\r\n
backup_minute<\/td>\r\nmax_replication_slots<\/td>\r\ntrack_commit_timestamp<\/td>\r\n<\/tr>\r\n
bgwriter_delay<\/td>\r\nmax_slot_wal_keep_size<\/td>\r\ntrack_functions<\/td>\r\n<\/tr>\r\n
bgwriter_flush_after<\/td>\r\nmax_stack_depth<\/td>\r\ntrack_io_timing<\/td>\r\n<\/tr>\r\n
bgwriter_lru_maxpages<\/td>\r\nmax_standby_archive_delay<\/td>\r\nvariant<\/td>\r\n<\/tr>\r\n
bgwriter_lru_multiplier<\/td>\r\nmax_standby_streaming_delay<\/td>\r\nversion<\/td>\r\n<\/tr>\r\n
deadlock_timeout<\/td>\r\nmax_wal_senders<\/td>\r\nwal_sender_timeout<\/td>\r\n<\/tr>\r\n
default_toast_compression<\/td>\r\nmax_worker_processes<\/td>\r\nwal_writer_delay<\/td>\r\n<\/tr>\r\n
enable_ipv6<\/td>\r\nmigration<\/td>\r\nwork_mem<\/td>\r\n<\/tr>\r\n
idle_in_transaction_session_timeout<\/td>\r\npg_partman_bgw.interval<\/td>\r\n\u00a0<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

Supported extensions<\/strong><\/p>\r\n\r\n\r\n\r\n

Managed Database using PostgreSQL supports the following extensions.<\/p>\r\n\r\n\r\n\r\n

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
address_standardizer<\/td>\r\nhstore<\/td>\r\npgrouting<\/td>\r\npostgres_fdw<\/td>\r\n<\/tr>\r\n
address_standardizer_data_us<\/td>\r\nintagg<\/td>\r\npgrowlocks<\/td>\r\npromscale<\/td>\r\n<\/tr>\r\n
aiven_extras<\/td>\r\nintarray<\/td>\r\npgstattuple<\/td>\r\nrum<\/td>\r\n<\/tr>\r\n
bloom<\/td>\r\nisn<\/td>\r\nplcoffee<\/td>\r\nsslinfo<\/td>\r\n<\/tr>\r\n
btree_gin<\/td>\r\nltree<\/td>\r\nplls<\/td>\r\ntablefunc<\/td>\r\n<\/tr>\r\n
btree_gist<\/td>\r\npg_buffercache<\/td>\r\nplperl<\/td>\r\ntimescale_analytics<\/td>\r\n<\/tr>\r\n
chkpass<\/td>\r\npg_cron<\/td>\r\nplpgsql<\/td>\r\ntimescaledb<\/td>\r\n<\/tr>\r\n
citext<\/td>\r\npg_partman<\/td>\r\nplv8<\/td>\r\ntsearch2<\/td>\r\n<\/tr>\r\n
cube<\/td>\r\npg_prometheus<\/td>\r\npostgis<\/td>\r\ntsm_system_rows<\/td>\r\n<\/tr>\r\n
dblink<\/td>\r\npg_repack<\/td>\r\npostgis_legacy<\/td>\r\nunaccent<\/td>\r\n<\/tr>\r\n
dict_int<\/td>\r\npg_similarity<\/td>\r\npostgis_raster<\/td>\r\nunit<\/td>\r\n<\/tr>\r\n
earthdistance<\/td>\r\npg_stat_statements<\/td>\r\npostgis_sfcgal<\/td>\r\nuuid-ossp<\/td>\r\n<\/tr>\r\n
fuzzystrmatch<\/td>\r\npg_trgm<\/td>\r\npostgis_tiger_geocoder<\/td>\r\n\u00a0<\/td>\r\n<\/tr>\r\n
hll<\/td>\r\npgcrypto<\/td>\r\npostgis_topology<\/td>\r\n\u00a0<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

Redis<\/h3>\r\n\r\n\r\n\r\n

Redis<\/a> is an open-source, in-memory data store commonly used as a database, cache, streaming engine, or message broker. It offers sub-millisecond response times, enabling millions of requests per second for real-time applications.<\/p>\r\n\r\n\r\n\r\n

OpenSearch<\/h3>\r\n\r\n\r\n\r\n

OpenSearch<\/a> is an open-source distributed search and analytics suite. Powered by the Apache Lucene search library, OpenSearch offers a vendor-agnostic toolset you can use to build secure, high-performance, cost-efficient applications, from real-time application monitoring to website search functionality.<\/p>\r\n\r\n\r\n\r\n

Database plans<\/h2>\r\n\r\n\r\n\r\n

Managed Databases are offered with 2 and 3-node clustered solutions as well as single-node unclustered options. The nodes can be configured with the required resources by selecting from the available plans. Each plan includes a set number of CPU cores, system memory, storage and backups. The Managed Database plans are priced according to the number of nodes and the resources allocated to each node.<\/p>\r\n\r\n\r\n\r\n

Database clusters are billed hourly according to the selected configuration plan until the instance is deleted, including while stopped.<\/p>\r\n\r\n\r\n\r\n

1 node – MySQL & PostgreSQL<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Memory<\/th>\r\nCPU cores<\/strong><\/th>\r\nStorage<\/strong><\/th>\r\nBackups<\/strong><\/th>\r\nPrice<\/th>\r\n\u00a0<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
2 GB<\/td>\r\n1<\/td>\r\n25 GB<\/td>\r\n24 hours<\/td>\r\n\u20ac0.0417\/h<\/td>\r\n\u20ac30\/mo<\/td>\r\n<\/tr>\r\n
4 GB<\/td>\r\n2<\/td>\r\n50 GB<\/td>\r\n24 hours<\/td>\r\n\u20ac0.0833\/h<\/td>\r\n\u20ac60\/mo<\/td>\r\n<\/tr>\r\n
4 GB<\/td>\r\n2<\/td>\r\n100 GB<\/td>\r\n24 hours<\/td>\r\n\u20ac0.1042\/h<\/td>\r\n\u20ac75\/mo<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

2 nodes<\/strong> – MySQL & PostgreSQL<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Memory<\/strong><\/th>\r\nCPU cores<\/strong><\/th>\r\nStorage<\/strong><\/th>\r\nBackups<\/strong><\/th>\r\nPrice<\/th>\r\n\u00a0<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
4 GB<\/td>\r\n2<\/td>\r\n50 GB<\/td>\r\n7 days<\/td>\r\n\u20ac0.1389\/h<\/td>\r\n\u20ac100\/mo<\/td>\r\n<\/tr>\r\n
4 GB<\/td>\r\n2<\/td>\r\n100 GB<\/td>\r\n7 days<\/td>\r\n\u20ac0.2083\/h<\/td>\r\n\u20ac150\/mo<\/td>\r\n<\/tr>\r\n
8 GB<\/td>\r\n4<\/td>\r\n50 GB<\/td>\r\n7 days<\/td>\r\n\u20ac0.2431\/h<\/td>\r\n\u20ac175\/mo<\/td>\r\n<\/tr>\r\n
8 GB<\/td>\r\n4<\/td>\r\n100 GB<\/td>\r\n7 days<\/td>\r\n\u20ac0.2778\/h<\/td>\r\n\u20ac200\/mo<\/td>\r\n<\/tr>\r\n
16 GB<\/td>\r\n6<\/td>\r\n100 GB<\/td>\r\n7 days<\/td>\r\n\u20ac0.5556\/h<\/td>\r\n\u20ac400\/mo<\/td>\r\n<\/tr>\r\n
16 GB<\/td>\r\n6<\/td>\r\n250 GB<\/td>\r\n7 days<\/td>\r\n\u20ac0.7778\/h<\/td>\r\n\u20ac560\/mo<\/td>\r\n<\/tr>\r\n
32 GB<\/td>\r\n8<\/td>\r\n100 GB<\/td>\r\n7 days<\/td>\r\n\u20ac1.0417\/h<\/td>\r\n\u20ac750\/mo<\/td>\r\n<\/tr>\r\n
32 GB<\/td>\r\n8<\/td>\r\n250 GB<\/td>\r\n7 days<\/td>\r\n\u20ac1.1111\/h<\/td>\r\n\u20ac800\/mo<\/td>\r\n<\/tr>\r\n
32 GB<\/td>\r\n8<\/td>\r\n500 GB<\/td>\r\n7 days<\/td>\r\n\u20ac1.2222\/h<\/td>\r\n\u20ac880\/mo<\/td>\r\n<\/tr>\r\n
64 GB<\/td>\r\n16<\/td>\r\n1 TB<\/td>\r\n7 days<\/td>\r\n\u20ac2.2222\/h<\/td>\r\n\u20ac1600\/mo<\/td>\r\n<\/tr>\r\n
64 GB<\/td>\r\n16<\/td>\r\n1.5 TB<\/td>\r\n7 days<\/td>\r\n\u20ac2.5000\/h<\/td>\r\n\u20ac1800\/mo<\/td>\r\n<\/tr>\r\n
128 GB<\/td>\r\n20<\/td>\r\n2 TB<\/td>\r\n7 days<\/td>\r\n\u20ac3.8889\/h<\/td>\r\n\u20ac2800\/mo<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

3 nodes<\/strong> – MySQL & PostgreSQL<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Memory<\/strong><\/th>\r\nCPU cores<\/strong><\/th>\r\nBackups<\/strong><\/th>\r\nPrice<\/th>\r\n\u00a0<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
2 GB<\/td>\r\n1<\/td>\r\n2 days<\/td>\r\n\u20ac0.069\/h<\/td>\r\n\u20ac50\/mo<\/td>\r\n<\/tr>\r\n
4 GB<\/td>\r\n2<\/td>\r\n2 days<\/td>\r\n\u20ac0.125\/h<\/td>\r\n\u20ac90\/mo<\/td>\r\n<\/tr>\r\n
8 GB<\/td>\r\n2<\/td>\r\n2 days<\/td>\r\n\u20ac0.153\/h<\/td>\r\n\u20ac110\/mo<\/td>\r\n<\/tr>\r\n
14 GB<\/td>\r\n2<\/td>\r\n2 days<\/td>\r\n\u20ac0.222\/h<\/td>\r\n\u20ac160\/mo<\/td>\r\n<\/tr>\r\n
28 GB<\/td>\r\n4<\/td>\r\n2 days<\/td>\r\n\u20ac0.417\/h<\/td>\r\n\u20ac300\/mo<\/td>\r\n<\/tr>\r\n
56 GB<\/td>\r\n8<\/td>\r\n2 days<\/td>\r\n\u20ac0.806\/h<\/td>\r\n\u20ac580\/mo<\/td>\r\n<\/tr>\r\n
112 GB<\/td>\r\n16<\/td>\r\n2 days<\/td>\r\n\u20ac1.611\/h<\/td>\r\n\u20ac1160\/mo<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

1 node – Redis<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Memory<\/strong><\/th>\r\nCPU cores<\/strong><\/th>\r\nStorage<\/strong><\/th>\r\nBackups<\/strong><\/th>\r\nPrice<\/th>\r\n\u00a0<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
4 GB<\/td>\r\n2<\/td>\r\n100 GB<\/td>\r\n14 days<\/td>\r\n\u20ac0.2431\/h<\/td>\r\n\u20ac175\/mo<\/td>\r\n<\/tr>\r\n
4 GB<\/td>\r\n2<\/td>\r\n200 GB<\/td>\r\n14 days<\/td>\r\n\u20ac0.3125\/h<\/td>\r\n\u20ac225\/mo<\/td>\r\n<\/tr>\r\n
8 GB<\/td>\r\n4<\/td>\r\n100 GB<\/td>\r\n14 days<\/td>\r\n\u20ac0.3889\/h<\/td>\r\n\u20ac280\/mo<\/td>\r\n<\/tr>\r\n
8 GB<\/td>\r\n4<\/td>\r\n200 GB<\/td>\r\n14 days<\/td>\r\n\u20ac0.4514\/h<\/td>\r\n\u20ac325\/mo<\/td>\r\n<\/tr>\r\n
16 GB<\/td>\r\n6<\/td>\r\n200 GB<\/td>\r\n14 days<\/td>\r\n\u20ac0.8333\/h<\/td>\r\n\u20ac600\/mo<\/td>\r\n<\/tr>\r\n
16 GB<\/td>\r\n6<\/td>\r\n500 GB<\/td>\r\n14 days<\/td>\r\n\u20ac0.9028\/h<\/td>\r\n\u20ac650\/mo<\/td>\r\n<\/tr>\r\n
32 GB<\/td>\r\n8<\/td>\r\n200 GB<\/td>\r\n14 days<\/td>\r\n\u20ac1.5556\/h<\/td>\r\n\u20ac1120\/mo<\/td>\r\n<\/tr>\r\n
32 GB<\/td>\r\n8<\/td>\r\n500 GB<\/td>\r\n14 days<\/td>\r\n\u20ac1.6944\/h<\/td>\r\n\u20ac1220\/mo<\/td>\r\n<\/tr>\r\n
32 GB<\/td>\r\n8<\/td>\r\n1 TB<\/td>\r\n14 days<\/td>\r\n\u20ac1.9722\/h<\/td>\r\n\u20ac1420\/mo<\/td>\r\n<\/tr>\r\n
64 GB<\/td>\r\n16<\/td>\r\n1 TB<\/td>\r\n14 days<\/td>\r\n\u20ac3.1111\/h<\/td>\r\n\u20ac2240\/mo<\/td>\r\n<\/tr>\r\n
64 GB<\/td>\r\n16<\/td>\r\n2 TB<\/td>\r\n14 days<\/td>\r\n\u20ac3.6667\/h<\/td>\r\n\u20ac2640\/mo<\/td>\r\n<\/tr>\r\n
128 GB<\/td>\r\n20<\/td>\r\n2 TB<\/td>\r\n14 days<\/td>\r\n\u20ac5.5278\/h<\/td>\r\n\u20ac3980\/mo<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

2 nodes – Redis<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Memory<\/strong><\/th>\r\nCPU cores<\/strong><\/th>\r\nBackups<\/strong><\/th>\r\nPrice<\/th>\r\n\u00a0<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
2 GB<\/td>\r\n1<\/td>\r\n3 days<\/td>\r\n\u20ac0.139\/h<\/td>\r\n\u20ac100\/mo<\/td>\r\n<\/tr>\r\n
4 GB<\/td>\r\n2<\/td>\r\n3 days<\/td>\r\n\u20ac0.236\/h<\/td>\r\n\u20ac170\/mo<\/td>\r\n<\/tr>\r\n
8 GB<\/td>\r\n2<\/td>\r\n3 days<\/td>\r\n\u20ac0.319\/h<\/td>\r\n\u20ac230\/mo<\/td>\r\n<\/tr>\r\n
14 GB<\/td>\r\n2<\/td>\r\n3 days<\/td>\r\n\u20ac0.431\/h<\/td>\r\n\u20ac310\/mo<\/td>\r\n<\/tr>\r\n
28 GB<\/td>\r\n4<\/td>\r\n3 days<\/td>\r\n\u20ac0.819\/h<\/td>\r\n\u20ac590\/mo<\/td>\r\n<\/tr>\r\n
56 GB<\/td>\r\n8<\/td>\r\n3 days<\/td>\r\n\u20ac1.611\/h<\/td>\r\n\u20ac1160\/mo<\/td>\r\n<\/tr>\r\n
112 GB<\/td>\r\n16<\/td>\r\n3 days<\/td>\r\n\u20ac3.194\/h<\/td>\r\n\u20ac2300\/mo<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

3 nodes – Redis<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Memory<\/strong><\/th>\r\nCPU cores<\/strong><\/th>\r\nBackups<\/strong><\/th>\r\nPrice<\/th>\r\n\u00a0<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
2 GB<\/td>\r\n1<\/td>\r\n7 days<\/td>\r\n\u20ac0.208\/h<\/td>\r\n\u20ac150\/mo<\/td>\r\n<\/tr>\r\n
4 GB<\/td>\r\n2<\/td>\r\n7 days<\/td>\r\n\u20ac0.361\/h<\/td>\r\n\u20ac260\/mo<\/td>\r\n<\/tr>\r\n
8 GB<\/td>\r\n2<\/td>\r\n7 days<\/td>\r\n\u20ac0.472\/h<\/td>\r\n\u20ac340\/mo<\/td>\r\n<\/tr>\r\n
14 GB<\/td>\r\n2<\/td>\r\n7 days<\/td>\r\n\u20ac0.653\/h<\/td>\r\n\u20ac470\/mo<\/td>\r\n<\/tr>\r\n
28 GB<\/td>\r\n4<\/td>\r\n7 days<\/td>\r\n\u20ac1.250\/h<\/td>\r\n\u20ac900\/mo<\/td>\r\n<\/tr>\r\n
56 GB<\/td>\r\n8<\/td>\r\n7 days<\/td>\r\n\u20ac2.444\/h<\/td>\r\n\u20ac1760\/mo<\/td>\r\n<\/tr>\r\n
112 GB<\/td>\r\n16<\/td>\r\n7 days<\/td>\r\n\u20ac4.833\/h<\/td>\r\n\u20ac3480\/mo<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

1-day backups – OpenSearch<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Nodes<\/th>\r\nMemory<\/th>\r\nCores<\/th>\r\nBackup days<\/th>\r\nStorage<\/th>\r\nPrice<\/th>\r\n\u00a0<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
1<\/td>\r\n4 GB<\/td>\r\n2<\/td>\r\n1<\/td>\r\n80<\/td>\r\n\u20ac0.1389\/h<\/td>\r\n\u20ac100\/mo<\/td>\r\n<\/tr>\r\n
1<\/td>\r\n8 GB<\/td>\r\n2<\/td>\r\n1<\/td>\r\n160<\/td>\r\n\u20ac0.2083\/h<\/td>\r\n\u20ac150\/mo<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

3-day backups – OpenSearch<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Nodes<\/th>\r\nMemory<\/th>\r\nCores<\/th>\r\nBackup days<\/th>\r\nStorage<\/th>\r\nPrice<\/th>\r\n\u00a0<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
3<\/td>\r\n4 GB<\/td>\r\n2<\/td>\r\n3<\/td>\r\n120<\/td>\r\n\u20ac0.3889\/h<\/td>\r\n\u20ac280\/mo<\/td>\r\n<\/tr>\r\n
3<\/td>\r\n8 GB<\/td>\r\n2<\/td>\r\n3<\/td>\r\n240<\/td>\r\n\u20ac0.5556\/h<\/td>\r\n\u20ac400\/mo<\/td>\r\n<\/tr>\r\n
3<\/td>\r\n14 GB<\/td>\r\n2<\/td>\r\n3<\/td>\r\n420<\/td>\r\n\u20ac0.8056\/h<\/td>\r\n\u20ac580\/mo<\/td>\r\n<\/tr>\r\n
6<\/td>\r\n14 GB<\/td>\r\n2<\/td>\r\n3<\/td>\r\n840<\/td>\r\n\u20ac1.6111\/h<\/td>\r\n\u20ac1160\/mo<\/td>\r\n<\/tr>\r\n
9<\/td>\r\n14 GB<\/td>\r\n2<\/td>\r\n3<\/td>\r\n1260<\/td>\r\n\u20ac2.4028\/h<\/td>\r\n\u20ac1730\/mo<\/td>\r\n<\/tr>\r\n
12<\/td>\r\n14 GB<\/td>\r\n2<\/td>\r\n3<\/td>\r\n1680<\/td>\r\n\u20ac3.2083\/h<\/td>\r\n\u20ac2310\/mo<\/td>\r\n<\/tr>\r\n
15<\/td>\r\n14 GB<\/td>\r\n2<\/td>\r\n3<\/td>\r\n2100<\/td>\r\n\u20ac4.0139\/h<\/td>\r\n\u20ac2890\/mo<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

7-day backups – OpenSearch<\/h3>\r\n\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Nodes<\/th>\r\nMemory<\/th>\r\nCores<\/th>\r\nBackup days<\/th>\r\nStorage<\/th>\r\nPrice<\/th>\r\n\u00a0<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
3<\/td>\r\n4 GB<\/td>\r\n2<\/td>\r\n7<\/td>\r\n600<\/td>\r\n\u20ac0.8056\/h<\/td>\r\n\u20ac580\/mo<\/td>\r\n<\/tr>\r\n
3<\/td>\r\n8 GB<\/td>\r\n2<\/td>\r\n7<\/td>\r\n1200<\/td>\r\n\u20ac1.3889\/h<\/td>\r\n\u20ac1000\/mo<\/td>\r\n<\/tr>\r\n
3<\/td>\r\n14 GB<\/td>\r\n2<\/td>\r\n7<\/td>\r\n2100<\/td>\r\n\u20ac2.2500\/h<\/td>\r\n\u20ac1620\/mo<\/td>\r\n<\/tr>\r\n
6<\/td>\r\n14 GB<\/td>\r\n2<\/td>\r\n7<\/td>\r\n4200<\/td>\r\n\u20ac4.5000\/h<\/td>\r\n\u20ac3240\/mo<\/td>\r\n<\/tr>\r\n
9<\/td>\r\n14 GB<\/td>\r\n2<\/td>\r\n7<\/td>\r\n6300<\/td>\r\n\u20ac6.7500\/h<\/td>\r\n\u20ac4860\/mo<\/td>\r\n<\/tr>\r\n
12<\/td>\r\n14 GB<\/td>\r\n2<\/td>\r\n7<\/td>\r\n8400<\/td>\r\n\u20ac9.0000\/h<\/td>\r\n\u20ac6480\/mo<\/td>\r\n<\/tr>\r\n
15<\/td>\r\n14 GB<\/td>\r\n2<\/td>\r\n7<\/td>\r\n10500<\/td>\r\n\u20ac11.2500\/h<\/td>\r\n\u20ac8100\/mo<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

Note that the database management system and host operating system use a small portion of the allocated storage capacity, typically 1 – 2 GB.<\/p>\r\n\r\n\r\n\r\n

Database features<\/h2>\r\n\r\n\r\n\r\n

High availability<\/h3>\r\n\r\n\r\n\r\n

In clustered database deployments, nodes are created on physically separated backend hosts to ensure redundancy in case of hardware failure.<\/p>\r\n\r\n\r\n\r\n

In normal operation, the DNS entry of the database points to a primary node. One of the replicas will be promoted automatically in case of a primary failure.<\/p>\r\n\r\n\r\n\r\n

Scalability<\/h3>\r\n\r\n\r\n\r\n

Users are able to scale their Managed Database services both vertically and horizontally by increasing or decreasing the number of nodes in the cluster or the resources allocated to each node.<\/p>\r\n\r\n\r\n\r\n

Changes to the Managed Database configuration are handled seamlessly in the background with minimal interruption to the services.<\/p>\r\n\r\n\r\n\r\n

Connectivity<\/h3>\r\n\r\n\r\n\r\n

Managed Databases can be reached via the user\u2019s private UpCloud Utility network or optionally through the public network connection. A private connection is enabled by default. This makes the database accessible for all the user\u2019s Cloud Servers within the same data centre as the Managed Database.<\/p>\r\n\r\n\r\n\r\n

At the configuration settings, users can set a preferred hostname. The hostname is used to automatically create DNS entries using a unique subdomain name. Each Managed Database can have up to four DNS entries, one for private and another for public access, as well as read-only access for each.<\/p>\r\n\r\n\r\n\r\n

Private:<\/strong> example-mctapmghasah.db.upclouddatabases.com <\/em>Private read-only:<\/strong> replica-example-mctapmghasah.db.upclouddatabases.com<\/em>
Public:<\/strong> public.example-mctapmghasah.db.upclouddatabases.com <\/em>Public read-only:<\/strong> public-replica-example-mctapmghasah.db.upclouddatabases.com<\/em><\/p>\r\n\r\n\r\n\r\n

Maximum connections<\/h3>\r\n\r\n\r\n\r\n

To ensure a consistent experience, concurrent database connections are limited based on the node resources.<\/p>\r\n\r\n\r\n\r\n

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Memory<\/strong><\/th>\r\nMySQL<\/strong><\/th>\r\nPostgreSQL<\/strong><\/th>\r\nRedis<\/th>\r\n<\/tr>\r\n<\/thead>\r\n
2 GB<\/td>\r\n150<\/td>\r\n25<\/td>\r\n8192<\/td>\r\n<\/tr>\r\n
4 GB<\/td>\r\n400<\/td>\r\n100<\/td>\r\n16384<\/td>\r\n<\/tr>\r\n
8 GB<\/td>\r\n800<\/td>\r\n200<\/td>\r\n32768<\/td>\r\n<\/tr>\r\n
14 GB<\/td>\r\n\u00a0<\/td>\r\n\u00a0<\/td>\r\n57344<\/td>\r\n<\/tr>\r\n
16 GB<\/td>\r\n1600<\/td>\r\n400<\/td>\r\n\u00a0<\/td>\r\n<\/tr>\r\n
28 GB<\/td>\r\n\u00a0<\/td>\r\n\u00a0<\/td>\r\n114688<\/td>\r\n<\/tr>\r\n
32 GB<\/td>\r\n3200<\/td>\r\n800<\/td>\r\n\u00a0<\/td>\r\n<\/tr>\r\n
56 GB<\/td>\r\n\u00a0<\/td>\r\n\u00a0<\/td>\r\n229376<\/td>\r\n<\/tr>\r\n
64 GB<\/td>\r\n6400<\/td>\r\n1000<\/td>\r\n\u00a0<\/td>\r\n<\/tr>\r\n
112 GB<\/td>\r\n\u00a0<\/td>\r\n\u00a0<\/td>\r\n458752<\/td>\r\n<\/tr>\r\n
128 GB<\/td>\r\n12800<\/td>\r\n1000<\/td>\r\n\u00a0<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/figure>\r\n\r\n\r\n\r\n

Data metering<\/h3>\r\n\r\n\r\n\r\n

Both inbound and outbound network transfer is unmetered by the Managed Database. The database plans do not include a transfer quota nor will the Managed Databases benefit from the user\u2019s Network Transfer Pool. However, any network transfer via the public network is metered normally user’s Cloud Servers utilising the Network Transfer Pool.<\/p>\r\n\r\n\r\n\r\n

Data transfer via the Utility network is always free of charge.<\/p>\r\n\r\n\r\n\r\n

IP access control<\/h3>\r\n\r\n\r\n\r\n

Users can set connection permissions to specific IP addresses by selecting from the list of Cloud Servers on the user\u2019s account or manually entering IP addresses.<\/p>\r\n\r\n\r\n\r\n

By default, all Utility network IP addresses are allowed. Setting a permitted IP address will exclude connection from all other addresses unless \u201callow all\u201d is enabled for either public or Utility networks.<\/p>\r\n\r\n\r\n\r\n

Maintenance<\/h3>\r\n\r\n\r\n\r\n

Users can set their preferred maintenance windows at their UpCloud Control Panel.<\/p>\r\n\r\n\r\n\r\n

Normal version upgrades are performed in place. Users will be provided with the ability to opt in for any major upgrades.<\/p>\r\n\r\n\r\n\r\n

Backups<\/h3>\r\n\r\n\r\n\r\n

Each Managed Database plan includes automated backups. Backup retention is set to either 1, 7 or 14 days for 1, 2, and 3 node clusters respectively.<\/p>\r\n\r\n\r\n\r\n

The databases are backed up automatically with full backups daily and the write-ahead log (WAL) is recorded continuously. Full backups are version-specific binary backups, which when combined with WAL allow consistent recovery to a point in time (PITR).<\/p>\r\n\r\n\r\n\r\n

All backups are encrypted and stored off-site independently from the user\u2019s Managed Database without using the cluster\u2019s storage capacity.<\/p>\r\n\r\n\r\n\r\n

The 1-day backups allow the user to go back to any given minute within the last 24 hours. 2-node plans offer 7 days of backups and 3-node plans include 14 days.<\/p>\r\n","protected":false},"featured_media":1173,"template":"","documentation_category":[],"class_list":["post-2272","documentation","type-documentation","status-publish","has-post-thumbnail","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/studiogo.tech\/upcloudold\/wp-json\/wp\/v2\/documentation\/2272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studiogo.tech\/upcloudold\/wp-json\/wp\/v2\/documentation"}],"about":[{"href":"https:\/\/studiogo.tech\/upcloudold\/wp-json\/wp\/v2\/types\/documentation"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studiogo.tech\/upcloudold\/wp-json\/wp\/v2\/media\/1173"}],"wp:attachment":[{"href":"https:\/\/studiogo.tech\/upcloudold\/wp-json\/wp\/v2\/media?parent=2272"}],"wp:term":[{"taxonomy":"documentation_category","embeddable":true,"href":"https:\/\/studiogo.tech\/upcloudold\/wp-json\/wp\/v2\/documentation_category?post=2272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}