A naukri.com initiative
AWS Blogs
2w
189
Image Credit: AWS Blogs
Amazon Aurora PostgreSQL Limitless Database is now generally available
- Amazon Aurora PostgreSQL Limitless Database is now generally available, which allows the distribution of a database workload over multiple Aurora writer instances while maintaining the ability to use it as a single database.
- Aurora PostgreSQL Limitless Database uses a two-layer architecture consisting of multiple database nodes in a DB shard group – either routers or shards to scale based on the workload.
- Routers are nodes that accept SQL connections from clients, send SQL commands to shards, maintain system-wide consistency, and return results to clients; shards store a subset of tables and full copies of data, which accept queries from routers.
- Aurora PostgreSQL Limitless Database has three table types: sharded, reference, and standard. Sharded tables are useful for scaling the largest, most I/O-intensive tables in an application. Reference tables copy data in full on every shard so that join queries can work faster by eliminating unnecessary data movement.
- To load data into Aurora PostgreSQL Limitless Database: create the DB shard group, sharded reference tables, and load data into it using the COPY command; for queries, connect to the cluster endpoint using psql or any other PostgreSQL-compatible connection utility.
- Aurora PostgreSQL Limitless Database supports PostgreSQL syntax and utilizes two querying methods: single-shard queries and distributed queries. Compute capacity is limited to 16-6144 ACUs per DB shard group.
- Storage is restricted to the Amazon Aurora I/O-Optimized DB cluster storage configuration, with each shard having a maximum capacity of 128 TiB, and reference tables limited to 32 TiB for the entire DB shard group.
- You can use Amazon CloudWatch and Amazon CloudWatch Logs to monitor Aurora PostgreSQL Limitless Database, along with new statistics functions and views and wait events for Aurora PostgreSQL Limitless Database that can be used for monitoring and diagnostics.
- Now available in regions including AWS US East (N. Virginia), US East (Ohio), US West (Oregon) and Europe (Ireland), explore this feature today in the Amazon RDS console
- Give Aurora PostgreSQL Limitless Database a try and for more detail about this feature visit the Amazon Aurora User Guide, and send feedback to AWS through the usual support contacts.
Read Full Article
11 Likes
For uninterrupted reading, download the app