By using AWS re:Post, you agree to the Terms of Use

AWS Aurora MYSQL enabling Federated Server

0

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

2 Answers
0

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.

answered 12 days ago
  • Thank you @yutaka_h , i'm new to Athena , will go through the document and come back .

0

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]

SUPPORT ENGINEER
answered 14 days ago

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