Tag: Amazon Aurora

Feed: Recent Announcements. Amazon Aurora PostgreSQL-Compatible Edition adds support for the pg_proctab extension in AWS GovCloud (US) regions. pg_proctab is a collection of stored functions that can access the operating systems process table so that system statistics can be queried through the database. pg_proctab functions make it easier to collect data on your PostgreSQL database including up-to-date information on processor and I/O statistics on SQL queries which makes troubleshooting easier. You can view a list of all PostgreSQL extensions supported on RDS on the AWS User Guide. With this regional expansion, pg_proctab is available in all commercial regions. For full feature ... Read More

Feed: AWS Architecture Blog. This post was co-written by Ashutosh Pateriya, Solution Architect at AWS and Nirmal Tomar, Principal Consultant at Infosys Technologies Ltd.  Various organizations have stringent regulatory compliance obligations or business requirements that require an effective cross-account and cross-region database setup. We recommend to establish a Disaster Recovery (DR) environment in different AWS accounts and Regions for a system design that can handle AWS Region failures. Account-level separation is important for isolating production environments from other environments, that is, development, test, UAT and DR environments. These are defined by external compliance requirements, such as PCI-DSS or HIPAA. Cross-account ... Read More

Feed: Recent Announcements. Amazon Aurora PostgreSQL-Compatible Edition supports the Partition Manager (pg_partman) extension in AWS GovCloud (US) regions. pg_partman is a PostgreSQL extension that helps you to manage both time series and serial-based table partition sets, including automatic management of partition creation and runtime maintenance. pg_partman works with PostgreSQL native partitioning so users can benefit from significant performance enhancements. You can view a list of all PostgreSQL extensions supported on RDS on the AWS User Guide. With this regional expansion, pg_partman is available in all commercial regions. For full feature parity list, head to our feature parity page, and to ... Read More

Feed: Recent Announcements. Amazon Aurora PostgreSQL-Compatible Edition adds support for the pg_bigm extension in AWS GovCloud (US) regions. pg_bigm extension provides full text search capability in PostgreSQL. This extension allows a user to create *2-gram* (bigram) index for faster full text search. Characters that comprise text are represented as numbers to computers. Languages such as English, French, Russian, and Hebrew use character sets of fewer than 256 characters that can be encoded in a single byte. Languages with many characters (e.g., Japanese) require more numbers, which are represented by multi-byte encoding. pg_bigm allows you to create a 2-gram (bigram) index for ... Read More

Feed: Recent Announcements. Amazon Aurora PostgreSQL-Compatible Edition adds support for the pg_cron extension in AWS GovCloud (US) regions. pg_cron allows you to use cron syntax to schedule PostgreSQL commands directly within your database. You can use pg_cron to schedule tasks such as periodically rolling up data for analytic reports, refreshing materialized views, and scheduling vacuum jobs to reclaim storage. pg_cron includes an AWS open source contribution that adds an audit table so that you can query the outcome of each scheduled job. You can view a list of all PostgreSQL extensions supported by database version on Amazon Aurora on the AWS ... Read More

Feed: Recent Announcements. Following the announcement of updates to the PostgreSQL database by the open source community, we have updated Amazon Aurora PostgreSQL-Compatible Edition to support PostgreSQL 12.6, 11.11, 10.16, and 9.6.21 in AWS GovCloud (US) regions. These releases contain bug fixes and improvements by the PostgreSQL community. As a reminder, Amazon Aurora PostgreSQL 9.6 will reach end of life on January 31, 2022. You can initiate a minor version upgrade manually by modifying your DB cluster, or you can enable the ** “Auto minor version upgrade*”* option when creating or modifying a DB cluster. Doing so means that your DB ... Read More

Feed: AWS Architecture Blog. “Everything fails all the time” Werner Vogels, AWS CTO In 2010, Netflix introduced a tool called “Chaos Monkey”, that was used for introducing faults in a production environment. Chaos Monkey led to the birth of Chaos engineering where teams test their live applications by purposefully injecting faults. Observations are then used to take corrective action and increase resiliency of applications. In this blog, you will learn about the fault injection capabilities available in Amazon Aurora for simulating various database faults. Chaos Experiments Chaos experiments consist of: Understanding the application baseline: The application’s steady-state behavior Designing an experiment: ... Read More

Feed: Recent Announcements. Amazon Aurora now allows you to create clones between Aurora Serverless v1 and provisioned Aurora DB clusters to enable quick sharing of data.  Database cloning is faster than restoring a snapshot and requires no additional space at the time of creation. With this launch you can, for example, create a cloned Aurora Serverless v1 DB cluster from a provisioned Aurora DB cluster to get quick access to production data for development and testing. You can use the clone to verify schema changes, test different parameters, and run analytic queries on production data without providing direct access to ... Read More

Feed: Recent Announcements. Following the announcement of updates to the PostgreSQL database by the open source community, we have updated Amazon Aurora PostgreSQL-Compatible Edition to support PostgreSQL versions 12.6, 11.11, 10.16, and 9.6.21. These releases contain bug fixes and improvements by the PostgreSQL community. As a reminder, Amazon Aurora PostgreSQL 9.6 will reach end of life on January 31, 2022.  You can initiate a minor version upgrade manually by modifying your DB cluster, or you can enable the “Auto minor version upgrade” option when creating or modifying a DB cluster. Doing so means that your DB cluster is automatically upgraded after ... Read More

Feed: Recent Announcements. Characters that comprise text are represented as numbers to computers. Languages such as English, French, Russian, and Hebrew use character sets of fewer than 256 characters that can be encoded in a single byte. Languages with many characters (e.g., Japanese) require more numbers, which are represented by multi-byte encoding. pg_bigm allows you to create a 2-gram (bigram) index for faster full text search of text encoded with multi-byte characters. You can view a list of all PostgreSQL extensions supported on RDS on the AWS User Guide. Amazon Aurora combines the performance and availability of high-end commercial databases with ... Read More