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
Cédric BLANC
said
over 2 years ago
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.
Cédric BLANC
Does Semarchy Support Amazon Aurora?
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.
Cédric BLANC
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.
-
xDM Compatibility with Java 17?
-
xDM on Docker
-
How to Upgrade Apache Tomcat?
-
Application Server Gives 404 Error
-
Change Prod Repository Type Without Reinstallation
-
Is It Possible to Import a V5.1.1 Data Model to V5.2.8?
-
"500 Internal Server Error" While Opening with Localhost
-
Enable Access to Azure File Storage?
-
Why am I getting Status 404 -- Not Found Error on Azure?
See all 29 topics