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

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

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceDatabaseAmazon AuroraAurora MySQL
Language
English
hfx2022
asked 2 years ago223 views
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.

AWS
YUTAKA_H
answered 2 years ago
  • hfx2022
    2 years 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]

profile pictureAWS
SUPPORT ENGINEER
Chirag_R
answered 2 years 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

Relevant content