AWS Database Blog
Tag: HAQM Aurora
How to migrate from Oracle to HAQM Aurora MySQL using AWS CloudFormation (Part 1)
Database migrations are challenging, especially for heterogeneous database migrations such as Oracle to HAQM Aurora PostgreSQL, Oracle to HAQM 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 […]
Monitor HAQM Aurora Database Activities Using DataSunrise Database Security
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 […]
Using JSON with MySQL 5.7–compatible HAQM Aurora
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 […]
How to Migrate from MySQL to HAQM Aurora using AWS SCT and AWS DMS
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 […]
HAQM Aurora under the hood: indexing geospatial data using Z-order curves
When designing high-performance database systems like HAQM 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 […]
Migrate Microsoft Azure SQL Database to HAQM Aurora
Increasingly, customers are looking to move databases from proprietary engines such as Oracle and Microsoft SQL Server to open source engines running on AWS. One of the preferred destinations for this data is HAQM Aurora. In this post, we walk through a migration of a Microsoft Azure SQL database to an HAQM Aurora MySQL cluster […]
Monitor HAQM Aurora MySQL, HAQM RDS for MySQL and MariaDB logs with HAQM CloudWatch
NEW! HAQM Aurora with MySQL compatibility now supports publishing of all logs to CloudWatch Logs using the process described below. HAQM RDS has long offered customers the ability to view and download logs associated with their DB instances for troubleshooting purposes. Now, with HAQM Relational Database Service (HAQM RDS) for MySQL and HAQM RDS for […]
Accelerate Magento Content Services Deployment on HAQM Aurora with AWS Quick Start
We first released AWS Quick Start for Magento, a very popular open-source content management system, in September 2015. Since its initial launch, the Quick Start has consistently been among the top 10 Quick Starts that are most popular with our customers. In October 2017, we released an update to the AWS Quick Start for Magento […]
Audit HAQM Aurora Database Logs for Connections, Query Patterns, and More, using HAQM Athena and HAQM QuickSight
HAQM Aurora offers a high-performance advanced auditing feature that logs detailed database activity to the database audit logs in HAQM CloudWatch. If you are using Aurora 1.10.1 or greater, you can use advanced auditing to meet regulatory or compliance requirements by capturing eligible events like tables queried, queries issued, and connections and disconnections. You can […]
HAQM Aurora as an Alternative to Oracle RAC
Written by David Yahalom, CTO and co-founder of NAYA Tech—a leading database, big data, and cloud professional and consulting service provider, located in San Jose, CA. In this post, I discuss how HAQM Aurora can serve as a powerful and flexible alternative to Oracle RAC. Both Oracle RAC and HAQM Aurora are designed to provide increased high availability and performance scalability for your databases.