RDS-like service for PostgreSQL
Hi habrovchane! 
I talked a lot with developers about Amazon Web Services and many complained that RDS does not provide PostgreSQL. Yes, this is a blunder from the AWS side, because many people use this RDMS. But this is no reason not to use AWS.
In September, I was in Chicago at Cloud Connect and there I came across an exhibition stand at EnterpriseDB , where they promoted themselves as a provider of the PosgreSQL cloud option. And today, finally, it turned out to test them! And you know, we will use them!
This is the EnterpriseDB booth I was talking about. Yes, the dude is not sales at all ... was absorbed in the phone.
')
So, what do EnterpriseDB offer under the Cloud Database brand:
Pretty attractive, isn't it? Here is their official video promo:
Those. The price of the software is added to the regular price of the instance and you pay for it as usual in AWS.
First you need to create a subscription in the AWS Marketplace . After you have activated your subscription, you can use the Cloud Database.
In order to enable the Cloud Database console to manage the resources of your account.
I gave the IAM user EC2 Full Access in order to have the rights to work with EC2. When creating a user, save his credits (2 keys) - they will be needed for registration.
Directly as shown in the video above, go to the link aws-us-east-1a.theclouddatabase.com and register. In the same place, in step 2, we introduce the IAM user credential, which has rights to EC2.
After registration, we also create a cluster using the video instructions. Nothing complicated, is it?
Now in our EC2 console we have instances to which we can connect and work. If instances are more than 2x, then note that they are in different zones.
I haven't done any serious tests yet, but the main requirements for the functionality of the Cloud Database are:
Have a great day everyone!
I talked a lot with developers about Amazon Web Services and many complained that RDS does not provide PostgreSQL. Yes, this is a blunder from the AWS side, because many people use this RDMS. But this is no reason not to use AWS.
In September, I was in Chicago at Cloud Connect and there I came across an exhibition stand at EnterpriseDB , where they promoted themselves as a provider of the PosgreSQL cloud option. And today, finally, it turned out to test them! And you know, we will use them!
This is the EnterpriseDB booth I was talking about. Yes, the dude is not sales at all ... was absorbed in the phone.
')
What is it?
So, what do EnterpriseDB offer under the Cloud Database brand:
- automatic configuration vyskonedelnosti (High Availability)
- self-healing
- autoscaling
- load balancing
- automatic backups
- easy cloning
- gui
- pay for what you use: pay as you go
Pretty attractive, isn't it? Here is their official video promo:
How much is?
| DB Instance Class | Introductory Price per Hour |
| Small db instance | $ 0.11 |
| Large DB Instance | $ 0.44 |
| Extra Large DB Instance | $ 0.88 |
| High Memory DB Instance Class | Introductory Price per Hour |
| Extra Large DB Instance | $ 0.65 |
| Double Extra Large DB Instance | $ 1.30 |
| Quadruple Extra Large DB Instance | $ 2.60 |
| High CPU DB Instance Class | Introductory Price per Hour |
| High CPU Medium DB Instance | $ 0.22 |
| High CPU Extra Large DB Instance | $ 0.88 |
| Data Transfer | Introductory Price |
| GB of data transfer out | You pay amazon fees only without added markup |
| GB of regional data transfer in / out | You pay amazon fees only without added markup |
Those. The price of the software is added to the regular price of the instance and you pay for it as usual in AWS.
How to start working?
Step 1. Activate the subscription.
First you need to create a subscription in the AWS Marketplace . After you have activated your subscription, you can use the Cloud Database.
Step 2. Create an IAM user.
In order to enable the Cloud Database console to manage the resources of your account.
I gave the IAM user EC2 Full Access in order to have the rights to work with EC2. When creating a user, save his credits (2 keys) - they will be needed for registration.
Step 3. Register and work with Cloud Database
Directly as shown in the video above, go to the link aws-us-east-1a.theclouddatabase.com and register. In the same place, in step 2, we introduce the IAM user credential, which has rights to EC2.
After registration, we also create a cluster using the video instructions. Nothing complicated, is it?
Now in our EC2 console we have instances to which we can connect and work. If instances are more than 2x, then note that they are in different zones.
I haven't done any serious tests yet, but the main requirements for the functionality of the Cloud Database are:
- servers under our control
- zone replication - High Availability
- the ability to transfer data to another region - Disaster Recovery
Have a great day everyone!
Source: https://habr.com/ru/post/159349/
All Articles