How to save state of sphinx delta index?

Question

MySQL

There are 2 MySQL servers. Replication is set to master-master mode. One of the servers is always read-only to avoid accidental changes in the database. If necessary, the first server becomes read-only and the record is transferred to the second.

With this configuration, I would like to index the database with a sphinx from a read-only server, but read_only cannot store the ID of the last indexed object (in particular, REPLACE INTO phpbb_sphinx SELECT 1, MAX(post_id) FROM phpbb_posts). Is it possible to save the state of the index delta without writing to the database?

Answer 1

Create a separate config for the delta index.
After indexing is complete, generate a new config file with the last indexed id
Crutch of course, but it should work.

Answer 2

As an alternative to the above, you can also read the docid of the last indexed document from the index itself.

Answer 3

Do indexing via xmlpipe, tsvpipe or csvpipe, which work in such a way that you can specify a command that will return all the data that should be indexed. The same command can also save the state where it is needed, and not just where it reads the data from.