Topic: Primary and secondary DB server
I would like to run my Rails application with a primary and secondary database server using MySQL5.
1. I need a backup
Damn it, a stupid user deleted important data and want to restore it immediately. But how should the backup process work? Once per hour?
2. Secondary database server stands in for primary database server
Primary database server crashes, but we have a secondary database server and the Rails app is still running.
Has anyone some experiences with these issues?