Ruby on Rails

Peter Hickman wrote in post #1114323:
> To reduce the time we lose when we restore a backup we could of course
> just
> take more frequent backups. But this would start to become a performance
> issue, not to mention pulling the backups off the server will start to
> eat
> into our bandwidth.

> Any thoughts?

A robust solution is to use database replication and then run your
backups off the replica, This way you have at least two servers that are
kept synchronized constantly, Backups of the replica will also not
impact the performance of the application accessing the source database.

http://dev.mysql.com/doc/refman/5.0/en/replication.html

--
Posted via http://www.ruby-forum.com/.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/518aa35b4b284600343f15dbbd6ae070%40ruby-forum.com.
For more options, visit https://groups.google.com/groups/opt_out.