Help, my disk array has one dead member

[william drescher]

On 4/1/2017 11:56 PM, Kevin O'Gorman wrote:

> That's not going to work for me.  Most of the data is in a single
> SQLite database.  It's all or nothing and rsync doesn't help.
> Moreover, remember this is a hobby project, and I have no
> "offsite" to use.  I can and do back up the individual
> contributions to the database, or the algorithms and commands
> used, so restoring from those would be  possible but ugly.
>

I may be completely off base for you, but we have found that
  using mySQL replication is our solution.
The slave server is off site connected via a hardware based VPN.
This gives us a hot backup of our data and the ability to switch 
to the backup server if the primary dies.

In your case it would give you the safety of continuous backup of 
your data.  You could have the backup server at the same location 
(Our "obsolete" windows machines become fully functional linux 
servers.)

of course the conversion from SQLite to mySQL would be a big job.
--bill