Relational Database Service (RDB)

The Relational Database (RDB) service automatically creates a database entity for your project. It is possible to create several entities within one project/region.

Have a Question?

The current page gives the general information on the service and the main workflows. However, while working with the services, our users encounter new questions they need assistance with. The most frequently asked questions on EPAM Cloud Services are gathered on the Cloud Services FAQ page.
Visit the page to check whether we have a ready answer for your question.

Related CLI Commands

The table below provides the list of service-related commands and their descriptions:

Command Short Command Description
or2-manage-rdb --action [describe, install, remove] or2rdb Starts the service in the specified project and region

Further on this page, you can find more details on the RDB service manipulation.

Supported Databases

The service is available only in EPAM regions. Still, it is similar to AWS RDS service, and the set of the databases provided by the two platforms is the same. The table below contains the list of databases supported by EPAM Orchestrator, and their versions, as well as the host VM configurations:

Database PostgreSQL MySQL MariaDB Oracle MS SQL Server
Version 12 5.7 10.3 19c 2017 Express Edition
Host VM Shape Medium Medium Medium Medium Medium
Host VM Image Ubuntu18.04 64-bit Ubuntu18.04 64-bit Ubuntu18.04 64-bit OracleLinux7 64-bit W2019Std

Service Activation and Manipulation

The service is manipulated with the or2-manage-rdb (or2rdb) command with different --action/-a parameter values (describe, install, remove).

All you have to do to start the service is run the command with the following parameters:

or2rdb -p project -r region -a install -t type [-n db_name] -u db_username [-pwd db_password] [-d description] [-f file_path]

Where:

Parameter Description
-a install Obligatory parameter; the action parameter specifying that a new database instance should be created.
-t type Obligatory parameter; the type of the database to be installed (mysql, mssql, postgresql, oracle, mariadb).
-u db_username Obligatory parameter; the username that will be used to login to the created database.
-n db_name Optional parameter; the name of the database to be created; if not specified, will be generated automatically.
-pwd db_password Optional parameter; the password to be used to login to the created database. If not specified, a random password will be generated.
-d description Optional parameter; the description of the new database.
-f file_path The parameter specifying the path to the initialization script used for database configuration.

When the command is launched, Orchestrator runs a respective VM with 40GB system volume, installs the necessary database and applies all the settings.

To deactivate the RDB service, run the same or2rdb command with the -a remove option. This command deactivates the service and terminates the virtual machine created for it:

or2rdb -p project -r region -a remove -S service_id

Login to the DB

When the configuration is complete, you can login to your instance and start using the database with the credentials specified/generated during the service start.

Please note, that if you run the service with MSSQL, you have admin access to the whole MSSQL instance and can login to it using your domain credentials.

Pricing

The service usage price is defined by the price of the VM on which the DB is hosted and all the attached storages.

For example, the parameters of a VM hosting a My SQL database are as follows:

  • Shape: MEDIUM
  • Image: Ubuntu18.04_64-bit (for PostgreSQL, MySQL, MariaDB), OracleLinux7 64-bit (for Oracle), W2019Std (for MS SQL Server)

Therefore, the approximate monthly cost of one RDB instance in case of 100% and 24/7 load is about $30.64 in EPAM-BY2 region (as to July 2020). The price may vary depending on the region and the selected database.
To get more detailed estimations, please use our Cost Estimator tool.

To estimate the price of the AWS-based infrastructure you plan to create, you can use the AWS Simple Monthly Calculator.

References

More information on the RDB Service can be found in the EPAM Cloud Services Guide. For detailed description of the Maestro CLI commands used to manage the RDB Service, refer to the Maestro CLI User Guide.