Help, my disk array has one dead member

[william drescher]

On 4/2/2017 7:34 AM, william drescher wrote:
> 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
>
>
>
replication updates the slave server in sync (more or less) with 
the primary server