Hello,
I have flexmonster with a lot of index and when they do the refresh the work on the db server is too much mostly if is done during the working day. If I disable the automatic refresh of the index is there a way to refresh it only night time when the work on the db server is low?
Thanks,
Andrea
Hello, Andrea,
Thank you for your question.
Yes, there is a way to schedule indexes to be refreshed only at a specific time.
This approach will require using Flexmonster Data Server as a service:
The idea lies in using a cron job to send requests to your Flexmonster Data Server service to refresh the indexes at a scheduled time.
As mentioned previously in the following Support Ticket, Flexmonster Data Server service provides an API endpoint on port 9555 for reloading indexes.
This way, you could reload indexes programmatically by sending the following PUT
request "http://localhost:9555/admin/indexes/reload/YOUR_INDEX_NAME".
With this in mind, you could set up a cron job that will send such PUT
requests at a specific time, for example, only at night. This way, your indexes will be refreshed when your cron job executes at the scheduled time.
Please note that the API accepts requests only from the same machine where the Flexmonster Data Server service is installed.
Therefore, your cron job should run on the same machine where your Flexmonster Data Server service is running for the index refresh API to be accessible.
Please let us know if such an approach would work for you.
Looking forward to your reply.
Kind regards,
Vera
Hi Vera thanks for your answer,
that was the way I thought, I will implement it.
Regards,
Andrea