Re: shadowing (like IB/Firebird)

Поиск
Список
Период
Сортировка
От Glen Parker
Тема Re: shadowing (like IB/Firebird)
Дата
Msg-id AJEKKAIECKNMBCEKADJPKEMPCCAA.glenebob@nwlink.com
обсуждение исходный текст
Ответ на Re: shadowing (like IB/Firebird)  (David Garamond <lists@zara.6.isreserved.com>)
Ответы Re: shadowing (like IB/Firebird)  (David Garamond <lists@zara.6.isreserved.com>)
Re: shadowing (like IB/Firebird)  (<wespvp@syntegra.com>)
Список pgsql-general
Sounds an aweful lot like RAID level one :-)  Why would a DB system need to
do what RAID already does quite well?

> Sorry, should've at least described 'shadowing'. A shadow is a
> synchronous page-level (I think) mirror file. That is, when you open a
> database /disk1/dbname.fdb and then issue a:
>
>   > CREATE SHADOW 1 '/disk2/dbname.fdb';
>   > CREATE SHADOW 2 '/disk3/dbname.fdb';
>
> then all 3 files will be kept synchronized at all times. Each subsequent
> page write will go to all 3 files (if any of the write fails, the
> transaction fails, so it's not unlike a synchronous replication).
>
> 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.
>
> Alternatively, when a shadow fails, IB/Firebird can refuse further
> transactions until there is another shadow coming up, so the database is
> shadowed all the time.


В списке pgsql-general по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: [JDBC] loading data into postgresql became slow
Следующее
От: Guy Fraser
Дата:
Сообщение: Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly