Hi All, I had a query. This is the scenario:
I created 2 instances of datahub on different machines, call them datahub_1 and datahub_2. The mysql server is hosted on different dbs on RDS, call them datahub_primary and datahub_secondary for the resprective instances.
I ingested some data in datahub_1, this data goes into the metadata_aspect_v2 table of datahub_primary db.
Now i want to point datahub_2 to use the same metadata. Just copying the metadata_aspect_v2 table from primary to secondary db is not enough? I tried doing it but i still not see the data in datahub_2.
Is there some other way of restoring the metadatas?
This test was done by deploying both the instances through docker and I was trying to test the back and restore functionality of datahub. Can anyone please suggest why the above result was seen and if there is a better or a official way of restoring metadata and indices. Happy to take this offline if needed.
Thanks a lot!
Edit: I have tried directly pointing the db of datahub_2 to the same db of datahub_1 but no use. I created different dbs and copied the table but still no use