Steps for archived data migration from MySQL to ElasticSearch

Products

• VMware Smart Assurance

Issue/Introduction

How do we migrate the archived the data in MySQL DB to ElasticSearch .

Environment

All supported releases of M&R

Resolution

You can enable events migration from MySQL to ES from emc-smarts Solution Pack configuration for Events Component. Kindly refer APG-Event-Database-Migration.pdf document present under <APG_HOME>/Event-Processing/Event-Database-Migration/emc-smarts/doc for more details on this utility.

NOTE:

It is recommended to test this migration in the test system first before implementing in the production.

Additional Information

CLI to migrate events from MySQL and ES:

<APG_HOME>/bin/migrate-event-database-emc-smarts.sh <APG_HOME>/Event-Processing/Event-Database-Migration/emc-smarts/conf/processing.xml