AWS Aurora MYSQL enabling Federated Server

Question

Hello,
is it possible to enable Federated server on AWS Aurora MYSQL ?  If yes,
How can i enable it?
i would like to pull data from separate MYSQL instance in different cluster.
i.e  using "ABC" MySQL instance i would like to pull data from "XYZ" MySQL instance in different cluster.

Thanks

Answer

Aurora MySQL doesn't support federated storage engine. To consolidate data from multiple Aurora MySQL clusters, setup EC2 instance or Lambda, then fetch data from source clusters, and insert into target cluster.

As alternative, Amazon Athena federated query might be the option.
- [Amazon Athena federated query](https://docs.aws.amazon.com/athena/latest/ug/connect-to-a-data-source.html) 
- [Amazon Athena Pricing](https://aws.amazon.com/athena/pricing/)
- [AWS Lambda Pricing](https://aws.amazon.com/lambda/pricing/)

Answer

Hello,

Here's an entire blog documentation for your particular use-case of federated querying.

Link-- https://docs.aws.amazon.com/redshift/latest/dg/getting-started-federated-mysql.html -- [1]

AWS Aurora MYSQL enabling Federated Server

Relevanter Inhalt