Tag: Amazon Aurora

Miscellaneous

Monitor Amazon 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 …

Miscellaneous

Scale with Maxscale part-4 (Amazon Aurora)

This is part-4 of the Maxscale Blog series Maxscale and Galera Maxscale Basic Administration Maxscale for Replication Maxscale started supporting Amazon Aurora lately from its version 2.1 which comes with a BSL license, we are good until we use only 3 nodes, Amazon Aurora (Our Previous blog ) is a brilliant technology built by AWS team which …

Miscellaneous

Using JSON with MySQL 5.7–compatible Amazon 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 …

Miscellaneous

Migrating from MySQL to Amazon 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 …

Miscellaneous

Aurora Hash Join Optimization (with a Gentle Reminder on Lab Features)

  The Aurora hash join feature for relational databases has been around for a while now. But unlike MySQL Block Nested Loop algorithm, an Aurora hash join only caters to a specific number of use cases. When implemented with the optimizer properly, they can provide great benefits with certain workloads. Below we’ll see a brief …

Miscellaneous

Migrate Microsoft Azure SQL Database to Amazon 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 Amazon Aurora. In this post, we walk through a migration of a Microsoft Azure SQL database to an Amazon Aurora MySQL cluster …

Miscellaneous

Amazon Aurora under the hood: indexing geospatial data using Z-order curves

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 …