Aurora Serverless MySQL to access the binlog or Activity Streams

0

Is there a way to access the binlog or Activity Stream from Aurora Serverless MySQL?

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/DBActivityStreams.Overview.html This page talks about instance class size that has Activity Streams. Aurora Serverless MySQL does not utilize instance classes though and not clear that they would be available.

Additionally, the documentation about enabling binlogs for Aurora
https://aws.amazon.com/premiumsupport/knowledge-center/enable-binary-logging-aurora/ does not have the associated parameter group available in Aurora Serverless v1 (List of parameter groups here: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.how-it-works.html)

Any advice or support would be greatly appreciated! Thank you!

asked 2 years ago969 views
1 Answer
0

Hi dtornow

I understand you are trying to access the binglog or Activity stream from Aurora Serverless MySQL.

Some of the Limitations of Aurora Serverless v1 are:

- It does not support Database activity streams.

- Replicating data using replication based on binary logs (binlogs). This limitation is true regardless of whether your Aurora MySQL-based DB cluster Aurora Serverless v1 is the source or the target of the replication. 

If you are attempting to replicate data into an Aurora Serverless v1 DB cluster from a MySQL DB instance outside Aurora, such as one running on Amazon EC2, consider using AWS Database Migration Service.

AWS Database Migration Service (AWS DMS) is a cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud or between combinations of cloud and on-premises setups.

You can migrate between source and target endpoints that use the same database engine, such as from an Oracle database to an Oracle database. You can also migrate between source and target endpoints that use different database engines, such as from an Oracle database to a PostgreSQL database. The only requirement to use AWS DMS is that one of your endpoints must be on an AWS service. You can't use AWS DMS to migrate from an on-premises database to another on-premises database.

With AWS DMS, you can perform one-time migrations, and you can replicate ongoing changes to keep sources and targets in sync. If you want to migrate to a different database engine, you can use the AWS Schema Conversion Tool (AWS SCT) to translate your database schema to the new platform. You then use AWS DMS to migrate the data.

For more information on AWS Database Migration Service, check [2]

I hope this helps

References:

[1] Aurora Serverless v1 Limitations
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.limitations

[2] Database Migration User Guide
https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html

answered 2 years ago
  • In DMS though there is also a limitation: "You can use Aurora MySQL-Compatible Edition Serverless for full load, but you can't use it for CDC. This is because you can't enable the prerequisites for MySQL."

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions