On 4 July 2013 11:43, Peter Hickman wrote:
On 3 July 2013 20:25, Robert Walker wrote:

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.
We tried that, we use PostgreSQL and londiste, but when it decided to
break it stayed broken. I spent weeks trying to get things to work again
once it failed. That was only 2 databases, what would happen for the >25
databases that we have?

Unless someone dumps a large amount of cash in my lap I have to improve
the situation we are in with what we have to hand rather than throwing
money around.
Sorry to hear you spent some fruitless time there. PostgreSQL supports
various kinds of replication - both internal streaming and Londiste work
very well for many people, so those technology choices are good ones.

Probably trite to say time = money; I do recognise that the functional
relationship between time and money differs for everybody. In general the
open source ecosystem does have a place for companies that specialise in
building, maintaining and supporting system software to assist in cases
like this.

--
  Simon Riggs http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services

--
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/CA%2BU5nMJ7CSGinY7uT1-mAeesW93UwrdWfJfN%3D5ucKCT%3DQ%3DKMkQ%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 9 | next ›
Discussion Overview
grouprubyonrails-talk @
categoriesrubyonrails
postedJul 3, '13 at 2:09p
activeJul 5, '13 at 6:31a
posts9
users5
websiterubyonrails.org
irc#RubyOnRails

People

Translate

site design / logo © 2017 Grokbase