Yipee! All the information related to replication is included here: http://devcenter.heroku.com/articles/heroku-postgresql
On Jun 18, 4:47 pm, Jeff Schmitz <jeffrey.j.schm...@gmail.com> wrote: > Has the pricing plan been announced? > > Jeff > > On Jun 18, 2011, at 11:07 AM, Oren Teich <o...@heroku.com> wrote: > > > > > We launched replication into beta this week. We have many large > > customers using it already in production. Drop a note to > > b...@heroku.com and he can hook you up with the details. > > > Oen > > > On Fri, Jun 17, 2011 at 9:16 PM, Karl <threadh...@gmail.com> wrote: > >> I have a client app that will be coming online soon, and one of the > >> the requirements is that it generates non-repeating serial numbers > >> with no vacancies. There can NEVER, EVER be a repeated serial number. > >> If you are curious, it's financial transactions between countries that > >> are monitored by the FINRA (and others) and they use the serial > >> numbers to detect fraud. > > >> So, let's say there is a one-in-a-billion chance that Heroku loses > >> some of my database, no matter how small. They, or we, can restore > >> from backups, but there is no possible way I can determine that > >> records could have been created after the last backup. I'm not so > >> concerned about system downtime, it's potential data loss. > > >> As I understand, Heroku does not provide any form of replication for > >> its PostgreSQL offerings (psst, I would be willing to pay $$$). Until > >> then I need to come up with a fault tolerant scheme of data audit > >> trails. > > >> First thought - just use Amazon RDS. But whoa, it's really expensive. > >> My clients won't float $3K per month just for data storage. But maybe > >> I'm pricing it wrong and don't understand their pricing model. > > >> Second thought - Lotsa backups! Better, but still no guarantee. > > >> Third thought - MongoDB or Cloudant. I could use either to write audit > >> logs, essentially duplicating my 'serialized documents', but not the > >> entire db. Since I only need to verify that every new document > >> generated is serialized, seem easy to hit MongoDB/Cloudant to find the > >> last document store and if it does not match the last one in > >> PostgreSQL shut the app down until I can manually restore from the > >> audit log. > > >> Seem fairly easy and straightforward. > > >> Has anyone else done this? > >> How successful were you? any gotchas? > >> Any gems out there that can do this? > > >> Advice appreciated. > > >> -- > >> You received this message because you are subscribed to the Google Groups > >> "Heroku" group. > >> To post to this group, send email to heroku@googlegroups.com. > >> To unsubscribe from this group, send email to > >> heroku+unsubscr...@googlegroups.com. > >> For more options, visit this group > >> athttp://groups.google.com/group/heroku?hl=en. > > > -- > > You received this message because you are subscribed to the Google Groups > > "Heroku" group. > > To post to this group, send email to heroku@googlegroups.com. > > To unsubscribe from this group, send email to > > heroku+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/heroku?hl=en. -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.