Lonnie
CEO - Co-founder US, Mexico Binational Tech Start-up Accelerator, Incubator at Framework Science
May 9, 2019
9.18k views9.18k
CommentsAmazon ElastiCache vs Amazon RDS for PostgreSQL
Overview
Share your Stack
Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.
CLI (Node.js)
Manual
Advice on Amazon ElastiCache, Amazon RDS for PostgreSQL
Detailed Comparison
ElastiCache improves the performance of web applications by allowing you to retrieve information from fast, managed, in-memory caches, instead of relying entirely on slower disk-based databases. ElastiCache supports Memcached and Redis. | Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and back-ups for disaster recovery. With just a few clicks in the AWS Management Console, you can deploy a PostgreSQL database with automatically configured database parameters for optimal performance. Amazon RDS for PostgreSQL database instances can be provisioned with either standard storage or Provisioned IOPS storage. Once provisioned, you can scale from 10GB to 3TB of storage and from 1,000 IOPS to 30,000 IOPS. |
Support for two engines: Memcached and Redis;Ease of management via the AWS Management Console. With a few clicks you can configure and launch instances for the engine you wish to use.;Compatibility with the specific engine protocol. This means most of the client libraries will work with the respective engines they were built for - no additional changes or tweaking required.;Detailed monitoring statistics for the engine nodes at no extra cost via Amazon CloudWatch;Pay only for the resources you consume based on node hours used | Monitoring and Metrics –Amazon RDS provides Amazon CloudWatch metrics for you DB Instance deployments at no additional charge.;DB Event Notifications –Amazon RDS provides Amazon SNS notifications via email or SMS for your DB Instance deployments.;Automatic Software Patching – Amazon RDS will make sure that the PostgreSQL software powering your deployment stays up-to-date with the latest patches.;Automated Backups – Turned on by default, the automated backup feature of Amazon RDS enables point-in-time recovery for your DB Instance.;DB Snapshots – DB Snapshots are user-initiated backups of your DB Instance.;Pre-configured Parameters – Amazon RDS for PostgreSQL deployments are pre-configured with a sensible set of parameters and settings appropriate for the DB Instance class you have selected.;PostGIS;Language Extensions :PL/Perl, PL/pgSQL, PL/Tcl;Full Text Search Dictionaries;Advanced Data Types : HStore, JSON;Core PostgreSQL engine features |
Statistics | |
Stacks 1.3K | Stacks 814 |
Followers 1.0K | Followers 607 |
Votes 151 | Votes 40 |
Pros & Cons | |
Pros
| Pros
|
What are some alternatives to Amazon ElastiCache, Amazon RDS for PostgreSQL?
MemCachier
MemCachier provides an easy and powerful managed caching solution for all your performance and scalability needs. It works with the ubiquitous memcache protocol so your favourite language and framework already supports it.
Heroku Postgres
Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.
Memcached Cloud
Memcached Cloud is a fully-managed service for running your Memcached in a reliable and fail-safe manner. Your dataset is constantly replicated, so if a node fails, an auto-switchover mechanism guarantees data is served without interruption. Memcached Cloud provides various data persistence options as well as remote backups for disaster recovery purposes.
ElephantSQL
ElephantSQL hosts PostgreSQL on Amazon EC2 in multiple regions and availability zones. The servers are continuously transferring the Write-Ahead-Log (the transaction log) to S3 for maximum reliability.
Database Labs
We manage an optimized Postgres image. You focus on your core app, not on becoming a database administrator.
Google Cloud SQL for PostgreSQL
With Cloud SQL for PostgreSQL, you can spend less time on your database operations and more time on your applications.
Azure Database for PostgreSQL
Azure Database for PostgreSQL provides a managed database service for app development and deployment that allows you to stand up a PostgreSQL database in minutes and scale on the fly – on the cloud you trust most.
Neon Database
It is a fully managed serverless PostgreSQL. Neon separates storage and compute to offer modern developer features such as serverless, branching, bottomless storage, and more.
Amazon Aurora PostgreSQL
It is a fully managed, PostgreSQL–compatible, and ACID–compliant relational database engine that combines the speed, reliability, and manageability of Amazon Aurora with the simplicity and cost-effectiveness of open-source databases.
Crunchy Bridge
It is a fully-managed database as a service. It takes care of backups, high availability, monitoring. Additionally, it is multi-cloud supporting AWS and Azure and comes with PL/Python3u and PL/R for more powerful work.
