Greg Stark <gsst...@mit.edu> writes: > On Wed, Apr 20, 2011 at 3:47 AM, Robert Haas <robertmh...@gmail.com> wrote: > >> While I was out at the MySQL conference last week, I heard that one of >> the forthcoming MySQL features is "time-delayed replication": > > Incidentally, this is a popular Oracle feature. It's a poor man's > "flashback" and similar to how some filesystems automatically create > regular snapshots of every home directory so you can get back stuff at > some arbitrary point in the past.
Yup. One of the big bosses where I work went asking for this a couple years ago. We're multi-platform; Oracle, MySQL, EnterpriseDB, Vertica. They put a 6 hour delay on the critical Oracle boxes. NOthing was done for MySQL or Vertica since no feature support. My C-foo being rusty, I elected to add more hacks to our home-spun PYthon version of pg_standby rather than adding the feature to pg_standby itself. Been running with delayed WAL apply ever since.. Shipping happens immediatly on log creation at master and we simply wait for the files to age the configured time before application. In a few cases, we have 2 or more standbys off the same prod master. One in real-time mode and the others lagged. Thanks all! -- Jerry Sievers Postgres DBA/Development Consulting e: gsiever...@comcast.net p: 305.321.1144 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
