Re: [GENERAL] shadowing (like IB/Firebird)

2004-05-26 Thread David Garamond
Kragen Sitaker wrote: On Tue, Apr 27, 2004 at 10:36:24AM +0700, David Garamond wrote: Glen Parker wrote: Sounds an aweful lot like RAID level one :-) Why would a DB system need to do what RAID already does quite well? I think IB/FB's shadowing was implemented before RAID was invented Heh, not

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-27 Thread Robert Treat
On Mon, 2004-04-26 at 23:43, Bruce Momjian wrote: David Garamond wrote: Now suppose /disk1 fails, one of the shadow can be configured to immediately take over as the master database, without any down time. We can then add /disk4/dbname.fdb, for instance, to become a new shadow.

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-27 Thread Bruce Momjian
Robert Treat wrote: On Mon, 2004-04-26 at 23:43, Bruce Momjian wrote: David Garamond wrote: Now suppose /disk1 fails, one of the shadow can be configured to immediately take over as the master database, without any down time. We can then add /disk4/dbname.fdb, for instance, to become

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-27 Thread Lincoln Yeoh
At 09:53 AM 4/27/2004 -0400, Bruce Momjian wrote: Actually, what is needed is: - an exact mirror at all times; - a very simple, straightforward, and fast way to failover; done by software. They can do hardware mirroring, or software/OS mirroring. Why put that in the database

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-27 Thread wespvp
On 4/26/04 3:25 PM, Glen Parker [EMAIL PROTECTED] wrote: Sounds an aweful lot like RAID level one :-) Why would a DB system need to do what RAID already does quite well? One case I can think of is where the shadow is on a separate system (e.g. a SAN or NetApps, another linux box, etc.). RAID

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-27 Thread Peter Eisentraut
David Garamond wrote: Actually, what is needed is: - an exact mirror at all times; - a very simple, straightforward, and fast way to failover; done by software. http://www.drbd.org/ works well for us and can be set up quickly and from commodity parts. ---(end of

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-27 Thread David Garamond
[EMAIL PROTECTED] wrote: died it caused corruption elsewhere. I have also seen (a couple of times) a controller go bad and proceed to write garbage all over the disks. The mirroring worked quite well - we had a very nice file system full of mirrored garbage. Does this mean software RAID is

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-27 Thread wespvp
On 4/27/04 11:48 PM, David Garamond [EMAIL PROTECTED] wrote: Does this mean software RAID is actually safer than hardware RAID? (Since the OS and processor is usually more reliable than a disc controller). I'm not sure I would jump to that conclusion. If a controller went bad and trashed a

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-26 Thread Bruce Momjian
David Garamond wrote: Bruce Momjian wrote: David Garamond wrote: Is there a feature similar to this currently in Postgres, or will there be? Sometimes (like in a shared hosting environment), we cannot have the luxury of hot-swapped RAID or expensive SAN, and it's nice to be able to

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-26 Thread David Garamond
Bruce Momjian wrote: David Garamond wrote: Is there a feature similar to this currently in Postgres, or will there be? Sometimes (like in a shared hosting environment), we cannot have the luxury of hot-swapped RAID or expensive SAN, and it's nice to be able to have a synchronous backup so that