Amazon Aurora
- Amazon Aurora Promises 5x throughput of Standard MySQL and 3x the throughput of Standard PostgreSQL.
- The performance will be on par with commercial databases, at 1/10 of the cost
- Aurora is cloud-optimized MySQL and PostgreSQL compatible relational database.
- Aurora provides the performance and durability by implementing a fully distributed and self-healing storage system & it provides availability by using elasticity and management capabilities of AWS Cloud.
- With Aurora the storage is bit different compared to regular RDS. There is a seperate storage layer that is automatically replicated across six different storage nodes in three availability zones.
- This is an important factor since data is mirrored at six different places at no additional cost.
- Amazon aurora uses quorum system for reads and writes to ensure your data is available in multiple storage nodes. At the same time the data is continously backed up to s3 to ensure that you have durable & available data.
- With Aurora the storage volume automatically grows upt 128 TB
- Aurora supports up to 15 copies of read replicas.
- In the case of Aurora, the data replication happens at the storage level in a synchronous manner. Therefore the primary database node is reffered as master and the read replica, the data replication happens in synchronous fashion.
Amazon Dynamo Db
- This is fully managed NoSQL database service that provides fast and predicatble performance with seamless capability
- NoSQL is a term used to describe high-performance, non relational databases.
- NoSQL databases use a variety of data models like
- graphs
- key-value pairs
- JSON documents
- DynamoDB supports both document & key value data structures
- A key-value store provides support for storing, querying and updating collections of objects that are identified using a key and values that contain the actual data
- A document store provides support for storing, querying and updating items in a document format such as JSON, XML and HTML.
- AWS Provides SDKs in various programming languages to interact with DynamoDB
- Python Refer Here
- Java Refer Here
- JavaScript Refer Here
- Node Js Refer Here
- .net Refer Here
- Create a Dynamo DB table
