i known how implement backup of realtime index using flush rtindex , compressing involved files (.ram, .kill, .meta files) below:
tar zcvf /backups/myrtbackup.tar.gz /sphinxdata/myrtindex.{*.sp*,ram,kill,meta} /sphinxdata/binlog.* but there's question, if system crashed, or somehow delete data mistake, how recover backup?
following crash, or if server goes , need bring online new 1 etc. restore files data folder (while searchd not running) , start searchd.
if search wont start might have luck not restoring binlog, rather index files.
if delete data, not going you. can't 'roll back' , go specific time.
in general sphinx 'index' designed created index on real database somewhere else. not authoritative database in itself.
sphinxes "backups" not robust enough able rely on them. because sphinx indexes should disposable, if currupted, recreate them source data.
(the backups can do, 'hacks' may online quicker in case of disaster)
Comments
Post a Comment