How will you test and approve MySQL tables to Elastic Search

30 pts.
Tags:
DevOps
Elastic Search
MySQL
In our e-commerce company, the DevOps engineer were facing a lot of trouble managing certain tables in MySQL namely logs_users, logs_actions which store logs of each visitor who comes to their e-commerce store. In an year's time the table size grew to 70GB. We hired a senior DevOps and when he analyzed the situation he immediately asked engineers to migrate these tables to elastic search. Migration took 7 days to complete, but engineers are not sure if it was successful. How should we test it and make sure it was successful?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    This sounds like a class assignment. If not what steps have you taken to address the situation so far?
    89,455 pointsBadges:
    report
  • sarthak31
    Yes it is and i have no idea how to answer this question
    30 pointsBadges:
    report
  • Subhendu Sen
    This is not a few lines of answer. It is better to sync the tables directly with elasticsearch. It is also possible, to make index of MySQL data directly in elasticsearch. For that mechanism, you have to write some scripting. Which helps to update/ delete in MySQL database and it directly reflects in elasticsearch. However, for database you can try for NoSQL. This is rather good for what did you want to do.
    93,600 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: