Category: Best Practices

When you migrate from Oracle to Amazon Aurora PostgreSQL-Compatible Edition or Amazon Relational Database Service (Amazon RDS) for PostgreSQL, you may need to deal with partitioned tables and ensure global uniqueness across partitions. Oracle Database supports global indexes. A global index contains keys from multiple table partitions in a single index partition. Each table partition […]

In OLTP databases, the buffer cache is memory allocated for storing cached data and dirty pages. Cached data speeds up the retrieval of frequently accessed information, and reading from these cached pages minimizes disk I/O operations. Setting appropriate values for shared_buffers is important for optimal PostgreSQL performance and can lead to significant reductions in overall […]

Amazon Relational Database Service (Amazon RDS) uses Amazon Elastic Block Store (Amazon EBS) as an underlying storage. RDS snapshots (automated and manual) are saved in Amazon Simple Storage Service (Amazon S3). For RDS instances that are restored from snapshots, the instances are made available as soon as the needed infrastructure is provisioned. However, there is […]

Planning a migration journey with extensive on-premises database and analytics resources have many requirements such as including time to generate a migration plan and expertise in compiling inventory, designing a migration strategy, and finalizing migration targets. Transition to AWS became remarkably streamlined with AWS DMS Fleet Advisor service. AWS DMS Fleet Advisor helps you construct […]

Organizations are usually required by regulations or law to maintain database audit logs to demonstrate compliance for various data privacy and regulatory obligations. For example, the PCI-DSS framework requires financial organizations to keep audit logs for data security and adherence. In this post, we show how to effectively and efficiently set up audits in Amazon […]

Amazon DynamoDB is a fully managed NoSQL database that provides fast and predictable performance with seamless scalability. Customers across multiple industries utilize DynamoDB as their database of choice. Numerous education technology (EdTech) companies utilize DynamoDB as a persistent data store to track students’ exam scores and course progress. As students advance through various grades, their […]

Amazon Managed Blockchain and many partners of AWS offer a convenient way to use Ethereum nodes without operating your own infrastructure. But sometimes, when you want to run archive nodes or participate in Ethereum staking, the managed nodes aren’t enough, and you may choose to run your own Ethereum nodes on AWS. To run a […]

Migrating a Transparent Data Encryption (TDE)-enabled Amazon Relational Database Service (Amazon RDS) for Oracle database instance from one AWS account to another is a common use case in scenarios when you acquire, sell, or merge operations, or if you’re reorganizing your AWS accounts and organizational structure. TDE is a permanent and persistent option in RDS […]

In this post, we explain how to migrate the logins, database roles, users, and object-level permissions from on-prem or Amazon Elastic Compute Cloud (Amazon EC2) for SQL Server to Amazon Relational Database Service (Amazon RDS) for SQL Server using the T-SQL.

Cosmos is a decentralized network of interoperable blockchain networks that serves as an open and highly scalable environment on which to build blockchain applications. With effective support for cross-chain interaction between homogeneous and heterogeneous blockchains, Cosmos aims to extend interoperability to a broader landscape. In this post, we discuss the value and technical architecture of Cosmos and provide a detailed tutorial on the quick deployment of the Cosmos enterprise framework (IRITA) within the AWS environment.