Need reindexing after cloning a Wordpress site? topic with WPSOLR

Need reindexing after cloning a Wordpress site?

pseudo visitor
Participant

# 7 months, 2 weeks ago

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
Keymaster

# 7 months, 2 weeks ago

Can you explain what you want to achieve?

pseudo visitor
Participant

# 7 months, 2 weeks ago

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
Keymaster

# 7 months, 2 weeks ago

No need, no.

pseudo visitor
Participant

# 7 months, 2 weeks ago

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
Keymaster

# 7 months, 2 weeks ago

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

pseudo visitor
Participant

# 7 months, 2 weeks ago

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

wpsolr
Keymaster

# 7 months, 2 weeks ago

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

pseudo visitor
Participant

# 7 months, 2 weeks ago

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
Keymaster

# 7 months, 2 weeks ago

it should be 300 per 5-10 sec.

pseudo visitor
Participant

# 7 months, 2 weeks ago

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

wpsolr
Keymaster

# 7 months, 2 weeks ago

You have an issue.

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

pseudo visitor
Participant

# 7 months, 2 weeks ago

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

wpsolr
Keymaster

# 7 months, 2 weeks ago

On SSDs?

pseudo visitor
Participant

# 7 months, 2 weeks ago

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