The Relational Database (RDB) service automatically creates a database entity for your project. It is possible to create several entities within one project/region.
EPC Services
- Cloud Computing Service (C2S)
- Cloud Networking Service (CNS)
- Cloud Block Storage Service (CBS)
- Infrastructure Scheduling Service (CRON)
- Cloud Security Service(CS2)
- Cloud Identity Service (SSH)
- Auto Configuration Service (ACS)
- Terraform As A Service(TAS)
- Telemetry As A Service (TMS)
- Cloud Monitoring Service (CMS)
- Desktop As A Service
- CloudWach & SSM (SSM)
- Cloud Formation Service (CFS)
- Log Aggregation Service (LAS)
- Load Balancer Service (LBS)
- Relational Database Service (RDB)
- Docker Service (DOS)
- OpenShift as a Sevice (OSS)
- Kubernetes as a Service (KUB)
- Jenkins as a Service (JaS)
- Gerrit as a Service (GAS)
- Sonar as a Service (SQS)
- Artifactory as a Service (AFS)
- Messaging Service (MES)
- Cloud Support Service (CSS)
Relational Database Service (RDB)
This topic contains the following sections:
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.