Category: Amazon Aurora

By Nathaniel Kangpan, SVP Technology & Data Services, Kepler Group I have yet to meet a client in the past 12 months that doesn’t already (a) have a team or two dipping their toes into cloud-based infrastructure, or (b) have the cloud on their roadmap for 2018. Total cost of ownership (TCO) savings for migrating […]

Database migrations are challenging, especially for heterogeneous database migrations such as Oracle to Amazon Aurora PostgreSQL, Oracle to Amazon Aurora MySQL, or Microsoft SQL Server to MySQL. The schema structure, data types, and database code of source databases can be quite different from those of the target databases, requiring a schema and code transformation step before the […]

July 2023: This post was reviewed for accuracy. Amazon Relational Database Service (Amazon RDS) enables you to use AWS Identity and Access Management (IAM) to manage database access for Amazon RDS for MySQL DB instances and Amazon Aurora MySQL DB clusters. Database administrators can associate database users with IAM users and roles. By using IAM, you can manage user access to all […]

In this post, we build an AWS CloudFormation stack to deploy resources to help demonstrate the process of migrating from an Oracle database to an Amazon Aurora PostgreSQL database. Because this is a heterogeneous migration, we follow a two-phase approach similar to what is detailed in How to Migrate Your Oracle Database to PostgreSQL. The […]

November 2022: This post was reviewed and updated for accuracy. AWS recently announced general availability of Amazon Aurora with PostgreSQL compatibility. With this release, AWS has also included the first release of a useful feature in Amazon Relational Database Service (Amazon RDS) called Performance Insights. Using a dashboard that visualizes database load—along with which SQL […]

Radik Chumaren, Engineering Leader at DataSunrise DataSunrise is a database security software company that offers a breadth of security solutions, including activity monitoring, data masking (dynamic and static masking), a database firewall, and sensitive data discovery for diversified databases. Our goal is to protect databases against external and internal threats and vulnerabilities. We often see […]

What’s the big deal about JSON support in MySQL 5.7? MySQL 5.6 supports numeric, date and time, string (character and byte) types, and spatial data types. Although this is a broad set of supported types, these primitive data types can limit your flexibility to evolve an application. If you use MySQL 5.6, you have two […]

David Rader is the vice president of engineering at OpenSCG. OpenSCG is an AWS Consulting Partner and a leading expert in PostgreSQL, helping customers migrate to, operate, and optimize PostgreSQL and other data platforms on premises and in the cloud. In previous posts, we looked at the overall approach for a successful database migration and […]

MySQL is a great open-source database engine, which a lot of companies use because it’s cost-effective. However, like any other open-source database, it takes a lot of work to get commercial-grade performance out of it. As the size of your database increases, the complexity of scaling and crash recovery in MySQL also increases. Scaling out […]

When designing high-performance database systems like Amazon Aurora, you typically want to work on things that deliver the most impact for the broadest set of workloads. But sometimes, it pays to focus on specialized use cases where you have the opportunity to change the game. In this post, let’s take a look at how Aurora […]