[pseudo visitor]

5 years, 4 months ago #8938

Quick questions after the Elasticsearch indexing is over:
1. if i upgrade the WordPress version, do we need to re-index the data to ES server again (ES server is different from the website server)?
2. If we delete and reinstall the WPSOLR plugin, do we need to do the re-indexing again?
3. Is it possible to connect the elastic server to the same website duplicated on a different server with same WPSOLR account?

[wpsolr]

5 years, 4 months ago #8940

Can you explain what you want to achieve?

[pseudo visitor]

5 years, 4 months ago #8941

In 1st, if we upgrade the current wordpress version, it will ask for database upgrade. So, I was worried if we need to reindex the Elasticsearch.

[wpsolr]

5 years, 4 months ago #8942

No need, no.

[pseudo visitor]

5 years, 4 months ago #8943

In 3rd, if we use the website snapshot (Created by digital ocean) on a different server and do some changes, can we connect the Elasticsearch server to the same website hosted on different IP address?

[wpsolr]

5 years, 4 months ago #8944

Your clone will point to the same Elasticsearch index, which is dangerous.

[pseudo visitor]

5 years, 4 months ago #8945

But we will delete the main website after the clone is there.

[wpsolr]

5 years, 4 months ago #8946

Then create a new index, and set it up in the clone. It will work fine with the clone.

[pseudo visitor]

5 years, 4 months ago #8947

Perfect…
One last thing…the current index rate is slow…around 300 per minute.
We have 1.4 million products.
Can we speed up?

[wpsolr]

5 years, 4 months ago #8948

it should be 300 per 5-10 sec.

[pseudo visitor]

5 years, 4 months ago #8949

In a batch of 100. Right now, it has been 30 minutes and 10400 documents indexed so far.

[wpsolr]

5 years, 4 months ago #8950

You have an issue.

a) SQL is slow to retrieve data to index
b) Elasticsearch is slow to ingest data

[pseudo visitor]

5 years, 4 months ago #8951

I believe the SQL is slow. Although we are on 16 GB RAM server.

[wpsolr]

5 years, 4 months ago #8952

On SSDs?

[pseudo visitor]

5 years, 4 months ago #8953

Yes, SSD. DigitalOcean. Should we increase the RAM and CPU for indexing purpose and then bring it down?