RDS-like service for PostgreSQL

Hi Khabrovites!

I talked a lot with developers about Amazon Web Services, and many complained that RDS did not provide PostgreSQL. Yes, this is a miss from AWS, as many people use this RDMS. But this is no reason not to use AWS.

In September, I was in Chicago on Cloud Connect and there at the exhibition I came across the EnterpriseDB booth , where they advertised themselves as the provider of the cloud version of PosgreSQL. And today, finally, it turned out to test them! And you know, we will use them!

Here is the EnterpriseDB booth I spoke of. Yes, dude not sales at all ... was consumed by the phone.

What is it?

So, what does EnterpriseDB offer under the Cloud Database brand:

• automatic high availability configuration
• self-healing
• autoscaling
• load balancing
• automatic backups
• easy cloning
• gooey
• pay for what you use: pay as you go

Pretty attractive, isn't it? Here is their official video promotion:

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. software price is added to the regular instance price and you pay for it as usual in AWS.

How to get started?

Step 1. Activate the subscription.

First you need to create a subscription in the AWS Marketplace . Once 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 to the EC2 Full Access user so that he had the right to work with EC2. When creating a user, save his credentials (2 keys) - they will be needed for registration.

Step 3. Registration and work with Cloud Database

Just as shown in the video above, go to the link aws-us-east-1a.theclouddatabase.com and register. There, in step 2, we introduce the IAM credentials of the user who has rights to EC2.

After registration, we also create a cluster using the video instructions. Nothing complicated, right?

Now we have in the EC2 console instances to which we can connect and work. If there are more than 2 instances, then, mind you, they are in different zones.

I have not done any serious tests yet, but the main requisitions on the Cloud Database functionality have passed:

• servers under our control
• Cross-Zone Replication - High Availability
• the ability to transfer data to another region - Disaster Recovery

Have a nice day everyone!