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

score 1 · Accepted Answer · answered Jul 03 '18 at 14:26

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 03 '18 at 14:26

avolkmann

2,962
2
19
27

And worth noting that the third point is probably the less trivial one. – Val Jul 03 '18 at 14:49
Thanks. Can I use specific table of my SQL server instead of all of it for indexing? – razi marjani Jul 03 '18 at 15:03
Yes you decide yourself what to index. – avolkmann Jul 03 '18 at 15:07
2

And this may help: https://stackoverflow.com/questions/37613611/multiple-inputs-on-logstash-jdbc/37613839#37613839 – Val Jul 03 '18 at 16:05

Impact of integrating Elasticsearch with SQL Server

1 Answers1