AWS Database Blog
Category: Amazon Aurora
How Autodesk Increased Database Scalability and Reduced Replication Lag with Amazon Aurora
Autodesk is a leader in 3D design, engineering, and entertainment software. Autodesk makes software for people who make things. If you’ve ever driven a high-performance car, admired a towering skyscraper, used a smartphone, or watched a great film, chances are you’ve experienced what millions of Autodesk customers are doing with their software. Autodesk has successfully […]
How to plan and optimize Amazon Aurora with MySQL compatibility for consolidated workloads
Amazon Aurora with MySQL compatibility is a popular choice for customers looking to consolidate database workloads. Aurora MySQL is a relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. It also delivers up to five times the throughput of the standard MySQL community […]
Best practices for migrating RDS for MySQL databases to Amazon Aurora
MySQL is the most popular open-source database in the world. However, many customers find that the undifferentiated heavy lifting of backups, high availability, and scaling of MySQL databases to be complex, time-consuming, or both. This is one of the leading reasons why customers move their existing MySQL footprint to Amazon RDS for MySQL. Amazon RDS […]
Failover with Amazon Aurora PostgreSQL
Replication, failover, resilience, disaster recovery, and backups—it can be challenging to achieve any or all of these in a traditional or non-cloud-based architecture. In addition, they sometimes require a considerable re-engineering effort. Due to the high implementation and infrastructure costs that are involved, some businesses are compelled to tier their applications so that only the […]
Amazon RDS Performance Insights is now generally available
Today we are pleased to announce general availability of Performance Insights. Already available since October 2017 as an open preview with Amazon Aurora with PostgreSQL compatibility, Performance Insights makes it easy to view the load on an Amazon RDS database. Using Performance Insights, you can more easily identify bottlenecks and discover what to do when […]
How to migrate BLOB and CLOB tables from Oracle to PostgreSQL using Ora2pg and AWS DMS
Many enterprises are considering migrating their Oracle databases to PostgreSQL because of the close compatibility between the platforms and the enterprises’ desire to reduce licensing costs. Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL compatibility make it easy to set up, operate, and scale PostgreSQL deployments in the cloud in a cost-efficient manner. AWS […]
How to set up a single pgpool endpoint for reads and writes with Amazon Aurora PostgreSQL
Amazon Aurora provides endpoints for the primary DB instance (the cluster endpoint) and for Read Replicas (the reader endpoint). Aurora updates the cluster endpoint automatically so that it always points to the primary instance. The reader endpoint load balances read operations across all available Read Replicas. Amazon Aurora Replicas typically have less than 100 ms […]
Migrate to the MySQL-compatible edition of Amazon Aurora while protecting personal data using encryption
Security is a top priority at AWS, and the same is true for our customers. We spend a significant amount of resources protecting personal data and are constantly enhancing our capabilities to make data protection easier for our customers. All AWS services including the MySQL-compatible edition of Amazon Aurora comply with the European Union’s General […]
How to extract, transform, and load data for analytic processing using AWS Glue (Part 2)
One of the biggest challenges enterprises face is setting up and maintaining a reliable extract, transform, and load (ETL) process to extract value and insight from data. Traditional ETL tools are complex to use, and can take months to implement, test, and deploy. After the ETL jobs are built, maintaining them can be painful […]
How Cloudability boosted performance, simplified tuning, and lowered costs with Amazon Aurora
Cloudability is a cloud cost-management platform that empowers enterprises to run with known cloud financials and full accountability. Our platform collects an avalanche of billing and utilization data points—33 million per resource, with over 275,000 services and options from each cloud vendor and more than 1,000 new services rolled out annually per cloud provider. Using […]