Word of the Day: Amazon Aurora

Word of the Day Daily updates on the latest technology terms | January 17, 2019 Amazon Aurora Amazon Aurora is a relational database engine from Amazon Web Services. The engine is compatible with MySQL, which means code, applications and drivers used in databases relying on MySQL can be used in Aurora with minimal or no changes. MySQL is an open source database management system based on Structured Query Language (SQL). Amazon Relational Database Service (RDS) manages Aurora databases by handling provisioning, patching, backup, recovery and other tasks. A developer can migrate to and from MySQL databases by using the mysqldump (export) and mysqlimport (import) utilities or by using RDS' DB Snapshot migration feature. Data migration typically takes one hour. Aurora stores a minimum of 10 GB and scales automatically to a maximum of 64 TB. The service divides the volume of a database into 10 GB chunks, which are spread across different disks. Each chunk is replicated six ways across three AWS Availability Zones (AZs). If data in one AZ fails, Aurora attempts to recover data from another AZ. Aurora is also self-healing, meaning it performs automatic error scans of data blocks and disks. A developers can scale up resources allocated to a database instance and improve availability through Amazon Aurora Replicas, which share the same storage as the Elastic Compute Cloud (EC2) instance. An Amazon Aurora Replica can be promoted to a primary instance without any data loss, which helps with fault tolerance if the primary instance fails. If a developer has made an Aurora Replica, the service automatically fails over within one minute; it takes about 15 minutes to fail over without a replica. For security, Amazon Aurora encrypts data in transit through the AWS Key Management Service. Automated backups, snapshots, data at rest in the underlying storage and Replicas within the same cluster are also encrypted. Additionally, Aurora database instances are created within an Amazon VPC, allowing users to isolate a database within their network for more security. Amazon is a pay-per-use service in which a user pays per instance; customers can opt for either On-Demand or Reserve pricing. AWS also bills customers for any storage Aurora uses in GB per month increments and according to I/O rate (per million requests). Quote of the Day "Aurora handles many of the granular, low-level tasks needed to deploy a database, such as provisioning, setup, patching and backup." - Stephen J. Bigelow Trending Terms relational database MySQL Amazon RDS Amazon EC2 instance availability zones MongoDB Learning Center Follow these steps for an Oracle-to-AWS migration Many organizations have considered an Oracle-to-AWS migration to reduce overhead. Review the steps needed for a successful move to Amazon's cloud, and discover which option is the best fit for your organization, from EC2 to Aurora. AWS, MongoDB database collision stirs open source tensions Amazon DocumentDB serves as a competitive broadside against the MongoDB database and fuels the debate around open source software licensing. RDS on VMware extends AWS' hybrid strategy RDS on VMware is only available in a public preview, but users can still examine its features before it goes GA and identify if the service will be the proper match for their hybrid workloads. Amazon Aurora Parallel Query blurs database lines The Amazon Aurora Parallel Query feature adds analytical capabilities to a transactional database. It could make the managed service more attractive, as long as AWS doesn't overlook the need to also improve the core database functionality enterprises require. Perform an Amazon RDS failover with minimal downtime Multi-availability-zone deployments are the bread and butter for most AWS users, but what happens in the Amazon RDS failover process? Walk through this example using the Amazon Aurora engine to learn more. Quiz Yourself The AWS portfolio ______ more than 100 services, including those for compute, databases, infrastructure management, application development and security. a. comprises b. composes Answer Stay in Touch For feedback about any of our definitions or to suggest a new definition, please contact me at: mrouse@techtarget.com Visit the Word of the Day Archives and catch up on what you've missed! FOLLOW US About This E-Newsletter This e-newsletter is published by the TechTarget network. To unsubscribe from Whatis.com, click here. Please note, this will not affect any other subscriptions you have signed up for. TechTarget, Whatis, 275 Grove Street, Newton, MA 02466. Contact: webmaster@techtarget.com Copyright 2018 TechTarget. All rights reserved.