Start a new topic
Answered

Amazon Aurora support

Does Semarchy Support Amazon Aurora?


Best Answer


Semarchy xDM supports Amazon Aurora PostgreSQL-Compatible Edition but not the equivalent SQL Server edition. Note that Amazon considers Aurora to be part of RDS, sort of. For example, in the URL above you see that Aurora is part of the RDS umbrella. But Aurora PostgreSQL version is different from "Amazon RDS for PostgreSQL". 

Finally, here are some practical notes from the field about xDM on Aurora.

We have seen that Aurora gives excellent I/O performance and low latency due to disk redundancy (some kind of RAID with 4 copies of the data on SSD). It also offers better monitoring tools than the regular RDS PostgreSQL (plan management, performance insight, ...).

The main drivers to stay away from Aurora Postgres would be the cost and pricing model. (We've seen that the instance class is kind of determined by how much local storage you need, and this local storage is heavily used by sort and aggregation operations).

Customers that consider using Aurora PostgreSQL should also be tempted to choose the serverless version, "Amazon Aurora Serverless". In that case no direct connection is possible from outside the VPC, which would make it pretty hard to use as a source any database or file source that is not hosted on AWS. This version should be considered only by customers that go all-in on AWS.


1 Comment

Answer


Semarchy xDM supports Amazon Aurora PostgreSQL-Compatible Edition but not the equivalent SQL Server edition. Note that Amazon considers Aurora to be part of RDS, sort of. For example, in the URL above you see that Aurora is part of the RDS umbrella. But Aurora PostgreSQL version is different from "Amazon RDS for PostgreSQL". 

Finally, here are some practical notes from the field about xDM on Aurora.

We have seen that Aurora gives excellent I/O performance and low latency due to disk redundancy (some kind of RAID with 4 copies of the data on SSD). It also offers better monitoring tools than the regular RDS PostgreSQL (plan management, performance insight, ...).

The main drivers to stay away from Aurora Postgres would be the cost and pricing model. (We've seen that the instance class is kind of determined by how much local storage you need, and this local storage is heavily used by sort and aggregation operations).

Customers that consider using Aurora PostgreSQL should also be tempted to choose the serverless version, "Amazon Aurora Serverless". In that case no direct connection is possible from outside the VPC, which would make it pretty hard to use as a source any database or file source that is not hosted on AWS. This version should be considered only by customers that go all-in on AWS.


Login to post a comment