Need reindexing after cloning a Wordpress site?

  • pseudo visitor
    Participant
    # 10 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
    # 10 months, 2 weeks ago

    Can you explain what you want to achieve?

    pseudo visitor
    Participant
    # 10 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
    # 10 months, 2 weeks ago

    No need, no.

    pseudo visitor
    Participant
    # 10 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
    # 10 months, 2 weeks ago

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

    pseudo visitor
    Participant
    # 10 months, 2 weeks ago

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

    wpsolr
    Keymaster
    # 10 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
    # 10 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
    # 10 months, 2 weeks ago

    it should be 300 per 5-10 sec.

    pseudo visitor
    Participant
    # 10 months, 2 weeks ago

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

    wpsolr
    Keymaster
    # 10 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
    # 10 months, 2 weeks ago

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

    wpsolr
    Keymaster
    # 10 months, 2 weeks ago

    On SSDs?

    pseudo visitor
    Participant
    # 10 months, 2 weeks ago

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

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic.