[FEATURE] Add Support for multiple remote metadata stores #2046
Description
Is your feature request related to a problem?
At Present, alerting plugin supports only the local system indices as the metadata store, Extend support to multiple data stores to perform CRUD operations.
The choice of data store should be controlled by a simple setting.
What solution would you like?
Integrate with OpenSearch Remote Metadata SDK Client which provides different clients like AWS DynamoDb and Remote Opensearch cluster etc. Upon Integrating, Migrate the existing transport layer client API calls to use the OpenSearch Remote Metadata SDK Client.
Github : https://github.com/opensearch-project/opensearch-remote-metadata-sdk
What alternatives have you considered?
A generic DAO layer based storage repository which can be extended to use multiple clients