Additionally, the architecture has the benefits of being serverless, whereas AWS DMS requires an Amazon EC2 instance for replication. Amazon Aurora is fully managed by Amazon Relational Database Service (RDS), which automates time-consuming administration tasks like hardware provisioning, database setup, patching, and backups. Since Amazon Aurora is fully MySQL- and PostgreSQL-compatible, your applications can easily be reconnected to the new instance without any changes. You can publish these dashboards and share them with others. First, create a database by following these steps in the Amazon RDS console: After you create the database, use MySQL Workbench to connect to the database using the CNAME from the console. RDS – Because RDS is less complex, it’s easier to scale – requiring just a few clicks on the AWS Console to determine an auto-scale max capacity. In certain cases, it may be optimal to use AWS Database Migration Service (AWS DMS) to capture data changes in Aurora and use Amazon S3 as a target. Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. You can also backtrack within seconds to a previous point in time, to recover from user errors. Learn more about AWS Database Migration Service ». You can follow the simple, step by step instructions in the user guide to perform the migration. Web and mobile games that are built to operate at very large scale need a database with high throughput, massive storage scalability, and high availability. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability. Samsung moved over a billion users across three continents from Oracle to Amazon Aurora, improving latency and scalability while lowering monthly costs. This means you can easily migrate MySQL or PostgreSQL databases to Aurora using standard MySQL or PostgreSQL import/export tools or snapshots. It can be more costly, more complex to work with and much more powerful. And if you want a more powerful relational database for non-analytical purposes, Aurora might be best, although you should consider the restrictions ‘serverless’ will impose on your work. Next, create a dimension table. Ensure that the highlighted (bold) variables are replaced with appropriate values. For example, AWS DMS might be a good option if you don’t need to transform data from Amazon Aurora. Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Most of the other services I’m fairly comfortable with.