Creating a service instance
-
Go to the VK Cloud management console.
-
Select the project where you need to create a service instance.
-
Go to the Data Platform → Service Instances section.
-
Click Create Instance.
-
At the Configuration step:
-
Select the
Cloud Iceberg Metastoreservice type. -
Select the service version.
-
Select the service instance configuration:
-
Single: in this configuration, the service instance will be located on a single server.This solution is suitable for development and testing, reducing the cost of deploying test infrastructure. It does not provide fault tolerance: a node failure causes all operations to stop.
-
Cluster: in this configuration, a fault-tolerant cluster will be created with maximum availability, automatic recovery, and failover after failures.This solution is suitable for storing databases of most projects, including high-load ones with high requirements for data integrity.
-
-
Click Next Step.
-
-
At the Parameters step:
-
Set the instance parameters:
-
Name: set a name for the service instance.
-
(Optional) Description: add a description.
-
Assign external IP: enable the option to make the Cloud Iceberg Metastore instance accessible via the Internet.
-
Kubernetes cluster: select the desired cluster from the drop-down list or create a new one by selecting
Create a new clusterfrom the list. When creating a new cluster, set the parameters: -
Network: select the subnet where the cluster will be available from the list, or create a new one by selecting
Create a new networkfrom the list. When creating a new subnet, specify the SDN and the subnet address. -
Availability zone: select the cluster availability zone from the list.
-
-
Select the cluster configuration:
BasicorAdvanced.BasicAdvancedSelect one of the ready-made cluster templates. The templates differ in the amount of CPU and RAM on the Postgres nodes.
-
Click Next Step.
-
-
At the Maintenance step:
-
Select the days of the week and the start time of maintenance, considering the time zone specified in the block.
The duration of maintenance, including backup, is 4 hours. During this time, the service may be unavailable.
-
Set the maximum number of full backups. This number depends on the data archival retention requirements or may be dictated by regulatory requirements. When the maximum number is exceeded, older backups will be overwritten.
A full backup includes files, databases, settings, and configurations necessary to restore the system in case of failure, data loss, or other issues.
-
Click Next Step.
-
-
At the Credentials step, set the parameters for the database owner:
-
Login for accessing Cloud Iceberg Metastore.
Login requirements:
- Only digits, Latin letters, and the
_character are allowed. - The first character must be a Latin letter of any case or
_. - Disallowed names:
os_admin,root,dataplatform_moth.
- Only digits, Latin letters, and the
-
Role: leave the value
Database Owner.A user with this role has maximum privileges on the created database. This user cannot be deleted. There can be only one user with owner privileges in the database.
-
Password for accessing Cloud Iceberg Metastore. To set a password, click the Generate button or set your own.
Password requirements:
- at least 16 characters;
- at least one uppercase and one lowercase letter of the Latin alphabet;
- at least one digit;
- at least one of the characters:
!,?,%,#,/,(,),-,+,*.
-
(Optional) To add another account, click the Add Account button.
All subsequent accounts are created with the
Standard Userrole.A user with this role has privileges to create new objects (tables, schemas, functions, etc.), edit and view them. Newly created objects will be owned by this user.
If a user with the standard role is deleted, all objects they owned are transferred to the user with the
Database Ownerrole.The number of users with this role is unlimited.
-
Click Next Step.
-
-
At the Network Accesses step:
-
Specify the database name. Name requirements:
- Latin letters, digits, and the
_character are allowed. - The first character must be a Latin letter of any case.
- No more than 63 characters.
- Latin letters, digits, and the
-
(Optional) Set network accesses for the accounts created at the previous step. To do this, click the Add Access button:
-
In the User block, select the user account.
-
In the Allow Connection block, select the connection privileges for the user:
- All databases — privileges to access all databases of the instance.
- Physical replication — privileges for replication, reading the WAL (transaction log), and making changes to replica data.
- <DB_NAME> — privileges to access a specific database.
-
Select the connection method:
- TLS encryption only — connection with TLS encryption.
- Encryption not required (TLS option) — connection without TLS encryption.
-
-
Click Create.
-