Impact of integrating Elasticsearch with SQL Server

Question

I want to use Elastic search for full text searching in mu SQL server. As i read I can index my SQL server by elastic search. My questions is about resource usage. As I understood by indexing I must duplicate my entire SQL server database. and I must take both elastic and SQL server sync. Am I wrong? Thanks

avolkmann · Accepted Answer · 2018-07-03 14:26:42Z

1

Yes, you are right. I also maintain a sql server + elastic environment.

You need a separate instance of elasticsearch running.
You will have to index / insert all your existing data from sql server to elastic. There are libraries for almost any language to easily insert data.
You will have to sync these two in order to keep the data up to date.
In theory you only need 1 instance / node of elastic running, but it is recommended to have a full cluster, due to failover, etc.

answered Jul 3, 2018 at 14:26

avolkmann

3,1312 gold badges22 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Val Over a year ago

And worth noting that the third point is probably the less trivial one.

razi marjani Over a year ago

Thanks. Can I use specific table of my SQL server instead of all of it for indexing?

avolkmann Over a year ago

Yes you decide yourself what to index.

Val Over a year ago

And this may help: stackoverflow.com/questions/37613611/…

Collectives™ on Stack Overflow

Impact of integrating Elasticsearch with SQL Server

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related