Relational Database Service

1. About

  • Use this component to deploy the Relational Database Service (RDS) on Open Telekom Cloud. With RDS, you can deploy a MySQL, PostgreSQL, or Microsoft SQL Server.

  • RDS is a cloud service with auto-backup, auto-upgrade and high availability features, which are fully managed via Open Telekom Cloud console.

  • Because the cloud service is fully managed by Open Telekom Cloud, users cannot SSH to the RDS Virtual Machine. If you wish to have a full control of the VM, use the MySQL server instead.

2. How to use

2.1. How to deploy a MySQL server

  1. Drop the RDSMySQL component.

  2. Connect RDSMySQL to a Private network. (Optional) connect it to a Public network if you wish to assign a floating IP to the RDS.

  3. Specify the component_version (e.g., 8.0). For all supported versions, see Help Documentation.

  4. Specify the root_password (e.g., Test1234). If you do not want to expose the password as plaintext, set it as a secret (Step 4b). See How to define secrets for your application.

../_images/rds1.png

Figure 1. RDSMySQL

  1. Specify the instance_size (e.g., 1vCPU|2GB for 1 vCPU and 2GB RAM).

  2. Specify the volume_type for the Block Storage (e.g., SATA or SSD).

  3. Specify the volume_size for the Block Storage (e.g., 40 GB).

  4. Specify the backup_keep_days for the backup retention time (e.g., 7). If set to 0, auto-backup feature is disabled.

  5. Specify the ha_mode (e.g., single for one instance).

  6. Specify the availability_zone (e.g., eu-de-03).

2.2. How to deploy the MySQL server in high availability mode

  1. Specify the ha_mode as ha.

  2. Specify two availability_zone (e.g., eu-de-01 and eu-de-03).

  3. Specify ha_replication_mode (async or semisync).

2.3. How to get the IP address of RDS

  1. Select RDSMySQL component.

  2. Set the attribute private_address as output properties.

../_images/rds3.png

Figure 2. Set output for RDS

The deployment will output the private IP of RDS. Alternatively, you can get the IP via the Open Telekom Cloud console.

2.4. How to create MySQL database and user

  1. Drop more than one MySQLDatabaseConnector components on a Compute.

  2. Connect MySQLDatabaseConnector to RDSMySQL via connect_to_mysql_server.

  3. Specify the database name, encoding, user and password accordingly.

../_images/rds2.png

Figure 3. Using MySQLDatabaseConnector

3. Expect result

  • A MySQL Client (i.e., the PyMySQL package) is deployed on the Compute VM.

  • The orchestration engine uses the Compute VM to access the remote RDS on port 3306 and create the given database and user on the remote RDS.

Tip

If you do not wish to use the connector component, you can create the database and user manually using any MySQL client e.g., mysql -h <RDS_IP_ADDRESS> -P 3306 -u root -p

last updated: 2024-11-13 13:47 UTC - commit: 5b758d5c766d54d4e5841d3c65e5b420d565a5e3