# Sync data form MySQL to AWS-elastic-service

**URL:** https://discuss.elastic.co/t/sync-data-form-mysql-to-aws-elastic-service/169927
**Category:** Elasticsearch
**Created:** [February 26, 2019, 2:02am UTC](https://discuss.elastic.co/t/sync-data-form-mysql-to-aws-elastic-service/169927 "2019-02-26T02:02:38Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![raychou1203](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raychou1203/32/41479_2.png) [@raychou1203](https://discuss.elastic.co/u/raychou1203)
#### Post date: [February 26, 2019, 2:02am UTC](https://discuss.elastic.co/t/sync-data-form-mysql-to-aws-elastic-service/169927/1 "2019-02-26T02:02:38Z")

</div>

I have an Elastic Service on AWS, there is no entrance to run command on command line or LogStash plugin.  
Is there an solution to sync data from mysql to elastic search?

MySQL is on cloud, too.  
//elastic 6.4

Thanks!

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [February 26, 2019, 4:22am UTC](https://discuss.elastic.co/t/sync-data-form-mysql-to-aws-elastic-service/169927/2 "2019-02-26T04:22:34Z")

</div>

I shared most of my thoughts there: [http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/](http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/)

Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.

BTW did you look at [https://www.elastic.co/cloud](https://www.elastic.co/cloud) and [https://aws.amazon.com/marketplace/pp/B01N6YCISK](https://aws.amazon.com/marketplace/pp/B01N6YCISK) ?

Cloud by elastic is one way to have access to all features, all managed by us. Think about what is there yet like Security, Monitoring, Reporting, SQL, Canvas, APM, Logs UI, Infra UI and what is coming next 🙂 ...

---

<div class="post-metadata">

### Author: ![raychou1203](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raychou1203/32/41479_2.png) [@raychou1203](https://discuss.elastic.co/u/raychou1203)
#### Post date: [March 2, 2019, 3:05am UTC](https://discuss.elastic.co/t/sync-data-form-mysql-to-aws-elastic-service/169927/3 "2019-03-02T03:05:23Z")

</div>

Thanks David，finally I deployed my elasticsearch instance on server, using Logstash sync data from MySQL to my instance.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 30, 2019, 3:05am UTC](https://discuss.elastic.co/t/sync-data-form-mysql-to-aws-elastic-service/169927/4 "2019-03-30T03:05:43Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
